1Z0-062 Practice Questions
261 real 1Z0-062 exam questions with expert-verified answers and explanations. Page 1 of 6.
- Question #1
Which three statements are true about a job chain?
- Question #2
The hr user receiver, the following error while inserting data into the sales table: On investigation, you find that the users tablespace uses Automnrif Segment Space Management (A...
- Question #3
You execute the commands: Which two statements are true?
- Question #4
Examine the query and its output: What might have caused three of the alerts to disappear?
- Question #5
Which two statements are true?
- Question #6
Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).
- Question #7
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze som...
- Question #8
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with f...
- Question #9
The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL p...
- Question #10
Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (`SH', `CUSTOMERS', `PUBLISH', `false'); Which three statements are true about the effect of this command?
- Question #11
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source): Which three are prerequisites for successful execution of the com...
- Question #12
Which two are true concerning a multitenant container database with three pluggable database?
- Question #13
Examine the current value for the following parameters in your database instance: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issue the fol...
- Question #14
Which three statements are true concerning unplugging a pluggable database (PDB)?
- Question #15
Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are...
- Question #16
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT. You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; S...
- Question #17
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Wh...
- Question #18
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: After changing the value, you notice that FULL redaction continues...
- Question #19
You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of o...
- Question #20
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to an...
- Question #21
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following erro...
- Question #22
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?
- Question #23
Identify two correct statements about multitenant architectures.
- Question #24
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script: SQL > @utlrp.sql Which two actions does the script perform?
- Question #25
Which statement is true concerning dropping a pluggable database (PDB)?
- Question #26
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further...
- Question #27
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?
- Question #28
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?
- Question #29
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Iss...
- Question #30
Which three statements are true about Automatic Workload Repository (AWR)?
- Question #31
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you...
- Question #32
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the...
- Question #33
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/wri...
- Question #34
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the...
- Question #35
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: - Version: Oracle Database...
- Question #36
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialize...
- Question #37
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED...
- Question #38
Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSF...
- Question #39
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic...
- Question #40
Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After a...
- Question #41
Which three statements are true about adaptive SQL plan management?
- Question #42
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?
- Question #43
Which two statements are true about variable extent size support for large ASM files?
- Question #44
You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema. The RECYCLE_BIN...
- Question #45
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE...
- Question #46
You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause. What are two effects of not using the "ENABLE PLUGGABLE database"...
- Question #47
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_...
- Question #48
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
- Question #49
Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not c...
- Question #50
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?