网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQL>UPDATE EMPLOYEE SET SALARY = 2000 WHERE EMPNO = ’E0025’； SQL>COMMIT； On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQL>UPDATE EMPLOYEE SET SALARY = 2400 WHERE EMPNO = ’E0025’； SQL>COMMIT； On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’ SQL>UPDATE EMPLOYEE SET SALARY = 2900 WHERE EMPNO = ’E0025’； SQL>COMMIT； On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）
A
Flashback Drop
B
Flashback Table
C
Flashback Database
D
Flashback Version Query
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQLUPDATE EMPLOYEE SET SALARY = 2000 WHERE EMPNO = ’E0025’； SQLCOMMIT； On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQLUPDATE EMPLOYEE SET SALARY = 2400 WHERE EMPNO = ’E0025’； SQLCOMMIT； On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’ SQLUPDATE EMPLOYEE SET SALARY = 2900 WHERE EMPNO = ’E0025’； SQLCOMMIT； On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）A Flashback DropB Flashback TableC Flashback DatabaseD Flashback Version Query” 相关考题
考题
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;
考题
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.
考题
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?()
A. no privilegesB. only the SELECT privilegeC. only the CONNECT privilegeD. all the privileges of a default user
考题
The DBA issues this SQL command:What privileges does the user Scott have at this point?()
A. No privileges.B. Only the SELECT privilege.C. Only the CONNECT privilege.D. All the privileges of a default user.
考题
在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）A.ALTER USER scott IDENTIFIED BY helloB.ALTER scott USER IDENTIFIED BY helloC.ALTER USER scott IDENTIFIED AS helloD.ALTER USER hello IDENTIFIED BY scott
考题
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）A、 Only the Flashback TableB、 Both the Flashback Transaction Query and the Flashback Version QueryC、 Only the Flashback DropD、 Only the Flashback Version
考题
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）A、 the datafiles associated with the SYSTEM tablespaceB、 the datafiles associated to the DATA1 tablespaceC、 the datafiles associated to the SYSTEM and DATA1 tablespacesD、 all the datafiles in the database
考题
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT
考题
You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（） A、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.B、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.C、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.D、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
考题
You issued the following statement to monitor the usage of the index： SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（） A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
考题
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）A、no privilegesB、only the SELECT privilegeC、only the CONNECT privilegeD、all the privileges of a default user
考题
You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）A、 The batch operation started by the user， SCOTT， terminates with an error.B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.
考题
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）A、No privileges.B、Only the SELECT privilege.C、Only the CONNECT privilege.D、All the privileges of a default user.
考题
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;
考题
单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A
V$FLASHBACK_DATABASE_LOGB
V$FLASHBACK_DATABASE_STATC
V$DATABASED
V$UNDOSTAT
考题
单选题Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）A
the datafiles associated with the SYSTEM tablespaceB
the datafiles associated to the DATA1 tablespaceC
the datafiles associated to the SYSTEM and DATA1 tablespacesD
all the datafiles in the database
考题
单选题The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）A
no privilegesB
only the SELECT privilegeC
only the CONNECT privilegeD
all the privileges of a default user
考题
多选题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.)AALTER DATABASE FLASHBACK ON;BGRANT SELECT any transaction TO scott;CGRANT EXECUTE ON dbms_flashback TO scott;DALTER DATABASE ADD SUPPLEMENTAL LOG DATA;EALTER TABLESPACE undots1 RETENTION GUARANTEE;FALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
考题
单选题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.
考题
单选题You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）A
Only the Flashback TableB
Both the Flashback Transaction Query and the Flashback Version QueryC
Only the Flashback DropD
Only the Flashback Version
考题
多选题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are purged.CAll the objects owned by scott are permanently dropped from the database.DAll the objects of scott in the Recycle Bin must be purged before executing the DROP command.EAny objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
考题
单选题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 packageB
by granting the DBA roleC
by using the DBMS_RESOURCE_MANAGER packageD
by using the DBMS_RESOURCE_MANAGER_PRIVS package
考题
多选题You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）AThe batch operation started by the user， SCOTT， terminates with an error.BThe batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.CThe batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.DThe user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.EThe user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.
考题
单选题You issued the following statement to monitor the usage of the index： SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）A
INDEX_STATSB
DBA_INDEXESC
DBA_IND_COLUMNSD
V$OBJECT_USAGE
考题
多选题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？（）AALTER DATABASE FLASHBACK ONBGRANT SELECT any transaction TO scottCGRANT EXECUTE ON dbms_flashback TO scottDALTER DATABASE ADD SUPPLEMENTAL LOG DATAEALTER TABLESPACE undots1 RETENTION GUARANTEEFALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS
考题
单选题The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）A
No privileges.B
Only the SELECT privilege.C
Only the CONNECT privilege.D
All the privileges of a default user.
考题
单选题You are working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQLUPDATE EMPLOYEE SET SALARY = 2000 WHERE EMPNO = ’E0025’； SQLCOMMIT； On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQLUPDATE EMPLOYEE SET SALARY = 2400 WHERE EMPNO = ’E0025’； SQLCOMMIT； On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’ SQLUPDATE EMPLOYEE SET SALARY = 2900 WHERE EMPNO = ’E0025’； SQLCOMMIT； On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）A
Flashback DropB
Flashback TableC
Flashback DatabaseD
Flashback Version Query
考题
单选题You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）A
The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.B
The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.C
The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.D
The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
热门标签
最新试卷