Free Oracle 1Z0-050 Exam Dumps Questions & Answers

View the Exhibit for some of the parameter settings.

You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename)
TABLESPACE users INVISIBLE;
What is the outcome of the above command?

• A.  The index is not used by the optimizer and is not maintained during DML operations.
• B.  The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.
• C.  The index is not used by the optimizer but is maintained during DML operations.
• D.  The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.

You want to perform the following operations for the DATA ASM disk group:
-Verify the consistency of the disk.
-Cross-check all the file extent maps and allocation tables for consistency. -Check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?

• A.  ALTER DISKGROUP data CHECK DISK;
• B.  ALTER DISKGROUP data CHECK;
• C.  ALTER DISKGROUP data CHECK FILE;
• D.  ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)

• A.  A single ADR can support multiple ADR homes for different database instances.
• B.  The alert files are stored in XML file format in the TRACE directory of each ADR home.
• C.  The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.
• D.  If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.

In which two aspects does hot patching differ from conventional patching? (Choose two.)

• A.  It can be installed and uninstalled via OPatch unlike conventional patching.
• B.  It does not require down time to apply or remove unlike conventional patching.
• C.  It consumes more memory compared with conventional patching.
• D.  It is not persistent across instance startup and shutdown unlike conventional patching.
• E.  It takes more time to install or uninstall compared with conventional patching.

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

• A.  The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
• B.  The data remains encrypted when it is read into memory.
• C.  The data is decrypted during SORT and JOIN operations.
• D.  The data remains encrypted when it is stored in the redo logs.