Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 181:

  In which of the scenario will the DBA perform recovery? (Choose all that apply.)

  A. The alert log file is corrupted
  B. A tablespace is accidentally dropped
  C. One of the redo log members is corrupted
  D. A database user terminates the session abnormally
  E. The hard disk on which the data files is stored is corrupted
  B. A tablespace is accidentally dropped
  E. The hard disk on which the data files is stored is corrupted

• Question 182:

  Examine these attributes for the profile assigned to USER1 whose password is oracle_4U. PASSWORD_REUSE_MAX IS 5 PASSWORD_REUSE_TIME IS 10 PASSWORD_GARCE_TIME IS 15

  Which two conditions must be met for USER1 to reuse oracle_4U? (Choose two.)

  A. At least 10 days must have passed since oracle_4U was last used
  B. The password must have changed 5 times since oracle_4U was last used
  C. At least 15 days must have passed since oracle_4U was last used
  D. At least 5 days must have passed since oracle_4U was last used
  E. The password must have changed 10 times since oracle_4U was last used
  C. At least 15 days must have passed since oracle_4U was last used
  E. The password must have changed 10 times since oracle_4U was last used

• Question 183:

  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
  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support

• Question 184:

  You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.

  What must this name be made up of?

  A. It must be made up of a database name and a domain name.
  B. It must be made up of the value in ORACLE_SID and HOSTNAME.
  C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.
  D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.
  A. It must be made up of a database name and a domain name.

• Question 185:

  A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?

  A. Set REMOTE_OS_ROLES to FALSE
  B. Set OS_ROLES parameter to FALSE
  C. Set the REMOTE_OS_AUTHENT parameter to FALSE
  D. Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE
  C. Set the REMOTE_OS_AUTHENT parameter to FALSE

• Question 186:

  Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

  A. You can add SQL test cases to the incident package.
  B. You can add or remove the trace files to the package.
  C. You cannot create an incremental incident package when the physical files are purged from the ADR.
  D. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
  A. You can add SQL test cases to the incident package.
  B. You can add or remove the trace files to the package.
  D. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

• Question 187:

  Which two statements are true regarding Oracle Data Pump? (Choose two.)

  A. EXPDP and IMPDP are the client components of Oracle Data Pump
  B. DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clients
  C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege
  D. Oracle Data Pump imports can be done from the export files generated in the Original Export Release 9.x
  E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands
  A. EXPDP and IMPDP are the client components of Oracle Data Pump
  B. DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clients

• Question 188:

  Which two statements about the background process of the database writer are true? (Choose two.)

  A. It is possible to have multiple database writers in an Oracle instance.
  B. It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
  C. It writes dirty buffers, if any, to data files whenever a transaction commits.
  D. It writes dirty buffers, if any, to data files before the log writer (LGWR) writes.
  A. It is possible to have multiple database writers in an Oracle instance.
  B. It writes dirty buffers, if any, to data files whenever a checkpoint occurs.

• Question 189:

  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.
  B. It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.

• Question 190:

  You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?

  A. FULL
  B. SCHEMAS
  C. TRANSFORM
  D. REMAP_SCHEMA
  E. REMAP_TABLESPACE
  D. REMAP_SCHEMA