违法和不良信息举报 联系客服
免费注册 登录

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

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

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

第2题：

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

第3题：

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 adjusted

C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged

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


参考答案：B

第4题：

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

第5题：

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

第6题：

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 bin

B. It retrieves the oldest version of the table from the recycle bin

C. It retrieves the version of the table for which undo information is available

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column


参考答案：A

第7题：

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

第8题：

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.


参考答案：C

第9题：

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

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

正确答案:C

更多相关问题
相关内容