Question 1

Changing cardinalities in a database is:

Accepted Answer

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

Question 2

Location transparency allows for which of the following?

Accepted Answer

A) Users to treat the data as if it is at one location 
B) Programmers to treat the data as if it is at one location 
C) Managers to treat the data as if it is at one location 
D) All of the above. 
A) Users to treat the data as if it is at one location 
B) Programmers to treat the data as if it is at one location 
C) Managers to treat the data as if it is at one location 
D) All of the above.

Question 3

A distributed database is which of the following?

Accepted Answer

A) A single logical database that is spread to multiple locations and is interconnected by a network 
B) A loose collection of file that is spread to multiple locations and is interconnected by a network 
C) A single logical database that is limited to one location. 
D) A loose collection of file that is limited to one location. 
A) A single logical database that is spread to multiple locations and is interconnected by a network 
B) A loose collection of file that is spread to multiple locations and is interconnected by a network 
C) A single logical database that is limited to one location. 
D) A loose collection of file that is limited to one location.

Question 4

A distributed database has which of the following advantages over a centralized database?

Accepted Answer

A) Software cost 
B) Software complexity 
C) Slow Response 
D) Modular growth 
A) Software cost 
B) Software complexity 
C) Slow Response 
D) Modular growth

Question 5

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. 
A) Maintains a log of transactions 
B) Maintains before and after database images 
C) Maintains appropriate concurrency control 
D) All of the above.

Question 6

A distributed database has which of the following advantages over a centralized database?

Accepted Answer

A) Software cost 
B) Software complexity 
C) Slow Response 
D) Modular growth 
A) Software cost 
B) Software complexity 
C) Slow Response 
D) Modular growth

Question 7

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

Accepted Answer

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

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

Which of the following is not one of the stages in the evolution of distributed DBMS?

Accepted Answer

A) Unit of work 
B) Remote unit of work 
C) Distributed unit of Work 
D) Distributed request 
A) Unit of work 
B) Remote unit of work 
C) Distributed unit of Work 
D) Distributed request

Question 10

A semijoin is which of the following?

Accepted Answer

A) Only the joining attributes are sent from one site to another and then all of the rows are returned. 
B) All of the attributes are sent from one site to another and then only the required rows are returned. 
C) Only the joining attributes are sent from one site to another and then only the required rows are return 
A) Only the joining attributes are sent from one site to another and then all of the rows are returned. 
B) All of the attributes are sent from one site to another and then only the required rows are returned. 
C) Only the joining attributes are sent from one site to another and then only the required rows are return

Changing cardinalities in a database is:

Location transparency allows for which of the following?

A distributed database is which of the following?

A distributed database has which of the following advantages over a centralized database?

A transaction manager is which of the following?

A distributed database has which of the following advantages over a centralized database?

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 true concerning a global transaction?

Which of the following is not one of the stages in the evolution of distributed DBMS?

A semijoin is which of the following?

Database Management System DBMS: Part A

Database Management System DBMS: Part B

Database Management and Data Mining

Database Management System: Relational Model and Operations

Filters

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

Changing cardinalities in a database is:

Location transparency allows for which of the following?

A distributed database is which of the following?

A distributed database has which of the following advantages over a centralized database?

A transaction manager is which of the following?

A distributed database has which of the following advantages over a centralized database?

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 true concerning a global transaction?

Which of the following is not one of the stages in the evolution of distributed DBMS?

A semijoin is which of the following?

Database Management System DBMS: Part A

Database Management System DBMS: Part B

Database Management and Data Mining

Database Management System: Relational Model and Operations

Filters