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、AL

题目

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] introduce[B] summon[C] trigger[D] create

2.Which statement creates a new user? ()A. CREATIVE USER susan;B. CREATIVE OR REPLACE USER susan;C. CREATE NEW USER susan DEFAULTD. CREATE USER susan IDENTIFIED BY blue;E. CREATE NEW USER susan IDENTIFIED BY blue;F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;

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.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, user3B. CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3C. CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3D. 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;

更多“A user needs to create a trigger”相关问题

  • 第1题：

    User2 is complaining that he is unable to list the contents of a directory. What is the most likely cause?()

    A. User2 needs write permission to the directory.

    B. User2 needs both read and write permissions to the directory.

    C. User2 needs both read and execute permissions to the directory.

    D. User2 needs both write and execute permissions to the directory.


    参考答案：C

  • 第2题：

    A storage specialist needs to automate some tasks triggered in the event of disaster recovery.  What is the best solution to accomplish this（）

    • A、using the DS GUI， step through Real Time Manager， Copy Services， Create custom scripts； actions and event conditions can be defined that triggerthe script； there is no need for a password
    • B、create a shell script usingdscli commands； trigger the script from the operating system， and call the script using the -pwd option with the password
    • C、create a password file； create a shell script using dscli commands； trigger the script from the operating system
    • D、create a password file； create a shell script usingdscli commands； trigger the script from the operating system； call the dscli script with the dscli -script  -pwdfile command

    正确答案:C

  • 第3题：

    下列（）语句用于删除触发器。

    • A、CREATE PROCEDURE
    • B、CREATE TRIGGER
    • C、ALTER TRIGGER
    • D、DROP TRIGGER

    正确答案:D

  • 第4题：

    What three tasks are required to add a CRS application?（）

    • A、create a trigger  
    • B、create an application  
    • C、restart the CRS engine  
    • D、upload script to repository  
    • E、configure default session timeout 

    正确答案:A,B,D

  • 第5题：

    Companycom LPAR that is using a Virtual IO Server needs to be more highly available. How can this be accomplished using APV features?（）

    • A、Reallocate the Virtual IO Server disks to the user LPAR
    • B、Create a stripe-group within the Virtual IO Server to protect against disk failure
    • C、Reconfigure the user LPAR to use both locally owned disk and a Virtual SCSI disk
    • D、Create a second Virtual IO Server and reconfigure the user LPAR to mirror across both Virtual IO  Servers

    正确答案:D

  • 第6题：

    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

  • 第7题：

    You install Microsoft Windows Vista on a computer.  You will share the computer with another user.  You need to prevent the user from making unauthorized changes to the computer.  What should you do？ （）

    • A、Add the user to the Guests group.
    • B、Create a standard user account for the user.
    • C、Create an administrator account for the user.
    • D、Add the user to the Remote Desktop Users group.

    正确答案:B

  • 第8题：

    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

  • 第9题：

    You need to recommend a strategy for delegating administration to the consulting firm.What should you recommend？（）

    • A、Create local user accounts.
    • B、Create domain user accounts.
    • C、Create IIS Manager user accounts.
    • D、Implement Active Directory Lightweight Directory Services （AD LDS）.

    正确答案:C

  • 第10题：

    单选题
    A storage specialist needs to automate some tasks triggered in the event of disaster recovery.  What is the best solution to accomplish this（）
    A

    using the DS GUI， step through Real Time Manager， Copy Services， Create custom scripts； actions and event conditions can be defined that triggerthe script； there is no need for a password

    B

    create a shell script usingdscli commands； trigger the script from the operating system， and call the script using the -pwd option with the password

    C

    create a password file； create a shell script using dscli commands； trigger the script from the operating system

    D

    create a password file； create a shell script usingdscli commands； trigger the script from the operating system； call the dscli script with the dscli -script  -pwdfile command


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

  • 第11题：

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

  • 第12题：

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

  • 第13题：

    The network printer is locking up and printing garbled text. When the user cancels the job fromtheir local print queue, nothing happens. Which of the following is the MOST likely cause?（）

    • A、The printer needs to be power cycled to clear the job.
    • B、The print server’s queue needs to be checked.
    • C、The printer needs to be set to factory defaults.
    • D、The user’s workstation needs to be rebooted.

    正确答案:B

  • 第14题：

    Which statement creates a new user?（）

    • A、CREATE USER susan;
    • B、CREATE OR REPLACE USER susan;
    • C、CREATE NEW USER susan    DEFAULT;
    • D、CREATE USER susan    IDENTIFIED BY blue;
    • E、CREATE NEW USER susan   IDENTIFIED by blue;
    • F、CREATE OR REPLACE USER susan   IDENTIFIED BY blue;

    正确答案:D

  • 第15题：

    Which two traffic types trigger pass-through firewall user authentication？（）

    • A、SSH
    • B、Telnet
    • C、ICMP
    • D、OSPF
    • E、HTTP

    正确答案:B,E

  • 第16题：

    User2 is complaining that he is unable to list the contents of a directory. What is the most likely cause?（）

    • A、User2 needs write permission to the directory.
    • B、User2 needs both read and write permissions to the directory.
    • C、User2 needs both read and execute permissions to the directory.
    • D、User2 needs both write and execute permissions to the directory.

    正确答案:C

  • 第17题：

    Which statement creates a new user?（）

    • A、CREATIVE USER susan;
    • B、CREATIVE OR REPLACE USER susan;
    • C、CREATE NEW USER susan DEFAULT
    • D、CREATE USER susan IDENTIFIED BY blue;
    • E、CREATE NEW USER susan IDENTIFIED BY blue;
    • F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;

    正确答案:D

  • 第18题：

    You have a master-detail relationship in the EMPLOYEE form module. You set the Delete Record Behavior property to Cascading. When a user deletes a master record, how does Forms implement the cascade-delete foreign-key rule? （）

    • A、With a Pre-Delete trigger. 
    • B、With an On-Delete trigger. 
    • C、With a Post-Delete trigger. 
    • D、With the On-Check-Delete-Master trigger.

    正确答案:A

  • 第19题：

    You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You create a window named ManageOrders that contains a Button control named showOtherSide. You add an animation named FlipSides as a resource of ManageOrders. You need to ensure that the following requirements are met: FlipSides runs each time a user clicks showOtherSide. FlipSides runs only when a user clicks showOtherSide. What should you do?（）

    • A、 Add a property trigger to the Triggers collection of ManageOrders.   Configure the property trigger to be based on the IsPressed property of showOtherSide. 
    • B、 Add an event trigger to the Triggers collection of ManageOrders.   Configure the event trigger to be based on the Click event of showOtherSide.
    • C、 Call the BeginAnimation method of showOtherSide.   Pass FlipSides as a parameter of the BeginAnimation method. 
    • D、 Call the BeginAnimation method of ManageOrders.   Pass FlipSides as a parameter of the BeginAnimation method.

    正确答案:B

  • 第20题：

    TestKing.com has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user. What are two possible ways to achieve this goal？（）

    • A、Create a function that returns a list of values that represent the login times for the given user.
    • B、Create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.
    • C、Create a function that returns a numeric value that represents the number of hours that a user has logged for the current day.
    • D、Create a function that returns a numeric value that represents the number of hours that a user has logged for the current month.

    正确答案:C,D

  • 第21题：

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

  • 第22题：

    多选题
    Which two traffic types trigger pass-through firewall user authentication？（）
    A

    SSH

    B

    Telnet

    C

    ICMP

    D

    OSPF

    E

    HTTP


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

  • 第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
    解析： 暂无解析

相关内容