Cause all that matters here is passing the Oracle 1z0-034 exam. Cause all that you need is a high score of 1z0-034 Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP exam. The only one thing you need to do is downloading Actualtests 1z0-034 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-034 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q21. memory_target big integer 808M
pga_aggregate_target big integer 0
sga_target big integer 0
SQL> SHOW PARAMETER SGA_MAX_SIZE
NAME TYPE VALUE
sga_max_size big integer 808M
Which statement is correct about the database?
A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.
B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and
C. SGA_TARGET are set.
D. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set.
E. Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup.
Q22. You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1,PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The databaseuser who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grantprivileges 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/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because PROD1 and PROD2 databases belong to the older version.
C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
D. They produce an error because you need to connect to the target database to execute this packagedprocedure.
Q23. Note the output of the following query: SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive; FLASHBACK_ARCHIVE_NAMESTATUS
You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
What is the outcome of this command?
A. The table uses the default Flashback Data Archive.
B. The Flashback Data Archive is created in the SYSAUX tablespace.
C. The Flashback Data Archive is created in the same tablespace where the tables are stored.
D. The command generates an error because no Flashback Data Archive name is specified and there is no default Flashback Data Archive.
Q24. 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.
A. The data file backup is done with multiple channels
B. The data files is in the read-write mode after being backed up in the read only mode
C. The backup was taken after the data files was taken offline-normal or is in the read only mode
D. The data file backup complies with the back retention policy and the backup duplexing feature
Q25. 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.
A. 2 and 3
B. 1 and 3
C. 1 and 2
D. 1, 2 and 3
Q26. Note the following statements that use flashback technology:
1. FLASHBACK TABLE <table> TO SCN <scn>;
2. SELECT * FROM <table> AS OF SCN 123456;
3. FLASHBACK TABLE <table> TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?
A. 1, 2, and 5
B. 1, 3, and 4
C. 2, 3, 4, and 5
D. 1, 2, 3, 4, and 5
The BEFORE DROP clause uses Recycle Bin;
The FLASHBACK DATABASE uses flashback logs at FRA area.
Q27. 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.)
A. ALTER TABLESPACE adtbs RESIZE 20G;
B. ALTER TABLESPACE adtbs ADD DATAFILE;
C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
D. ALTER TABLESPACE adtbs ADD DATAFILE'/proddb/data/adtbs1.dbf' SIZE 10G;
E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 28 20:34:23 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
SQL> CREATE BIGFILE TABLESPACE adtbs
DATAFILE'C:\adtbs.dbf' SIZE 1G;
SQL> ALTER TABLESPACE adtbs RESIZE 2G
SQL> ALTER TABLESPACE adtbs ADD DATAFILE'C:\adtbs.dbf' SIZE 1G;
ALTER TABLESPACE adtbs ADD DATAFILE 'C:\adtbs.dbf' SIZE 1G
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
SQL> ALTER TABLESPACE adtbs AUTOEXTEND ON;
SQL> ALTER TABLESPACE adtbs MODIFY DATAFILE 'C:\adtbs.dbf' AUTOEXTEND ON;
ALTER TABLESPACE adtbs MODIFY DATAFILE 'C:\adtbs.dbf' AUTOEXTEND ON
ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option
Q28. Evaluate the following block of code: What is the outcome of the above code?
A. It produces an error because a fully qualified host name needs to be specified.
B. It produces an error because the range of ports associated with the hosts has not been specified.
C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
Q29. 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?
A. SQL Tuning Advisor
B. SQL Performance Analyzer
C. Active Session History report
D. AWR Compare Periods report
Q30. SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS
704 SQL> ALTER TABLE altb SHRINK SPACE COMPACT; Table altered. SQL> SELECT blocks FROM user_segments WHERE segment_name=*ALTB*; BLOCKS
704 View the Exhibit and examine the output and commands executed on the ALTB table. Why does the number of blocks for the table remain the same after the shrink operation?
A. because the table did not contain migrated or chained rows
B. because the row IDs remain the same for all rows during the shrink operation
C. because the progress of the shrink operation is not saved in the bitmap blocks of the table
D. because the high-water mark (HWM) did not move due to the compact option that is used in the shrink operation