Question 1

An autonomous homogenous environment is which of the following?

Accepted Answer

A)  The same DBMS is at each node and each DBMS works independently.
B)  The same DBMS is at each node and a central DBMS coordinates database access.
C)  A different DBMS is at each node and each DBMS works independently.
D)  A different DBMS is at each node and a central DBMS coordinates database access. A

Question 2

A homogenous distributed database is which of the following?

Accepted Answer

A)  The same DBMS is used at each location and data are not distributed across all nodes.
B)  The same DBMS is used at each location and data are distributed across all nodes.
C)  A different DBMS is used at each location and data are not distributed across all nodes.
D)  A different DBMS is used at each location and data are distributed across all nodes. B

Question 3

A CASE SQL statement is which of the following?

Accepted Answer

A)  A way to establish an IF-THEN-ELSE in SQL.
B)  A way to establish a loop in SQL.
C)  A way to establish a data definition in SQL.
D)  All of the above. A

Question 4

Which of the following is a disadvantage of replication?

Accepted Answer

A)  Reduced network traffic
B)  If the database fails at one site, a copy can be located at another site.
C)  Each site must have the same storage capacity.
D)  Each transaction may proceed without coordination across the network.

Question 5

Which one of the following sorts rows in SQL?

Accepted Answer

A)  SORT BY
B)  ALIGN BY
C)  ORDER BY
D)  GROUP BY

Question 6

Which of the following statements is true concerning routines and triggers?

Accepted Answer

A)  Both consist of procedural code.
B)  Both have to be called to operate.
C)  Both run automatically.
D)  Both are stored in the database.

Question 7

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

Accepted Answer

A)  Full backup
B)  Consistent backup
C)  Inconsistent backup
D)  Differential backup

Question 8

Which of the following is true concerning a global transaction?

Accepted Answer

A)  The required data are at one local site and the distributed DBMS routes requests as necessary.
B)  The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
C)  The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
D)  The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

Question 9

A heterogeneous distributed database is which of the following?

Accepted Answer

A)  The same DBMS is used at each location and data are not distributed across all nodes.
B)  The same DBMS is used at each location and data are distributed across all nodes.
C)  A different DBMS is used at each location and data are not distributed across all nodes.
D)  A different DBMS is used at each location and data are distributed across all nodes.

Question 10

Which of the following is true concerning a procedure?

Accepted Answer

A)  You do not create them with SQL.
B)  They do not need to have a unique name.
C)  They include procedural and SQL statements.
D)  They are the same thing as a function.

Question 11

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

Accepted Answer

A)  Two
B)  Three
C)  Four
D)  Six

Question 12

Storing a separate copy of the database at multiple locations is which of the following?

Accepted Answer

A)  Data Replication
B)  Horizontal Partitioning
C)  Vertical Partitioning
D)  Horizontal and Vertical Partitioning

Question 13

A distributed database can use which of the following strategies?

Accepted Answer

A)  Totally centralized at one location and accessed by many sites
B)  Partially or totally replicated across sites
C)  Partitioned into segments at different sites
D)  All of the above

Question 14

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

Accepted Answer

A)  ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0) ;
B)  ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0) ;
C)  ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade> 0) ;
D)  None of the above is correct.

Question 15

A transaction manager is which of the following?

Accepted Answer

A)  Maintains a log of transactions
B)  Maintains before and after database images
C)  Maintains appropriate concurrency control
D)  All of the above

Question 16

The SQL keyword(s) ________ is used with wildcards.

Accepted Answer

A)  LIKE only
B)  IN only
C)  NOT IN only
D)  IN and NOT IN

Question 17

Some of the columns of a relation are at different sites is which of the following?

Accepted Answer

A)  Data Replication
B)  Horizontal Partitioning
C)  Vertical Partitioning
D)  Horizontal and Vertical Partitioning

Question 18

Which of the following is not true about indexes?

Accepted Answer

A)  Indexes are created to enforce uniqueness on columns.
B)  Indexes are created to enable fast retrieval by column values.
C)  Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
D)  Indexes are created with the ALTER TABLE command.

Question 19

If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

Accepted Answer

A)  the primary key
B)  any alternate key
C)  a surrogate key
D)  a foreign key

Question 20

Replication should be used when which of the following exist?

Accepted Answer

A)  When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.
B)  When using many nodes with different operating systems and DBMSs and database designs.
C)  The application's data can be somewhat out-of-date.
D)  All of the above.

Exam 5: Oracle Backup, Distributed Databases, and SQL Commands

An autonomous homogenous environment is which of the following?

A homogenous distributed database is which of the following?

A CASE SQL statement is which of the following?

Which of the following is a disadvantage of replication?

Which one of the following sorts rows in SQL?

Which of the following statements is true concerning routines and triggers?

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

Which of the following is true concerning a global transaction?

A heterogeneous distributed database is which of the following?

Which of the following is true concerning a procedure?

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

Storing a separate copy of the database at multiple locations is which of the following?

A distributed database can use which of the following strategies?

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

A transaction manager is which of the following?

The SQL keyword(s) ________ is used with wildcards.

Some of the columns of a relation are at different sites is which of the following?

Which of the following is not true about indexes?

If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

Replication should be used when which of the following exist?