QUESTION NO: 1
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
QUESTION NO: 2
You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.)
A. Disable automatic checkpoint tuning.
B. Check the size of the redo log file size and increase the size if it is small.
C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group.
Answer: B,C
QUESTION NO: 3
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?
A. host naming method
B. local naming method
C. external naming method
D. directory naming method
Answer: B
QUESTION NO: 4
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 wasdisabled. What are the two effects of this command? (Choose two.)
A. It fails if any existing row violates the constraint.
B. It does not validate the existing data in the table.
C. It enables the constraint to be enforced at the end of each transaction.
D. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
Answer: A,D
QUESTION NO: 5
Examine the commands executed in a DBA session: SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ‘/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Tablespace created.SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered. Which two statements are true regarding the MRKT tablespace? (Choose two.)
A. No more data files can be added to the tablespace.
B. Segment space is managed by free lists in the tablespace.
C. A user created without being assigned a default tablespace uses this tablespace.
D. The tablespace can be dropped with the current setting with segments present in it.
Answer: A,C
QUESTION NO: 6
Automatic Shared Memory Management (ASMM) has been enabled for your database instance.The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario?
A. The minimum memory size for the database buffer cache is set to 100 MB.
B. The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.
C. The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.
D. The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.
Answer: A
QUESTION NO: 8
Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0
Which two will be the implications of these values in your database?(Choose two.)
A. The SGA advisor will be disabled.
B. The MTTR advisor will be disabled.
C. Automatic checkpoint tuning will be disabled.
D. Checkpoint information will not be written to the alert log file.
Answer: B,C
QUESTION NO: 9
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. Whatis the impact of this setting?
A. Optimizer statistics are collected automatically.
B. Only timed operating system (OS) statistics and plan execution statistics are collected.
C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
Answer: C
QUESTION NO: 10
You executed this command to create a temporary table:
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ROWS;Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?
A. The rows stay in the table only until session termination.
B. The rows stay in the table only until the next transaction starts on the table.
C. The rows are visible to all current sessions after the transaction is committed.
D. The rows stay available for subsequent sessions after the transaction is committed.
Answer: A
Oracle 1z0-052 Database 