Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 121:

  Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)

  A. You can load data into multiple tables during the same load session
  B. You can load data from multiple files to a table during the same load session
  C. You cannot perform selective data loading based on the values available in the records
  D. You can use an export file generated by the EXPDP utility as an input data file to load the data
  E. You can load data only if the input file is available on the disk and tape but not a named pipes
  A. You can load data into multiple tables during the same load session
  B. You can load data from multiple files to a table during the same load session

• Question 122:

  Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users to work with the database simultaneously. Some users of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. As a DBA, which configuration would you set to support more than 1,500 connections at a time?

  A. You would configure more listeners for the database.
  B. You would configure the database in shared server mode to use the connection pooling feature.
  C. You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
  D. You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
  B. You would configure the database in shared server mode to use the connection pooling feature.

• Question 123:

  You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name. Which statement is true in this case?

  A. The ORACLE_BASE parameter is not set.
  B. The installation is being performed by the root user.
  C. The operating system group that will be specified should have root user as its member.
  D. The installation is being performed without the "Create Starter Database" option selected.
  E. The operating system group that will be specified must have permission to write to the inventory directory.
  E. The operating system group that will be specified must have permission to write to the inventory directory.

• Question 124:

  You are managing an Oracle Database 11g database with the following backup strategy:

  1.

  On Sunday, an incremental level 0 tape backup is performed

  2.

  Monday through Saturday, a cumulative incremental level 1 tape backup is performed Which two statements are true regarding the backups performed? (Choose two.)

  A. The backup performed in step 1 backs up all blocks that have ever been in use in the database
  B. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup
  C. The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup
  D. The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1
  A. The backup performed in step 1 backs up all blocks that have ever been in use in the database
  B. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup

• Question 125:

  You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.

  Which three statements are true about these backups? (Choose three.)

  A. The backups would be consistent.
  B. The backups would be inconsistent.
  C. The backups would be possible only if the database is running in ARCHIVELOG mode.
  D. The backups would be possible only if the database is running in NOARCHIVELOG mode.
  E. The backups need to be restored and the database has to be recovered in case of a media failure.
  B. The backups would be inconsistent.
  C. The backups would be possible only if the database is running in ARCHIVELOG mode.
  E. The backups need to be restored and the database has to be recovered in case of a media failure.

• Question 126:

  database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server: $ impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr

  flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')" The command fails displaying the following error: ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA- 27037: unable to obtain file status What would you do to overcome the error?

  A. Add the user, SYSTEM, to the schemas option.
  B. Add the network_link = devdb.us.oracle.com option.
  C. Change the dumpfile option to [email protected].
  D. Replace the schemas option with the network_link = devdb.us.oracle.com
  E. Replace the dumpfile option with the network_link = devdb.us.oracle.com
  E. Replace the dumpfile option with the network_link = devdb.us.oracle.com

• Question 127:

  View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:

  SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US

  FROM v$memory_dynamic_components

  WHERE current_size!=0;

  What do you infer from this?

  Exhibit:

  A. The database instance is running with manual PGA management.
  B. The database instance is running with manual shared memory management.
  C. The database instance has the MEMORY_TARGET value set to a nonzero value.
  D. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.
  C. The database instance has the MEMORY_TARGET value set to a nonzero value.

• Question 128:

  You have decided to implement the principle of least privilege and separation of duties. Which two actions must you take? (Choose two.)

  A. Assign different O/S groups to the OSOPER and OSDBA credentials
  B. Grant SYSOPER to application schema owners
  C. Assign the OSOPER and OSDBA groups to the Oracle software owner O/S account
  D. Assign the DBA role to application schema owners
  E. Grant access to the Oracle software owner O/S account to all database administrators
  A. Assign different O/S groups to the OSOPER and OSDBA credentials
  D. Assign the DBA role to application schema owners

• Question 129:

  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
  D. Recovery Manager (RMAN) script

• Question 130:

  View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users in the last one hour. The undo tablespace NDOTBS1 is full with transactions and no

  transaction was committed more than one hour ago. The database has two more undo tablespaces.

  What happens to the new DML operations in this scenario?

  Exhibit:

  

  A. The DML commands will fail
  B. The undo data generated by the DML is stored in one of the two other undo tablespace
  C. The undo data generated by the DML will overwrite the extents that contain committed undo data
  D. The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace
  A. The DML commands will fail