Pass the Oracle Oracle Database 19c 1z0-083 Questions and answers with CertsForce

Viewing page 2 out of 8 pages
Viewing questions 11-20 out of questions
Questions # 11:

Which three are true about an application container?

Options:

A.

It can contain a single application


B.

Two application containers can share an application seed PDB.


C.

It must have an application root PDB.


D.

An application PDB can belong to multiple application containers.


E.

It must have an application seed PDB.


F.

It can contain multiple applications.


Expert Solution
Questions # 12:

choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE comman

Options:

A.

It succeed


B.

It fails because no parallel channels are allocated for the auxiliary databa


C.

It fails because connection to the AUXILIARY instance must be as SYSD


D.

Itsucceeds only if the target database is greater than 40


E.

No catalogued backup of the TARGET is used to duplicate the databa


Expert Solution
Questions # 13:

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

Options:

A.

defining primary keys for all tables to speed up all queries


B.

using check constraints to speed up updates


C.

defining foreign keys for all tables to speed up joins


D.

the physical data model


E.

the configuration of storage arrays


Expert Solution
Questions # 14:

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

Options:

A.

Reduced logical I/O


B.

Reduced virtual memory utilization


C.

Improved Serial Execution performance


D.

Reduced physical I/O


E.

Reduced CPU utilization


Expert Solution
Questions # 15:

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

Options:

A.

The number of table rows is considered when evaluating the cost of accessing a table using an index.


B.

Index balanced B*Tree height is considered when evaluating the cost of using an index.


C.

The Statistics Advisor can help recommend the best way to gather statistics.


D.

Statistics collected using DBMS_STATS always yield the best optimizer result.


E.

The Statistics Advisor generates actions for all recommendations.


Expert Solution
Questions # 16:

Choose two. Which two are true about Oracle Grid Infrastructure for a Standalone Server?

Options:

A.

It can manage database resources on the server where it is installed or on a different server.


B.

The CSS daemon runs from the Grid Infrastructure home.


C.

It supports volume management, file system, and automatic restart capabilities.


D.

It requires Oracle Automatic Storage Management (ASM) components to be installed separately.


E.

It must be installed before the Oracle database software is installed.


Expert Solution
Questions # 17:

Examine the statements that use flashback technologies:

FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM¬DD HH:MI:SS');

SELECT * FROM customers AS OF SCN 123456;

FLASHBACK TABLE customers TO BEFORE DROP;

FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');

SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;

ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of relevant undo data in the undo tablespace?

Options:

A.

1,3,6


B.

1,2,5


C.

3,4,5


D.

2,3,5,6


Expert Solution
Questions # 18:

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

Options:

A.

Database Replay


B.

Automatic Database Diagnostic Monitor (ADDM) Compare Period report


C.

Active Session History (ASH) report


D.

SQL Performance Analyzer


Expert Solution
Questions # 19:

Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?

Options:

A.

DBUA must be launched from the target Oracle Home.


B.

Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.


C.

A whole database backup must exist before upgrade.


D.

The Pre-Upgrade Information Tool script is executed by DBUA.


E.

All pluggable databases are automatically upgraded as part of a container database upgrade.


F.

The database must be opened in read-only mode.


Expert Solution
Questions # 20:

Choose two. A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required?

Options:

A.

after losing all members of the CURRENT online redo log group


B.

after losing all copies of the control file


C.

after losing an UNDO tablespace that is in use


D.

after losing all members of an INACTIVE online redo log group


E.

after losing a SYSAUX tablespace data file


Expert Solution
Viewing page 2 out of 8 pages
Viewing questions 11-20 out of questions