niusouti.com

单选题A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore 

题目
单选题
A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）
A

 Flashback Drop

B

 Flashback Query

C

 Flashback Versions Query

D

 Flashback Transaction Query

E

 Flashback Table

相似考题

1.He died _________ the earthquake.A. shortly asB. shortly afterC. shortly whileD. short after

2.（ 35 ） “ 把查询 sc 表和更新 sc 表的 grade 列的权限授予用户 user1 ” 的正确 SQL 语句是A ） GRANT SELECT ， UPDATE （ grade ） ON TABLE sc TO user1B ） GRANT SELECT sc ， UPDATE sc . grade TO user1C ） GRANT SELECT ， UPDATE ON TABLE sc . grade TO user1D ） GRANT SELECT ON TABLE sc ， UPDATE ON TABLE sc(grade) TO user1

3.Which of the following is enabled in the BIOS that will prompt a user to enter their password every time the laptop performs a POST?()A. Power User accessB. Power on passwordC. Administrative passwordD. User profile access

4.Shortly after the accident, Terry Lapham was _____ from his post as project manager.A.dismissedB.discussedC.disappearedD.discovered

更多“A user performs an update on a table. Shortly after committi”相关问题

  • 第1题：

    Kerberos is a form of user authentication that:()

    A. Provides users access to network resources.

    B. Performs router commands after user authentication.

    C. Provides users with remote access only capabilities.

    D. Does not require an authentication server


    参考答案：A

  • 第2题：

    更改oracle用户HR，使其变为不可用（锁定）状态（）

    • A、UPDATE  USER  HR  ACCOUNT  DISABLE
    • B、UPDATE  USER  HR  ACCOUNT  LOCK
    • C、ALTER USER  HR  ACCOUNT  DISABLE
    • D、ALTER USER  HR  ACCOUNT  LOCK

    正确答案:D

  • 第3题：

    Kerberos is a form of user authentication that:（）

    • A、Provides users access to network resources.
    • B、Performs router commands after user authentication.
    • C、Provides users with remote access only capabilities.
    • D、Does not require an authentication server

    正确答案:A

  • 第4题：

    You have been tasked with performing an update to the IDP attack database. Which three requirements areincluded as part of this task？（）

    • A、The IDP security package must be installed after it is downloaded.
    • B、The device must be rebooted to complete the update.
    • C、The device must be connected to a network.
    • D、An IDP license must be installed on your device.
    • E、You must be logged in as the root user

    正确答案:A,C,D

  • 第5题：

    A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）

    • A、 Flashback Drop
    • B、 Flashback Query
    • C、 Flashback Versions Query
    • D、 Flashback Transaction Query
    • E、 Flashback Table

    正确答案:E

  • 第6题：

    单选题
    The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）
    A

    An update in a leaf row takes place.

    B

    The index becomes invalid after the update.

    C

    The leaf block containing the row to be updated is marked as invalid.

    D

    A row in the leaf block of the index for the key value is deleted and inserted.


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

  • 第7题：

    单选题
    Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）
    A

    The table created by SKD isnot accessibleand SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    D

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


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

  • 第8题：

    多选题
    Shortly after the Press Ctrl-Alt-Delete to login screen appears in Windows XP， a user gets the error One or more services failed to start. Which of the following locations could be accessed to identify the service that did not start and attempt to start the service manually？（）
    A

    Computer Management

    B

    Services MMC Plug-in

    C

    Event Log

    D

    Task Manager

    E

    System Configuration Utility


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

  • 第9题：

    单选题
    All the database users are presently connected to the database instance and working. The HR userhas opened 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 seethe effect of the UPDATE and DELETE commands （）
    A

    all sessions of the HR user only

    B

    all sessions of the HR user and the SYS user

    C

    the session of the HR user that executed the commands

    D

    all the sessions for which the database users have access privilege to the PERSONS table


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

  • 第10题：

    多选题
    The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table：  ERROR at line 1：  ORA-00060： deadlock detected while waiting for resource  On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock.  two statements are true regarding the session of SCOTT in this scenario（）
    A

    The session is terminated after receiving the error and JIM can continue with his transaction.

    B

    SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

    C

    The session is rolled back after receiving the error and JIM can continue with his transaction.

    D

    SCOTT has to reexecute the last command in the transaction after he commits the transaction.


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

  • 第11题：

    单选题
    A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）
    A

     Flashback Drop

    B

     Flashback Query

    C

     Flashback Versions Query

    D

     Flashback Transaction Query

    E

     Flashback Table


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

  • 第12题：

    单选题
    You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? （）
    A

    CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

    B

    CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

    C

    CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3

    D

    CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;

    E

    CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;


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

  • 第13题：

    Shortly after the accident, two___________ police were sent to the spot to keep order.

    A.dozens of
    B.dozens
    C.dozen of
    D.dozen

    答案：D
    解析：
    此题题干中的空前有数词two修饰，dozen不能加S，其后也不能加of，故选D。译为事故发生后不久，有二十四个警察被派往现场维持秩序。

  • 第14题：

    Which of the following is enabled in the BIOS that will prompt a user to enter their password every time the laptop performs a POST?（）

    • A、Power User access
    • B、Power on password
    • C、Administrative password
    • D、User profile access

    正确答案:B

  • 第15题：

    Shortly after the Press Ctrl-Alt-Delete to login screen appears in Windows XP， a user gets the error One or more services failed to start. Which of the following locations could be accessed to identify the service that did not start and attempt to start the service manually？（）

    • A、Computer Management
    • B、Services MMC Plug-in
    • C、Event Log
    • D、Task Manager
    • E、System Configuration Utility

    正确答案:A,B

  • 第16题：

    The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）

    • A、An update in a leaf row takes place.
    • B、The index becomes invalid after the update.
    • C、The leaf block containing the row to be updated is marked as invalid.
    • D、A row in the leaf block of the index for the key value is deleted and inserted.

    正确答案:D

  • 第17题：

    You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）

    • A、 Create an INSERT trigger to assign the default value to each item in the table. 
    • B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. 
    • C、 Create an UPDATE trigger to update the default value for each new item in the table. 
    • D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.

    正确答案:D

  • 第18题：

    单选题
    Which of the following is enabled in the BIOS that will prompt a user to enter their password every time the laptop performs a POST?（）
    A

    Power User access

    B

    Power on password

    C

    Administrative password

    D

    User profile access


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

  • 第19题：

    单选题
    “把查询sc表和更新sc表的grade列的权限受予用户user1”的正确SQL语句是（）。
    A

    GRANT SELECT，UPDATE（grade）ON TABLE sc TOuser1

    B

    GRANT SELECT sc，UPDATE sc，grade TO user1

    C

    GRANT SELECT，UPDATE ON TABLE sc.grade TO user1

    D

    GRANT SELECT ON TABLE sc，UPDATE ON TABLE sc（grade）TO user1


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

  • 第20题：

    单选题
    View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table： SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；  Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table：  SQL> ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））；  What would happen in this scenario（）
    A

    The ALTER TABLE command modifies the column successfully.

    B

    The DDL operation gets higher priority and transaction for user a is rolled back.

    C

    The ALTER TABLE command waits indefinitely until user a ends the transaction.

    D

    The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.


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

  • 第21题：

    单选题
    The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?（）
    A

    TRIG_A

    B

    TRIG_B

    C

    TRIG_C

    D

    TRIG_D


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

  • 第22题：

    多选题
    You have been tasked with performing an update to the IDP attack database. Which three requirements areincluded as part of this task？（）
    A

    The IDP security package must be installed after it is downloaded.

    B

    The device must be rebooted to complete the update.

    C

    The device must be connected to a network.

    D

    An IDP license must be installed on your device.

    E

    You must be logged in as the root user


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

  • 第23题：

    单选题
    The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）
    A

    The command fails because SCOTT still has privileges.

    B

    The command succeeds and privileges are revoked from JIM.

    C

    The command fails because HR cannot revoke the privileges from JIM.

    D

    The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.


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

  • 第24题：

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

    B

    All sessions of the HR user and the SYS user

    C

    The session of the HR user that executed the commands

    D

    All the sessions for which the database users have access privilege to the PERSONS table


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

相关内容