1Z0-052 Exam Questions

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

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs...

Examine the command: SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false'); Which statement describes the effect of the above command?

The database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You h...

Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the...

Note the following points describing various utilities in Oracle Database 11g: 1. It enables the high-speed transfer of data from one database to another 2. It provides a complete...

You have an ORDERS table with the following structure: Name Null? Type ----------- -------- ------------------ OID NUMBER(6) ODATE DATE CCODE NUMBER(6) OAMT NUMBER(10,2) The table...

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the...

You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statisti...

Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity...

View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table: SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005'; Before...

Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

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

Note the following structures in your database server: 1. Extents 2. OS Blocks 3. Tablespace 4. Segments 5. Oracle Data Block Which option has the correct arrangement of these stru...

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

Which three operations require undo data? (Choose three.)

Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)

Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

Which statement is true about the Manageability Monitor (MMON) background process?

Which two statements are true regarding transactions in an Oracle database? (Choose two.)

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to...

Given below is a list of scenarios: 1. A user terminates his session abnormally. 2. The connection between the server and the client application terminates because of a network fai...

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...

Which two statements are true regarding B-tree index? (Choose two.)

In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the SALES table during the last fe...

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...

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 installatio...

View the Exhibit and examine the output of the query. What do you infer from this?

View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener? (Choose two.)

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the following error after the INSERT statement is issued and few rows are inserted: INSERT...

Some non-DBA users in your database have been granted ANY TABLE system privileges and they are able to access data dictionary base tables. You decide to restrict their access to da...

The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server: Which statement is true regardin...

In your database, the current status of a PL/SQL procedure has become INVALID. Which action would fix the problem and make the PL/SQL procedure usable?

In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)

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 sim...

Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)

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 o...

These are points that describe the contents of different memory components: 1: Descriptive information or metadata about schema objects that are queried by using SQL statements 2:...

Examine the commands executed in the following sequence: Which statement is true about the above commands?

Which statement is true about loading data using the conventional path of SQL*Loader?

Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

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...

You want to configure and schedule offline database backups to run automatically. Which tool or utility would you use to achieve this?

Which two statements are true regarding undo tablespaces? (Choose two.)

Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy...

User SCOTT wants to export his objects using Oracle Data Pump and executes the following command: $ expdp scott/tiger directory = EXPORT_DIR dumpfile = scott.dmp include = table in...

When you try to open your database, you receive the following error: ORA-00205: error in identifying controlfile Where would you find the details required to resolve this error?

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database file...

You specified extent management as local for a tablespace. How will it affect space management in the tablespace?