D426 Practice Test || Error-free Answers 100%.
UPDATE tablename
*****
[WHERE conditionlist];
What command replaces the ***** in the above statement?
a. SET columnname = expression
b. columnname = expression
c. expression = columnname
d. LET columnname = expression correct answers a. SET columnname = expression
A record consists of a ____.
a. character
b. collection of related records
c. set of one or more fields
d. group of files correct answers c. set of one or more fields
A DBMS performs several important functions that 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 correct answers c. data reports
,Which item is unstructured data.
a. A record representing one student
b. A video
c. A table that holds student data
d. A relational database that hold course registration data. correct answers b. a video
Data is/are:
a. information
b. raw facts
c. processed information
d. a DBMS correct answers b. raw facts
A pet owner can have many pets; a specific pet is linked 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 correct answers a. one-to-many
Database models were developed to ____.
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 database activities correct answers a. model
real-world events or conditions
What type of relationship is expressed with the phrase "A Painter paints one or more Paintings"?
a. 1:M
b. 1:1
c. M:1
d. M:N correct answers . 1:M or One-to-Many
The entity integrity rule requires that ____.
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 correct answers a. all primary key entries are unique
What does the 'refer' in referential integrity mean
a. The relationships between entities and attributes, 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 correct answers c. A foreign key in a table must refer to a valid primary key in
another table
A table is perceived as a ____.
UPDATE tablename
*****
[WHERE conditionlist];
What command replaces the ***** in the above statement?
a. SET columnname = expression
b. columnname = expression
c. expression = columnname
d. LET columnname = expression correct answers a. SET columnname = expression
A record consists of a ____.
a. character
b. collection of related records
c. set of one or more fields
d. group of files correct answers c. set of one or more fields
A DBMS performs several important functions that 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 correct answers c. data reports
,Which item is unstructured data.
a. A record representing one student
b. A video
c. A table that holds student data
d. A relational database that hold course registration data. correct answers b. a video
Data is/are:
a. information
b. raw facts
c. processed information
d. a DBMS correct answers b. raw facts
A pet owner can have many pets; a specific pet is linked 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 correct answers a. one-to-many
Database models were developed to ____.
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 database activities correct answers a. model
real-world events or conditions
What type of relationship is expressed with the phrase "A Painter paints one or more Paintings"?
a. 1:M
b. 1:1
c. M:1
d. M:N correct answers . 1:M or One-to-Many
The entity integrity rule requires that ____.
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 correct answers a. all primary key entries are unique
What does the 'refer' in referential integrity mean
a. The relationships between entities and attributes, 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 correct answers c. A foreign key in a table must refer to a valid primary key in
another table
A table is perceived as a ____.
