Online Access Free 1Z0-052 Exam Questions

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

• A.it can be used by executing the PL/SQL procedures in the DBMS_ADDM package
• B.It improves database performance by automatically implementing Oracle's best practices
• C.It runs automatically after each Automatic Workload Repository snapshot is created
• D.It can assist the DBA in diagnosing database instance startup failures
• E.Its findings are accessible only by using Oracle Enterprise Manager
• F.It provides recommendations to improve database performance

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.
Which constraints will remain enabled by default during this operation? (Choose all that apply.)

• A.NOT NULL
• B.UNIQUE
• C.FOREIGN KEY
• D.PRIMARY KEY
• E.CHECK

USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.
USER1 executes these commands:

What will be the outcome and why?

• A.It will fail because there is an uncommitted transaction on USER1.EMP
• B.It will execute successfully and drop DEPT.DNO
• C.It will execute successfully and drop the DEPT.DNO and EMP.DNO columns
• D.It will fail because a referential integrity constraint is defined on USER1.EMP
• E.It will fail because there is an uncommitted transaction on USER1.DEPT

You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.
View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file?

• A./u01/app/oracle/admin/orcl/adump
• B.ORACLE_BASE/diag/rdbms/orcl/orcl/trace
• C.ORACLE_HOME/dbs
• D.ORACLE_BASE/diag/rdbms/orcl/alert
• E.ORACEL_HOME/rdbms
• F./u01/app/oracle/flash_recovery_area

These are points that describe the contents of different memory components:
1: Descriptive information or metadata about schema objects that are queried by using SQL statements
2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements
3 : Results of SQL queries and PL/SQL functions
4 : Executable forms of SQL cursors, PL/SQL programs, and Java classes
5 : The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in the Shared Pool if the necessary configurations are done?

• A.1,3, and 4
• B.1,2,3 and 4
• C.3,4 and 5
• D.2 and 5
• E.1 and 2