The HR user executes the following q

多选题

The HR user executes the following query on the EMPLOYEE table but does not issue COMMIT, ROLLBACK, or an data definition language (DDL) command after that：

SQL> SELECT job FROM employees WHERE job=‘CLERK’ FOR UPDATE OF empno;

HR then opens a second session. Which two operations wait when executed in HR’s second session?

A、

SELECT empno, ename FROM employee WHERE job= ‘ CLERK ’ ;

B、

INSERT INTO employee (empno, ename, job) VALUE (2001, ‘ Harry ’,‘ CLERK ’);

C、

SELECT job FROM employees WHERE job= ‘ CLERK ’ FOR UPDATE OF empno;

D、

INSERT INTO employee (empno, ename) VALUE (1289, ‘ Dick ’ );

E、

LOCK TABLE employee IN EXCLUSIVE MODE;

查看答案

下载APP答题

由4l***ph提供分享举报纠错

相关试题

单选题 Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management(ASM). How would you achieve this?

A、

by using RMAN

B、

by using Data Pump

C、

by using the Database Upgrade Assistant (DBUA)

D、

by using a transportable database

查看答案

单选题 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

Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transaction?

A、

Transactions write their undo in a temporary tablespace

B、

Transactions fail.

C、

Transactions write their undo in the SYSTEM undo segment.

D、

Transactions wait until space becomes available in UNDOTBS1

查看答案

单选题 Examine the details of he uncompressed,non-partitioned heap table CITIES.

Name null type

CITYID NOT NULL NUMBER(4)

CITY_NAME VARCHAR2(50)

Examine the command:

SQL>ALTER TABLE cities SHRINK SPACE COMPACT;

What must you do before executing it?

A、

Make sure that row movement is disabled

B、

Disable any constraints on the table

C、

Make sure that row movement is enabled.

D、

Make any invisible indexes on the table visible.

E、

Make all indexes on the table invisible.

查看答案

单选题 what is a requirement for creating a remote database scheduler job?

A、

The remote database job must run as a user that is valid on target remote database

B、

A private datbase link must be created from the originating database to the target remote database

C、

The target remote database on which the job is shceduled must be Oracle Database 11g Release 2 or later 11.1

D、

The target remote database must be on a different host from the originating scheduler database host

查看答案

单选题 Examine these commands and output:

SELECT open_mode from v4database;

------------------------------------

READ WRITE

ARCHIVE LOG LIST;

Database log mode No archive Mode

Automatic archive Dsiabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Now examine these steps

1)STARTUP NOMOUNT

2)STARTUP MOUNT

3)STARTUP FORCE

4)ALTER DATABASE ARCHIVELOG

5)ALTER DATABASE MOUNT;

6)ALTER DATABASE OPWEN RESETLOGS

7)SHUTDOWN IMMEDIATE

8)ALTER DATABASE OPEN;

Identify the required steps in the correct order to change the database to run in ARCHIBELOG mode.

A、

7,1,4,5,6

B、

7,2,4,8

C、

3,4,8

D、

7,2,4,6

E、

3,4,6

查看答案

单选题 One of your databases has archive logging enabled and RMAN backups are taken at regular intervals.

The data file for the USERS tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace?

A、

SWITCH DATAFILE ALL;

B、

STARTUP FORCE

C、

ALTER TABLESPACE users OFFLINE TEMPORARY;

D、

ALTER TABLESPACE users OFELINE NORMAL;

E、

ALTER TABLESPACE users OFFLINE IMMEDIATE;

查看答案

单选题 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?

A、

COLUMN STORE COMPRESS FOR QUERY HIGH

B、

ROW STORE COMPRESS ADVANCED

C、

COLUNN STORE COMPRESS FOR QUERY LOW

D、

COLUNN STORE COMPRESS FOR ARCHIVE HIGH

E、

COLUNN STORE COMPRESS FOR ARCHIVE LOW

查看答案

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

A、

Use Enterprise Manager Express.

B、

Use SQL*Developer

C、

Use the Database Creation Assistant(DBCA)to upgrade

D、

Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

E、

Perform a rolling upgrade.

查看答案