搜题

【多选题】

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）

A、ALTER DATABASE FLASHBACK ON;

B、GRANT SELECT any transaction TO scott;

C、GRANT EXECUTE ON dbms_flashback TO scott;

D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

E、ALTER TABLESPACE undots1 RETENTION GUARANTEE;

F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

查看正确答案

更多“User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）”相关的问题

第1题

[多选题] User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)

A、ALTER DATABASE FLASHBACK ON; B、GRANT SELECT any transaction TO scott; C、GRANT EXECUTE ON dbms_flashback TO scott; D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; E、ALTER TABLESPACE undots1 RETENTION GUARANTEE; F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

点击查看答案

第2题

[多选题] You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

A、All the objects of scott are moved to the Recycle Bin. B、Any objects in the Recycle Bin belonging to scott are purged. C、All the objects owned by scott are permanently dropped from the database. D、All the objects of scott in the Recycle Bin must be purged before executing the DROP command. E、Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

点击查看答案

第3题

[多选题] User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）

A、 ALTER DATABASE FLASHBACK ON B、 GRANT SELECT any transaction TO scott C、 GRANT EXECUTE ON dbms_flashback TO scott D、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA E、 ALTER TABLESPACE undots1 RETENTION GUARANTEE F、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS

点击查看答案

第4题

[] User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror after the INSERT statement is issued and few rows are inserted：INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *ERROR at line 1： ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions eitherof which will help you resolve this problem. （） User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror after the INSERT statement is issued and few rows are inserted：INSERT&en

A、A.Grant the RESOURCE role to SCOTT. B、B.Add data files to the USERS tablespace. C、C.Grant the CREATE ANY TABLE privilege to SCOTT. D、D.Increase the space for SCOTT on the USERS tablespace. E、E.Increase the size of the data file associated with the USERS tablespace

点击查看答案

第5题

[单选题] What will be the result of using the SQL> DROP USER SCOTT CASCADE； command？（）

A、 The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are already in the Recycle Bin are dropped. B、 The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped. C、 The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped. D、 The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.

点击查看答案

第6题

[] 授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是（）。

A、A.GRANT CHANGE ON SCOTT.EMP TO SA B、B.GRANT UPDATE ON SCOTT.EMP（SAL） TO SA C、C.GRANT UPDATE （SAL） ON SCOTT.EMP TO SA D、D.GRANT MODIFY ON SCOTT.EMP（SAL） TO SA

点击查看答案

第7题

[单选题] You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code： SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP （’SCOTT’， ’GRP1’， FALSE）； How will you grant the switch privilege to the user， Scott？（）

A、 by using the DBMS_SESSION package B、 by granting the DBA role C、 by using the DBMS_RESOURCE_MANAGER package D、 by using the DBMS_RESOURCE_MANAGER_PRIVS package

点击查看答案

第8题

[单选题] User SCOTT wants to export his objects using Oracle Data Pump and executes the following command： $ expdp scott/tiger directory = EXPORT_DIR dumpfile = scott.dmp include = table include = view："like ’%DEPARTMENTS%’" content = DATA_ONLY Which task would the command accomplish？（）

A、A B、B C、C D、D E、E

点击查看答案

第9题

[] You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（） You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

A、A. You must have change tracking enabled in your database B、B. Your database must be running in NOARCHIVELOG mode C、C. To back up a tablespace, it must be in backup mode D、D. To back up a tablespace, it must first be taken offline

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服