当前位置:1Z0-007题库

问题:

[单选] 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

What is the required element for encryption key management on an LTO-5 drive within a tapelibrary?() IBM LTO Encryption Manager。 IBM Tape Encryption Manager。 IBM Tivoli Single Sign On Manager (SSO)。 IBM Tivoli Key Lifecycle Manager (TKLM)。 排水系统布置应遵循的原则有()。 排水沟道要处于控制面积的最低处,以求尽量自流排水。 根据地形应将排水地区划分为高.中.低等片,做到高水高排,低水低排,自排为主,抽排为辅。 排水干沟的出口应选择在容泄区水位较高和河床比较稳定的地方。 排水沟布置要避开土质好的地带,以节省工程费用并使排水安全及时。 在有外水入侵的排水区,不应布置截流沟或撇洪沟。 In your datawarehousing application, you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins, resulting in a large performance overhead.  What kind of database structure would you use to reduce the response time of the query?()  hash clusters。 index clusters。 partitioned tables。 index-organized table (IOT)。 Which command will change the user webserver’s shell to ksh93?() chshell -ksh93 webserver。 chsh webserver /usr/bin/ksh93。 chuser -a shell=/usr/bin/ksh93 webserver。 setuid -a SHELL=/usr/bin/ksh93 -u webserver。 A customer has purchased a new IBM Storwize V7000 storage array and is considering an IPbased DR replication solution that is cost-optimized and provides a near instant recovery option fortheir Microsoft Exchange application and server. The backup site is 30 kilometers away. Whatwould be the best choice for replication?() Storwize V7000 Metro Mirror。 Tivoli Storage ManagerFastBack。 Storwize V7000 Reverse FlashCopy。 Tivoli Storage Productivity Center for Replicatio。 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? ()
参考答案:

  参考解析

本题暂无解析

在线 客服