1Z1-060問題集、Oracle実際の試験問題

質問 1

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 DDL commands that resulted in the creation of new segments are logged.

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

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

正解: B

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

質問 2

You issue the following command to alter the country column in the departments table:

Which statement is true?

A. It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'.

B. It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table.

C. It produces an error because column definitions cannot be altered to add default values.

D. It produces an error because the data type for the column is not specified.

正解: A

質問 3

Which two are true concerning a multitenant container database with three pluggable databases?

A. Pluggable databases increase patching time.

B. Pluggable databases can make database consolidation easier

C. Pluggable databases are patched together

D. All administration tasks must be done to each pluggable database.

E. Pluggable databases in the same container database (CDB) each have their own buffer cache

正解: B,C

質問 4

You need to create a table for a banking application. One of the columns in the table has the following requirements:
1) You want a column in the table to store the duration of the credit
period.
2) The data in the column should be stored in a format such that it can be easily added and subtracted with date data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30
days.
4) The interest has to be calculated for the number of days an
individual has taken a credit for.
Which data type would you use for such a column in the table?

A. TIMESTAMP

B. INTERVAL YEAR TO MONTH

C. DATE

D. INTERVAL DAY TO SECOND

E. NUMBER

正解: D

質問 5

You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
` /mydir/rman_change_track.f';
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true?

A. More than one database block may be read by an incremental backup for a change made to a single block.

B. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

C. The change tracking file must always be backed up when you perform a full database backup.

D. Block change tracking will always reduce I/O performed during cumulative incremental backups.

E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

正解: A,B,E

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

質問 6

Which two statements are true when row archival management is enabled?

A. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

B. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

C. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

D. The ORA_ARCHIVE_STATEcolumn is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

E. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

正解: B,E

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

質問 7

Which statement is true regarding the default behavior of the order by clause?

A. Numeric values are displayed from the maximum to the minimum value if they have decimal positions.

B. NULL values are not considered at all by the sort operation.

C. In a character sort, the values are case-sensitive.

D. Only those columns that are specified in the select list can be used in the order by clause.

正解: C

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

質問 8

Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX?

A. The local listener may pass the request to an existing process which in turn will create a thread.

B. Thread creation must be routed through a dispatcher process.

C. Each multithreaded Oracle process has an SCMN thread.

D. Each Oracle process runs an SCMN thread.

正解: A,B

質問 9

In your Oracle 12c database, you create two roles: AUDITORand AUDIT_ADMIN. You then execute the following commands:

To create a privilege analysis policy for the AUDIT_ADMINrole, you execute the following PL/SQLblock:

Which statement is correct about the procedure?

A. It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT module is used.
PAYABLE

B. It always captures the use of the privileges exercised through the AUDITOR and AUDIT_ADMIN roles.

C. It captures the use of the privileges used through the AUDIT_ADMIN and AUDITOR roles when the module is used.
ACCOUNT PAYABLE

D. It always captures the use of the CREATE VIEW and CREATE TABLE privileges.

正解: A

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

質問 10

You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN:
RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION
`+RECO';
Which five steps are performed by RMAN?

A. truncating the SCOTT.EMP table in the original database

B. flashing back the original database to the desired point in time

C. recovering the auxiliary database to the desired point in time

D. restoring the tablespaces required for point-in-time recovery

E. exporting the SCOTT.EMP table from the auxiliary database

F. dropping the SCOTT.EMP table in the original database

G. creating an auxiliary instance

H. importing the SCOTT.EMP table into the original database

正解: B,C,D,G,H

質問 11

Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOGmode. An RMAN backup exists for the databases.
You issue the following commands and get an error:

Examine the following commands:

Identify two correct sequences of commands to perform a recovery and make the data available.

A. 1,2,3,4,7,8

B. 1,2,5,6,7,8

C. 1,2,10,5,6,9

D. 10,3,4,8,9

正解: B,C

質問 12

The tnsnames.ora file has an entry for the service alias ORCL as follows:

The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?

A. The orcl.oracle.com database service is not registered with the listener.

B. The TNS_ADMIN environment variable is set to the wrong value.

C. The listener is running on a different port.

D. The listener is not running on the database node.

E. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.

正解: A

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

質問 13

You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
- RANDOM redaction on the SAL and COMM columns
- PARTIAL redaction on the HIREDATE column
- FULL redaction on the MGR column
What would you define to implement this?

A. several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type

B. several redaction policies, with one redaction policy for each table column that must be redacted

C. several redaction policies, with one redaction policy foe each data type defined for the table must be redacted

D. one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted

正解: D

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

質問 14

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

A. All the components may be moved from the SYSAUX tablespace.

B. All the components may be moved into SYSAUX tablespace.

C. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

D. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

正解: C,D

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

Oracle Upgrade to Oracle Database 12c - 1Z1-060 模擬練習