1Z0-034 - Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

Go back to Oracle

Example Questions

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 package. Which statement is true regarding the ACL created? Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; } Which statement is true about the duplicate database in this scenario? 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 query to determine the name and status of the stopped job? 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 actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this? The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are the minimum requirements for the statement to execute successfully? (Choose all that apply) 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, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.) During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation? 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 the last backup. Which method would you use to recover the data file using RMAN? Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value? You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database l1g database .The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER.CATOWNER executes the following command to grant privileges to a new user vpc1 using Oracle Database 11g RMAN executables: RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1; Then you issue the following commands: RMAN> CONNECT CATALOG vpc1/[email protected]; RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;" What is the outcome of the above commands? Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command? The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations. How would you achieve this? You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this? You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting? Note the output of the following query: SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive; FLASHBACK_ARCHIVE_NAMESTATUS -------------------------------------------------------------- FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table: ALTERTABLEexchange_rateFLASHBACK ARCHIVE; What is the outcome of this command? Examine these Data Pump commands to import objects to non-existent users hr1 and oe1. S expdp system/manager Schemas =hr,oe directory =EXP_ DIR include = table $ impdp system/manager Schemas = hr1,oe1 Directory = EXP_DIR Dumpfile = export.dat Remap_schema =hr:hr1,oe :oe1 What would be achieved by running the above commands? Which three elements can a job chain process involve? (Choose three) 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 a query on the orders table and receives the following error: ERROR at line I: ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status What would be the most efficient way to rectify this error? Which three statements are true about windows? You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up. Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.) Which two statements are true about encrypting RMAN backups? Your database initialization parameter file has the following entry: SEC_MAX_FAILZD_LOGIN_ATTEMPTS=3 Which statement is true regarding this setting? You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery? You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>'group1', COMMENT => 'New Group'); This command errors out displaying the following message: ERROR at line 1: ORA-29371: pending area is not active ORA-06512: at "SYS.DBMS_RMIN", line 115 ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1 What action would you take to overcome this error? Which two statements are true regarding an Automatic Storage Management (ASM) instance? (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(po_id)) PARTITION BY RANGE(po_date) ( PARTITION Q1 VALUES LESS THAN (TO_DATE('1-apr-2007','d-mon-yyyy'), PARTITION Q2 VALUES LESS THAN (TO_DATE('1-jul-2007','d-mon-yyyy'), PARTITION Q3 VALUES LESS THAN (TO_DATE('1-oct-2007','d-mon-yyyy'), PARTITION Q4 VALUES LESS THAN (TO_DATE('1-jan-2008','d-mon-yyyy')); CREATE TABLE purchase_order_items ( po_id NUMBER(4) NOT NULL, product_id NUMBER(6) NOT NULL, unit_price NUMBER(8,2), quantity NUMBER(8), CONSTRAINT po_items_fk FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id)) PARTITION BY REFERENCE(po_items_fk); What are the two consequences of the above statements? (Choose two.) The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem. What would you suggest to analyze this performance problem for the user? Identify three key features of Oracle Data Pump (Choose three.) What happens when you run the SQL Tuning Advisor with limited scope? Examine the following command for RMAN backup: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true regarding the approach in the command? Identify two advantages of using a recovery catalog instead of the control file of the target database in Recovery Manager (RMAN). You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M; Which two statements are correct regarding the mytbs tablespace? (Choose two) The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery? In which two aspects does hot patching differ from conventional patching? (Choose two.) Identify two correct statements about the Active Session History (ASH) data. You execute these RMAN commands: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do? Which steps are mandatory to enable Direct NFS? 1. Mount all required file systems using the kernel NFS driver. 2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS. 3. Replace the ODM library libodm11.so_stub with libodm11.so. To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the tablespace in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the userstablespace? Which two statements are true about the duplexing of the backups taken by RMAN? Which two statements are true regarding hot patching? (Choose two.) You created a tablespace with the following statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G; There is now a requirement to increase the size of the tablespace. Which two ALTER statements are correct in this scenario? (Choose two.) In Recovery Manager (RMAN), you are taking Image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task? Examine the following scenario: - Database is running in ARCHIVELOG mode. - Complete consistent backup is taken every Sunday. - On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted - The disk having active online redo log files is also corrupted. - The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure? UNDO__RETENTION is set to 1000 and retention is not guaranteed. You configure the database with a fixed size undo tablespace. Which is true about undo retention in this configuration? 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_PITR_OBJECTS_TO_BE_DROPPEDview and realized that there are a large number of objects that would be dropped when you start the recoveryby using this method. You want to preserve these objects. Which option must you use to perform TSPITR andpreserve the object? Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.) To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.) You issued the following commands to configure settings in RMAN: RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO Sbt; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command? 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 BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered. You decide to perform an incomplete recovery using the following command: SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00'; Identify the files that must be restored to recover the missing tables successfully.

Study Guides