Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 51:

  Which is true about the SYSTEM and SYSAUX tablespaces?

  A. Both tablespaces can be used for temporary storage if no temporary tablespace is defined
  B. Both tablespaces must be online for a database to be accessible
  C. The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot
  D. Only the SYSTEM tablespace contains data dictionary tables
  C. The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot

• Question 52:

  Which two statements are true about standard database auditing? (Choose two.)

  A. DDL statements can be audited.
  B. Statements that refer to standalone procedure can be audited.
  C. Operations by the users logged on as SYSDBA cannot be audited.
  D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.
  A. DDL statements can be audited.
  B. Statements that refer to standalone procedure can be audited.

• Question 53:

  Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)

  A. An SPFILE is a binary file
  B. An SPFILE cannot reside on a client
  C. An SPFILE cannot contain static parameters
  D. An SPFILE can store changes persistently across instance restarts
  E. An SPFILE can be read by the database server, but it is not written to by the server
  F. An SPFILE must be created manually, before creating a database, even if you use the Database Configuration Assistant (DBCA) to create the database
  A. An SPFILE is a binary file
  B. An SPFILE cannot reside on a client
  D. An SPFILE can store changes persistently across instance restarts

• Question 54:

  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
  A. When row directories need more row entries
  D. When more transaction slots are required than are initially configured

• Question 55:

  Your database is open in ARCHIVELOG mode.

  LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is 100% full when a log switch takes place.

  What is the outcome?

  A. The archivelog entries are made in the diagnostic destination and when space is available, new archivelogs are generated
  B. Obsolete backups are automatically deleted and new archivelogs are generated
  C. All active sessions hang until the database administrator (DBA) makes space available in the FRA
  D. No archivelogs are generated
  E. All active sessions are disconnected and their transactions rolled back
  B. Obsolete backups are automatically deleted and new archivelogs are generated

• Question 56:

  View the Exhibit and examine the privileges granted to the SL_REP user.

  

  The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command?

  A. The command executes successfully
  B. The command produces an error because the EMP table is owned by SCOTT
  C. The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION
  D. The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table
  A. The command executes successfully

• Question 57:

  A database instance was terminated due to a lost data file and has not been restarted. You wish to restore database availability by using the Data Recovery Advisor. Examine this list of RMAN commands:

  

  What are the minimum required commands and in what order must they be executed to achieve this?

  A. 1, 2, 3, 4, and 5
  B. 1 and 4
  C. 1, 2, 3, and 4
  D. 1, 3, and 4
  E. 1, 3, 4, and 5
  D. 1, 3, and 4

• Question 58:

  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.
  A. The database automatically determines the extent-sizing policy for the tablespace.
  D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.

• Question 59:

  Which two are true about AWR snapshots? (Choose two.)

  A. They are always created automatically.
  B. They can be modified by using DMLs.
  C. They are not generated if STATISTICS_LEVEL is set to TYPICAL.
  D. They are stored in the SYSAUX tablespace.
  E. They can be retained forever.
  A. They are always created automatically.
  B. They can be modified by using DMLs.

• Question 60:

  In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement.

  What would you do to automate this configuration for the memory components with change in mode of working?

  A. Set the SGA_TARGET initialization parameter to zero.
  B. Set the PRE_PAGE_SGA initialization parameter to TRUE.
  C. Set the MEMORY_MAX_TARGET initialization parameter to zero.
  D. Set the SGA_TARGET initialization parameter to a nonzero value.
  D. Set the SGA_TARGET initialization parameter to a nonzero value.