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题：

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

第2题：

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

第3题：

_______________

[A] introduce

[B] summon

[C] trigger

[D] create

正确答案：D

第4题：

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

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

正确答案:D

第5题：

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

第6题：

A.REFERENCES

B.SELECT

C.UPDATE

D.ALTER

参考答案：D

第7题：

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

第8题：

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

第9题：

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

第10题：

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

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

正确答案:B,E

A user needs to create a trigger

题目

相似问题和答案

更多相关问题

相关内容