Latest Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion, Page 10

Question #100

Examine the following statement that is used to modify the primary key constraint on the SALES table:
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;
Which three statements are true regarding the above command? (Choose three.)

A. It allows the loading of data into the table using SQL *Loader.

B. The constraint remains valid.

C. The index on the constraint is dropped.

D. New data conforms to the constraint, but existing data is not checked.

E. It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

Discussion 0

Correct Answer: A,B,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #101

You executed the following command to create a tablespace called SALES_DATA:
SQL> CREATE TABLESPACE sales_data
DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES_DATA tablespace? (Choose two)

A. The database automatically determines the extent-sizing policy for the tablespace.

B. The space utilization description of the data blocks in segments is managed through free lists.

C. The allocation of extents within the tablespace is managed through the dictionary tables.

D. The segments are automatically shrunk when the contents are removed from them.

E. The space utilization description of the data blocks in segments is recorded in bitmap blocks.

Discussion 0

Correct Answer: A,E Vote an answer

Question #102

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

A. The ADDM calls other advisors if required, but does not provide recommendations about the advisors

B. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

C. The ADDM requires at least four AWR snapshots for analysis

D. The ADDM analysis provides only diagnostics information but does not provide recommendations

E. The ADDM runs after each AWR snapshot is collected automatically by MMON

Discussion 0

Correct Answer: B,E Vote an answer

Question #103

You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value.
Which action would help to use the previous set of statistics on the objects?

A. Restore statistics from statistics history.

B. Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.

C. Reduce the Automatic Workload Repository (AWR) retention period by 2 days.

D. Reduce the optimizer statistics retention period by 2 days.

Discussion 0

Correct Answer: A Vote an answer

Question #104

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?

A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT

B. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

C. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully

D. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

E. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

Discussion 0

Correct Answer: B Vote an answer

Question #105

A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

Which are the two possible solutions to enable SMITH to query the data in V$SESSION?
(Choose two.)

A. granting SELECT privilege to SMITH on V_$SESSION

B. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE

C. granting SELECT privilege to SMITH on V$SESSION

D. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

E. granting SELECT privilege to SMITH on V$FIXED_TABLES

F. asking the user SMITH to run the catalog.sql script

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #106

A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.
What are the two effects of this command? (Choose two.)

A. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.

B. It enables the constraint to be enforced at the end of each transaction.

C. It does not validate the existing data in the table.

D. It fails if any existing row violates the constraint.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #107

You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

A. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

B. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

C. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

D. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

Discussion 0

Correct Answer: B Vote an answer

Question #108

Which two statements are true about standard database auditing? (Choose two.)

A. Statements that refer to standalone procedure can be audited.

B. Operations by the users logged on as SYSDBA cannot be audited.

C. DDL statements can be audited.

D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

Discussion 0

Correct Answer: A,C Vote an answer

Question #109

Which action is automatically performed as part of the Incident Packaging Service in Enterprise Manager Support Workbench?

A. invoking the Data Recovery Advisor and SQL Repair Advisor

B. Creating a service request with My Oracle Support

C. invoking the SQL Test Case Builder

D. gathering metadata from the Automatic Diagnostic Repository (ADR)

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #110

The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?

A. Inactive and current redo log files are required to accomplish recovery

B. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

C. All redo log entries after the last checkpoint are applied from redo log files to data files

D. Online and archived redo files are required to accomplish instance recovery

Discussion 0

Correct Answer: C Vote an answer

Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z0-052 Demo