Question 1

Which of the following is true concerning a global transaction?
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.

Accepted Answer

A global transaction involves operations on data that are distributed across multiple locations. Therefore, the correct statement is that the required data are located in at least one nonlocal site, and the distributed DBMS routes requests as necessary to access this data.

Question 2

A transaction manager is which of the following?
A)Maintains a log of transactions
B)Maintains before and after database images
C)Maintains appropriate concurrency control
D)All of the above.

Accepted Answer

A transaction manager is responsible for maintaining a log of transactions, maintaining before and after images of the database to ensure data integrity, and managing appropriate concurrency control to allow multiple transactions to occur simultaneously without interfering with each other.

Question 3

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)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.

Accepted Answer

The correct SQL command to add a constraint named GradeCheck that ensures the values of the Grade column must be greater than 0 is: ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0). This syntax correctly uses ADD CONSTRAINT followed by the constraint name and the CHECK keyword to define the condition.

Question 4

Changing cardinalities in a database is:
A)a common database design task.
B)a rare database design task, but does occur.
C)a database design task that never occurs.
D)is impossible to do, so a new database must be constructed and the data moved into it.

Accepted Answer

Changing cardinalities in a database is a common task during the database design process, as requirements evolve or as a better understanding of the data relationships is developed.

Question 5

Which one of the following sorts rows in SQL?
A)SORT BY
B)ALIGN BY
C)ORDER BY
D)GROUP BY

Accepted Answer

The correct SQL clause to sort rows is "ORDER BY". It is used to sort the result set in ascending or descending order based on one or more columns.

Question 6

The SQL keyword(s) ________ is used with wildcards.
A)LIKE only
B)IN only
C)NOT IN only
D)IN and NOT IN

Accepted Answer

The SQL keyword "LIKE" is used with wildcards to search for a specified pattern in a column.

Question 7

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.
A)the primary key
B)any alternate key
C)a surrogate key
D)a foreign key

Accepted Answer

The correct answer is A) the primary key. In a database, if a relationship has a cascade updates constraint, then changing the primary key value in the parent table will automatically update any corresponding foreign key values in the child table to maintain referential integrity.

Question 8

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
A)Two
B)Three
C)Four
D)Six

Accepted Answer

The answer of For every relationship, how many possible types...

Question 9

In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
A)The line numbers reported match the line numbers you see in your text editor.
B)SQL*Plus will automatically show the errors to you.
C)To see the errors, enter SHOW ERRORS in SQL*Plus.
D)If there are no syntax errors, you will receive the message "NO ERRORS."

Accepted Answer

To see the errors after attempting to compile a procedure in SQL*Plus, you need to manually enter the command "SHOW ERRORS". This command will display any compile errors that occurred during the procedure creation. The other options do not accurately describe the behavior of SQL*Plus or the process of handling compile errors in procedures.

Question 10

Which of the following is not true about indexes?
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.

Accepted Answer

Indexes are typically created using the CREATE INDEX command, not the ALTER TABLE command.

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

Which of the following is true concerning a global transaction?

A transaction manager is which of the following?

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?

Changing cardinalities in a database is:

Which one of the following sorts rows in SQL?

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

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.

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

In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

Which of the following is not true about indexes?