In which of the scenarios will the DBA perform recovery? (Choose all that apply.)
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this. Which data types would you use for the new column?
Note the following structures in your database server: 1. Extents 2. OS Blocks 3. Tablespace 4. Segments 5. Oracle Data BlockWhich option has the correct arrangement of these structures from the smallest to the largest?
Examine the following command that is used to create a table: SQL> CREATE TABLE orders ( oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamt NUMBER(10,2) ) TABLESPACE […]
Identify the two situations in which the alert log file is updated with details. (Choose two.)
The database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$SKD, and then assign external […]
User A executes the following command to drop a large table in your database: SQL> DROP TABLE trans;While the drop table operation is in progress; user B executes the following command on the same table; SQL> DELETE FROM trans WHERE tr_type=’SL’;Which statement is true regarding the […]
You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?
After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database: SQL> ALTER DATABASE OPEN;Which two statements are true? (Choose two.)
Which two statements are true about the Automatic Database Diagnostic Monitor(ADDM)? (Choose two.)