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

Question #34

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

Question #35

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock.
Which two statements are true regarding the session of SCOTT in this scenario? (Choose two.)

A. The session is rolled back after receiving the error and JIM can continue with his transaction.

B. SCOTT has to reexecute the last command in the transaction after he commits the transaction.

C. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

D. The session is terminated after receiving the error and JIM can continue with his transaction.

Discussion 0

Correct Answer: B,C Vote an answer

Question #36

You want to install an Oracle 11g database and deploy it on ASM.
Your plan is to install both Oracle database and Grid Infrastructure.
Which two are true in this scenario? (Choose two.)

A. Each product must be installed in a different ORACLE_HOME

B. Both products must be of the same version

C. Both products must be installed by the same OS user

D. Grid Infrastructure must be installed first

E. Both products can share the OS group assigned to their OSDBA and OSOPER privileged groups

F. Both products must be installed by using the same ORACLE_BASE

Discussion 0

Correct Answer: A,E Vote an answer

Question #37

Examine the following output:

Which two statements about the above index are true? (Choose two.)

A. It is not used while the index is being rebuilt.

B. The index cannot be rebuilt, and has to be re-created.

C. The index is automatically rebuilt when used the next time.

D. It is ignored by the query optimizer.

Discussion 0

Correct Answer: A,D Vote an answer

Question #38

View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the table. You decide to prepare an index on the ZONE column to enhance the performance of the queries on the ZONE column.
Which type of index would you select in this scenario?
Exhibit:

A. Normal BTree index

B. Reverse key index

C. Bitmap index

D. Functionbased index

Discussion 0

Correct Answer: C Vote an answer

Question #39

To make audit information more productive, the DBA executes the following command before starting an audit operations:
SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
Which statement is true regarding the audit record generated when auditing starts after restarting the database?

A. It contains the plan and statistics associated with the SQL statement executed by the user

B. It contains the SQL text executed by the user and the bind variables used with it

C. It contains the plan for the SQL statement executed by the user and the bind variables used with it

D. It contains only the plan for the SQL statement executed by the user

Discussion 0

Correct Answer: B Vote an answer

Question #40

Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What affect would this command have on the database?

A. The extents in the undo tablespace retain data until the next full database backup

B. The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down

C. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten

D. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes

Discussion 0

Correct Answer: D Vote an answer

Question #41

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;
Which two statements are true about the effect of the command? (Choose two.)

A. The ORDERS table is dropped along with the ITEM table.

B. No flashback is possible to bring back the ITEM table.

C. The dependent referential integrity constraints in the ORDERS table are removed.

D. The dependent referential integrity constraints in the ORDERS table are disabled.

E. The table definition of the ITEM table and associated indexes are placed in the recycle bin.

Discussion 0

Correct Answer: B,C Vote an answer

Question #42

You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task?

A. Configure the FAST_START_MTTR_TARGET initialization parameter.

B. Configure the database instance for ARCHIVELOG mode.

C. Configure the Flash Recovery Area.

D. Multiplex all database files.

Discussion 0

Correct Answer: B Vote an answer

Question #43

The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:

Which statement is true regarding the archived redo log files?

A. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location specified by the DB_RECOVERY_FILE_DEST parameter.

B. It will be created only in the flash recovery area (fast recovery area).

C. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs.

D. It will be created on the local file system in the location specified LOG_ARCHIVE_DEST_1 parameter.

Discussion 0

Correct Answer: D Vote an answer

Question #44

You want to create a role to meet these requirements:
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
Which method would you use to restrict enabling of such roles?

A. Create the role as a secure application role.

B. Create the role with external authentication.

C. Create a role and use Fine-Grained Access Control (FGAC) to secure the role.

D. Create the role as a password-protected role.

Discussion 0

Correct Answer: A Vote an answer

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

Download Free Oracle 1Z0-052 Demo