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

Question #23

Which two are true about Optimizer Statistics? (Choose two.)

A. They are gathered by the Manageability Monitor (MMON) background process

B. They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package

C. They can be used to determine the events on which a database instance waited

D. They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements

E. They are automatically updated when DDL statements execute

F. They do not persist across instance restarts

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #24

Which two are true about external tables? (Choose two.)

A. They can always be updated using SQL

B. They support the ORACLE_DATAPUMP access driver.

C. They can be stored in Oracle Automatic Storage Management File System (Oracle ACFS)

D. They support all DML operations.

E. They have extents

Discussion 0

Correct Answer: A,B Vote an answer

Question #25

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 leaf block containing the row to be updated is marked as invalid.

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

D. The index becomes invalid after the update.

Discussion 0

Correct Answer: C Vote an answer

Question #26

Examine these facts about a database:
* The database default tablespace is USERS
* DEFERRED_SEGMENT_CREATION IS TRUE
* The default tablespace of USER1 is tbs1
* USER1 has only these privileges:
* CREATE SESSION
* CREATE TABLE
* UNLIMITED quota on tbs1
Examine these commands executed by USER1:

What will be the outcome of the INSERT operation and why?

A. It will fail because USER1 has no quota on USERS

B. A row will be inserted into EMP but no index entry will be made into EMP_IDX

C. A row will be inserted into EMP and an index entry will be made into EMP_IDX

D. A row will be inserted into EMP and an index entry will be inserted into a virtual column of EMP because USER1 has no quota on USERS

E. It will fail because an indexed column cannot have NULL values

Discussion 0

Correct Answer: C Vote an answer

Question #27

Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)

A. Checkpoint information will not be written to the alert log file

B. Automatic checkpoint tuning will be disabled

C. The MTTR advisor will be disabled

D. The SGA advisor will be disabled

Discussion 0

Correct Answer: B,C Vote an answer

Question #28

View the Exhibit.

You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled.
What could be the reason for this?

A. The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).

B. You are using General Purpose template and not the Custom Database template to create the database.

C. You have chosen the File System option as the storage option.

D. You have chosen the Automatic Storage Management (ASM) as the storage option.

Discussion 0

Correct Answer: B Vote an answer

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

Question #29

Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;
What would be the outcome of this command?

A. The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).

B. The command succeeds, but you need to restart the database for changes to take effect.

C. The command succeeds only if Automatic Memory Management is not enabled.

D. The command returns an error because the size of the redo log buffer cannot be changed dynamically.

Discussion 0

Correct Answer: D Vote an answer

Question #30

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

A. The archived redo log files are missing for which the backup is not available

B. The database files are corrupted when the database is open

C. The user has dropped an important table that needs to be recovered

D. The database is not opening because the required database files are missing

Discussion 0

Correct Answer: B,D Vote an answer

Question #31

You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

A. Set the TIMED_STATISTICS parameter to TRUE.

B. Change STALE_PERCENT to zero for the tables.

C. Set the STATISTICS_LEVEL parameter to BASIC.

D. Lock statistics for the tables.

E. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

Discussion 0

Correct Answer: D Vote an answer

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

Question #32

You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).
You select the "Install and Configure Grid Infrastructure for a Standalone Server' option.
Which task is performed by OUI as part of this installation?

A. creation of an ASM disk group and registration of ASM components with Oracle Restart

B. creation of privileged operating system group that are used for OS authentication.

C. creation of a general purpose database

D. creation and configuration of Enterprise Managed Cloud Control on the server

Discussion 0

Correct Answer: A Vote an answer

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

Question #33

View the Exhibit and examine the output of the query.

What do you infer from this?

A. The instance is started, but the database is not yet open.

B. The SGA_TARGET is a static parameter.

C. The server parameter file (SPFILE) was used to start the instance.

D. The SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE parameter is specified.

Discussion 0

Correct Answer: C Vote an answer

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

Download Free Oracle 1Z0-052 Demo