单选题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

题目

单选题

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? （）

CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3

CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;

CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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

第2题：

You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do？（）

A、Create a single storage group. Create one database for all users
B、Create two storage groups. In each storage group， create one database. Place mailboxes for remote users in one storage group database， and place all other mailboxes in the other storage group database
C、Create two storage groups. In each storage group， create one database. Place executive mailboxes in one storage group database， and place all other mailboxes in the other storage group database
D、Create two storage groups. In one storage group， create a database， and place all mailboxes for remote users and executives in the database. In the other storage group， create a database for all other mailboxes

正确答案:C

第3题：

You would like to create a custom performance counter for an application that you created recently.To do this, you decide to create a custom category named ApplicationPerformance and a performance counter named HitNumber.You need to ensure that this counter is shared across numerous applications.What should you do?（）

参考答案：D

第4题：

You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

A、 SQL scripts
B、 Recovery Manager （RMAN） script
C、 Data Pump
D、 SQL*Loader
E、 Flashback database

正确答案:A,C

第5题：

Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

A、You need to perform the restore and recover operations manually, because the backup was made manually.
B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database.
C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database.
D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.

正确答案:C

第6题：

You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）

A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.
B、Create a CHECK constraint.
C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.
D、Create a DML AFTER trigger that writes the failed records to a file or table.

正确答案:C

第7题：

You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

A、Update the view to use an outer join between the Customers and Sales tables.
B、Create a clustered index on the v CustomerSales view.
C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

正确答案:B

第8题：

You create a Web application. The Web application enables users to change fields in their personal profiles. Some of the changes are not persisting in the database. You need to raise a custom event to track each change that is made to a user profile so that you can locate the error.Which event should you use? （）

A. WebAuditEvent

B. WebEventManager

C. WebBaseEvent

D. WebRequestEvent

参考答案：C

第9题：

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）

A、 Enable supplemental logging for the database.
B、 Specify undo retention guarantee for the database
C、 Create Flashback Data Archive in the tablespace where the tables are stored.
D、 Create Flashback Data Archive and enable Flashback Data Archive for specific tables

正确答案:D

第10题：

You executed the following procedure to collect statistics regarding an index： SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）

A、 INDEX_STATS
B、 DBA_INDEXES
C、 DBA_IND_COLUMNS
D、 V$OBJECT_USAGE

正确答案:A

You are the DBA for an academic database. You need to create

题目

相似问题和答案

更多相关问题

相关内容