Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 211:

  View the Exhibit and examine the output of the query.

  

  What do you infer from this?

  A. The SGA_TARGET is a static parameter.
  B. The instance is started, but the database is not yet open.
  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.
  C. The server parameter file (SPFILE) was used to start the instance.

• Question 212:

  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. 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
  B. The MTTR advisor will be disabled
  C. Automatic checkpoint tuning will be disabled

• Question 213:

  You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks. Which two actions could you take to prevent this locking problem in the future? (Choose two.)

  A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
  B. Use Database Resource Manager to automatically log out sessions that block others and are idle
  C. Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
  D. Decrease the maximum number of interested transaction list (ITL) slots for the segments on which the blocking user performs the transaction.
  A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
  B. Use Database Resource Manager to automatically log out sessions that block others and are idle

• Question 214:

  Which three are true about dynamic performance views? (Choose three.)

  A. Read consistency is not guaranteed for these views
  B. Some of them display data that is useful for SQL statement tuning
  C. They display selected data from data dictionary base tables
  D. They can be queried only by SYS even when the database is open
  E. They contain information that is not available in data dictionary views
  A. Read consistency is not guaranteed for these views
  D. They can be queried only by SYS even when the database is open
  E. They contain information that is not available in data dictionary views

• Question 215:

  You want to install an Oracle 11g database and deploy it on ASM. Your plan is to install both Oracle database and Grid Infrastructure. Which two are true in this scenario? (Choose two.)

  A. Grid Infrastructure must be installed first
  B. Both products must be installed by the same OS user
  C. Each product must be installed in a different ORACLE_HOME
  D. Both products must be installed by using the same ORACLE_BASE
  E. Both products must be of the same version
  F. Both products can share the OS group assigned to their OSDBA and OSOPER privileged groups
  C. Each product must be installed in a different ORACLE_HOME
  F. Both products can share the OS group assigned to their OSDBA and OSOPER privileged groups

• Question 216:

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

  A. They can be stored in Oracle Automatic Storage Management File System (Oracle ACFS)
  B. They can always be updated using SQL
  C. They have extents
  D. They support the ORACLE_DATAPUMP access driver.
  E. They support all DML operations.
  B. They can always be updated using SQL
  D. They support the ORACLE_DATAPUMP access driver.

• Question 217:

  Table EMP resides in the USERS tablespace.

  Examine this command:

  SQL> DROP TABLE emp PURGE;

  Which two methods would you use to recover EMP? (Choose two.)

  A. Flashback Transaction Backout
  B. re-creating the table and reinserting the rows
  C. Flashback Drop
  D. Flashback Table
  E. performing a tablespace point in time recovery of USERS
  B. re-creating the table and reinserting the rows
  E. performing a tablespace point in time recovery of USERS

• Question 218:

  Which four are true about the tools used to administer Oracle databases? (Choose four.)

  A. SQL *Plus can be used to create databases
  B. DBCA can be used to upgrade databases
  C. RMAN can be used to start up Oracle instances
  D. SQL *Plus can be used to start up Oracle instances
  E. SRVCTL can be used to shut down Oracle instances
  F. Data Pump can be used to load data from text files
  A. SQL *Plus can be used to create databases
  B. DBCA can be used to upgrade databases
  C. RMAN can be used to start up Oracle instances
  D. SQL *Plus can be used to start up Oracle instances

• Question 219:

  You are installing Oracle Database 11g on a machine. When you run the installer, the Universal Installer (OUI) shows the message that says one of the product-specific prerequisite checks has failed:

  Checking available swap space requirements ...

  Expected result: 1512MB

  Actual Result: 1018MB

  Check complete. The overall result of this check is: Failed <<<< Problem: The system does not have the required swap space.

  What happens to the installation in this situation?

  A. It can be continued.
  B. It resizes the swap space automatically when you proceed further.
  C. It can be continued, but the instance cannot be started without increasing the swap space.
  D. It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed.
  A. It can be continued.

• Question 220:

  View the Exhibit1, which shows the options that are selected to create the user SL_REP. View the Exhibit2 and examine the contents of DATABASE_PROPERTIES.

  Which two statements are true regarding this user? (Choose two.) Exhibit1 (exhibit):

  

  Exhibit2 (exhibit):

  

  A. The user is authenticated by the operating system.
  B. The objects created by the user are placed in the USERS tablespace.
  C. The user does not require quota on the TEMP tablespace to perform sort operations.
  D. The user is forced to change the password at the first login to the database instance.
  E. The objects created by the user in future are unlocked to be accessed by all the users in the database by default.
  B. The objects created by the user are placed in the USERS tablespace.
  C. The user does not require quota on the TEMP tablespace to perform sort operations.