单选题View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（）AThe ORDERS_MASTER table would contain the ORDERJDs 1 and 2.BThe ORDERS_MASTER table would contain the ORDERJDs 1， 2 an

题目
单选题
View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（）
A

 The ORDERS_MASTER table would contain the ORDERJDs 1 and 2.

B

 The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 3.

C

 The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 4.

D

 The ORDERS MASTER table would contain the ORDER IDs 1， 2， 3 and 4.

相似考题

1.View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

2.Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;What would be the outcome of this command?（）A. It produces an error because data already exists in the table.B. It produces an error because compression can be enabled at table creation only.C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.

3.You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）A. It retrieves the latest version of the table from the recycle binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

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.

参考答案和解析
正确答案： D
解析： 暂无解析
更多“单选题View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（）A  The ORDERS_MASTER table would contain the ORDERJDs 1 and 2.B  The ORDERS_MASTER table would contain the ORDERJDs 1”相关问题

  • 第1题：

    View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?()

    A. 90 MB

    B. 272 MB

    C. 362 MB

    D. 1,440 MB


    参考答案：C

  • 第2题：

    Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()

    A. SER_NO

    B. ORDER_ID

    C. STATUS

    D. PROD_ID

    E. ORD_TOTAL

    F. Composite index on ORDER_ID and ORDER_DATE


    参考答案：A, F

  • 第3题：

    Refer to the exhibit. Examine the partial configuration and the routing table excerpt. Which routes would be redistributed into OSPF area 1? ()

    A. 10.10.10.16/28 only

    B. 10.10.10.16/28 and 10.10.10.64/26

    C. 10.10.10.16/28, 10.10.10 .64/26, and 172.16.10.0/24

    D. 10.10.10.64/26 only


    参考答案：D

  • 第4题：

    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

  • 第5题：

    Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）

    • A、 Flashback Drop
    • B、 Flashback Query
    • C、 Flashback Transaction Query
    • D、 Flashback Versions Query
    • E、 Flashback Table

    正确答案:C

  • 第6题：

    Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）

    • A、A syntax error will result as you cannot specify more than one partition in the same statement
    • B、All data in p1 and p3 partitions are removed and the table definition is changed
    • C、All data in p1 and p3 partitions are removed, but the table definition remains unchanged
    • D、Only the first partition (p1) will be dropped as only one can be dropped at any time

    正确答案:B

  • 第7题：

    单选题
    You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）
    A

    MERGE

    B

    SELECT …CROSS JOIN

    C

    INSERT ALL …SELECT

    D

    CREATE VIEW …CONSTRAINT


    正确答案： 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.


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

  • 第9题：

    单选题
    View the Exhibit and examine the details of the EMPLOYEES table.  The query was written to format the PHONE_NUMBER for the employees.   Which option would be the correct format in the output？（）
    A

     xxx-xxx-xxxx

    B

     （xxx） xxxxxxx

    C

     （xxx） xxx-xxxx

    D

     xxx-（xxx）-xxxx


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

  • 第10题：

    单选题
    A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）
    A

    Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.

    B

    Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.

    C

    Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.

    D

    Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.


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

  • 第11题：

    单选题
    Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）
    A

     Flashback Drop

    B

     Flashback Query

    C

     Flashback Transaction Query

    D

     Flashback Versions Query

    E

     Flashback Table


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

  • 第12题：

    多选题
    Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    Composite index on ORDER_ID and ORDER_DATE


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

  • 第13题：

    Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;What is the outcome of executing the above statement?()

    A.A syntax error will result as you cannot specify more than one partition in the same statement

    B.All data in p1 and p3 partitions are removed and the table definition is changed

    C.All data in p1 and p3 partitions are removed, but the table definition remains unchanged

    D.Only the first partition (p1) will be dropped as only one can be dropped at any time


    参考答案：B

  • 第14题：

    Refer to the exhibit. Examine the partial configuration and the routing table excerpt. Which routes would be redistributed into OSPF area 1?()

    A. 10.10.10.16/28 only

    B. 10.10.10.16/28 and 10.10.10.64/26

    C. 10.10.10.16/28, 10.10.10.64/26, and 172.16.10.0/24

    D. 10.10.10.64/26 only


    参考答案：D

  • 第15题：

    A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）

    • A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
    • B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.
    • C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
    • D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

    正确答案:C

  • 第16题：

    You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

    • A、MERGE
    • B、SELECT …CROSS JOIN
    • C、INSERT ALL …SELECT
    • D、CREATE VIEW …CONSTRAINT

    正确答案:A

  • 第17题：

    Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space，you issued the following command：   ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS；   What would be the outcome of this command？（）

    • A、 It produces an error because data already exists in the table.
    • B、 It produces an error because compression can be enabled at table creation only.
    • C、 It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
    • D、 It immediately compresses all existing data as well as new data， resulting from either fresh additions or modifications to existing data.

    正确答案:C

  • 第18题：

    单选题
    Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space，you issued the following command：   ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS；   What would be the outcome of this command？（）
    A

     It produces an error because data already exists in the table.

    B

     It produces an error because compression can be enabled at table creation only.

    C

     It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.

    D

     It immediately compresses all existing data as well as new data， resulting from either fresh additions or modifications to existing data.


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

  • 第19题：

    单选题
    Evaluate the CREATE TABLE statement：   CREATE TABLE products   （product_id NUMBER （6）  CONSTRAINT prod_id_pk PRIMARY KEY，  product_name VARCHAR2 （15））；   Which statement is true regarding the PROD_ID_PK constraint？（）
    A

     It would be created only if a unique index is manually created first.

    B

     It would be created and would use an automatically created unique index.

    C

     It would be created and would use an automatically created nonunique index.

    D

     It would be created and remains in a disabled state because no index is specified in the command.


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

  • 第20题：

    单选题
    View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY （emp_id）   USING INDEX emp_id_idx；   Which statement is true regarding the effect of the command？（）
    A

     The PRIMARY KEY is created along with a new index.

    B

     The PRIMARY KEY is created and it would use an existing unique index.

    C

     The PRIMARY KEY would be created in a disabled state because it is using an existing index.

    D

     The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.


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

  • 第21题：

    单选题
    The INV_HISTORY table is created using the command: You would like to store the data belonging to the year 2006 in a single partition and issue the command: What would be the outcome of this command? （）
    A

    It executes successfully, and the transition point is set to '1-apr-2006'.

    B

    It executes successfully, and the transition point is set to '15-apr-2006'.

    C

    It produces an error because the partitions specified for merging are not adjacent.

    D

    It produces an error because the date values specified in the merge do not match the date values stored in the table.


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

  • 第22题：

    单选题
    Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）
    A

    A syntax error will result as you cannot specify more than one partition in the same statement

    B

    All data in p1 and p3 partitions are removed and the table definition is changed

    C

    All data in p1 and p3 partitions are removed, but the table definition remains unchanged

    D

    Only the first partition (p1) will be dropped as only one can be dropped at any time


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

  • 第23题：

    单选题
    EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）
    A

    Exhibit A

    B

    Exhibit B 

    C

    The query returns no rows 

    D

    The query fails because the outer query is retrieving more than one column

    E

    The query fails because both the inner and outer queries are retrieving data from the same table.


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

相关内容