Practice Test: Question Set - 26
1. The database language that allows you to access or maintain data in a database
- (A) DCL
- (B) DML
- (C) DDL
- (D) None of
above
2. It is most common type of query. It retrieves records from one or more tables and then displays the
- (A) Parameter
- (B) Select
- (C) Crosstab
- (D) All of above
3. An Access database object that is used to enter, view or edit records
- (A) Table
- (B) Form
- (C) Query
- (D) Report
4. What is the full form of SQL?
- (A) Sophisticated
Question List
- (B) Structured
Question List
- (C) Structured
Query Language
- (D) Small Query
Length
5. Which of the following data type is used to store logical value in MS Access?
- (A) True/False
- (B) On/Off
- (C) Yes/No
- (D) All of Above
6. In a module, a(n) _______ is a series of commands and properties that perform a specific task.
- (A) Event
- (B) Property
- (C) Procedure
- (D) Macro
7. If a color property contains “#336699”, how many blue units are in the color?
- (A) 33
- (B) 66
- (C) 99
- (D) 255
8. Which function extracts the name of the month from a date/time value?
- (A) Month
- (B) MonthName
- (C) MonthLabel
- (D) MonthValue
9. In a junction table, the ________ field consists of the foreign key from both the linked tables.
- (A) First
defined
- (B) Last
defined
- (C) Foreign key
- (D) Primary
key
10. Which of the following views is used to graphically summarize and analyze data in a recordset?
- (A) Datasheet
- (B) Form
- (C) PivotChart
- (D) PivotTable
11. The content and application of the Search tool CANNOT be retained when you ________.
- (A) Format an
object
- (B) Resize a
column
- (C) Use
Datasheet View
- (D) Close an
object
12. Search engines use a(n) ________ to automatically index sites.
- (A) Crawler
- (B) Query
- (C) Enterprise
- (D) Site builder
13. To store your picture in a database requires a(n) ________ field.
- (A) BLOB
- (B) Text
- (C) Image
- (D) Logical
14. What is the maximum length a text field can be?
- (A) 120
- (B) 255
- (C) 265
- (D) 75
15. When a picture or other graphic image is placed in the report header section it will appear________
- (A) Once in the
bugging of the report
- (B) At the top
of every page
- (C) Every after
record break
- (D) On the 1st
and last pages of the report
Next Tests:
Blogger Comment
Facebook Comment