Interview Question in SQL Server Indexing
Interview Question :: Computer class help me plz
In Access' table Design View, you will see many of a field's properties (characteristics that define a field).
a. True
b. False
Save answer
Question 2 (1 point)
Typically, the field on the "many" side of a one-to-many relationship in Access shares the same name as the primary key in the table on the "one" side.
a. True
b. False
Save answer
Question 3 (1 point)
Which of the following is not an advantage to using Microsoft Access for listing information?
a. Duplicate data is minimized
b. Provides powerful mathematical functions like
Excel
c. Data entry is fast and easy
d. Information is secure through the use of passwords
Save answer
Question 4 (1 point)
In database terminology, a ______ is defined as the smallest unit of data organization consisting of a specific category of data.
a. record
b. table
c. object
d. field
Save answer
Question 5 (1 point)
Which of Access' keyboard shortcuts is used to move to the last field of the last record in a table?
a. [Ctrl]
b. [Ctrl][End]
c. [End]
d. [Shift][Tab]
Save answer
Question 6 (1 point)
What is the name of the thin line that separates field names in Access that can be dragged to the left or right to resize a column?
a. Column sizer
b. Resize line
c. Field selector
d. Column separator
Save answer
Question 7 (1 point)
Which of the following is not one of the options that you can select in Access' Navigation Pane?
a. Tables
b. Reports
c. SQL
d. Queries
Save answer
Question 8 (1 point)
The Access table data type that allows for the storage of Office and Windows files that can be linked or embedded is _______.
a. OLE Object
b. Text
c. Memo
d. Number
Save answer
Question 9 (1 point)
What is the name given to the field in an Access table that uniquely identifies each record in the table?
a. Primary Key
b. Index Field
c. Foreign Key
d. Relationship Indicator
Save answer
Question 10 (1 point)
A ___________ relationship between two tables means that a record from one table is related to one or many records in a second table.
a. multi-table
b. key-to-key
c. one-to-many
d. primary-foreign
Loading ...