1Z0-052 Exam Questions

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command: SQL> SELECT reason,metric_value FROM dba_outstandin...

You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable...

In a new installation of Oracle Database 11g, you perform these activities: 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent n...

You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Fla...

All the database users are presently connected to the database instance and working. The HR user has opened three database sessions and executed the following command in one of his...

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that perfor...

The user HR receives the following error while inserting data into the TTK table: ERROR at line 1: ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigat...

Which two statements are true about checkpointing? (Choose two.)

Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

View the Exhibit. You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose database and during the databa...

Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you...

Which of these is true about undo tablespace?

Your database is in shutdown state. What will happend if you issue next command: SQL> startup

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

View Exhibit to examine the current memory allocation and parameter settings, respectively. Why are advisors not available for the shared pool and the buffer cache?

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

A database user SMITH tries to query the V$SESSION view and fails to access it as follows: Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Cho...

Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization paramete...

Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)

View the Exhibit and examine the PL/SQL package and procedure. You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Which statement is true after you rec...

View the Exhibit. What would happen if Oracle Home is not empty?

Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows: SQL> INSERT INTO cust VALUES(101, 'JACK'...

You plan to configure the new Oracle Database 11g installation by performing these tasks: - Use Automatic Storage Management (ASM) as the storage option. - Use Oracle Enterprise Ma...

Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)

The tnsnames.ora file has an entry for the service alias ORCL as follows: ORCL = ( DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521)) (CONNECT_DATA = (SE...

You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the t...

You execute a command to resize a data file, sales.dbf, of size 200 MB in your database: ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M; Which statement is true about thi...

You executed the following commands to find the location of the alert log file: Where is the alert log file stored? (Choose all that apply.)

You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile. Some user sessions are currently connected to the database instance and...

View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response. Which action would you t...

Note the functionalities of various background processes: 1: Perform recovery at instance startup. 2: Free the resources used by a user process when it fails. 3: Cleanup the databa...

Identify the logical structure that will never have more than one data segment created for it.

View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed...

The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command: Which statement is true after HR issues the REVOKE command?

Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?

You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived redo log files. You notice thi...

Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)

View the Exhibit and examine the setting for a table. Which statement is true about the PCTFREE setting for the table?

You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the...

View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose three....

You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.)

Identify the memory component from which memory may be allocated for: Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and r...

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

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

You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file. View th...

You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode. Given below are the steps to accomplish the task in random order: 1. Shut do...

See the Exhibit. Which statements are true regarding the USERS tablespace? (Choose all that apply.)

In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?

You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days o...