星期二『51-100』

Q.51
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 can reference activity tracking columns,
    to indicate that a row is no longer considered active.
B. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns,
   to indicate that a row is no longer considered active.
C. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
D. The row archival visibility session parameter defaults to all rows.
E. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
Correct Answer: A,E


Q.52
You have installed two 64G flash devices to support the Database Smart Flash Cache feature 
on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ' /dev/f lash_device_1'
                    ,' /dev/f lash_device_2'
How should the D3_flash_cache_size be configured to use both devices?
A. Set DB_FLASH_CACHE_SIZE=64G.
B. Set DB_FLASH_CACHE_SIZE=64G, 64G.
C. Set DB_FLASH_CACHE_SIZE=128G.
D. db_flash_cache_size is automatically configured by the instance at startup.
Correct Answer: B


Q.53
Examine the commands executed in the root container of your multitenant container database (CDB) 
that has multiple pluggable databases (PDBs):
SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;
SQL> REVOKE c##role1 FROM c##a_admin;
What is the result of the revoke command?
A. It fails and reports an error because the container=all clause is not used.
B. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.
C. It fails and reports an error because the comtainer=current clause is not used.
D. It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
Correct Answer: B


Q.54
In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?
A. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.
B. The tablespace will be renamed and all the changes will be logged in the alert log.
C. The tablespace will be renamed and a message written to the alert log indicating 
   that you should change the corresponding initialization parameter.
D. The tablespace will be renamed but the data file headers will not be updated.
E. The statement will fail because you cannot rename an undo tablespace.
Correct Answer: B


Q.55
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. 
You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1.Create directory structures similar to the production database on all new machines.
2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3.Create a database clone template for the database.
4.Run the Database Configuration Assistant (DBCA) to create the database.
5.Run OUI in graphical mode on each machine.
6.Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.
A. 2, 1, 6, and 4
B. 1, 5, and 4
C. 3, 1, 5, and 6
D. 2, 3, 1, and 6
E. 2, 3, and 6
Correct Answer: D


Q.56
Your database supports an OLTP workload. Examine the output of the query:
SQL> SELECT target_mttr,
            estimated_mttr
       FROM v$instance_recovery
Target_mttre stimated_mttr
------------ -------------
           0            76
To ensure faster instance recovery, 
you set the fast_start_mttr target initialization parameter to 30.
What is the effect of this setting on the database?
A. The MTTR advisor is disabled.
B. Automatic checkpoint tuning is disabled.
C. The frequency of log switches is increased.
D. The overhead on database performance is increased because of frequent writes to disk.
Correct Answer: B


Q.57
You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk1/%U;
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/disk2/%U;
RMAN>BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUP command?
A. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2.
B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations.
C. Two channels are allocated and two copies of the backup set are taken in parallel in both locations.
D. The default channel is allocated and the backup set is created in only one destination.
Correct Answer: A


Q.58
LDAP_DIRECTORY_SYSAUTH is set to YES.
(LDAP_DIRECTORY_SYSAUTHでは、SYSDBAおよびSYSOPERのディレクトリベースの認可を使用可能または使用禁止にします。)
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).
SSL has been configure for the database and OLD and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplus scott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?
A. authentication by using the Oracle Internet Directory
B. authentication by password file
C. authentication by using the local OS of the database server
D. authentication by using certificates over SSL
Correct Answer: B


Q.59
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
A. when the duplicate ... from active database command contains the section size clause
B. when you perform active database duplication on a database with flashback disabled
C. when you specify set encryption before the duplicate ... from active database command
D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
E. when you perform active database duplication on a database that has read-only tablespaces
Correct Answer: A,C,D


Q.60
Your database is running in archivelog mode and a nightly backup of the database, 
along with an autobackup of the control file, is taken by using RMAN. 
Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the startup force nomount command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in nomount state.
Identify the required steps in the correct order.
A. 2, 1, 5, 6, 7, 4, 3
B. 1, 2, 5, 3, 6, 4
C. 1, 2, 3, 5, 6, 4
D. 2, 1, 5, 7, 3, 4
Correct Answer: D


Q.61
You plan to use the In-Database Archiving feature of Oracle Database 12c, 
and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?
A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
D. Database files stored in ZFS and accessed using conventional NFS mounts.
E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
Correct Answer: A,E,G


Q.62
You are performing regular backups of your production database by using a recovery catalog.
You add two new tablespaces to your production database after performing a backup. 
They must be included in future backups.
Which action should you perform?
A. Synchronize all the physical data files with the logical records in the recovery catalog 
   by using the CROSSCHECK command.
B. Synchronize the recovery catalog with the target database control file.
C. Add the tablespaces in the recovery catalog by using the CATALOG command.
D. Create a new database incarnation record.
Correct Answer: B


Q.63
In your database, the user SCOTT wants to retrieve the dropped HR. 
EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed?
A. Undo retention guarantee must be enabled.
B. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.
C. The recycle bin should be enabled.
D. SCOTT should have the FLASHBACK ANY TABLE privilege.
E. No other table with the same name should exist in the HR schema.
F. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.
Correct Answer: B,C,D


Q.64
You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command:
SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?
A. It executes successfully and continues to store metadata related to the EMPLOYEES table.
B. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.
C. It executes successfully and all metadata related to the EMPLOYEES table before 
   altering the table definition is purged from Flashback Data Archive.
D. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
Correct Answer: A


Q.65
Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00', 'YYYY-MM- DD HH:MI:SS');
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customer FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?
A. 2,3,5,6
B. 1,2,5
C. 1,3,6
D. 3,4,5
Correct Answer: A


Q.66
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$.oraenv
ORACLE_SID = [oracle] ? cdb1
The oracle base for ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle 
$ rman target /
Recovery Manage: Release 12.1.0.0.2 - Production on Fri Jul19 05:18:33:2013
Copyright (c) 1982,2013,Oralce and/or its affiliates. All rights reserved.
Connected to  target database :CBD1(DBID=782249327)
RMAN>SELECT name FROM v$tablespace;
Which statement is true about the execution of the last command?
A. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
B. It succeeds and displays all the tablespaces that belong to the root database.
C. It fails and returns an error because a connection is not made by using the sysdba privilege.
D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
Correct Answer: B


Q.67
You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?
A. ALTER TABLESPACE adtbs RESIZE 20G;
B. ALTER TABLESPACE adtbs ADD DATAFILE;
C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
D. ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;
Correct Answer: A,C


Q.68
You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET = 90M
SGA_TARGET = 270M
Which two statements are true?
A. The value of the memory_max_target parameter remains zero for the database instance.
B. The pga_aggregate_target and sga_target parameters are automatically set to zero.
C. The memory_max_target parameter is automatically set to 500 MB.
D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
E. The instance does not start up because Automatic Memory Management (AMM)
   is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.
Correct Answer: A,E


Q.69
Your database instance is abnormally terminated because of a power outage. 
At the next startup, from which point in the redo log does the recovery start?
A. from the last complete checkpoint position
B. from the beginning of the current redo log file until the instance failure
C. from the last committed transaction
D. from the beginning of the current redo log file to the checkpoint position
E. from the most recent incremental checkpoint
Correct Answer: A


Q.70
Which statement is true about the loss or damage of a temp file that belongs to the temporary 
tablespace of a pluggable database (PDB)?
A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
B. The PDB is closed and requires media recovery at the PDB level.
C. The PDB does not close and starts by using the default temporary tablespace defined for the CD.
D. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
Correct Answer: A


Q.71
Which two statements are true about Flashback Version Query?
A. The result of a query can be used as part of a DML statement.
B. It retrieves all versions of rows that exist in a time interval, including the start time and end time.
C. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.
D. It can be used only if Flashback Data Archive is enabled for a table.
E. It can be used to create views.
Correct Answer: A,D


Q.72
Which two statements are true about a multitenant architecture?
A. Each pluggable database (PDB) has its own initialization parameter file.
B. A PDB can have a private temporary tablespace.
C. Each PDB has a private control file.
D. Log switches occur only at the container database level.
E. A PDB can have a private undo tablespace.
Correct Answer: B,D


Q.73
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually.
 Examine the following steps:
1.Set the evolve task parameters.
2.Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3.Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps.
A. 1, 2, 3, 4, 5
B. 1, 2, 4, 5
C. 2, 1, 4, 3, 5
D. 2, 4, 5
Correct Answer: C


Q.74
You want to consolidate backup information and centrally manage backup and recovery scripts 
for multiple databases running in your organization.
Which two backup solutions can be used?
A. Oracle Secure Backup
B. RMAN Media Management Library
C. Enterprise Manager Database Express
D. Enterprise Manager Cloud Control
E. RMAN recovery catalog
Correct Answer: D,E


Q.75
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs),
 pdb2_1 and pdb2_2, both of which are open. 
RMAN is connected to the target pluggable database pdb2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?
A. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.
B. All data files belonging to pdb2_1 are backed up and all archive log files are deleted.
C. All data files belonging to pdb2_1 are backed up along with the archive log files.
D. Only the data files belonging to pdb2_ are backed up.
Correct Answer: C


Q.76
You are administering a multitenant container database (CDB) that has no startup triggers 
and contains three pluggable databases (PDBs).
You execute the command to start up the CDB.
SQL> STARTUP
Which statement is true?
A. CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.
B. CDB$ROOT and PDB$SEEDare opened in read-only mode, but the PDBs are in closed mode.
C. CDB$ROOT is opened in read/write mode, but PDB$SEEDand the PDBs are in closed mode.
D. CDB$ROOT is opened in read/write mode, PDB$SEEDin read-only mode, and the PDBs in MOUNT state.
E. CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.
Correct Answer: D