网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “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” 相关考题
考题
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;
考题
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;
考题
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
考题
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.
考题
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.
考题
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 passwordB、create a shell script usingdscli commands； trigger the script from the operating system， and call the script using the -pwd option with the passwordC、create a password file； create a shell script using dscli commands； trigger the script from the operating systemD、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
考题
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 susanIDENTIFIED by blue;F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;
考题
Which two traffic types trigger pass-through firewall user authentication？（）A、SSHB、TelnetC、ICMPD、OSPFE、HTTP
考题
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
考题
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.
考题
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 LPARB、Create a stripe-group within the Virtual IO Server to protect against disk failureC、Reconfigure the user LPAR to use both locally owned disk and a Virtual SCSI diskD、Create a second Virtual IO Server and reconfigure the user LPAR to mirror across both Virtual IO Servers
考题
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;
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
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）.
考题
单选题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.
考题
单选题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 passwordB
create a shell script usingdscli commands； trigger the script from the operating system， and call the script using the -pwd option with the passwordC
create a password file； create a shell script using dscli commands； trigger the script from the operating systemD
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
考题
多选题Which two traffic types trigger pass-through firewall user authentication？（）ASSHBTelnetCICMPDOSPFEHTTP
考题
单选题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_AB
TRIG_BC
TRIG_CD
TRIG_D
考题
单选题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.
考题
单选题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.
热门标签
最新试卷
