Oracle-1z0-062-dumps pdf

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

slide 1:

Oracle Database 12c: Installation and Administration Oracle 1z0-062 For more information: https://www.dumpspass4sure.com/oracle/1z0-062-dumps.html

slide 2:

Oracle - 1z0-062 Practice Test 3 of 9 A. B. C. D. bit in the bitmap corresponds to a possible rowid. If the bit is set then it means that the row with the corresponding rowid contains the key value. The internal representation of bitmaps is best suited for applications with low levels of concurrent transactions such as data warehousing. Question :2 - Exam Topic 2 You are connected using SQL Plus to a multitenant container database CDB with SYSDBA privileges and execute the following sequence statements: What is the result of the last SET CONTAINER statement and why is it so It succeeds because the PDB_ADMIN user has the required privileges. It fails because common users are unable to use the SET CONTAINER statement. It fails because local users are unable to use the SET CONTAINER statement. If fails because the SET CONTAINER statement cannot be used with PDBSEED as the target pluggable database PDB. Answer: C Question :3 - Exam Topic 2 In your multitenant container database CDB containing same pluggable databases PDBs you execute the following commands in the root container:

slide 3:

Oracle - 1z0-062 Practice Test 4 of 9 A. B. C. D. E. A. B. C. D. Which two statements are true Choose two. The C ROLE1 role is created in the root database and all the PDBs. The C ROLE1 role is created only in the root database because the container clause is not used. Privileges are granted to the CA_ADMIN user only in the root database. Privileges are granted to the CA_ADMIN user in the root database and all PDBs. The statement for granting a role to a user fails because the CONTAINER clause is not used. Answer: A C Explanation You can include the CONTAINER clause in several SQL statements such as the CREATE USER ALTER USER CREATE ROLE GRANT REVOKE and ALTER SYSTEM statements. CREATE ROLE with CONTAINER optional clause / CONTAINER ALL Creates a common role. / CONTAINER CURRENT Creates a local role in the current PDB. Question :4 - Exam Topic 2 You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c. The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade. What must you do first in this situation to attempt to fix this problem Run catuppst.sql to perform revalidation actions Run utluiobj.sql to filter out objects that were invalidated by the upgrade process. Run preupgrd.sql and then execute the generated “fix-up” scripts to resolve status issues.

slide 4:

Oracle - 1z0-062 Practice Test 5 of 9 D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view. Answer: D

slide 5:

Oracle - 1z0-062 Practice Test 6 of 9 A. B. C. D. A. B. C. D. E. Topic 3 Exam Pool C Question :5 - Exam Topic 3 Examine the command: SQL CREATE TABLESPACE test1 DATAFILE /u01/app/oracle/oradata/orc1/test01.dbf SIZE 5M AUTOEXTEND ON UNIFORM Which statement is true The data file TEST01.DBF can be auto extended to a maximum size of 5M. The tablespace TEST1 can contain a maximum of one data file. Allocated and free extents are tracked using bitmaps. Segment free space is tracked in the data dictionary. Answer: C Question :6 - Exam Topic 3 You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed. You want to get advice on creation of or modifications to indexes materialized views and partitioning in these schemas. What must you run to achieve this SQL Access Advisor with a SQL tuning set B. Automatic Database Diagnostic Monitor ADDM report SQL Tuning Advisor SQL Access Advisor with a hypothetical workload SQL Performance Analyzer Answer: D

slide 6:

Oracle - 1z0-062 Practice Test 7 of 9 A. B. C. D. E. A. B. C. D. Question :7 - Exam Topic 3 You are administering a database that supports an OLTP workload. The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes. The user SCOTT queries a large table during peak activity. The query runs for more than 15 minutes and then SCOTT receives the following error: ORA-01555: snapshot too old Which is possible reason for this The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began. The query is unable to place data blocks in the UNDO tablespace. The flashback data archive is not enabled for the table on which the query is issued. There is not enough space in Fast Recovery Area. The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates. Answer: A Question :8 - Exam Topic 3 Your database has been running with a peak load for the past hour. You want to preserve the performance statistics collected during this period for comparison when you analyze the performance of the database later. What must you do to achieve this Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository AWR snapshot retention period. Create a baseline on a pair of snapshots that span the peak load period. Generate Active Session History reports for the peak load period. Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour. Answer: B

slide 7:

Oracle - 1z0-062 Practice Test 8 of 9 A. B. C. D. E. F. A. B. C. D. E. Topic 1 Exam Pool A Question :9 - Exam Topic 1 Examine this command: SQL ALTER SYSTEM SET ENABLE_DDL_LOGGINGTRUE Which two statements are true Choose two. All data definition language DDL statements are written to the control file Some DDL statements are written to an XML file in the ADR home All DDL statements are logged in to a text file in Automatic Diagnostic Repository ADR home Some data definition language DDL statements are written to the control file Some DDL statements are written to a text file in the ADR home The Alert Log still contains some DDL statements Answer: D E Question :10 - Exam Topic 1 You ran this command on a source database: expdp hr/hr DIRECTORYdumpdir DUMPFILEemp1.dmp VIEWS_AS_TABLESemp_dept On the target database you run this command: impdp hr/hr DIRECTORYdumpdir DUMPFILEemp1.dmp VIEWS_AS_TABLESemp_dept Which two statements are true Choose two. The expdp operation exports all rows for tables contained in the defining query of the EMP_DEPT view The impdp operation creates separate tables for each table contained in the defining query of the EMP_DEPT view The expdp operation exports all rows that are displayed when querying the EMP_DEPT view with no filter The impdp operation creates EMP_DEPT as a table

slide 8:

Oracle - 1z0-062 Practice Test 9 of 9 E. F. The expdp operation exports the table definitions for tables that are queried in the EMP_DEPT view. The impdp operation creates EMP_DEPT as a view Answer: D E

authorStream Live Help