Free Oracle 1Z1-052 Practice Test & Real Exam Questions

Which two statements are true regarding a PL/SQL package body? (Choose two.)

Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

You plan to install Oracle Grid Infrastructure and Oracle Database
Which two mandatory tasks must be completed before you perform these installations?
(Choose two.)

You have executed this command to change the size of the database buffer cache:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;
System altered.
To verify the change in size, you executed this command:

Why is the value set to 4194304 and not to 2516582?

Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the previous day. Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.)

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;
Which two statements are true about the effect of the command? (Choose two.)

Which two events always cause the LGWR to write? (Choose two.)

View the Exhibit and examine the setting for a table.

Which statement is true about the PCTFREE setting for the table?

For which database operation would you need the database to be in the MOUNT state?

SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)