单选题What is necessary for your query on an existing view to execute successfully?（）A The underlying tables must have data.B You need SELECT privileges on the view.C The underlying tables must be in the same schema.D You need SELECT privileges only on the u

题目
单选题
What is necessary for your query on an existing view to execute successfully?（）
A

The underlying tables must have data.

B

You need SELECT privileges on the view.

C

The underlying tables must be in the same schema.

D

You need SELECT privileges only on the underlying tables.

相似考题

1.The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ‘6‘ MINUTE)WHERE ename = ‘ALLEN‘;What are the minimum requirements for the statement to execute successfully? （）A. ARCHIVELOG mode must be enabledB. Row Movement must be enabled for the tableC. FLASHBACK must be set to ON for the databaseD. The UNDO_MANAGEMENT parameter must be set to AUTOE. The UNDO_RETENTION parameter must be set appropriately

2.What is true about joining tables through an equijoin? ()A. You can join a maximum of two tables through an equijoin.B. You can join a maximum of two columns through an equijoin.C. You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.D. To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.E. You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

3.What is necessary for your query on an existing view to execute successfully? ()A. The underlying tables must have data.B. You need SELECT privileges on the view.C. The underlying tables must be in the same schema.D. You need SELECT privileges only on the underlying tables.

4.What is true about updates through a view? ()A. You cannot update a view with group functions.B. When you update a view group functions are automatically computed.C. When you update a view only the constraints on the underlying table will be in effect.D. When you update a view the constraints on the views always override the constraints on the underlying tables.

更多“单选题What is necessary for your query on an existing view to execute successfully?（）A The underlying tables must have data.B You need SELECT privileges on the view.C The underlying tables must be in the same schema.D You need SELECT privileges only on the u”相关问题

  • 第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.


    正确答案：A
    解析：Explanation:SQLServer2000allowsfilegroupsotherthantheprimaryfilegrouptobemarkedasreadonly.Afilegroupthatismarkedread-onlycannotbemodified.Tablesthatmustnotbemodifiedcanbeplacedonafilegroupthatcanthenbemarkasread-only.Thiswillpreventsaccidentalupdates.IncorrectAnswers:B:Thissolutioneffectivelypermitsalluserstomodifyanytableinthedatabase,astheywouldallhaveSELECTpermissionstothedatabase.C:ThissolutionwilleffectivelypreventallusersfrombeingabletoperformingthesetasksonalltablesinthedatabaseastheyaredeniedpermissionstorunINSERT,UPDATE,orDELETEstatementsagainstthedatabase.Abettersolutionwouldbetoapplythedenypermissionsatthetablelevelofthelookuptables.Thiswould,however,requireunnecessaryadministrativetime.D:Viewsarevirtualtablesthatareusedtofiltertablesorrowsthattheusersshouldnothaveaccessto,however,iftheusershaveaccesstothebasetables,theycanstillrunINSERT,UPDATE,andDELETEstatementsagainstthebasetable.

  • 第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？（）

    • A、View the message headers in the sent item folder
    • B、Open Microsoft Outlook and modify Read Receipt Settings
    • C、Open Microsoft Outlook and modify Delivery Receipt Settings
    • D、Open the ECP and select Organize E-Mail

    正确答案:C

  • 第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？（）

    • A、SYSDBA
    • B、SYSOPER
    • C、No system privileges are required for the RMAN user.
    • D、Only SYS user can connect and execute RMAN commands on a target database.

    正确答案:A

  • 第4题：

    What is true about updates through a view? （）

    • A、You cannot update a view with group functions.
    • B、When you update a view group functions are automatically computed.
    • C、When you update a view only the constraints on the underlying table will be in effect.
    • D、When you update a view the constraints on the views always override the constraints on the underlying tables.

    正确答案:A

  • 第5题：

    Which two statements about views are true?（）

    • A、A view can be created as read only.
    • B、A view can be created as a join on two or more tables.
    • C、A view cannot have an ORDER BY clause in the SELECT statement.
    • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
    • E、A view must have aliases defined for the column names in the SELECT statement.

    正确答案:A,B

  • 第6题：

    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.

    正确答案:C

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

    • 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. 

    正确答案:C

  • 第8题：

    You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）

    • A、Specify a view based on the archival data table and current data tables.
    • B、Specify that the data must be queried by using a stored procedure.
    • C、Specify that both the archival data table and the current data tables must have indexes created on the same columns.
    • D、Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

    正确答案:A

  • 第9题：

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


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    What is true about updates through a view?（）
    A

    You cannot update a view with group functions.

    B

    When you update a view group functions are automatically computed.

    C

    When you update a view only the constraints on the underlying table will be in effect.

    D

    When you update a view the constraints on the views always override the constraints on the underlying tables.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    What is necessary for your query on an existing view to execute successfully?（）
    A

    The underlying tables must have data.

    B

    You need SELECT privileges on the view.

    C

    The underlying tables must be in the same schema.

    D

    You need SELECT privileges only on the underlying tables.


    正确答案： C
    解析： 暂无解析

  • 第12题：

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


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Which two roles or privileges must you have to export tables owned by another user？（）

    • A、CREATE USER
    • B、CREATE SESSION
    • C、CREATE ANY TABLE
    • D、IMP_FULL_DATABASE
    • E、EXP_FULL_DATABASE

    正确答案:B,E

  • 第14题：

    What is true about joining tables through an equijoin?（）

    • A、You can join a maximum of two tables through an equijoin.
    • B、You can join a maximum of two columns through an equijoin.
    • C、You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
    • D、To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
    • E、You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

    正确答案:E

  • 第15题：

    What is necessary for your query on an existing view to execute successfully? （）

    • A、The underlying tables must have data.
    • B、You need SELECT privileges on the view.
    • C、The underlying tables must be in the same schema.
    • D、You need SELECT privileges only on the underlying tables.

    正确答案:B

  • 第16题：

    Which describes the default behavior when you create a table?（）

    • A、The table is accessible to all users.
    • B、Tables are created in the public schema.
    • C、Tables are created in your schema.
    • D、Tables are created in the DBA schema.
    • E、You must specify the schema when the table is created.

    正确答案:C

  • 第17题：

    What does the FORCE option for creating a view do?（）

    • A、creates a view with constraints
    • B、creates a view even if the underlying parent table has constraints
    • C、creates a view in another schema even if you don't have privileges
    • D、creates a view regardless of whether or not the base tables exist

    正确答案:D

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

    • A、ARCHIVELOG mode must be enabled
    • B、Row Movement must be enabled for the table
    • C、FLASHBACK must be set to ON for the database
    • D、The UNDO_MANAGEMENT parameter must be set to AUTO
    • E、The UNDO_RETENTION parameter must be set appropriately

    正确答案:D,E

  • 第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？（）

    • 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.

    正确答案:C

  • 第20题：

    单选题
    What does the FORCE option for creating a view do? （）
    A

    creates a view with constraints

    B

    creates a view even if the underlying parent table has constraints

    C

    creates a view in another schema even if you don't have privileges

    D

    creates a view regardless of whether or not the base tables exist


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）
    A

    Specify a view based on the archival data table and current data tables.

    B

    Specify that the data must be queried by using a stored procedure.

    C

    Specify that both the archival data table and the current data tables must have indexes created on the same columns.

    D

    Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    多选题
    Which two statements about views are true?（）
    A

    A view can be created as read only.

    B

    A view can be created as a join on two or more tables.

    C

    A view cannot have an ORDER BY clause in the SELECT statement.

    D

    A view cannot be created with a GROUP BY clause in the SELECT statement.

    E

    A view must have aliases defined for the column names in the SELECT statement.


    正确答案： D,E
    解析： 暂无解析

  • 第23题：

    多选题
    Which two roles or privileges must you have to export tables owned by another user？（）
    A

    CREATE USER

    B

    CREATE SESSION

    C

    CREATE ANY TABLE

    D

    IMP_FULL_DATABASE

    E

    EXP_FULL_DATABASE


    正确答案： C,A
    解析： 暂无解析

  • 第24题：

    单选题
    Your company has an Active Directory Domain Services （AD DS） domain that includes an AD security group named Development. You have a member server that runs Windows Server 2008 R2 with the Hyper-V role installed. You need to ensure that Development group members can only manage virtual machines （VMs）. Development group members must not have administrative privileges on the host server. What should you use？（）
    A

    Authorization Manager

    B

    Local Users and Groups

    C

    the net localgroup command

    D

    Active Directory Administrative Center


    正确答案： C
    解析： 暂无解析

相关内容