多选题Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）AIt is ignored by the q

题目
多选题
Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）
A

It is ignored by the query optimizer.

B

It is not used while the index is being rebuilt.

C

The index cannot be rebuilt， and has to be re-created.

D

The index is automatically rebuilt when used the next time

相似考题

1.View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()A. 4B. 8C. 7D. 0

2.You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.Which two variables would likely fix this issue?()A.Table_open_cacheB.Table_open_cache_instancsC.Table_definition_cacheD.Tmp_table_sizeE.Max_heap_table_sizeF.Max_tmp_tables

3.Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.

4.Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.

更多“Examine the following output： SQL> SELECT index_name，status ”相关问题

  • 第1题：

    Examine the following command:CREATE TABLE (prod_id number(4),Prod_name varchar2 (20),Category_id number(30),Quantity_on_hand number (3) INVISIBLE);Which three statements are true about using an invisible column in the PRODUCTS table?（）

    A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.

    B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.

    C. Referential integrity constraint cannot be set on the invisible column.

    D. The invisible column cannot be made visible and can only be marked as unused.

    E. A primary key constraint can be added on the invisible column.


    参考答案：A, B, C

  • 第2题：

    Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement:SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager"FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id)AND e.salary > 4000;What is its output?（）

    A.A

    B.B

    C.C

    D.D

    E.E


    参考答案：A

  • 第3题：

    Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）

    • A、It is ignored by the query optimizer.
    • B、It is not used while the index is being rebuilt.
    • C、The index cannot be rebuilt， and has to be re-created.
    • D、The index is automatically rebuilt when used the next time

    正确答案:A,B

  • 第4题：

    Given the following function: CREATE FUNCTION emplist （　） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?

    • A、SELECT TABLE(EMPLIST()) FROM EMPLOYEE
    • B、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
    • C、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
    • D、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

    正确答案:D

  • 第5题：

    View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command：  SQL> SELECT reason，metric_value FROM dba_outstanding_alerts； REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output（）

    • A、An Automatic Workload Repository snapshot has been taken recently.
    • B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
    • C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
    • D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

    正确答案:C

  • 第6题：

    假设需要查询Oracle数据文件的文件名和存储位置，可以使用如下（）方式。

    • A、SELECT name，status FROM V$datafile
    • B、SELECT name，status FROM V$userfile
    • C、SELECT name，status FROM V$DBA
    • D、SELECT name，status FROM V$ctrlfile

    正确答案:A

  • 第7题：

    Note the output of the following query；   SQL> SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table：   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE；   What is the outcome of this command？（）  

    • A、 The table uses the default Flashback Data Archive.
    • B、 The Flashback Data Archive Is created In the SYSAUX tablespace.
    • C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.
    • D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

    正确答案:A

  • 第8题：

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

  • 第9题：

    单选题
    Examine the commands executed in the following sequence：  1：SQL> CREATE ROLE mgrrole；  2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；  3：SQL> GRANT select，update ON sh.sales TO mgrrole；  4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；  5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；  6：SQL> GRANT ceo TO mgrrole；  Which statement is true about the above commands（）
    A

    The commands execute successfully.

    B

    Command 6 produces an error because of circular role grant.

    C

    Command 5 produces an error because a role cannot be granted to another role.

    D

    Command 3 produces an error because the MGRROLE role already contains system privileges.

    E

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    F

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


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

  • 第10题：

    单选题
    View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command：  SQL> SELECT reason，metric_value FROM dba_outstanding_alerts； REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output（）
    A

    An Automatic Workload Repository snapshot has been taken recently.

    B

    The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.

    C

    The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.

    D

    The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.


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

  • 第11题：

    单选题
    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）
    A

    The table is moved to the SYSAUX tablespace.

    B

    The table is moved to the SYSTEM tablespace.

    C

    The table is removed from the database permanently.

    D

    The table is renamed and remains in the TBSFD tablespace.


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

  • 第12题：

    多选题
    Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）
    A

    It is ignored by the query optimizer.

    B

    It is not used while the index is being rebuilt.

    C

    The index cannot be rebuilt， and has to be re-created.

    D

    The index is automatically rebuilt when used the next time


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

  • 第13题：

    Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement?

    A.SELECT TABLE(EMPLIST()) FROM EMPLOYEE

    B.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE

    C.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE

    D.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t


    参考答案：D

  • 第14题：

    Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）

    A.A

    B.B

    C.C

    D.D

    E.E


    参考答案：A

  • 第15题：

    While applying a service update on a system using SMIT, the system administrates SMIT Command Status screen shows "Command: failed". Which of the following procedures should be performed to investigate the failure?（）

    • A、Exit the SMIT session and re-apply the update.
    • B、Select the SMIT option to Clean UP After an Interrupted Installation.
    • C、Examine the installation summary report to determine the cause of the failure.
    • D、Examine the console log to view the error messages generated by the failure.

    正确答案:C

  • 第16题：

    You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?（）

    • A、Table_open_cache
    • B、Table_open_cache_instancs
    • C、Table_definition_cache
    • D、Tmp_table_size
    • E、Max_heap_table_size
    • F、Max_tmp_tables

    正确答案:D,E

  • 第17题：

    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

    • A、The table is moved to the SYSAUX tablespace.
    • B、The table is moved to the SYSTEM tablespace.
    • C、The table is removed from the database permanently.
    • D、The table is renamed and remains in the TBSFD tablespace.

    正确答案:D

  • 第18题：

    Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   Which statement describes the effect of the execution of the above PL/SQL block？（）  

    • A、 The plan baselines are verified with the SQL profiles.
    • B、 All fixed plan baselines are converted into nonfixed plan baselines.
    • C、 All the nonaccepted SQL profiles are accepted into the plan baseline.
    • D、 The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

    正确答案:D

  • 第19题：

    TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）

    • A、In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.
    • B、In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.
    • C、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.
    • D、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.

    正确答案:A,C

  • 第20题：

    单选题
    View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）
    A

    The database instance is running with manual PGA management.

    B

    The database instance is running with manual shared memory management.

    C

    The database instance has the MEMORY_TARGET value set to a nonzero value.

    D

    All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed


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

  • 第21题：

    单选题
    Note the output of the following query；   SQL> SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table：   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE；   What is the outcome of this command？（）
    A

     The table uses the default Flashback Data Archive.

    B

     The Flashback Data Archive Is created In the SYSAUX tablespace.

    C

     The Flashback Data Archive is created in the same tablespace where the tables are stored.

    D

     The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.


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

  • 第22题：

    单选题
    Examine the following PL/SQL block：   DECLARE   my_plans pls_integer； BEGIN  my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id=> ？9twu5t2dn5xd？； END；   Which statement is true about the plan being loaded into the SQL plan baseline by the above command？（）
    A

     It is loaded with the FIXED status.

    B

     It is loaded with the ACCEPTED status.

    C

     It is not loaded with the ENABLED status.

    D

     It is not loaded with the ACCEPTED status.


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

  • 第23题：

    多选题
    You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?（）
    A

    Table_open_cache

    B

    Table_open_cache_instancs

    C

    Table_definition_cache

    D

    Tmp_table_size

    E

    Max_heap_table_size

    F

    Max_tmp_tables


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

  • 第24题：

    单选题
    Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   Which statement describes the effect of the execution of the above PL/SQL block？（）
    A

     The plan baselines are verified with the SQL profiles.

    B

     All fixed plan baselines are converted into nonfixed plan baselines.

    C

     All the nonaccepted SQL profiles are accepted into the plan baseline.

    D

     The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.


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

相关内容