[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 81-90

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.81

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 true about using an invisible column in the PRODUCTS table? (Choose three.)

  1. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.

  2. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.

  3. Referential integrity constraint cannot be set on the invisible column.

  4. The invisible column cannot be made visible and can only be marked as unused.

  5. A primary key constraint can be added on the invisible column.

Correct Answer: ABE

Explanation:

AB: You can make individual table columns invisible. Any generic access of a table does not show the invisible columns in the table. For example, the following operations do not display invisible columns in the output:

SELECT * FROM statements in SQL DESCRIBE commands in SQL*Plus

%ROWTYPE attribute declarations in PL/SQL Describes in Oracle Call Interface (OCI)

Incorrect:

Not D: You can make invisible columns visible.

You can make a column invisible during table creation or when you add a column to a table, and you can later alter the table to make the same column visible.

Question No.82

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

  1. Bind Variable Peeking

  2. SQL Plan Baselines

  3. Adaptive Cursor Sharing

  4. Bind variable used in a SQL statement

  5. Literals in a SQL statement

Correct Answer: ACD

Question No.83

You execute the commands:

image

Which two statements are true? (Choose two.)

  1. The create user command fails if any role with the name Sidney exists in the database.

  2. The user Sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace.

  3. The user Sidney is created but cannot connect to the database instance because no profile is default.

  4. The user Sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace.

  5. The user Sidney is created and authenticated by the operating system.

Correct Answer: AD

Question No.84

Examine the following impdp command to import a database over the network from a pre- 12c Oracle database (source):

image

Which three are prerequisites for successful execution of the command? (Choose three.)

  1. The import operation must be performed by a user on the target database by a user with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user with the DATAPUMP_EXP_FULL_DATABASE role on the source database.

  2. All the user-defined tablespaces must be in read-only mode on the source database.

  3. The export dump file must be created before starting the import on the target database.

  4. The source and target database must be running on the same operating system (OS) with the same endianness.

  5. The impdp operation must be performed by the same user that performed the expdp operation.

Correct Answer: ABD

Explanation:

In this case we have run the impdp without performing any conversion if endian format is different then we have to first perform conversion.

Question No.85

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 one day. Which two must you do to track the transactions? (Choose two.)

  1. Enable supplemental logging for the database.

  2. Specify undo retention guarantee for the database.

  3. Create a Flashback Data Archive in the tablespace where the tables are stored.

  4. Create a Flashback Data Archive in any suitable tablespace.

  5. Enable Flashback Data Archiving for the tables that require tracking.

Correct Answer: DE

Explanation:

E: By default, flashback archiving is disabled for any table. You can enable flashback archiving for a table if you have the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive that you want to use for that table.

D: Creating a Flashback Data Archive

Create a Flashback Data Archive with the CREATE FLASHBACK ARCHIVE statement, specifying the following:

Name of the Flashback Data Archive

Name of the first tablespace of the Flashback Data Archive (Optional) Maximum amount of space that the Flashback Data Archive can use in the first tablespace

Create a Flashback Data Archive named fla2 that uses tablespace tbs2, whose data will be retained for two years:

CREATE FLASHBACK ARCHIVE fla2 TABLESPACE tbs2 RETENTION 2 YEAR

Question No.86

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

  1. All AWR tables belong to the SYSTEM schema.

  2. The AWR data is stored in memory and in the database.

  3. The snapshots collected by AWR are used by the self-tuning components in the database

  4. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

  5. AWR contains system wide tracing and logging information.

Correct Answer: BCD

Question No.87

Which three statements are true about adaptive SQL plan management? (Choose three.)

  1. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

  2. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.

  3. It adds new, bettor plans automatically as fixed plans to the baseline.

  4. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

  5. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

Correct Answer: ADE

Explanation:

With adaptive SQL plan management, DBAs no longer have to manually run the verification or evolve process for non-accepted plans. When automatic SQL tuning is in COMPREHENSIVE mode, it runs a verification or evolve process for all SQL statements that have non-accepted plans during the nightly maintenance window. If the non-accepted plan performs better than the existing accepted plan (or plans) in the SQL plan baseline, then the plan is automatically accepted and becomes usable by the optimizer. After the verification is complete, a persistent report is generated detailing how the non-accepted plan performs compared to the accepted plan performance. Because the evolve process is now an AUTOTASK, DBAs can also schedule their own evolve job at end time.

Note:

The optimizer is able to adapt plans on the fly by predetermining multiple subplans for portions of the plan.

Adaptive plans, introduced in Oracle Database 12c, enable the optimizer to defer the final plan decision for a statement until execution time. The optimizer instruments its chosen plan (the default plan) with statistics collectors so that it can detect at runtime, if its cardinality estimates differ greatly from the actual number of rows seen by the operations in the plan. If there is a significant difference, then the plan or a portion of it will be automatically adapted to avoid suboptimal performance on the first execution of a SQL statement.

Question No.88

What is the effect of specifying the quot;ENABLE PLUGGABLE DATABASEquot; clause in a quot;CREATE DATABASEquot; statement?

  1. It will create a multitenant container database (CDB) with only the root opened.

  2. It will create a CDB with root opened and seed read only.

  3. It will create a CDB with root and seed opened and one PDB mounted.

  4. It will create a CDB that must be plugged into an existing CDB.

  5. It will create a CDB with root opened and seed mounted.

Correct Answer: B

Explanation:

The CREATE DATABASE … ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs. Along with the root (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). The following graphic shows a newly created CDB:

image

Creating a PDB

Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation.

Question No.89

Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.)

  1. The root container can be flashed back without flashing back the pluggable databases (PDBs).

  2. To enable flashback database, the CDB must be mounted.

  3. Individual PDBs can be flashed back without flashing back the entire CDB.

  4. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

  5. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Correct Answer: ABD

Question No.90

You created a new database using the quot;create databasequot; statement without specifying the quot;ENABLE PLUGGABLEquot; clause. What are two effects of not using the quot;ENABLE PLUGGABLE databasequot; clause?

  1. The database is created as a non-CDB and can never contain a PDB.

  2. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).

  3. The database is created as a non-CDB and can never be plugged into a CDB.

  4. The database is created as a non-CDB but can be plugged into an existing CDB.

  5. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

Correct Answer: AD

Explanation:

A (not B,not E): The CREATE DATABASE … ENABLE PLUGGABLE DATABASE SQL statement

creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.

D: You can create a PDB by plugging in a Non-CDB as a PDB. The following graphic depicts the options for creating a PDB:

image

Incorrect:

Not E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF