You are granted the CREATE VIEW privilege. What does this allow you to do?()
第1题:
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? ()
A. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);
B. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);
E. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
第2题:
You are granted the CREATE VIEW privilege. What does this allow you to do?()
第3题:
You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich set of SQL statements achieves the desired results? ()
A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
第4题:
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.Which SQL statement would you use to create the view EMP_VU?()
第5题:
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?()
第6题:
Exhibit:
UPDATE EzonexamConsolidated
SET District = ‘Mexico’
WHERE RtvID = 45
You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.
When users run the query in the exhibit above the receive the following error message:
Server: Mrh3612, Level 16, Stats 1, Line 1
View or function ‘EzonexamConsolidated’ is not updateable because it
contains aggregates:
How should you enable the query to run?
A.Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.
B.The appropriate users should be granted UPDATE permissions on each base table.
C.To enable updates on the composite tables create an INSTEAD OF trigger on the view.
D.On each base table add a cascading update trigger.
第7题:
Which data dictionary table should you query to view the object privileges granted to the user on specific columns?()
第8题:
A. Create a table view.
B. Create a view in any schema.
C. Create a view in your schema.
D. Create a sequence view in any schema.
E. Create a view that is accessible by everyone.
F. Create a view only of it is based on tables that you created.
第9题:
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? ()
第10题:
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?()