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

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

You are administering a multitenant container database (CDB) cdb1.
Examine the command andits output:
SQL>show parameter file
NAME TYPE VALUE
-----------------------------------------------------------------------
Db_create_file_dest string
Db_file_name_convert string
Db_files integer 200
You verify that sufficient disk space is available and that no file currently exists in the
‘/u0l/app/oracle/oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATE PLUGGABLE DATABASE SALESPDB
ADMIN USER salesadm IDENTIFIED BY password ROLES=(dba)
DEFAULT TABLESPACE sales
DATAFILE '/u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf’ SIZE 250M AUTOEXTEND
ON
FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/',
'/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE 2G)
PATH_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';
Which statement is true?

Youare administering a multitenant container database (CDB)that contains multiplepluggable databases (PDBs). You are connected to cdb$root as the sysuser.
You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL>
GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;
Which statement is true about the c##connect role?

Examine the command:
$expdp SYSTEM FULL=Y DUMPFILE=dpump_dir1:full1%U.dmp, dpump_dir2:full2% U.dmp,
Dpump_dir3:full3%U.dmp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull
Which statement is true about the execution of the command?

You are administering a database that supports data warehousing workload and Is
Running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure. You want to recover the data file.
Examine the steps involved in the recovery process:
1 Shut down the database instance.
2 Start up the database instance in nomount state.
3 Mount the database.
4 Take the data file offline.
5 Put the data file online.
6 Restore the controlfile.
7 Restore the database.
8 Restore the data file.
9 Open the database with the resetlogs option.
10 Recover the database with the no redo option.
11 Recover the data file with the no redo option.
Identify the required steps in the correct order.

You execute the RMAN commands:
4 / 60RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs).
You execute the command to create a common user:
SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users
QUOTA 100M ON users TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them
To pluggable databases (PDBs). You have already created a test system to support the
Consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?

You are required to migrate your 11.2.0.3 database to an Oracle 12c database. Examine
7 / 60the list of steps that might be used to accomplish this task:
1 Place all user-defined tablespaces in read-only mode on the source database.
2 Use the RMAN convert command to convert data files to the target platform's endian format,
If required.
3 Perform a full transportable export on the source database with the parameters
VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.
4 Transport the data files for all the user-defined tablespaces.
5 Transport the export dump file to the target database.
6 Perform an import on the target database by using the full, network_link, and
Transportable_datafiles parameters.
7 Perform an import on the target database by using the full and transportable_datafiles
Parameters.
Identify the required steps in the correct order.

Because of logical corruption of data in a table, you want to recover the table from an

RMAN backup to a specified point in time.

Examine the steps to recover this table from an RMAN backup:

1 Determine which backup contains the table that needs to be recovered.

2 Issue the recover table RMAN command with an auxiliary destination defined and the

Point in time specified.

3 Import the Data Pump export dump file into the auxiliary instance.

4 Create a Data Pump export dump file that contains the recovered table on a target

Database.

Identify the required steps in the correctorder.

Your database is running in archivelogmode.
Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/arch'
8 / 60LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/arch MANDATORY'
Identify the statement that correctly describes these settings.

In a database supporting an OLTP workload, tables are frequently updated on both key

And non-key columns. Reports are also generated by joining multiple tables.

Which table organization or type would provide the best performance for this hybrid Workload?

Your database supports a Decision Support System (DSS)workload that involves the
Execution of complex queries. Currently, the database is running with peak workload. You
Want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and
Materialized views to improve query performance?

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your
10 / 60UNIX-based Oracle 12c database:
CONNECT /AS SYSDBA
ALTER SYSTEM SET THREADED EXECUTION= TRUE SCOPE=SPFILE;
SHUTDOWN IMMEDIATE
You then restart the instance and get an error:
STARTUP
ORA-01031: insufficient privileges
Why does the startup command return the error shown?

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

You specified the warning and critical thresholds for a locally managed tablespace to be60% and 70%, respectively. From the tablespace space usage metrics, you find that the spaceUsage has reached the specified warning threshold value, but no alerts have been generated.What could be the reason for this?

Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the datafile?

You want to reduce fragmentation and reclaim unused space for the sales table but not its
Dependent objects.
During this operation, you want to ensure the following:
I. Long-running queries are not affected.
Ii. No extra space is used.
Iii. Data manipulation language (DML) operations on the table succeed at all times throughout
The process.iv. Unused space is reclaimed both above and below the high water mark. Which alter TABLE
Option would yourecommend?

You wish to create jobs to satisfy theserequirements:
1 Automatically bulk load data from a flat file.
2 Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?

Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks isperformed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies therequirements?

Consider the following scenario for yourdatabase:- Backup optimization is enabled inRMAN.- The recovery window is set to seven days inRMAN.- The most recent backup to disk for the tools tablespace was taken on March 1, 2013.- The tools tablespace is read-only since March 2,2013.On March 15, 2013, you issue the RMAN command to back up the database to disk.Which statement is true about the backup of the tools tablespace?

1 2 3 4 5 6 17