次の認定試験に速く合格する！

簡単に認定試験を準備し、学び、そして合格するためにすべてが必要だ。

会員センターカート (0)

1z0-062 無料問題集「Oracle Database 12c: Installation and Administration」

ページ: 1 / 24
トータル 380 問

サインアップ、ログインされた後に、試験全体を無料で表示できるようになります。

完全版を入手する

質問 1

Which three operations can be performed as multipartition operations in Oracle? (Choose three.)

（A）Drop partitions of a list partitioned table

（B）Merge partitions of a reference partitioned index

（C）Coalesce partitions of a hash-partitioned global index.

（D）Rename partitions of a range partitioned table

（E）Merge partitions of a list partitioned table

（F）Move partitions of a range-partitioned table

正解：A、B、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:
$ make -fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME
Which two steps should you perform before executing this command? (Choose two.)

（A）Ensure that the initialization parameter AUDIT_TRAIL is set to DB.

（B）Drop any existing fine-grained audit (FGA) policies.

（C）Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.

（D）Stop the listener.

（E）Shut down the database instance.

正解：C、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

Examine the memory-related parameters set in the SPFILE of an Oracle database:

Which statement is true?

（A）Memory is dynamically re-allocated between the SGA and PGA as needed.

（B）Only SGA components are sized automatically.

（C）The value of the MEMORY_TARGET parameter cannot be changed dynamically.

（D）The size of the PGA cannot grow automatically beyond 500 MB.

正解：A 解答を投票する

質問 4

The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command:
SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION;
TOM then executes this command to grant privileges to the user JIM:
SQL> GRANT SELET ON hr.bonuses TO jim;
Which statement is true?

（A）TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM.

（B）JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them.

（C）HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.

（D）HR can revoke the SELECT ON HR.BONUSES privilege from JIM.

正解：C 解答を投票する

質問 5

What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

（A）The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

（B）Only timed operating system (OS) statistics and plan execution statistics are collected.

（C）Optimizer statistics are collected automatically.

（D）Automatic Workload Repository (AWR) snapshots are not generated automatically.

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statements are correct? (Choose two.)

（A）Only the ORD_CUSTOMER_IX2 index is created.

（B）Only the ORD_CUSTOMER_IX1 index is created.

（C）The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.

（D）Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

（E）Both the indexes are created; however, only the ORD_COSTOMER index is visible.

正解：D、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

（A）It generates fix-up scripts to be run on the source database before upgrade.

（B）It generates a log file containing the fixes that can be made to the source database.

（C）It provides a summary of the upgrade results.

（D）It recompiles all invalid PL/SQL and Java code.

（E）It provides parallel upgrade options to finish the upgrade process with a reduced down time.

正解：E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 8

Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

（A）Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.

（B）Use the DBMS_PDB package to clone an existing PDB.

（C）Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.

（D）Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

（E）Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.

正解：B、D、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

（A）The master table is the last object to be exported by the data pump.

（B）You can detach from a data pump export job and reattach later.

（C）Data pump uses parallel execution server processes to implement parallel import.

（D）You can detach from a data pump import job and reattach later.

（E）Data pump import requires the import file to be in a directory owned by the oracle owner.

正解：B、C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

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.)

（A）Enable Flashback Data Archiving for the tables that require tracking.

（B）Enable supplemental logging for the database.

（C）Create a Flashback Data Archive in any suitable tablespace.

（D）Create a Flashback Data Archive in the tablespace where the tables are stored.

（E）Specify undo retention guarantee for the database.

正解：A、C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 11

You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?

（A）The operating system group that is specified must have permission to write to the inventory directory.

（B）The ORACLE_BASE base parameter is not set.

（C）The operating system group that is specified should have the root user as its member.

（D）The installation is being performed by the root user.

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 12

Your database is running in ARCHIVELOG mode.
You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)

（A）The database instance must be shut down to take a user-managed consistent backup.

（B）User-managed backups only contain formatted data blocks.

（C）Consistent RMAN backups can be taken while the database is open.

（D）RMAN backups contain only data files.

（E）The database must be in MOUNT state to take consistent RMAN backups.

正解：B、C 解答を投票する

質問 13

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? (Choose three.)

（A）System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

（B）The granter of system privileges must possess the set container privilege.

（C）System privileges apply only to the PDB in which they are used.

（D）Common users connected to a PDB can exercise privileges across other PDBs.

（E）Local users cannot use local system privileges on the schema of a common user.

正解：A、B、C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 14

You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

（A）It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.

（B）It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.

（C）It generates an error when creating the table because the wallet is closed.

（D）It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

正解：C 解答を投票する

質問 15

Which two statements are true? (Choose two.)

（A）The predefined connect role is always automatically granted to all new users at the time of their creation.

（B）A role can be granted to other roles.

（C）The predefined resource role includes the unlimited_tablespace privilege.

（D）A role can contain both system and object privileges.

（E）All roles are owned by the sys user.

（F）A role cannot be assigned external authentication.

正解：B、D 解答を投票する

質問 16

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)

（A）The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

（B）The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

（C）RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

（D）The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

（E）The ASM compatibility attribute controls the format of the disk group metadata.

正解：B、C、E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

ページ: 1 / 24
トータル 380 問

1z0-062 の機能をすべて解除する

キャプチャ不要
365日無料更新サービス
希望する合格率を設定できる
時間の割り当てられる（時間：分）
1z0-062 に2つの練習用モード
サポートサービス対応

完全版を入手する

弊社を連絡する

我々は１２時間以内ですべてのお問い合わせを答えます。

オンラインサポート時間：( UTC+9 ) 9:00-24:00
月曜日から土曜日まで

サポート：現在連絡

トップ試験

MB-820 試験問題集
CPQ-Specialist 試験問題集
GB0-343 試験問題集
C-THR83-2405 試験問題集
DA0-001 試験問題集
NSK200 試験問題集

1z0-062 無料問題集「Oracle Database 12c: Installation and Administration」

弊社を連絡する

関連リンク

トップ試験