Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion
Which command is used to display files that no longer conform to the backup retention policy?
Correct Answer: A
Vote an answer
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.)
Correct Answer: A,D
Vote an answer
You executed this command to create a temporary table:
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (
startdate DATE,
enddate DATE,
class CHAR(20)
) ON COMMIT PRESERVE ROWS;
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (
startdate DATE,
enddate DATE,
class CHAR(20)
) ON COMMIT PRESERVE ROWS;
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?
Correct Answer: A
Vote an answer
Table EMP resides in the USERS tablespace.
Examine this command:
SQL> DROP TABLE emp PURGE;
Which two methods would you use to recover EMP? (Choose two.)
Examine this command:
SQL> DROP TABLE emp PURGE;
Which two methods would you use to recover EMP? (Choose two.)
Correct Answer: A,E
Vote an answer
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
Correct Answer: A,B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?
Correct Answer: A
Vote an answer
Which statement is true about loading data using the conventional path of SQL*Loader?
Correct Answer: E
Vote an answer
Which two are true about AWR snapshots? (Choose two.)
Correct Answer: A,C
Vote an answer
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?
View the Exhibit and check the commands executed.
What is the location of the alert_orcl.log file?
Correct Answer: F
Vote an answer
Your database is configured in archivelog mode.
The USERS01 tablespace is currently online.
You are required to take the tablespace offline.
Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?
The USERS01 tablespace is currently online.
You are required to take the tablespace offline.
Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You execute the following command to change the status of the SALES tablespace:
SQL> ALTER TABLESPACE sales OFFLINE;
Which statements describe the effect of the command? (Choose all that apply.)
SQL> ALTER TABLESPACE sales OFFLINE;
Which statements describe the effect of the command? (Choose all that apply.)
Correct Answer: B,D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
0
0
0
10