Latest Oracle 1Z1-052 Actual Free Exam Questions & Community Discussion, Page 8

Question #99

Which two are true about consistent database backups? (Choose two.)

A. They can only be taken by using RMAN command.

B. They can only be taken by using RMAIN when the database is in MOUNT state.

C. They can only be taken when a RECOVERY CATALOG is used.

D. They can only be taken if a NORMAL, TRANSACTIONAL, OR IMMEDIATE shutdown has been performed and the backup is taken before the database is reopened.

E. They can only be taken if the database is in ARCHIVELOG mode.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #100

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

A. Failure due to loss of connectivity-for example, an unplugged disk cable

B. Failure because a data file is renamed accidentally

C. Failure when no standby database is configured

D. Failure that requires no archive logs to be applied for recovery

Discussion 0

Correct Answer: A,B Vote an answer

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

Question #101

You executed the following commands to find the location of the alert log file:

Where is the alert log file stored? (Choose all that apply.)

A. in the BACKGROUND_DUMP_DEST location; in XML format

B. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format

C. in the BACKGROUND_DUMP_DEST location; in text format

D. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format

E. in the BACKGROUND_DUMP_DEST location; in both text and XML format

F. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format

Discussion 0

Correct Answer: C,F Vote an answer

Question #102

You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)

A. Decrease the number of redo log members if there are more than one redo log members available in each redo log group

B. Disable automatic checkpoint tuning

C. Check the size of the redo log file size and increase the size if it is small

D. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor

Discussion 0

Correct Answer: C,D Vote an answer

Question #103

While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?

A. Deallocate the unused space in the index using the ALTER INDEX ... DEALLOCATE UNUSED command

B. Rebuild the index using the ALTER INDEX ..... REBUILD ONLINE command

C. Validate the index structure using the ANALYZE .... INDEX command

D. Change the block space utilization parameters using the ALTER INDEX command

Discussion 0

Correct Answer: B Vote an answer

Question #104

All the database users are presently connected to the database instance and working. The HR user has opened three database sessions and executed the following command in one of his sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
1 23 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executed the above commands.
Which sessions can see the effect of the UPDATE and DELETE commands?

A. The session of the HR user that executed the commands

B. All the sessions for which the database users have access privilege to the PERSONS table

C. All sessions of the HR user and the SYS user

D. All sessions of the HR user only

Discussion 0

Correct Answer: A Vote an answer

Question #105

Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)

A. Allow escalation of row locks to block locks if too many row locks cause problem.

B. Allow the database to handle locks in default locking mode.

C. Avoid coding unnecessary longrunning transactions.

D. Always explicitly code the locks as per the requirement of the application.

Discussion 0

Correct Answer: B,C Vote an answer

Question #106

Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)

A. Diagnose and repair a data file corruption online.

B. Diagnose and repair a data file corruption offline.

C. Diagnose and repair failures on a standby database.

D. Recover from failures in the RAC environment.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #107

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 dependent referential integrity constraints in the ORDERS table are removed

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

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

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

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

Discussion 0

Correct Answer: A,C Vote an answer

Question #108

You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)

A. The backups would be consistent.

B. The backups would be inconsistent.

C. The backups would be possible only if the database is running in ARCHIVELOG mode.

D. The backups need to be restored and the database has to be recovered in case of a media failure.

E. The backups would be possible only if the database is running in NOARCHIVELOG mode.

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question #109

You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.
What will be the implications on the archiving and the location of archive redo log files?

A. Archiving will be enabled and the destination for the archived redo log file will be set to the Flash Recovery Area implicitly

B. Archiving will be enabled and the location for the archive redo log file will be created in the default location $ORACLE_HOME/log

C. The database instance will shut down and the error details will be logged in the alert log file

D. Archiving will be disabled because the destination for the redo log files is missing

Discussion 0

Correct Answer: A Vote an answer

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

Question #110

What can you achieve by implementing reverse key index?

A. Reverse the bytes of each column indexed including the row ID

B. Store a bitmap for each key value instead of a list of row IDs in the leaf node

C. Remove repeated key values from the index to fit more index entries in a given amount of disk space

D. Prevent contention on the highest leaf block when using sequences to generate keys

Discussion 0

Correct Answer: D Vote an answer

Question #111

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 #112

Which is true about enabling AUTOEXTEND for data files?

A. It can be enabled for an existing data file in a tablespace by using the ALTER TABLESPACE command.

B. It can be enabled only for data files only in biglfile tablespaces.

C. It can be enabled for a new data file that is added to a tablespace only if the existing data files in that tablespace have autoextend enabled.

D. It can be enabled only for data files only in smallfile tablespaces.

E. It can be enabled only for data files in non-OMF tablespaces.

Discussion 0

Correct Answer: A Vote an answer

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

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

Download Free Oracle 1Z1-052 Demo