1Z0-034 Exam Questions

You are managing a 24*7 database. The backup strategy for the database is to perform user- managedbackups. Identify two prerequisites to perform the backups. (Choose two.)

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN...

Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash reco...

Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?

Examine the following set of RMAN commands: RMAN> CONFIGURE CHANNELdelDEVICETYPEDISK FORMAT '/u02/backup/%U*; RKAN>RUN { ALLOCATECHANNELchlDEVICETYPEDISK; EXECUTESCRIPTfull_backup;...

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues...

The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

Your database initialization parameter file has the following entry: SEC_MAX_FAILZD_LOGIN_ATTEMPTS=3 Which statement is true regarding this setting?

You observed the following output for a user session: What do you infer from the preceding output?

In one of your online transaction processing (OLTP) applications, table keys are frequently updated and queries performed using many different operators. In addition, reports are g...

Examine the following scenario: - Database is running in ARCHIVELOG mode. - Complete consistent backup is taken every Sunday. - On Tuesday the instance terminates abnormally becaus...

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema. You query RECYCLEBIN and find multiple entries...

Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly. You are informed that some important tables in the BILL...

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, while querying the user1.emoloyees table, you receive the fo...

You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN): RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Identify the statement that c...

Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?

You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database. Which two statements are true?

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

You executed the following commands: SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false'...

Which two statements are true about encrypting RMAN backups?

You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to...

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in TimeRecovery (TSPITR). But before you start the recovery, you queried the TS_...

View the following SQL statements: Transaction T1 SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole'); 3 COMMIT; Transaction T2 SQL> UPDATE hr.regions 2 SET region_name='Poles' 3 WHERE...

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you r...

Evaluate the following block of code: What is the outcome of the above code?

What two are the prerequisites for enabling Flashback Database?

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume hug...

You created a database with the Database Configuration Assistant (DBCA) by using one of the default templates. Which tablespace will be the default permanent tablespace for non-sys...

While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours. Which view would you quer...

Note the output of the following query: SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive; FLASHBACK_ARCHIVE_NAMESTATUS ------------------------------------------...

Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables. 1. CREATE TABLE employee_ext 2. (employee_id, first_name, department_name)...

Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?

View the Exhibits exhibit1 and exhibit2. Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table....

Which two statements are correct about database transportation? (Choose two.)

Evaluate the following statements: CREATE TABLE purchase_orders ( po_id NUMBER(4), po_date TIMESTAMP, supplier_id NUMBER(6), po_total NUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(p...

You execute these RMAN commands: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?

Your database is in NOARCHIVELOG mode. One of the two data files belonging to the SYSTEM tablespace is corrupt. You discover that all online redo logs have been overwritten since t...

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the...

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point- in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process,...

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: Which statemen...

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After...

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics, you find that the...