D426 Alt Practice Test Questions And Answers Verified 100% Correct!!!
1. UPDATE tablename a. SET columnname = ex-
***** pression
[WHERE conditionlist];
What command replaces the ***** in the above state-
ment?
a. SET columnname = expression
b. columnname = expression
c. expression = columnname
d. LET columnname = expression
2. A record consists of a . c. set of one or more fields
a. character
b. collection of related records
c. set of one or more fields
d. group of files
3. A DBMS performs several important functions that c. data reports
guarantee the integrity and consistency of the data in
the database. Which of the following is NOT one of
those functions?
a. Data integrity management
b. Data storage management
c. Data reports
d. Security management
4. Which item is unstructured data. b. a video
a. A record representing one student
b. A video
c. A table that holds student data
, D426 Alt Practice Test Questions And Answers Verified 100% Correct!!!
d. A relational database that hold course registration
data.
5. Data is/are: b. raw facts
a. information
b. raw facts
c. processed information
d. a DBMS
6. A pet owner can have many pets; a specific pet is linked a. one-to-many
to one pet owner.
Which kind of binary relationship is described in this
example?
a. One-to-one
b. One-to-many
c. Many-to-many
d. Associative
7. Database models were developed to . a. model real-world events
or conditions
a. model real-world events or conditions
b. deposit data within a single file
c. keep data within multiple data repositories
d. allow DBMSs to maintain loose control over the data-
base activities
8. What type of relationship is expressed with the phrase . 1:M or One-to-Many
"A Painter paints one or more Paintings"?
a. 1:M
b. 1:1
, D426 Alt Practice Test Questions And Answers Verified 100% Correct!!!
c. M:1
d. M:N
9. The entity integrity rule requires that . a. all primary key entries
are unique
a. all primary key entries are unique
b. a part of the key may be null
c. foreign key values do not reference primary key
values
d. duplicate object values are allowed
10. What does the 'refer' in referential integrity mean c. A foreign key in a table
must refer to a valid pri-
a. The relationships between entities and attributes, mary key in another table
also called referrals
b. Reference points that databases place in each
record during backups
c. A foreign key in a table must refer to a valid primary
key in another table.
d. you delete a row in one table whose primary key
does not have a matching foreign key value in another
table
11. A table is perceived as a . b. two-dimensional struc-
ture
a. flat structure
b. two-dimensional structure
c. linked structure
d. graph
12. Another word for the term "relation" is . c. table
a. datafile
1. UPDATE tablename a. SET columnname = ex-
***** pression
[WHERE conditionlist];
What command replaces the ***** in the above state-
ment?
a. SET columnname = expression
b. columnname = expression
c. expression = columnname
d. LET columnname = expression
2. A record consists of a . c. set of one or more fields
a. character
b. collection of related records
c. set of one or more fields
d. group of files
3. A DBMS performs several important functions that c. data reports
guarantee the integrity and consistency of the data in
the database. Which of the following is NOT one of
those functions?
a. Data integrity management
b. Data storage management
c. Data reports
d. Security management
4. Which item is unstructured data. b. a video
a. A record representing one student
b. A video
c. A table that holds student data
, D426 Alt Practice Test Questions And Answers Verified 100% Correct!!!
d. A relational database that hold course registration
data.
5. Data is/are: b. raw facts
a. information
b. raw facts
c. processed information
d. a DBMS
6. A pet owner can have many pets; a specific pet is linked a. one-to-many
to one pet owner.
Which kind of binary relationship is described in this
example?
a. One-to-one
b. One-to-many
c. Many-to-many
d. Associative
7. Database models were developed to . a. model real-world events
or conditions
a. model real-world events or conditions
b. deposit data within a single file
c. keep data within multiple data repositories
d. allow DBMSs to maintain loose control over the data-
base activities
8. What type of relationship is expressed with the phrase . 1:M or One-to-Many
"A Painter paints one or more Paintings"?
a. 1:M
b. 1:1
, D426 Alt Practice Test Questions And Answers Verified 100% Correct!!!
c. M:1
d. M:N
9. The entity integrity rule requires that . a. all primary key entries
are unique
a. all primary key entries are unique
b. a part of the key may be null
c. foreign key values do not reference primary key
values
d. duplicate object values are allowed
10. What does the 'refer' in referential integrity mean c. A foreign key in a table
must refer to a valid pri-
a. The relationships between entities and attributes, mary key in another table
also called referrals
b. Reference points that databases place in each
record during backups
c. A foreign key in a table must refer to a valid primary
key in another table.
d. you delete a row in one table whose primary key
does not have a matching foreign key value in another
table
11. A table is perceived as a . b. two-dimensional struc-
ture
a. flat structure
b. two-dimensional structure
c. linked structure
d. graph
12. Another word for the term "relation" is . c. table
a. datafile
