063_在线真题试卷与模拟练习_063

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

You restore and recover your database to a new host by using an existing RMAN open
Database backup.
Which step must you perform next?

Examine the RMANcommand:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

In which situation can you use Flashback Database?

You create a default Flashback DataArchive FLA1and 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?

You want to back up a database such that only formatted blocks are backed up.
Which statement is true about this backup operation?

Your database is running in archive log mode and regular nightly backups are taken. Due
To a media failure, the current online redo log group, which has one member, is lost and the
Instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1 Restore the corrupted redo log group. 19 / 60
2 Restore the database from the most recent database backup.
3 Perform an incomplete recovery.
4 Relocate the member of the damaged online redo log group to a new location.
5 Open the database with the reset logs option.
6 Issue a checkpoint and clear the log.
Identify the required steps in the correct order.

LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet
Directory (OID).
SSL has been configure for the database and OID 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?

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 thedatabase.
4 Run the Database Configuration Assistant (DBCA)to create the database.
5 Run OUI in graphical mode on eachmachine.
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.

Your database has a table customers that contains the columns cust_name, amt_due, and old_status. Examine the commands executed and their output:
SQL>UPDATE customers SET amt_due=amt_due+amt_due*l. 1 WHERE cust_name='JAMES'; 1
Row updated.
SQL> ALTER TABLE customers DROP COLUMN old_status; Table Altered
SQL> UPDATE customers SET amt_due=amt_due+amt_due*1.5 WHERE cust_name='JAMES';
1 row updated.
SQL> COMMIT;
SQL> SELECT versions_xid AS XID, versions_startscn AS START_SCN,
Versions_endscn AS END_SCN, versions_operation AS OPERATION, amt_due FROM
Customers VERSIONS BETWEEN SCN MINVALULE AND MAXVALUE
WHERE custname='JAMES';
XID START_SCN END_SCN OPERATION AMT_DUE
---------------------------------------------------------------------------------------------------------------
07002f00cl030000 1706337 1706337 U 3300
Why is it that only one update is listed by the Flashback Version Query?

When is the UNDO_RETENTION parameter value ignored by a transaction?

You want to capture column group usage and gather extended statistics for better
Cardinality estimates for the customers table in the SHschema.
Examine the following steps:
1 Issue the SELECT DBMS_STATS. CREATE_EXTENDED_STATS (‘SH’, 'CUSTOMERS')from dual statement.
2 Execute the dbms_stats.seed_col_usage (null,‘SH’,500)procedure.
3 Execute the required queries on the customers table.
4 Issue the select dbms_stats.report_col_usage(‘SH’, 'customers')from dual statement.
Identify the correct sequence ofsteps.

Examine the steps/operations performed during the RMAN backup operation by using
Oracle Secure Backup (OSB):
1 Start the RMAN client by using the RMAN target /command.
2 Start the RMAN client by using the OSBuser.
3 RMAN creates the backup pieces.
4 Run the RMAN backup command with the sbt channels.
5 OSB creates a backup job and assigns a unique identifier.
6 OSB creates a backup job request through the OSB sbt library.
7 OSB stores metadata about RMAN backup pieces in the OSBcatalog.
8 OSB starts the backupoperation.
9 OSB updates the RMANcatalog.
Identify the required steps/operations performed in correct order.

The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set
To /u01/app/oracle/product/12.1.0/db_1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository
(ADR). Examine the initialization parameters set in your database.
NAME TYPE VALUE
-------------------------------------------- ------------------- ------------------------------------------------
Audit_file_dest string /u01/app/oracle/admin/eml2rep/adump
Background_dump_dest string
Core_dump_dest string
Db_create_file_dest string
Db_recovery_file_dest string /u01/app/oracle/fast_recovery_area
Diagnostic_dest string
What is the location of the ADR base?

Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
1 Create media families for data files and archived redo log files.
2 Configure database backup storage selectors or RMAN media management parameters.
3 Create an OSB user preauthorized for RMAN operations.
4 Configure RMAN Access to the OSB SBT.
5 Disable Non-Uniform MemoryAccess (NUMA) awareness by setting the ob_ignore_numa parameter to 0.
Identify the steps in the correct order.

You are administering a multitenant container database (CDB)that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?

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 telecom company wishes to generate monthly bills to include details of customer calls,
Listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?

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##role1 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?

Examine the following set of RMANcommands:
RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ;
RMAN> RUN
{
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN run block execution?

Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

1 2 3 4 5 6 17