网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
You are granted the CREATE VIEW privilege. What does this allow you to do?（）
- 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.
参考答案
更多 “You are granted the CREATE VIEW privilege. What does this allow you to do?（）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.” 相关考题
考题
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***
考题
You are granted the CREATE VIEW privilege. What does this allow you to do? ()
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.
考题
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;
考题
Exhibit:UPDATE EzonexamConsolidatedSET District = ‘Mexico’WHERE RtvID = 45You 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 1View or function ‘EzonexamConsolidated’ is not updateable because itcontains 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.
考题
You are granted the CREATE VIEW privilege. What does this allow you to do?（）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.
考题
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
考题
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.
考题
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? （）A、Use the DESCRIBE command in the EMP_DEPT VU view.B、Use the DEFINE VIEW command on the EMP_DEPT VU view.C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
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 WHERE department_id IN (10,20);E、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
考题
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?（）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***
考题
Choose the correct order to package and upload data for an incident to Oracle Support.（） A、 Schedule，create new package，view manifest，view contentsB、 Create new package，view manifest，view contents，scheduleC、 Schedule，create new package，view contents，view manifestD、 Create new package，view contents，view manifest，scheduleE、 None of the above.
考题
Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（ ） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform?（）A、 Remove all deterministic function calls from within the view. B、 Remove all nondeterministic function calls from within the view. C、 Schema-bind all functions that are called from within the view. D、 Create the view and specify the WITH CHECK OPTION clause.
考题
You are implementing an ASP. NET MVC 2 Web application. You add a controller named Company Controller. You need to modify the application to handle the URL path /company/info. Which two actions should you perform？（）A、Add the following method to the CompanyController class. Function Info（） As ActionResult Return View（） End FunctionB、Add the following method to the CompanyController class. Function Company_Info（） As ActionResult Return View（） End FunctionC、Right-click the Views folder， and select View from the Add submenu to create the view for the action.D、Right-click inside the action method in the CompanyController class， and select Add View to create a view for the action
考题
You need to use the Event Viewer window to review the event logs for only critical and error events. You also need the maximum amount of detail for each of these events. What should you do？ （）A、Edit the filter for the Administrative Events view.B、Create a custom view. Enable the Critical， Error， and Information level events. Select all logs.C、Create a custom view. Select the Critical checkbox， Error checkbox， and Verbose checkbox. Select all logs.D、Search for the Critical or Error string by using the Find option of the Administrative Events view.
考题
TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform？（）A、Remove all deterministic function calls from within the view.B、Remove all nondeterministic function calls from within the view.C、Schema-bind all functions that are called from within the view.D、Create the view and specify the WITH CHECK OPTION clause.
考题
You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?（）A、Create CHECK constraints on the tables. B、Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. C、Create the view, specifying the WITH SCHEMABINDING option. D、Create the view, specifying the WITH CHECK option.
考题
单选题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? （）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***
考题
单选题You are the network administrator for The network consists of a single Active Directory domain named The TestKing Staff department has a Windows 2003 computer that functions as a file server. The computer contains a folder named TestKingData. Auditing is enabled on the TestKingData folder. The TestKing Staff department reports that confidential files were deleted from the folder. You need to identify the user who deleted the confidential files. What should you do?（）A
In Event Viewer, create a new log view from the security log. Filter the log view to display only success audits.B
In Event Viewer, create a new log view from the security log. Filter the log view to display only failure audits.C
In Event Viewer, create a new log view from the system log. Filter the log view to display only success audits.D
In Event Viewer, create a new log view from the system log. Filter the log view to display only failure audits.
考题
单选题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?（）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***
考题
单选题Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES,DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced? （）A
Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn.B
Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.C
Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE LOCAL SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.D
Scott cannot create a synonym because synonyms can be created only for tables.E
Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.
考题
单选题ou are developing an ASP.NET MVC 2 application. You create a view that will be returned by action methods in multiple controllers. You need to place the view in the appropriate folder. To which subfolder within the Views folder should you add the view？（）A
MasterB
DefaultC
SharedD
Common
考题
单选题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?（）A
Use the DESCRIBE command in the EMP_DEPT VU view.B
Use the DEFINE VIEW command on the EMP_DEPT VU view.C
Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F
Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
单选题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
考题
多选题TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform？（）ARemove all deterministic function calls from within the view.BRemove all nondeterministic function calls from within the view.CSchema-bind all functions that are called from within the view.DCreate the view and specify the WITH CHECK OPTION clause.
考题
单选题Choose the correct order to package and upload data for an incident to Oracle Support.（）A
Schedule，create new package，view manifest，view contentsB
Create new package，view manifest，view contents，scheduleC
Schedule，create new package，view contents，view manifestD
Create new package，view contents，view manifest，scheduleE
None of the above.
考题
多选题Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（ ） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform?（）ARemove all deterministic function calls from within the view.BRemove all nondeterministic function calls from within the view.CSchema-bind all functions that are called from within the view.DCreate the view and specify the WITH CHECK OPTION clause.
考题
单选题You are granted the CREATE VIEW privilege. What does this allow you to do?（）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.
考题
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）A
Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.B
Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.C
Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.D
Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.
热门标签
最新试卷
