1Z1-060無料問題集「Oracle Upgrade to Oracle Database 12c」

質問 1

Which three statements are true about Automatic Workload Repository (AWR)?

（A）The snapshots collected by AWR are used by the self-tuning components in the database

（B）AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.

（C）The AWR data is stored in memory and in the database.

（D）AWR contains systemwide tracing and logging information.

（E）All AWR tables belong to the SYSTEM schema.

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

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

質問 2

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:
1snrctl > STOP
What happens to the sessions that are presently connected to the database Instance?

（A）They are able to perform only queries.

（B）They are terminated and the active transactions are rolled back.

（C）They are not affected and continue to function normally.

（D）They are not allowed to perform any operations until the listener LISTENER is started.

正解：C 解答を投票する

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

質問 3

You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.

（A）SYS, SYSTEM

（B）Both successful and failed executions

（C）Only for failed executions

（D）SCOTT

（E）Only for successful executions

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

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

質問 4

In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

Which two statements are true?

（A）The C # # ROLE1 role is created in the root database and all the PDBs.

（B）Privileges are granted to the C##A_ADMIN user only in the root database.

（C）The statement for granting a role to a user fails because the CONTAINER clause is not used.

（D）Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.

（E）The C # # ROLE1 role is created only in the root database because the container clause is not used.

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

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

質問 5

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges:

Which statement is true about the common user created by the command?

（A）The user can connect only to the root database.

（B）The user cannot connect any database because the CONTAINER clause is missing.

（C）The user cannot connect to any database because the CREATE ANY SESSION privilege must be granted.

（D）The user can connect to the root and all PDBs.

正解：D 解答を投票する

質問 6

Examine the following command:

Which three statements are true about using an invisible column in the PRODUCTStable?

（A）The invisible column cannot be made visible and can only be marked as unused.

（B）The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.

（C）Referential integrity constraint cannot be set on the invisible column.

（D）A primary key constraint can be added on the invisible column.

（E）The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.

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

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

質問 7

You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor?

（A）It will detect and advise about chained rows.

（B）It may advise the use of online table redefinition for tables in locally managed tablespaces

（C）It may advise the use of segment shrink for free list managed tables.

（D）It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

（E）It may advise the use of online table redefinition for tables in dictionary managed tablespace.

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

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

質問 8

You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script?

（A）The seed will be opened read-only.

（B）The seed will be in mount state.

（C）The seed will be opened read/write.

（D）The other PDBs will be in mount state.

（E）The other PDBs will be opened read-only.

（F）The PDBs will be opened read/write.

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

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

質問 9

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

（A）improved Serial Execution performance

（B）reduced virtual memory utilization

（C）reduced logical I/O

（D）reduced physical I/O

（E）reduced CPU utilization

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

質問 10

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

（A）BACKUP SPFILE SECTION SIZE 1M;

（B）BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

（C）BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

（D）BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

（E）BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

（F）BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

（G）BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

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

1Z1-060 無料問題集「Oracle Upgrade to Oracle Database 12c」

弊社を連絡する

関連リンク

トップ試験