The underlying tables must have data.
You need SELECT privileges on the view.
The underlying tables must be in the same schema.
You need SELECT privileges only on the underlying tables.
第1题:
You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.
You want to minimize changes to your security model and to your database applications. How should you modify the database?
A.Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.
B.Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.
C.Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.
D.Create a view of the lookup tables. Use the view to allow users access to the lookup tables.
第2题:
You have an Organization 2010.Internal user named User1 sends a confidential message to another internal user named User2.User1 does not have any administrative privileges in theory. You need to ensure User1 can identify whether the message was successfully delivered?. What should you instruct User1 to do?()
第3题:
You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database?()
第4题:
What is true about updates through a view? ()
第5题:
Which two statements about views are true?()
第6题:
You are granted the CREATE VIEW privilege. What does this allow you to do?()
第7题:
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?()
第8题:
You need to ensure that old data and current data can be queried according to the business requirements. What should you do?()
第9题:
Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.
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.
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.
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.
第10题:
You cannot update a view with group functions.
When you update a view group functions are automatically computed.
When you update a view only the constraints on the underlying table will be in effect.
When you update a view the constraints on the views always override the constraints on the underlying tables.
第11题:
The underlying tables must have data.
You need SELECT privileges on the view.
The underlying tables must be in the same schema.
You need SELECT privileges only on the underlying tables.
第12题:
Create CHECK constraints on the tables.
Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
Create the view, specifying the WITH SCHEMABINDING option.
Create the view, specifying the WITH CHECK option.
第13题:
Which two roles or privileges must you have to export tables owned by another user?()
第14题:
What is true about joining tables through an equijoin?()
第15题:
What is necessary for your query on an existing view to execute successfully? ()
第16题:
Which describes the default behavior when you create a table?()
第17题:
What does the FORCE option for creating a view do?()
第18题:
The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are the minimum requirements for the statement to execute successfully? ()
第19题:
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?()
第20题:
creates a view with constraints
creates a view even if the underlying parent table has constraints
creates a view in another schema even if you don't have privileges
creates a view regardless of whether or not the base tables exist
第21题:
Specify a view based on the archival data table and current data tables.
Specify that the data must be queried by using a stored procedure.
Specify that both the archival data table and the current data tables must have indexes created on the same columns.
Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.
第22题:
A view can be created as read only.
A view can be created as a join on two or more tables.
A view cannot have an ORDER BY clause in the SELECT statement.
A view cannot be created with a GROUP BY clause in the SELECT statement.
A view must have aliases defined for the column names in the SELECT statement.
第23题:
CREATE USER
CREATE SESSION
CREATE ANY TABLE
IMP_FULL_DATABASE
EXP_FULL_DATABASE
第24题:
Authorization Manager
Local Users and Groups
the net localgroup command
Active Directory Administrative Center