2) In Database Administrator evaluate how Oracle Database and its applications can best use the available computer resources; this evaluation should reveal which of the following information?

a. How many disk drives are available to the Oracle Products?b. How many, if any, dedicated tape drives are available to Oracle productsc. How much memory is available to the instances of Oracle Database you will rund. All mentioned above

6) In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups, DGROUP1, is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective.

DROP DISKGROUP dgroup1 EXCLUDING CONTENTS;

What would be the result of this command?

a. This command would result in an error because the disk group is not emptyb. The command would drop the disk group, ignoring the EXCLUDING CONTENTS optionc. The command would result in the disk group being marked as INVALID because it cannot be droppedd. The command would result in the contents being moved to the parent disk group and dropping of the disk group

9) An aborted database shutdown proceeds with which of the following conditions?

a. New connections are allowed, nor are new transactions not allowed to be started, after the statement is issued.b. Current client SQL statements not being processed by Oracle Database are immediately terminated.c. Uncommitted transactions are rolled backd. Oracle Database does wait for users currently connected to the database to Connect. The database implicitly connects all connected users.e. None of the above

a. Each server participating in a distributed database is administered independently from all other databases. b. Nodes of the system cannot mirror the logical organization of companies or groups that need to maintain independence.c. Local administrators cannot control corresponding local data. Therefore, each database administrator’s domain of responsibility is smaller and more manageable.d. Administrators cannot recover from isolated system failures independently from other nodes in the system.

21) In the error Logging Table format, which set of columns contain data from the row that caused the error and the column names match the column names from the table being inserted into (the "DML table")?

22) A transportable tablespace set consists of datafiles for the set of tablespaces being transported and an export file containing structural information (metadata) for the set of tablespaces we use ______

24) Which of the following performs the following operations during a distributed transaction?

1) Sends all of the distributed transaction SQL statements, remote procedure calls, and so forth to the directly referenced nodes, thus forming the session tree.2) Instructs all directly referenced nodes other than the commit point site to prepare the transaction.3) Instructs the commit point site to initiate the global commit of the transaction if all nodes prepare successfully.

a. Database serverb. Local coordinatorc. Global coordinatord. Commit point site