CMS专题

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

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

参考答案和解析
正确答案： C
解析： 暂无解析
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The DBA issues this SQL command: CREATE USER scott IDENTIFIED 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


参考答案：A

第2题：

在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）

A.ALTER USER scott IDENTIFIED BY hello

B.ALTER scott USER IDENTIFIED BY hello

C.ALTER USER scott IDENTIFIED AS hello

D.ALTER USER hello IDENTIFIED BY scott


正确答案：A

第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;


参考答案：B, C, D, F

第4题：

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.

正确答案:A

第5题：

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 tablespace
  • B、 the datafiles associated to the DATA1 tablespace
  • C、 the datafiles associated to the SYSTEM and DATA1 tablespaces
  • D、 all the datafiles in the database

正确答案:D

第6题：

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.


参考答案：A

第7题：

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 Table
  • B、 Both the Flashback Transaction Query and the Flashback Version Query
  • C、 Only the Flashback Drop
  • D、 Only the Flashback Version

正确答案:B

第8题：

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.


参考答案：B, C

第9题：

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_LOG
  • B、 V$FLASHBACK_DATABASE_STAT
  • C、 V$DATABASE
  • D、 V$UNDOSTAT

正确答案:A

第10题：

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_STATS
  • B、 DBA_INDEXES
  • C、 DBA_IND_COLUMNS
  • D、 V$OBJECT_USAGE

正确答案:D

更多相关问题
相关内容