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

相似考题

1.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;

2.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

3.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.

4.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.

更多“You are working as a DBA at NetFx Corporation. A user， Scott”相关问题

  • 第1题：

    在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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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.

    正确答案:A

  • 第6题：

    单选题
    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
    解析： 暂无解析

  • 第7题：

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


    正确答案： C
    解析： 暂无解析

  • 第8题：

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


    正确答案： D
    解析： 暂无解析

  • 第9题：

    多选题
    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.


    正确答案： C,D
    解析： 暂无解析

  • 第10题：

    多选题
    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.


    正确答案： E,D
    解析： 暂无解析

  • 第11题：

    多选题
    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


    正确答案： D,C
    解析： 暂无解析

  • 第12题：

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


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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.

    正确答案:A,D

  • 第17题：

    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;

    正确答案:B,C,D,F

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

    多选题
    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;


    正确答案： B,F
    解析： 暂无解析

  • 第20题：

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


    正确答案： C
    解析： 暂无解析

  • 第21题：

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


    正确答案： B
    解析： 暂无解析

  • 第22题：

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


    正确答案： B
    解析： 暂无解析

  • 第23题：

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


    正确答案： A
    解析： 暂无解析

  • 第24题：

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


    正确答案： B
    解析： 暂无解析

相关内容