Exam information

Exam 1Z0-050: Oracle Database 11g, New Features for Administrators

Other exams

which of the scenarios will the DBA perform recovery?

In which of the scenarios will the DBA perform recovery? (Choose all that apply.)

Which data types would you use for the new column?

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?


Which option has the correct arrangement of these structures from the smallest to the largest?

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?

Which two statements are true about the effect of the above command?

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

Identify the two situations in which the alert log file is updated with details. (Choose two.)

What would you achieve by the above process?

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 […]

Which statement is true regarding the DELETE command?

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 […]

Which option of IMPDP would you use to accomplish this task?

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?

Which two statements are true?

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

Which two statements are true about the Automatic Database Diagnostic Monitor(ADDM)? (Choose two.)

Page 1 of 2612345...1020...Last »