网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Examine the commands executed in the following sequence： 1：SQL> CREATE ROLE mgrrole； 2：SQL> GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL> GRANT select，update ON sh.sales TO mgrrole； 4：SQL> CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL> GRANT ceo TO mgrrole； Which statement is true about the above commands（）
A
The commands execute successfully.
B
Command 6 produces an error because of circular role grant.
C
Command 5 produces an error because a role cannot be granted to another role.
D
Command 3 produces an error because the MGRROLE role already contains system privileges.
E
The table created by HR remains and HR still has the CREATE TABLE system privilege.
F
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
参考答案
参考解析
解析：
暂无解析
更多 “单选题Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）A The commands execute successfully.B Command 6 produces an error because of circular role grant.C Command 5 produces an error because a role cannot be granted to another role.D Command 3 produces an error because the MGRROLE role already contains system privileges.E The table created by HR remains and HR still has the CREATE TABLE system privilege.F The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.” 相关考题
考题
Examine the following commands and their output:SQL SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.
考题
Examine the following set of RMAN commands:Which statement is true when the RMAN RUN block Is executed?()
A. The execution of the script fails because multiple channels cannot coexist.B. The script is executed and both the channels are used for the script execution.C. The new channel, CHI, is Ignored because a channel has been configured already.D. ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.
考题
Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.
考题
Examine the following command;ALTER SYSTEM SET enable_ddl_logging = TRUE;Which statement is true?()
A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B. All DDL commands are logged in the alert log file.C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D. Only DDL commands that resulted in the creation of new segments are logged.E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
考题
In(71)programming, the user determines the sequence of instructions to be executed, not programmer。A．structureB．event-drivenC．top-downD．data-driven
考题
A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO:con1hvarWhat is the current value of the :con1hvar host variable?（）A.2B.3C.11D.30
考题
In ______ programming, the user determines the sequence of instructions to be executed, not programmer.A．top-downB．structureC．data-drivenD．event-driven
考题
Which of the following commands should Karen, a technician, use to examine and restoreprotected system files?（）A、SFCB、RECOVERC、REPLACED、COPY
考题
Which of the following commands displays the number of system calls per second that are being executed？（）A、 sarB、 pstatC、 iostatD、 filemon
考题
Which of the following commands should be used to identify packet sequence problems？（）A、 ping and arpB、 lsattr and ifconfigC、 netstat and iostatD、 iptrace and tcpdump
考题
A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO:con1hvarWhat is the current value of the :con1hvar host variable?（）A、2B、3C、11D、30
考题
The following databases are registered in the base recovery catalog： PROD1， PROD2， and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this： 1.SQL GRANT recovery_catalog_owner TO vpc1； 2.RMAN CONNECT CATALOG vpc1/password@catdb； 3.RMAN GRANT CATALOG FOR DATABASE prod1 TO vpc1； 4.RMAN CONNECT CATALOG catowner/password@catdb； 5.RMAN CREATE VIRTUAL CATALOG； What is the correct sequence in which the commands have to be executed？（） A、 1，4，5，2，3B、 1，4，3，2，5C、 4，5，2，3，1D、 2，3，4，5，1E、 1，4，2，3，5
考题
What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ； A、 The entire backup will fail.It will not be usable for recovery.B、 The entire backup will failbut any datafile successfully backed up will be usable for recovery.C、 If this backup fails，subsequent backups will prioritize datafiles not backed up.D、 If this backup fails，an error will be raised and any other commands will not be executed. E、 If this backup fails，no error will be raised and any other commands will be executed.
考题
Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
考题
单选题The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL GRANT recovery_catalog_owner TO vpc1; 2.RMAN CONNECT CATALOG vpc1/password@catdb; 3.RMAN GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN CONNECT CATALOG catowner/password@catdb; 5.RMAN CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?（）A
1, 4, 5, 2, 3B
1, 4, 3, 2, 5C
4, 5, 2, 3, 1D
2, 3, 4, 5, 1E
1, 4, 2, 3, 5
考题
单选题Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL SHUTDOWN IMMEDIATE SQL STARTUP MOUNT SQL FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）A
Only 1B
Only 2C
Only 3D
3 and 1E
1 and 2
考题
单选题Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）A
The commands execute successfully.B
Command 6 produces an error because of circular role grant.C
Command 5 produces an error because a role cannot be granted to another role.D
Command 3 produces an error because the MGRROLE role already contains system privileges.E
The table created by HR remains and HR still has the CREATE TABLE system privilege.F
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
单选题Examine the following command: SQL ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）A
The shrink operation touches every block in the BOOKING tableB
The high-water mark (HWM) for the BOOKING table is shifted from its original positionC
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD
The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
考题
单选题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）A
Only the SET command must be within a RUN block.B
All commands should be executed at the RMAN prompt.C
All three commands must be within a single RUN block.D
Only the RESTORE and RECOVER commands must be within a single RUN block.
考题
单选题Which of the following commands should be used to identify packet sequence problems？（）A
ping and arpB
lsattr and ifconfigC
netstat and iostatD
iptrace and tcpdump
考题
单选题Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A
The table is moved to the SYSAUX tablespace.B
The table is moved to the SYSTEM tablespace.C
The table is removed from the database permanently.D
The table is renamed and remains in the TBSFD tablespace.
考题
单选题Examine the following command： SQL ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）A
The shrink operation touches every block in the BOOKING tableB
The high-water mark （HWM） for the BOOKING table is shifted from its original positionC
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD
The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
考题
单选题Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN RUN { 2 SET UNTIL SEQUENCE 230 THREAD 1； 3 ALTER DATABASE MOUNT； 4 RESTORE DATABASE； 5 RECOVER DATABASE； 6 ALTER DATABASE OPEN RESETLOGS； 7 }； With reference to this scenario， which statement is true？（）A
RMAN recovers up to log sequence 230， but not including 230.B
RMAN returns an error because the log sequence number mentioned in the command should be 229.C
RMAN returns an error because the log sequence number mentioned in the command may never be missing.D
RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
考题
单选题Which of the following commands cannot be executed when the database open？（）A
RECOVER DATABASEB
RECOVER TABLESPACEC
RECOVER DATAFILED
ALTER DATABASE RECOVER DATAFILE
考题
单选题Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）A
Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B
All DDL commands are logged in the alert log file.C
All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D
Only DDL commands that resulted in the creation of new segments are logged.E
All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
考题
单选题All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands（）A
All sessions of the HR user onlyB
All sessions of the HR user and the SYS userC
The session of the HR user that executed the commandsD
All the sessions for which the database users have access privilege to the PERSONS table
考题
单选题What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；A
The entire backup will fail.It will not be usable for recovery.B
The entire backup will failbut any datafile successfully backed up will be usable for recovery.C
If this backup fails，subsequent backups will prioritize datafiles not backed up.D
If this backup fails，an error will be raised and any other commands will not be executed. E
If this backup fails，no error will be raised and any other commands will be executed.
热门标签
最新试卷
