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

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

相似考题

1.View the following SQL statements:You want to back out transaction T2. Which option would you use?()A. It is possible, but transaction T3 also backs out.B. It is possible with the NOCASCADE_FORCE option.C. It is possible with the NONCONFLICT_ONLY option.D. It is not possible because it has conflicts with transaction T3.

2.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;

3.Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?()A. By default, EM express is available for a database after database creation.B. You can use EM express to manage multiple databases running on the same server.C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.D. You cannot start up or shut down a database Instance by using EM express.E. You can create and configure pluggable databases by using EM express.

4.View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()A. Accept the recommended SQL profile.B.Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Segment Advisor for recommendations.

更多“Which SQL statement would you use to remove a view called EM”相关问题

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

    正确答案:D

  • 第2题：

    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

    正确答案:B

  • 第3题：

    You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

    • A、use enterprise manager
    • B、use DBMS_SQL package
    • C、use DBMS_AWR package
    • D、use PRVT_WORKLOAD package
    • E、query the AWR snapshot repository objects
    • F、use DBMS_WORKLOAD_REPOSITORY package

    正确答案:A,F

  • 第4题：

    To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）  

    • A、 EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor
    • B、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
    • C、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
    • D、 Either B or C
    • E、 All of the above

    正确答案:D

  • 第5题：

    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）

    • A、Top SQL
    • B、snapshots
    • C、SQL Tuning sets
    • D、index access path
    • E、optimizer statistics
    • F、materialized view logs

    正确答案:A,B,C

  • 第6题：

    You have a login.ascx control and to display it in a view which method u would use（）

    • A、http.display
    • B、http.partial
    • C、http.load
    • D、http.get

    正确答案:B

  • 第7题：

    You are planning the migration of an existing application to Windows Azure and SQL Azure.  The original application includes a Microsoft SQL Server 2008 database.   You need to recommend an approach for ensuring that the database migrates successfully toSQL Azure.  Which two actions should you recommend？（）

    • A、 Remove all clustered indexes from the database.
    • B、 Remove all dependencies on the Microsoft Distributed Transaction Coordinator （MSDTC） from the application.
    • C、 Use SSL and SQL authentication to connect to the database.
    • D、 Use SSL and Windows authentication to connect to the database.

    正确答案:B,C

  • 第8题：

    多选题
    You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）
    A

    use enterprise manager

    B

    use DBMS_SQL package

    C

    use DBMS_AWR package

    D

    use PRVT_WORKLOAD package

    E

    query the AWR snapshot repository objects

    F

    use DBMS_WORKLOAD_REPOSITORY package


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

  • 第9题：

    多选题
    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）
    A

    Top SQL

    B

    snapshots

    C

    SQL Tuning sets

    D

    index access path

    E

    optimizer statistics

    F

    materialized view logs


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

  • 第10题：

    单选题
    Which command would you use to view interface usage details in real time?（）
    A

    show interfaces terse

    B

    show interfaces extensive

    C

    monitor interface traffic

    D

    monitor traffic interface


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

  • 第11题：

    单选题
    To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）
    A

     EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor

    B

     EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor

    C

     EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor

    D

     Either B or C

    E

     All of the above


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

  • 第12题：

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

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

  • 第14题：

    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）

    • A、function
    • B、package
    • C、procedure
    • D、database trigger
    • E、anonymous PL/SQL block

    正确答案:D

  • 第15题：

    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）

    • A、 functions
    • B、 package
    • C、 procedure
    • D、 database trigger
    • E、 anonymous PL/SQL block

    正确答案:D

  • 第16题：

    Which of the following cannot be used as input to the SQL Tuning Advisor？（）

    • A、 A single SQL statement provided by a user
    • B、 An existing SQL Tuning Set （STS）
    • C、 A preprocessed Database Replay workload
    • D、 A schema name
    • E、 SQL statement identified in EM as using excessive resources

    正确答案:C,D

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    单选题
    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）
    A

    function

    B

    package

    C

    procedure

    D

    database trigger

    E

    anonymous PL/SQL block


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

  • 第20题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


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

  • 第21题：

    单选题
    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）
    A

     functions

    B

     package

    C

     procedure

    D

     database trigger

    E

     anonymous PL/SQL block


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

  • 第22题：

    多选题
    Which two commands would you use to view OSPF routes?（）
    A

    show ip route ospf

    B

    show ospf routes

    C

    show route protocol ospf

    D

    show route


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

  • 第23题：

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

  • 第24题：

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

相关内容