Oracle 1Z0-052 Free Practice Questions

Q1. View the Exhibit and examine the setting for a table.

Which statement is true about the PCTFREE setting for the table?

A. It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.

B. It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.

C. It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.

D. It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.

View Answer

Q2. Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

A. Shared SQL Area will be allocated in the shared pool

B. Shared SQL Area will be allocated when a session starts

C. Shared SQL Area will be allocated in the large pool always

D. The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always

E. Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool

F. The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter

View Answer

Q3. Identify two situations in which the block header grows in a data block. (Choose two.)

A. When row directories need more row entries

B. When there is row migration in the data block

C. When there is an increase in the PCTFREE value for the data block

D. When more transaction slots are required than are initially configured

View Answer

Q4. You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.

View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file?

A. ORACLE_HOME/dbs

B. ORACEL_HOME/rdbms

C. /u01/app/oracle/admin/orcl/adump

D. /u01/app/oracle/flash_recovery_area

E. ORACLE_BASE/diag/rdbms/orcl/alert

F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace

View Answer

Q5. View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:

A. init.ora

B. spfile.ora

C. initorcl.ora

D. spfile+ASM.ora

View Answer

Q6. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

A. The ADDM requires at least four AWR snapshots for analysis

B. The ADDM runs after each AWR snapshot is collected automatically by MMON

C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

D. The ADDM analysis provides only diagnostics information but does not provide recommendations

E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors

View Answer

Q7. Identify the two situations in which the alert log file is updated with details. (Choose two.)

A. Running a query on a table returns "ORA-600: Internal Error"

B. Inserting a value in a table returns "ORA-01722: Invalid Number"

C. Creating a table returns "ORA-00955: name is already used by an existing object'

D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."

E. Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file # 14, block @ 50)."

F. Rebuilding an index using ALTER INDEX .... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file #14, block #50)."

View Answer

Q8. Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)

A. when the tablespace is online

B. when the tablespace has segments with data in it

C. when the tablespace is a default permanent tablespace for the database

D. when the tablespace contains a table that is currently being used by transactions

E. when the tablespace contains undo data that is needed to rollback an uncommitted transaction

View Answer

Q9. You executed the following command to create a tablespace called SALES_DATA:

SQL> CREATE TABLESPACE sales_data

DATAFILE SIZE 100M

SEGMENT SPACE MANAGEMENT AUTO;

Which two statements are true about the SALES_DATA tablespace? (Choose two)

A. The database automatically determines the extent-sizing policy for the tablespace.

B. The segments are automatically shrunk when the contents are removed from them.

C. The allocation of extents within the tablespace is managed through the dictionary tables.

D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.

E. The space utilization description of the data blocks in segments is managed through free lists.

View Answer

Q10. You are using Enterprise Manager to schedule backups for your database.

Which type of script would be generated by the backup scheduler?

A. XML script

B. PL/SQL script

C. Operating system script

D. Recovery Manager (RMAN) script

View Answer

Q11. The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:

1. Shut down the instance, if not already done.

2. Copy one of the remaining control files to a new location.

3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.

4. Start up the database instance to the NOMOUNT stage.

5. Recover the database to the point of failure of the control file.

6. Open the database.

Identify the correct sequence of steps?

Exhibit:

A. 1, 2, 4, 3, 5, 6

B. 2, 4, 3, 5, 6; 1 not required

C. 4, 5, 6, 2, 3; 1 not required

D. 5, 2, 3, 4; 1 and 6 not required

View Answer

Q12. 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. Online and archived redo files are required to accomplish instance recovery

C. All redo log entries after the last checkpoint are applied from redo log files to data files

D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

View Answer

Q13. You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)

A. Flashback log files

B. Backups that have become obsolete

C. User managed backups of the data files and control files

D. Archived redo log files that have multiple copies in a different archive location and not backed up

View Answer

Q14. View the Exhibit to examine the details for an incident.

Which statement is true regarding the status of the incident?

A. The DBA is working on the incident and prefers that the incident be kept in the ADR

B. The incident is now in the Done state and the ADR can select the incident to be purged

C. The incident has been newly created and is in the process of collecting diagnostic information

D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support

View Answer

Q15. View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respectively. Why are advisors not available for the shared pool and the buffer cache?

A. because the DB_CACHE_ADVICE parameter is set to OFF

B. because Automatic Memory Management (AMM) is disabled for the database instance

C. because Automatic Shared Memory Management (ASMM) is enabled for the database instance

D. because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not set initially

View Answer