IT Certification Exam Questions & Answers

QUESTION 92
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

QUESTION 93
Which two statements are true about the use of the procedures listed in the
v$sysaux_occupants.move_procedure column? (Choose two.)

QUESTION 94
Your database is running in NOARCHIVLOG mode.
Examine the following parameters:

You execute the following command after performing a STARTUP MOUNT:
SQL> ALTER DATABASE ARCHIVELOG;
Which statement is true about the execution of the command?

QUESTION 95
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to
back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost
an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data? (Choose three.)

QUESTION 96
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command? (Choose two.)

QUESTION 97
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode? (Choose four.)

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

Which statement is true?

QUESTION 99
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

QUESTION 100
You execute this command:

Which two statements are true about segment space management for segments in this tablespace?

QUESTION 101
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle
Database 12c when it is enabled?

QUESTION 102
Which two statements are true about the logical storage structure of an Oracle database?

QUESTION 103
Examine the parameters for your database instance:

You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?

QUESTION 104
You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.

QUESTION 105
Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);
Which two statements are true?

QUESTION 106
Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

QUESTION 107
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement? (Choose three.)

QUESTION 108
Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:

And then grant OPS$GUEST_USERthe CREATE SESSIONprivilege.
Which two statements are true? (Choose two.)

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

QUESTION 110
What is a pre-requisite to alter a role?

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

QUESTION 112
Which three statements are true concerning unplugging a pluggable database (PDB)?

QUESTION 113
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

QUESTION 114
What is the effect of specifying the “ENABLE PLUGGABLE DATABASE” clause in a “CREATE DATABASE” statement?

QUESTION 115
You create a locally managed tablespace ORDERS_TBS with automatic segment management.
You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?