You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again? (Choose two.)

• A.Increase the value of the ASM_POWER_LIMIT parameter.
• B.Set the DISK_REPAIR_TIME disk attribute to a lower value.
• C.Specify the statement that adds the disk back to the disk group.
• D.Increase the number of ASMB processes.
• E.Increase the number of DBWR_IO_SLAVES in the ASM instance.

Comment: *

Name: *

Email: *

Verification: *

In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true?

• A.The MYTAB table is owned by the SYS user.
• B.The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota
  on the SYSTEM tablespace by default.
• C.The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.
• D.The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.
• E.The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.

Comment: *

Name: *

Email: *

Verification: *

Examine these steps:
CONNECT / AS SYSDBA
CREATE DIRECTORY dumpdir AS '/u01/app/';
Directory created.
GRANT READ, WRITE ON DIRECTORY dumpdir TO PUBLIC;
Grant succeeded.
CREATE USER TEST IDENTIFIED BY test;
User created.
GRANT CREATE SESSION, RESOURCE, UNLIMITED TABLESPACE TO test;
Grant succeeded.
CONN test/test
Connected.
CREATE TABLE test_employees (id NUMBER(3), name VARCHAR2(20), salary NUMBER(7)); Table created.
SQL> CREATE SYNONYM emp FOR test_employees;
Synonym created.
Now examine this command:
$ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp CONTENT=data_only query='EMP:"WHERE salary=12000"' What is true about the execution of this command?

• A.It throws an error as Data Pump cannot find a table called TEST.EMP.
• B.It throws an error as the table test_employees is empty and CONTENT=data_only is specified.
• C.It throws an error as the QUERY parameter is not supported on an empty table.
• D.It performs the export successfully.

Comment: *

Name: *

Email: *

Verification: *

Which two categories of segments are analyzed by the Automatic Segment Advisor?

• A.segments in tablespaces that have exceeded a critical or warning space threshold
• B.segments that have the highest growth rate in a database
• C.segments that are sparsely populated and have more than 10% of free space below the high water mark.
• D.segments that have unusable indexes
• E.segments for tables created usingADVANCED ROW COMPRESSION

Comment: *

Name: *

Email: *

Verification: *

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and
SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

• A.All users except SYS
• B.All users except SCOTT
• C.All users except sys and SCOTT
• D.All users except sys, system, and SCOTT

Comment: *

Name: *

Email: *

Verification: *