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

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

相似考题

1.Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?()A. DROP emp_dept_uv;B. DELETE emp_dept_uv;C. REMOVE emp_dept_uv;D. DROP VIEW emp_dept_uv;E. DELETE VIEW emp_dept_uv;F. REMOVE VIEW emp_dept_uv;

2.Which version of a view would you use if you just want a quick， easy view within your XPage？（）A、Data Table ControlB、View ControlC、Repeat ControlD、Filter by category View Control

3. You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）A、ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);B、MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);C、ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;D、MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;E、CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;F、You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.

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

更多“单选题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 definitio”相关问题

  • 第1题：

    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

  • 第2题：

    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.

    正确答案:D

  • 第3题：

    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.

    正确答案:D

  • 第4题：

    Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）

    • A、DROP emp_dept_uv;
    • B、DELETE emp_dept_uv;
    • C、REMOVE emp_dept_uv;
    • D、DROP VIEW emp_dept_uv;
    • E、DELETE VIEW emp_dept_uv;
    • F、REMOVE VIEW emp_dept_uv;

    正确答案:D

  • 第5题：

    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.

    正确答案:B,C

  • 第6题：

    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.

    正确答案:B,C

  • 第7题：

    单选题
    You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）
    A

    ALTER VIEW emp_dept_vu (ADD manager_id NUMBER);

    B

    MODIFY VIEW emp_dept_vu (ADD manager_id NUMBER);

    C

    ALTER VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employee e, departments d   WHERE e.department_id = d.department_id;

    D

    MODIFY VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employees e, departments d   WHERE e.department_id = d.department_id;

    E

    CREATE OR REPLACE VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employees e, departments d   WHERE e.department_id = d.department_id;

    F

    You must remove the existing view first, and then run the CREATE VIEW command   with a new column list to modify a view.


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

  • 第8题：

    单选题
    Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）
    A

    DROP emp_dept_uv;

    B

    DELETE emp_dept_uv;

    C

    REMOVE emp_dept_uv;

    D

    DROP VIEW emp_dept_uv;

    E

    DELETE VIEW emp_dept_uv;

    F

    REMOVE VIEW emp_dept_uv;


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

  • 第9题：

    单选题
    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）
    A

     You do not need to restore all the data files.

    B

     You do not need to open the database with the RESETLOGS operation

    C

     You do not need to perform a full backup after the RESETLOGS operation.

    D

     You do not need to recover all the data files to the same system change number （SCN）.


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

  • 第10题：

    单选题
    Which version of a view would you use if you just want a quick， easy view within your XPage？（）
    A

    Data Table Control

    B

    View Control

    C

    Repeat Control

    D

    Filter by category View Control


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

  • 第11题：

    单选题
    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 created.) How do you obtain the definition of the view?（）
    A

    Use the DESCRIBE command on 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.


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

  • 第12题：

    单选题
    You want to use WLST to view metrics for a running domain. Which command should you issue to navigate through the Mbean hierarchy containing the metrics?（）
    A

    runtime ()  

    B

    runtimeMbeanServer ()

    C

    connectRuntime ()

    D

    beginRuntime ()

    E

    serverRuntime ()


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

  • 第13题：

    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 created.) How do you obtain the definition of the view?（）

    • A、Use the DESCRIBE command on 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.

    正确答案:D

  • 第14题：

    You want to use WLST to view metrics for a running domain. Which command should you issue to navigate through the Mbean hierarchy containing the metrics?（）

    • A、runtime ()  
    • B、runtimeMbeanServer ()
    • C、connectRuntime ()
    • D、beginRuntime ()
    • E、serverRuntime ()

    正确答案:E

  • 第15题：

    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

    • A、 Query the V$FLASHBACK_DATABASE_LOG view.
    • B、 Query the V$FLASHBACK_DATABASE_STAT view.
    • C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
    • D、 Query the V$RECOVERY_FILE_DEST view.

    正确答案:B

  • 第16题：

    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）

    • A、 You do not need to restore all the data files.
    • B、 You do not need to open the database with the RESETLOGS operation
    • C、 You do not need to perform a full backup after the RESETLOGS operation.
    • D、 You do not need to recover all the data files to the same system change number （SCN）.

    正确答案:C

  • 第17题：

    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 Function
    • B、Add the following method to the CompanyController class. Function Company_Info（） As ActionResult  Return View（） End Function
    • C、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

    正确答案:A,D

  • 第18题：

    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、Master
    • B、Default
    • C、Shared
    • D、Common

    正确答案:C

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

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


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

  • 第21题：

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


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

  • 第22题：

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

    Master

    B

    Default

    C

    Shared

    D

    Common


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

  • 第23题：

    单选题
    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）
    A

     Query the V$FLASHBACK_DATABASE_LOG view.

    B

     Query the V$FLASHBACK_DATABASE_STAT view.

    C

     Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.

    D

     Query the V$RECOVERY_FILE_DEST view.


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

相关内容