1Z0-083認定の有効な試験問題集解答学習ガイド！（最新の283問題) [Q145-Q159]

Rate this post

1Z0-083認定の有効な試験問題集解答学習ガイド！（最新の283問題)

1Z0-083問題集で時間限定！無料アクセスせよ

新問題 145
Which two are true about Oracle Optimizer Statistics, their use, and their collection?

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

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

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

The Statistics Advisor generates actions for all recommendations.

Statistics collected using DBMS_ATATS always yield the best optimizer result.

新問題 146
Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup?

Backups can be taken only if a fast recovery area is configured.

Backups can be written only to disk.

Backups can be taken only for data files.

Binary compression cannot be applied to the backup.

Backups can be written only if checksums are stored for each block.

Backups can be written only to media.

新問題 147
Examine this command for creating pluggable database PDB2 in container database CDB2 CREATE PLUGGABLE DATABASE pdb2 ADMIN USER pdb2_adrn IDENTIFIED BY 12 3pdb ROLES=(CONNECT) ; Select three options, any one of which is required for it to execute successfully.

Add the file_name_convert clause to the statement and set the pdb_file_name_convert parameter.

Set only the pdb_file_name_convert parameter.

Add the file_mame_comvert clause to the statement and enable Oracle Managed Files (OMF).

Enable only OMF.

Set the pdb_file_name_convert parameter and enable OMF.

Add only the create_file_dest clause to the statement.

新問題 148
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

It is integrated with the SQL Access Advisor.

It predicts the impact of system changes on SQL workload response time.

It provides before and after execution statistics for each SQL statement in the analysis task

It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

SQL statements that were originally run concurrently are run concurrently by SPA.

新問題 149
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

Media Management messages for SBT devices are always written to sbtio.log.

RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

RMAN error stacks should be read from the top down as that is the order in which errors are generated.

The RMAN LOG command line clause causes output issued during RMAN commandcompilation to be written to a log file and to standard output.

The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

Media Management messages for SBT devices are written to an Oracletrace file.

新問題 150
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)

CDB1 and CDB2 must be in shared undo mode.

A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

Cloning HR_ROOT automatically clones HR_PDB1.

The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

新問題 151
Examine this configuration:
1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2.ORCL uses disk group +FRA for the Fast Recovery Area.
3.LISTENER is the listener for ORCL.
4.The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5.All components are currently shut down.
You execute this command:

What is the outcome?

The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

Only the ORCL database instance is started.

Only the ORCL database and the ASM instances are started.

Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

Only the ORCL database instance and the +DATA and +FRA disk groups are started.

新問題 152
Which two are prerequisites for performing Flashback Transaction?

Fast Recovery Area must be enabled for the database

The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

Undo retention guarantee must be configured for the database.

A supplemental log must be enabled for the primary key.

Row movement must be enabled.

新問題 153
Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.
How do you achieve this?

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

This cannot be done due to the lack of a clean restore point.

新問題 154
Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)

A table’s constraints must be disabled before issuing the flashback.

The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.

A table’s indexes must be set to unusable before issuing the flashback.

Row Movement must be enabled on the table being flashed back.

The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.

新問題 155
Which three are true about recovery operations done without using Recovery Manager (RMAN)?
(Choose three.)

A lost SPFILE can be recovered from memory using SQL*PLUS.

A lost password file can be re-created with SQL*PLUS.

A lost TEMPFILE must always be re-created manually.

A lost password file can be manually re-created with the orapwd utility.

A lost PFILE can be re-created alert.log using SQL*PLUS.

A lost index tablespace can be re-created without performing any recovery.

新問題 156
The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

Backups must be done incrementally.

Backups must be contained in backup sets.

Backups can be taken only if the database is in ARCHIVE LOG mode.

Backups can be done incrementally.

The database must be registered in an RMAN catalog.

Only consistent backups can be created.

新問題 157
Which three are true about managing memory components in an Oracle database instance? (Choose three.)

With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

Automatic Memory Management must be used together with locking the System Global Area into physical memory.

With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

新問題 158
Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

to switch an existing Oracle Database home to a newer release of Oracle software on the same server

to switch to a read-only Oracle home

to switch back to the previous Oracle home as part of a rollback operation

to switch the Oracle Database home when using a centralized Rapid Home Provisioning server

to switch to a patched Oracle Database home

新問題 159
Which three are true about Database Point-in-Time Recovery? (Choose three.)

The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.

The database must be in MOUNT state when performing Database Point-in-Time Recovery.

Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

The Database must be in ARCHIVELOG mode.

The target point for the recovery must be specified as a stime or System Change Number (SCN).

The database must be open RESETLOGS after Database Point-in-Time Recovery.

Oracle 1Z0-083 認定試験は、経験豊富なデータベース管理者のスキルと知識を試験する、難しいが報酬の高い試験です。十分に準備し、Oracle データベース管理の熟練度を示すことにより、候補者はこの価値ある認定を取得し、キャリアを次のレベルに引き上げることができます。

Oracle 1Z0-083試験実践テスト問題：https://www.passtest.jp/Oracle/1Z0-083-shiken.html

1Z0-083認定の有効な試験問題集解答学習ガイド！（最新の283問題) [Q145-Q159]

コメントを残すコメントをキャンセル

1Z0-083練習テスト

関連認証

最近の投稿

アーカイブ

カテゴリー

1Z0-083認定の有効な試験問題集解答学習ガイド！（最新の283問題) [Q145-Q159]

コメントを残す コメントをキャンセル

1Z0-083練習テスト

関連認証

最近の投稿

アーカイブ

カテゴリー

コメントを残すコメントをキャンセル