Ensurepass

QUESTION 51

You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:

 

clip_image002Applications will connect to the database via a middle tier.

clip_image002[1]The number of concurrent user connections will be high.

clip_image002[2]The database will have mixed workload, with the execution of complex BI queries scheduled at night.

 

Which DBCA option must you choose to create the database?

 

A.

a General Purpose database template with default memory allocation

B.

a Data Warehouse database template, with the dedicated server mode option and AMM enabled

C.

a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

D.

a default database configuration

 

Correct Answer: C

Explanation:

http://www.oracledistilled.com/oracle-database/administration/creating-a-database-using-database-configuration-assistant/

 

QUESTION 52

Which two are prerequisites for performing a flashback transaction?

 

A.

Flashback Database must be enabled.

B.

Undo retention guarantee for the database must be configured.

C.

EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

D.

Supplemental logging must be enabled.

E.

Recycle bin must be enabled for the database.

F.

Block change tracking must be enabled tor the database.

 

Correct Answer: AC

Explanation:

Oracle Database Advanced Application Developer’s Guide 11g, Using Oracle Flashback Technology

 

 

QUESTION 53

Examine the following query output:

 

clip_image004

 

You issue the following command to import tables into the hr schema:

 

$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y

 

Which statement is true?

 

A.

All database operations performed by the impdp command are logged.

B.

Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

C.

Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

D.

None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

 

Correct Answer: C

Explanation:

Oracle Data Pump disable redo logging when loading data into tables and when creating indexes.

The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo generation for the objects during the course of import. The Master Table is used to track the detailed progress information of a Data Pump job.

The Master Table is created in the schema of the current user running the Pump Dump export or import, and it keeps tracks of lots of detailed information.

 

 

 

 

 

 

 

QUESTION 54

Which two statements correctly describe the relationship between data files and logical database structures?

 

A.

A segment cannot span data files.

B.

A data file can belong to only one tablespace.

C.

An extent cannot span data files.

D.

The size of an Oracle data block in a data file should be the same as the size of an OS block.

 

Correct Answer: BC

Explanation:

https://mohibalvi.wordpress.com/tag/alter-tablespace/

 

 

QUESTION 55

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

 

A.

By default, EM express is available for a database after database creation.

B.

You can use EM express to manage multiple databases running on the same server.

C.

You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D.

You cannot start up or shut down a database Instance by using EM express.

E.

You can create and configure pluggable databases by using EM express.

 

Correct Answer: A

Explanation:

EM Express is built inside the database.

Note:

Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basic database administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.

 

 

QUESTION 56

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.

 

You execute the following command from the root container:

 

SQL > REVOKE create table FROM C # # A_ADMIN;

 

What is the result?

 

A.

It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.

B.

It fails and reports an error because the CONTAINER=ALL clause is not used.

C.

It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.

D.

It fails and reports an error because the CONTAINER=CURRENT clause is not used.

E.

It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

 

Correct Answer: A

Explanation:

REVOKE ..FROM

If the current container is the root:

Specify CONTAINER = CURRENT to revoke a locally granted system privilege, object privilege, or role from a common user or common role. The privilege or role is revoked from the user or role only in the root. This clause does not revoke privileges granted with CONTAINER = ALL.

Specify CONTAINER = ALL to revoke a commonly granted system privilege, object privilege on a common object, or role from a common user or common role. The privilege or role is revoked from the user or role across the entire CDB. This clause can revoke only a privilege or role granted with CONTAINER = ALL from the specified common user or common role. This clause does not revoke privileges granted locally with CONTAINER = CURRENT. However, any locally granted privileges that depend on the commonly granted privilege being revoked are also revoked.

If you omit this clause, then CONTAINER = CURRENT is the default.

Reference: Oracle Database SQL Language Reference 12c, Revoke

 

 

QUESTION 57

You want to flash back a test database by five hours.

 

You issue this command:

 

SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE – 5/24);

 

Which two statements are true about this flashback scenario?


 

A.

The database must have multiplexed redo logs for the flashback to succeed.

B.

The database must be MOUNTED for the flashback to succeed.

C.

The database must use block change tracking for the flashback to succeed.

D.

The database must be opened in restricted mode for the flashback to succeed.

E.

The database must be opened with the RESETLOGS option after the flashback is complete.

F.

The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

 

Correct Answer: BE

 

 

QUESTION 58

Examine these two statements:

 

clip_image006

 

Which three are true about the MRKT tablespace?

 

A.

The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

B.

The MRKT tablespace may be dropped if it has no contents.

C.

Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

D.

No more data files can be added to the tablespace.

E.

The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

 

Correct Answer: BCD

 

 

QUESTION 59

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 some of the queries for an application that are cached in the library cache.

 

What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

 

A.

Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.

B.

Run the Automatic Workload Repository Monitor (ADDM).

C.

Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

D.

Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

 

Correct Answer: D

Explanation:

SQL Access Advisor is primarily responsible for making schema modification recommendations, such as adding or dropping indexes and materialized views. SQL Tuning Advisor makes other types of recommendations, such as creating SQL profiles and restructuring SQL statements.

The query optimizer can also help you tune SQL statements. By using SQL Tuning Advisor and SQL Access Advisor, you can invoke the query optimizer in advisory mode to examine a SQL statement or set of statements and determine how to improve their efficiency. SQL Tuning Advisor and SQL Access Advisor can make various recommendations, such as creating SQL profiles, restructuring SQL statements, creating additional indexes or materialized views, and refreshing optimizer statistics.

Note:

Decision support system (DSS) workload

The library cache is a shared pool memory structure that stores executable SQL and PL/SQL code. This cache contains the shared SQL and PL/SQL areas and control structures such as locks and library cache handles.

Reference: Tuning SQL Statements

 

 

QUESTION 60

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_EXECUTION = FALSE

 

Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

 

A.

You can conned as a common user by using the connect statement.

B.

You can connect as a local user by using the connect statement.

C.

You can connect by using easy connect.

D.

You can connect by using OS authentication.

E.

You can connect by using a Net Service name.

F.

You can connect as a local user by using the SET CONTAINER statement.

 

Correct Answer: CDEF

Explanation:

The choice of threading model is dictated by the THREADED_EXECUTION initialization parameter.

THREADED_EXECUTION=FALSE : The default value causes Oracle to run using the multiprocess model.

THREADED_EXECUTION=TRUE : Oracle runs with the multithreaded model.

OS Authentication is not supported with the multithreaded model.

THREADED_EXECUTION

When this initialization parameter is set to TRUE, which enables the multithreaded Oracle model, operating system authentication is not supported. Attempts to connect to the database using operating system authentication (for example, CONNECT / AS SYSDBA or CONNECT / ) when this initialization parameter is set to TRUE receive an ORA- 01031″insufficient privileges” error.

F: The new SET CONTAINER statement within a call back function:

The advantage of SET CONTAINER is that the pool does not have to create a new

connection to a PDB, if there is an exisitng connection to a different PDB. The pool can use the existing connection, and through SET CONTAINER, can connect to the desired PDB.

This can be done using:

ALTER SESSION SET CONTAINER=<PDB Name>

This avoids the need to create a new connection from scratch.

 

Free VCE & PDF File for Oracle 1Z0-062 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

Comments are closed.