单选题A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A REFERENCESB SELECTC UPDATED

题目
单选题
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）
A

REFERENCES

B

SELECT

C

UPDATE

D

ALTER

相似考题

1.A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A.REFERENCESB.SELECTC.UPDATED.ALTER

2.Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?()A.Define the column MAINID as NOT UPDATABLEB.Define the column MAINID as a PRIMARY KEYC.Define the column MAINID as a FOREIGN KEYD.Define an UPDATE trigger on table TABLEX

3.A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A、REFERENCESB、SELECTC、UPDATED、ALTER

4.Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()A.REVOKE DROP ON t1 FROM PUBLICB.REVOKE UPDATE ON t1 FROM PUBLICC.REVOKE DELETE ON t1 FROM PUBLICD.REVOKE CONTROL ON t1 FROM PUBLIC

更多“单选题A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A REFERENCESB SELECTC UPDATED”相关问题

  • 第1题：

    Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）

    • A、Define the column MAINID as NOT UPDATABLE
    • B、Define the column MAINID as a PRIMARY KEY
    • C、Define the column MAINID as a FOREIGN KEY
    • D、Define an UPDATE trigger on table TABLEX

    正确答案:D

  • 第2题：

    Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）

    • A、REVOKE DROP ON t1 FROM PUBLIC
    • B、REVOKE UPDATE ON t1 FROM PUBLIC
    • C、REVOKE DELETE ON t1 FROM PUBLIC
    • D、REVOKE CONTROL ON t1 FROM PUBLIC

    正确答案:C

  • 第3题：

    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 user creates a table. 3. The SKD user grants the CREATE TABLE 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 isperformed（）

    • A、The table created by SKD is not accessible and 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.

    正确答案:C

  • 第4题：

    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.

    正确答案:C

  • 第5题：

    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.

    正确答案:B

  • 第6题：

    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

    • A、 Create a FOR trigger. 
    • B、 Create an INSTEAD OF trigger. 
    • C、 Create an AFTER trigger. 
    • D、 Create a DDL trigger.

    正确答案:B

  • 第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.


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

  • 第8题：

    多选题
    User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）
    A

    null lock on the row being updated

    B

    null lock on the table containing the row

    C

    ROW SHARE lock for the row being updated

    D

    ROW EXCLUSIVE lock for the row being updated

    E

    shared row-exclusive lock for the row being updated

    F

    a shareable table lock for the table containing the row

    G

    exclusive table-level lock for the table containing the row


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

  • 第9题：

    单选题
    You want to create a temporary table while executing a procedure in a form. Which statement is true?（）
    A

    You cannot create a table form within Forms. 

    B

    You must use the FORMS_DDL built-in to create the table. 

    C

    You must use the DBMS_DYNAMIC_DDL package to create the table. 

    D

    You can write the CREATE TABLE statement directly into the trigger.


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

  • 第10题：

    单选题
    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 user creates a table. 3. The SKD user grants the CREATE TABLE 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 isperformed（）
    A

    The table created by SKD is not accessible and 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.


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

  • 第11题：

    单选题
    Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）
    A

    Define the column MAINID as NOT UPDATABLE

    B

    Define the column MAINID as a PRIMARY KEY

    C

    Define the column MAINID as a FOREIGN KEY

    D

    Define an UPDATE trigger on table TABLEX


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

  • 第12题：

    单选题
    A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）
    A

    REFERENCES

    B

    SELECT

    C

    UPDATE

    D

    ALTER


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

  • 第13题：

    A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）

    • A、Table
    • B、Columns
    • C、Table and Alias
    • D、Columns and Alias

    正确答案:A

  • 第14题：

    In which scenario do you use the Flashback Database feature？（）

    • A、 when a table is dropped and you restore it from the Recycle Bin
    • B、 when a user’s schema is dropped and you recover the user’s schema
    • C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
    • D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

    正确答案:B

  • 第15题：

    Consider this syntax：   MERGE INTO t1  USING t2 ON （join predicate）…..   What does the MERGE syntax do？（）

    • A、It performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. 
    • B、It creates a natural join of tables T1 and T2 for all columns that have the same name. 
    • C、It creates a Cartesian product of table T1 and table T2 for all columns that have the same name. 
    • D、For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.

    正确答案:D

  • 第16题：

    You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）

    • A、The tablespace TBS1 is full.
    • B、The user is not the owner of the SYSTEM tablespace.
    • C、The user does not have quota on the TBS1 tablespace.
    • D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
    • E、The user does not have sufficient privileges to create table on the default permanent tablespace.

    正确答案:C

  • 第17题：

    In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL > REVOKE create table FROM C # # A_ADMIN;What is the result?（）

    • A、It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
    • B、It fails and reports an error because the CONTAINER=ALL clause is not used.
    • C、It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
    • D、It fails and reports an error because the CONTAINER=CURRENT clause is not used.
    • E、It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

    正确答案:A

  • 第18题：

    单选题
    In which scenario do you use the Flashback Database feature？（）
    A

     when a table is dropped and you restore it from the Recycle Bin

    B

     when a user’s schema is dropped and you recover the user’s schema

    C

     when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp

    D

     when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration


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

  • 第19题：

    单选题
    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）
    A

     Create a FOR trigger. 

    B

     Create an INSTEAD OF trigger. 

    C

     Create an AFTER trigger. 

    D

     Create a DDL trigger.


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

  • 第20题：

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


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

  • 第21题：

    单选题
    Consider this syntax：   MERGE INTO t1  USING t2 ON （join predicate）…..   What does the MERGE syntax do？（）
    A

    It performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. 

    B

    It creates a natural join of tables T1 and T2 for all columns that have the same name. 

    C

    It creates a Cartesian product of table T1 and table T2 for all columns that have the same name. 

    D

    For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.


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

  • 第22题：

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

  • 第23题：

    单选题
    You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）
    A

    The tablespace TBS1 is full.

    B

    The user is not the owner of the SYSTEM tablespace.

    C

    The user does not have quota on the TBS1 tablespace.

    D

    The user does not have sufficient system privileges to create table in the TBS1 tablespace.

    E

    The user does not have sufficient privileges to create table on the default permanent tablespace.


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

  • 第24题：

    单选题
    Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）
    A

    REVOKE DROP ON t1 FROM PUBLIC

    B

    REVOKE UPDATE ON t1 FROM PUBLIC

    C

    REVOKE DELETE ON t1 FROM PUBLIC

    D

    REVOKE CONTROL ON t1 FROM PUBLIC


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

相关内容