Online Access Free 1Z1-052 Practice Test

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

• A.It can be changed and recompiled without making the package specification invalid.
• B.It cannot invoke subprograms defined in other packages.
• C.It cannot be created without a package specification.
• D.It can contain only the subprograms defined in the package specification.

View the Exhibit. What would happen if Oracle Home is not empty?

• A.The installation will not be continued until the location is empty.
• B.The installation terminates automatically after showing an error message.
• C.The installation can be continued, but the existing files will be overwritten.
• D.The installation will proceed without overwriting the existing files.

Examine this LISTENER.ORA file:

How should you configure and start an additional listener LISTENER2 that listens for the same SID?

• A.Add relevant details in SID_LIST_LISTENER under the existing LISTENER in LISTENER.ORA
• B.Add relevant details in DESCRIPTION under the existing LISTENER with a different port number in LISTENER.ORA
• C.Create another configuration file called LISTENER2.ORA with only LISTENER2 details in it
• D.Add LISTENER2 and its SID_LIST details separately under the name LISTENER2 in LISTENER.ORA

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old
What could be the reason for this error?
Exhibit:

• A.There is not enough free space in the flashback archive.
• B.The query is unable to get a read-consistent image.
• C.There is not enough space in Flash Recovery Area.
• D.The query is unable to place data blocks in undo tablespace.

Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)

• A.The MTTR advisor will be disabled
• B.Checkpoint information will not be written to the alert log file
• C.The SGA advisor will be disabled
• D.Automatic checkpoint tuning will be disabled