单项选择题

Examine the following steps performed on a database instance：
1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.
2. The SKD user creates a table.
3. The SKD user grants the CREATE TABLE system privilege to the HR user.
4. The HR user creates a table.
5. The DBA revokes the CREATE TABLE system privilege from SKD.
Which statement is true after step 5 isperformed（）

A.The table created by SKD is not accessible and SKD cannot create new tables.
B.The tables created by SKD and HR remain， but both cannot create new tables.
C.The table created by HR remains and HR still has the CREATE TABLE system privilege.
D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

<上一题目录下一题>

热门试题

多项选择题YouaremanaginganOracleDatabase11gdatabasewiththefollowingbackupstrategy：1）OnSunday，anincrementallevel0tapebackupisperformed.2）MondaythroughSaturday，acumulativeincrementallevel1tapebackupisperformed.Whichtwostatementsaretrueregardingthebackupsperformed（）

A.The backup performed in step 1 backs up all blocks that have ever been in use in the database.
B.The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
C.The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
D.The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1

单项选择题View the Exhibit and identify the component marked with a question mark.（）

A.Checkpoint （CKPT）
B.Process Monitor （PMON）
C.Archiver Processes （ARCn）
D.Recoverer Process （RECO）
E.Memory Manager process （MMAN）

多项选择题Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）

A.The SGA advisor will be disabled.
B.The MTTR advisor will be disabled.
C.Automatic checkpoint tuning will be disabled.
D.Checkpoint information will not be written to the alert log file.

单项选择题View the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）

A.The user must enable the role explicitly.
B.The user can grant the role to other users.
C.The user cannot use the role until the DBA enables it explicitly.
D.The user can start using the role immediately without any changes

单项选择题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（）

A.The backup will consist of used data blocks only.
B.The database must be shut down to accomplish the backup.
C.The backup can be accomplished without shutting down the database.
D.The backup will contain all database files that have never been backed up