Data base

data-base

Exit

Question 1 of 1

Time Left

188948

120

block

Consider this incomplete Relationship Diagram After all M:1 relationships have been added to this diagram, how many Foreign keys will exist in the Delivery table?

Select the correct answer(s).

(0/0)

188949

120

none

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

188950

120

none

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

188951

120

none

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

188952

120

none

How many of the following statements are True? • A table must have one primary key • A table may have zero foreign keys • A single table cannot have both a primary key and a foreign key • A table must have one foreign key

Select the correct answer(s).

(0/0)

188953

120

none

How many of the following statements are True? • A table may have multiple primary keys • A foreign key may have a null value • A single table cannot have both a primary key and a foreign key • A foreign key value must be unique within a database

Select the correct answer(s).

(0/0)

188954

120

none

How many of these statements about Indexes are True? • The use of indexes slows data retrieval times • The use of indexes improves data insertion times • An index cannot be created with duplicate key values • An index cannot be created on a Primary Key field

Select the correct answer(s).

(0/0)

188955

120

none

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

188956

120

none

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

188957

120

none

How many of these statements about Indexes are True? • The use of indexes slows data retrieval times • The use of indexes improves data insertion times • An index may be created with duplicate key values • An index may only be created on Primary Key fields

Select the correct answer(s).

(0/0)

188958

120

none

Assume that Foreign Keys may not contain null values. To which table can the first record in the database be added to?

Select the correct answer(s).

(0/0)

188959

120

none

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

188960

120

none

Which one of these is not a valid field datatype when you create a table in Access

Select the correct answer(s).

(0/0)

188961

120

none

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

188962

120

none

How many of the following statements are True? • A table may have a multiple parameters • An update query may have a parameter • One parameter may include one or more indexes • A select query may have multiple parameters

Data base

Question 1 of 1

Time Left

Consider this incomplete Relationship Diagram After all M:1 relationships have been added to this diagram, how many Foreign keys will exist in the Delivery table?

Select the correct answer(s).

(0/0)

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

How many of the following statements are True? • A table must have one primary key • A table may have zero foreign keys • A single table cannot have both a primary key and a foreign key • A table must have one foreign key

Select the correct answer(s).

(0/0)

How many of the following statements are True? • A table may have multiple primary keys • A foreign key may have a null value • A single table cannot have both a primary key and a foreign key • A foreign key value must be unique within a database

Select the correct answer(s).

(0/0)

How many of these statements about Indexes are True? • The use of indexes slows data retrieval times • The use of indexes improves data insertion times • An index cannot be created with duplicate key values • An index cannot be created on a Primary Key field

Select the correct answer(s).

(0/0)

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

How many of these statements about Indexes are True? • The use of indexes slows data retrieval times • The use of indexes improves data insertion times • An index may be created with duplicate key values • An index may only be created on Primary Key fields

Select the correct answer(s).

(0/0)

Assume that Foreign Keys may not contain null values. To which table can the first record in the database be added to?

Select the correct answer(s).

(0/0)

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

Which one of these is not a valid field datatype when you create a table in Access

Select the correct answer(s).

(0/0)

When the query is executed, how many records will appear in the Query Datasheet View?

Select the correct answer(s).

(0/0)

How many of the following statements are True? • A table may have a multiple parameters • An update query may have a parameter • One parameter may include one or more indexes • A select query may have multiple parameters

Select the correct answer(s).

(0/0)

Results

Correct

0

Incorrect

0

Skipped

0

Overall Percentage

0%

Rate Quiz