Chapter 7, Problem 16MC

Which part of the database application is responsible for application user authentication in the database role-based model? Choose the following options: a. Application b. Database

Which of the following releases a lock currently held by a user on the HOMEWORK10 table?a. A COMMIT command is issued.b. A DDL command is issued to end a transaction.c. The user exits the system.d. A ROLLBACK command is issued.e. all of the abovef. none of the above

In this exercise, you will create tablespaces and change their characteristics.1. Connect to the database as user SYSTEM.2. Create a tablespace (MYTBSP_YourName) in a suitable directory—anydirectory on which the Oracle owner has write permission will do:3. Create a table in the new tablespace, and determine the size of the firstextent:4. Add extents manually, and observe the size of each new extent byrepeatedly executing this command,5. Take the tablespace offline, Try to insert some data in to the table, try todelete data from table, observe the effect, and bring it back online. 6. Drop the tablespace, and use an operating system command to confirmthat the file has indeed gone:

Which of the following is FALSE regarding a Disk-Oriented DBMSarchitecture? The DBMS has an execution engine that will execute queries. The DBMS has a buffer pool that manages the movement back and forthbetween disk and memory. The database is all on disk, and the data in the database files is organized intopages, and the first page is the directory page.The buffer pool will ask the execution engine for a specific page, and theexecution engine will take care of bringing that page into memory. In order to operate on the data the DBMS needs to bring the data into memory.

Which of the following is FALSE regarding a Disk-Oriented DBMSarchitecture?O The DBMS has an execution engine that will execute queries.O The DBMS has a buffer pool that manages the movement back and forthbetween disk and memory.O The database is all on disk, and the data in the database files is organized intopages, and the first page is the directory page.

What types of privileges are available in Oracle 12c? Define each type

Which of the following criteria specifically describes the atomicity property? a.) Once transaction changes are done and saved, they cannot be lost. b.) Data used in one transaction cannot be used in another transaction until the first transaction is completed. c.) When a transaction is completed, the database must be in a consistent state. d.) All SQL requests of a transaction must be completed; if not, the transaction must be aborted.

Which of the following is/are the primary features of a DBMS? (A) To provide an environment that is congenial to user (B) To store the information (C) To retrieve information (D) All of the above

Which of the following are true about primary keys? SELECT ALL THAT APPLY. A) They must reference one or more columns in a single table. B) They are usually implemented using an index. C) They guarantee that no two rows in a table have duplicate primary key values. D) They must be defined for every database table.