D426 Practice Test with accurate detailed ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
solutions
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 answer✔✔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 answer✔✔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 answer✔✔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 answer✔✔b. a video
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Data is/are: ||//|\\||
a. information
||//|\\||
b. raw facts
||//|\\|| ||//|\\||
c. processed information
||//|\\|| ||//|\\||
d. a DBMS - correct answer✔✔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 answer✔✔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
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
answer✔✔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 answer✔✔. 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 answer✔✔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
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
solutions
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 answer✔✔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 answer✔✔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 answer✔✔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 answer✔✔b. a video
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Data is/are: ||//|\\||
a. information
||//|\\||
b. raw facts
||//|\\|| ||//|\\||
c. processed information
||//|\\|| ||//|\\||
d. a DBMS - correct answer✔✔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 answer✔✔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
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
answer✔✔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 answer✔✔. 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 answer✔✔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
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
