062_在线真题试卷与模拟练习_062_考试宝

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Your database has one control file and the instance is started using an
SPFILE. Examine these steps:
1) Issue SHUTDOWN IMMEDIATE
2) Issue STARTUP MOUNT
3) Issue STARTUP NOMOUNT
4) Copy the existing control file to the new location
5) Issue ALTER DATABASE OPEN
6) Issue STARTUP
7) Update the CONTROL_FILES initialization parameter in the SPFILE to include an
Additional file. Identify the minimum required steps in the correct order to multiplex the
Control file.

Examine this backup strategy for the ORCL database:
1) A LEVEL 0 backup is taken every two weeks.
2) A CUMULATIVE LEVEL 1 backup is taken weekly.
3) A DIFFERENTIAL LEVEL 1 backup is taken daily.
Which blocks are backed up in the CUMULATIVE LEVEL 1 backup?

Your database is in ARCHIVELOG mode. (同062重点1的52题几乎
一样) You want to disable archiving for the database.
Examine these steps:
1) Execute the ALTER DATABASE NOARCHIVELOG command.
2) Execute SHUTDOWN IMMEDIATE.
3) Execute STARTUP MOUNT.
4) Set the DB_ RECOVERY_ FILE_DEST parameter to $ORACLE_HOME/ dbs/.
5) Execute STARTUP NOMOUNT.
6) Open the database.
7) Execute SHUTDOWN TRANSACTIONAL
Identify the required steps in the correct
Sequence.

You must create a table, DAILY_ORDERS, for a DSS application.

Data should be compressed when using direct-path INSERT.

The table will also be used for occasional DSS queries.

Load performance is critical.

Which compression option satisfies these requirements?

You must upgrade your Oracle 11g Database to Oracle 12c R2.Which method can you use?

Examine the details of the uncompressed, non-partitioned heap table CITIES:
Name Null? Type
-------------------------- -------------------------- --------------------------
CITYID NOT NULL NUMBER (4)
CITY_NAME VARCHAR2 (50)
Examine the command:
SCL>ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?

Examine these commands and output:
Now examine these steps
1) STAR NOMOUNT
2) STARTUP MOUNT
3) STARTUP FORCE
4) ALTER DATABASE ARCHIVELOG;
5) ALTER DATABASE MOUNT
6) ALTER DATABASE OPEN RESETLOGS;
7) SHUTDOWN IMMEDIATE
8) ALTER DATABASE OPEN;
Identify the required steps in the correct order to change the database to run in ARCHIVELOG
Mode

The hr schema exists in databases, BOSTON and DENVER, with the same password, HR.
You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.
DENVER is defined as a service name in the tnsnames.ora of both databases.
You plan to use this command:
CREATE DATABASE LINK hr link CONNECT TO hr IDENTIFIED BY hr USING ' DENVER'
What must be done to ensure that all users in BOSTON can access the hr schema in DENVER?

Which four are true about creating and running a remote database scheduler obs?

Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database?

Which three statements are true PFILEs, SPFILEs or both?

Which two statement are true about using SQL*Loader?

You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can
You use?

Which two statements describe the relationship between a scheduler window, a resource Manager plan, and a job class?

Which are two ways for a database service to be recognized by a listener in Oracle Database 12c?

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken.
RMAN is configured to perform control file autobackup. In which three scenarios do you need media
Recovery?

Examine the parameters for a database instance:
NAME TYPE VALUE
----------------------------- ----------------------- -----------------------------
Temp_undo_enabled boolean TRUE
Undo_management string AUTO
Undo_retention integer 900
Undo_tablespace string UNDOTBS1
Which two statements are true?

Your database supports an online transaction processing (OLTP) workload in which one of the
Applications creates a temporary table for a session and performs transactions on it. This
Consumes a lot of undo tablespace and generates lots of redo. Which two actions would you
Take to solve this problem?

Backup requirements for a database:
*Level 0 backup on Sunday
*Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
*Differential incremental level 1 backup on Tuesday, Thursday, and Friday
Which three statements are true about the strategy?

You want a job that performs a bulk insert as soon as the loader file arrives on the local file system.

Which two would you do to accomplish this?