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

質問 1

Which files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)

（A）the password file

（B）the sqlnet.ora file

（C）the listener.ora file

（D）the initialization parameter file

（E）the tnsnames.ora file

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

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

質問 2

In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked.
You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?

（A）Impose standard database auditing to audit object privileges.

（B）Impose standard database auditing to audit SQL statements.

（C）Implement value-based auditing.

（D）Apply fine-grained auditing.

正解：C 解答を投票する

質問 3

Examine the parameters:
Your database instance is started with a PFILE.

You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?

（A）The value is changed for the current instance and in the PFILE.

（B）Change is applied to the current instance, but does not persist after instance restart.

（C）It fails because the SCOPE clause is missing.

（D）The value is changed only in the PFILE and takes effect at the next instance startup.

正解：B 解答を投票する

質問 4

Which three statements are true about user account administration? (Choose three.)

（A）A new user account can be created only by SYS or SYSTEM users.

（B）A user's quota can be set for any permanent tablespace but not for the default temporary tablespace.

（C）A user's current session is not affected when the user's profile is changed.

（D）Only users with the SYSDBA privilege can change the tablespace quota for other users.

（E）A user requires only the CREATE SESSION privilege to change his or her own password.

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

質問 5

Identify two correct statements about multitenant architectures.

（A）Patches are always applied at the CDB level.

（B）Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.

（C）A PDB can have a private undo tablespace.

（D）Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.

（E）Multiple CDBs share certain PDB resources.

（F）Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.

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

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

質問 6

Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

（A）All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

（B）All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

（C）Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

（D）Only DDL commands that resulted in the creation of new segments are logged.

（E）All DDL commands are logged in the alert log file.

正解：A 解答を投票する

質問 7

Identify three valid methods of opening, pluggable databases (PDBs).

（A）ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB

（B）ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root

（C）ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed

（D）ALTER DATABASE OPEN issued from that PDB

（E）ALTER DATABASE PDB OPEN issued from the root

（F）ALTER PLUGGABLE DATABASE OPEN issued from that PDB

（G）ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB

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

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

質問 8

Which three statements are true about space usage alerts? (Choose three.)

（A）Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.

（B）Database alerts can provide warnings about low space availability at both tablespace and segment levels.

（C）Alerts are issued only when the critical threshold for space available in a tablespace is breached.

（D）A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.

（E）The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.

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

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

質問 9

You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600.
Which two statements are true? (Choose two.)

（A）Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

（B）Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.

（C）Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

（D）A resumable statement can be suspended and resumed only once during execution.

（E）A suspended statement will report an error if no corrective action has taken place during a timeout period.

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

質問 10

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?

（A）It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

（B）It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.

（C）It must be made up of a database name and a domain name.

（D）It must be made up of the value in ORACLE_SID and HOSTNAME.

正解：C 解答を投票する

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

質問 11

Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?
(Choose three.)

（A）Field names should be the first line in the both the SQL* Loader data files.

（B）The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

（C）The SQL* Loader data file myfile1.dat has the column names for the EMP table.

（D）The SQL* Loader operation fails because no record terminators are specified.

（E）An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.

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

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

質問 12

Which two actions does an incremental checkpoint perform? (Choose two.)

（A）It writes the checkpoint position to the data file headers.

（B）It advances the checkpoint position in the checkpoint queue.

（C）It writes the checkpoint position to the control file.

（D）It signals CKPT to write the checkpoint position to the data file headers.

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

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

質問 13

In your database, archive logging and control file autobackup are enabled.
The data files and redo log files are intact but control files are impacted due to media failure.
In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)

（A）One control file copy is intact and damaged control file copies have to be restored to a non-default location.

（B）One control file copy is intact and damaged control file copies have to be restored to the default location.

（C）All copies of the control file are damaged and the auto backed up control file is used for recovery.

（D）One control file copy is intact so the spfile is changed to refer to only one copy.

（E）All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually.

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

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

弊社を連絡する

関連リンク

トップ試験