网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
单选题
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 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 TableB ColumnsC Table and AliasD Columns and Alias” 相关考题
考题 （ 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
查看答案
考题 实现“取消用户USER4对学生表STUD中学号(XH)的修改权限”这一功能的SQL语句是( )。A．REVOKE UPDATE (XH) ON TABLE FROM USER4;B．REVOKE UPDATE (XH) ON TABLE STUD FROM PUBLIC ;C．REVOKE UPDATE (XH) ON TABLE STUD FROM USER4;D．REVOKE ALL PRIVILEGES ON TABLE STUD FROM USER4;
查看答案
考题 “把查询SC表和更新SC表的9rade列的权限授予用户user”的正确SQL语句是（ ）。A)GRANT.SELECT sc, UPDATE sc.grade TO userB)GRANT SELECT, UPDATE (grade) ON TABLE sc TO userC)GRANT SELECT, UPDATE ON TABLE sc.grade TO userD)GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc(grade) TO user
查看答案
考题 Which view should a user query to display the columns associated with the constraints on a table owned by the user? () A. USER_CONSTRAINTSB. USER_OBJECTSC. ALL_CONSTRAINTSD. USER_CONS_COLUMNSE. USER_COLUMNS
查看答案
考题 Which data dictionary table should you query to view the object privileges granted to the user on specific columns? () A. USER_TAB_PRIVS_MADEB. USER_TAB_PRIVSC. USER_COL_PRIVS_MADED. USER_COL_PRIVS
查看答案
考题 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.TableB.ColumnsC.Table and AliasD.Columns and Alias
查看答案
考题 Which method will configure an e－mail notification when permanent hardware errors are logged in the errorlog?() A.Create or update the errnotify stanza in the ODM.B.Update errpt daemon configuration file /etc/errpt.conf.C.Update errpt daemon configuration file /var/adm/errpt.conf.D.Define a notification alias in the /etc/syslog.conf file with the *.error stanza.
查看答案
考题 Which of the following privileges permits a user to update the comment on a sequence?() A.CONTROLB.UPDATEC.USAGED.ALTER
查看答案
考题 在Oracle中,()数据字典表可以用来查看抽象数据类型的实际结构。 A.USER_TYPE_ATTRSB.USER_TABLESC.USER_TYPE_TABSD.USER_TAB_COLUMNS
查看答案
考题 更改oracle用户HR，使其变为不可用（锁定）状态（）A、UPDATE  USER  HR  ACCOUNT  DISABLEB、UPDATE  USER  HR  ACCOUNT  LOCKC、ALTER USER  HR  ACCOUNT  DISABLED、ALTER USER  HR  ACCOUNT  LOCK
查看答案
考题 Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）A、USER_TAB_PRIVS_MADEB、USER_TAB_PRIVSC、USER_COL_PRIVS_MADED、USER_COL_PRIVS
查看答案
考题 Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）A、USER_CONSTRAINTSB、USER_OBJECTSC、ALL_CONSTRAINTSD、USER_CONS_COLUMNSE、USER_COLUMNS
查看答案
考题 Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）：  CREATE TABLESPACE user_tbsp  DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M；  What would be the result of this command？（）A、It would result in an error because the template cannot be used along with the disk group.B、It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C、It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.D、It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
查看答案
考题 Which method will configure an e-mail notification when permanent hardware errors are logged in the errorlog？（）  A、Create or update the errnotify stanza in the ODmB、Update errpt daemon configuration file /etc/errpt.conf.C、Update errpt daemon configuration file /var/adm/errpt.conf.D、Define a notification alias in the /etc/syslog.conf file with the *.error stanza
查看答案
考题 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、TableB、ColumnsC、Table and AliasD、Columns and Alias
查看答案
考题 Which of the following privileges permits a user to update the comment on a sequence?（）A、CONTROLB、UPDATEC、USAGED、ALTER
查看答案
考题 User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）A、UPDATE pets…B、SELECT….FROM petsC、INSERT INTO pets…D、ALTER TABLE pets…
查看答案
考题 Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 （usder_temp） /user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）A、 It would result in an error because the template cannot be used along with the disk group.B、 It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C、 It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.D、 It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
查看答案
考题 在Oracle中，（）数据字典表可以用来查看抽象数据类型的实际结构。A、USER_TYPE_ATTRSB、USER_TABLESC、USER_TYPE_TABSD、USER_TAB_COLUMNS
查看答案
考题 You are adatabase developer. You develop atask management application that connect stoa SQLServer 2008 database named TaskDB.Users logon to the application by using a SQLServer login. The application contains amodule named Task that assigns tasks tousers. Information about the setasks is stored in the Tasks table of the TaskDB data base. The Tasks table contains multiple columns. These include the Close Dateand Estimated Timecolumns. The application must meet the following security requirements: Users assigned toad atabase role named User 1 canupd ate all task information columns except the Close Date and the Estimated Time columns in the Tasks table. Administrative users assigned toad atabase role named Task_Admin canupd ateall task information in the Tasks table.You needto design a strategy to meet the security requirements. Which two actions should you perform?（）A、Add the Task_Admin role to thedb_accessadmin fixed database role.B、Grant Update permissions on the Tasks table to the Task_Admin role.C、Grant Update permissions on the Tasks table to the User 1 role foreach column except the Close Dateand Estimated Time columns.D、Createan INSTEAD OF trigger on the Tasks Table. Use theIs_Member function toprevent the User 1 role from updating the Close Date and Estimated Time columns.
查看答案
考题 单选题“把查询sc表和更新sc表的grade列的权限受予用户user1”的正确SQL语句是（）。A GRANT SELECT，UPDATE（grade）ON TABLE sc TOuser1B 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
查看答案
考题 单选题A user can ping everything on the local network earth.net from an AIX box （which is located on earth.net）. However， if the user tries to ping something on another network （mars.net） the user must type the fully qualified hostname. What can the user do so that the fully qualified hostname does not have to be typed every time the user wants to access ANY machine on mars.net？（）A Edit the /etc/hosts file and add an alias to the correct entryB Set up an alias in his .kshrc file to alias the hostname to the fully qualified hostnameC Add an alias to /etc/aliasesD Add mars.net to the search path of the resolv.conf file
查看答案
考题 单选题Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）：  CREATE TABLESPACE user_tbsp  DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M;  What would be the result of this command？（）A It would result in an error because the template cannot be used along with the disk group.B It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C It would create a tablespace with a data file that has an alias， and its attributes are set by the user­defined template.D It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user­defined template.
查看答案
考题 单选题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.
查看答案
考题 单选题Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）A USER_CONSTRAINTSB USER_OBJECTSC ALL_CONSTRAINTSD USER_CONS_COLUMNSE USER_COLUMNS
查看答案
考题 单选题Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 （usder_temp） /user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）A  It would result in an error because the template cannot be used along with the disk group.B  It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C  It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.D  It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
查看答案
考题 单选题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;
查看答案
热门标签
最新试卷