移动端

  • 题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

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

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

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

单选题 Which statement is true regarding Flashback Version Query?()

A

 It returns versions of rows only within a transaction.

B

 It can be used in subqueries contained only in a SELECT statement.

C

 It will return an error if the undo retention time is less than the lower bound time or SCN specified.

D

 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

单选题 Evaluate the following SQL statements that are issued in the given order: What would be the status of the foreign key EMP_MGR_FK?()

A

 It would be automatically enabled and deferred.

B

 It would be automatically enabled and immediate.

C

 It would remain disabled and has to be enabled manually using the ALTER TABLE command.

D

 It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.

多选题 Which statements are correct regarding indexes? ()

A

 When a table is dropped, the corresponding indexes are automatically dropped.

B

 For each DML operation performed, the corresponding indexes are automatically updated.

C

 Indexes should be created on columns that are frequently referenced as part of an expression.

D

 A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.

多选题 View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries? ()

A

 displaying the minimum list price for each product status

B

 displaying all supplier IDs whose average list price is more than 500

C

 displaying the number of products whose list prices are more than the average list price

D

 displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable

E

 displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE

多选题 Which two statements are true regarding the execution of the correlated subqueries?()

A

 The nested query executes after the outer query returns the row.

B

 The nested query executes first and then the outer query executes.

C

 The outer query executes only once for the result returned by the inner query.

D

 Each row returned by the outer query is evaluated for the results returned by the inner query.

最新资讯

1 2 3 下一页 尾页 /

到第