We guarantee that you will also certainly pass the true exam without any difficulties. 100% passing assure is not hollow words and phrases. However, in case you really dont find through the Oracle true certification exam, no matter what? explanation, we offer you full cash back from the paying fees. No questions asked!

2021 Dec 1Z0-052 free question

Q51. Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)

A. The MTTR advisor will be disabled

B. Automatic checkpoint tuning will be enabled

C. The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET

D. The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter

Answer: BC


Q52. For which database operation would you need the database to be in the MOUNT state?

A. Renaming the control files

B. Re-creating the control files

C. Dropping a user in your database

D. Dropping a tablespace in your database

E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

Answer: E


Q53. Examine the commands executed in the following sequence:

Which statement is true about the above commands?

A. The commands execute successfully.

B. Command 6 produces an error because of circular role grant.

C. Command 5 produces an error because a role cannot be granted to another role.

D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.

E. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

Answer: B


Q54. 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 and 2

B. 2 and 5

C. 1,3, and 4

D. 3,4 and 5

E. 1,2,3 and 4

Answer: C


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

A. Avoid coding unnecessary longrunning transactions.

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

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

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

Answer: AB


Up to date 1Z0-052 rapidshare:

Q56. 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 generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

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

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

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

Answer: C


Q57. Note the following points describing various utilities in Oracle Database 11g:

1. It enables the high-speed transfer of data from one database to another

2. It provides a complete solution for the backup, restoration and recovery needs of the entire database

3. It enables the loading of data from an external file into table of an Oracle Database

4. It provides a tape backup management for the Oracle ecosystem

Which point describes Oracle Secure Backup?

A. 1

B. 2

C. 3

D. 4

E. 1,2 and 4

F. 1,2,3, and 4

Answer: D


Q58. You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:

Warning (%): 90

Critical (%): 95

Which background process is responsible for issuing alerts when the threshold is crossed?

A. System monitor (SMON)

B. Process monitor (PMON)

C. Memory manager process (MMAN)

D. Manageability Monitor process (MMON)

Answer: D


Q59. 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?

A. It records usernames and passwords of users when granted the DBA role

B. It contains usernames and passwords of users for whom auditing is enabled

C. It is used by Oracle to authenticate users for remote database administrator

D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

Answer: C


Q60. Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?

A. An update in a leaf row takes place.

B. The index becomes invalid after the update.

C. The leaf block containing the row to be updated is marked as invalid.

D. A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.

Answer: D