Oracle Database SQL Expert - 1Z0-047무료 덤프문제 풀어보기

A. It can improve the performance of a large query by storing the result of a query block having the WITH clause in the user's temporary tablespace.

B. It enables users to reuse the same query block in a SELECT statement, if it occurs more than once in a complex query.

C. It enables users to store the results of a query permanently.

D. It enables users to store the query block permanently in the memory and use it to create complex queries.

A. They should not be used with the NOT IN operator in the main query if NULL is likely to be a part of the result of the subquery.

B. They can contain group functions.

C. They use the < ALL operator to imply less than the maximum.

D. They always contain a subquery within a subquery.

E. They can be used to retrieve multiple rows from a single table only.

A. The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order.

B. The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.

C. The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause.

D. The statement would execute successfully and display all the rows in the ascending order of DEPARTMENT_ID.

A. INSERT INTO
(SELECT order_id ,order_date .customer_id
FROM orders)
VALUES (1,O9-mar-2007', 101);

B. INSERT INTO orders
VALUES (1,09-mar-2007', DEFAULT, 101, DEFAULT);

C. INSERT INTO orders
(order_id ,order_date ,order_mode .order_total)
VALUES (1 ,'10-mar-2007','online',1000);

D. INSERT INTO orders (order_id ,order_date ,order_mode, customer_id ,order_total) VALUES(1 ,TO_DATE(NULL), 'online', 101, NULL);

E. INSERT INTO orders
VALUES (1, O9-mar-2007', 'online',",1000);

A. ORDER BY DIFFERENCE

B. ORDER BY LIST_PRICE - MIN_PRICE

C. ORDER BY MIN_PRICE

D. ORDER BY LIST_PRICE

E. ORDER BY 4

A. CREATE INDEX ord_idx
ON ord(ord_no);

B. CREATE INDEX ord_idx
ON ord_items(ord_no);

C. CREATE INDEX ord_idx
ON ord_items(item_no);

D. CREATE INDEX ord_idx
ON ord,ord_items(ord_no, ord_date,qty);

A. A role can be granted to itself.

B. Roles are named groups of related privileges that can be granted to users or other roles.

C. The REVOKE command can be used to remove privileges but not roles from other users.

D. A role can be granted to PUBLIC.

E. A user can be granted only one role at any point of time.

A. CREATE TABLE ord_details
(ord_no NUMBER(2) PRIMARY KEY,
item_no NUMBER(3) PRIMARY KEY,
ord_date date NOT NULL);

B. CREATE TABLE ord_details
(ord_no NUMBER(2),
item_no NUMBER(3),
ord_date date DEFAULT SYSDATE NOT NULL,
CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no));

C. CREATE TABLE ord_details
(ord_no NUMBER(2) UNIQUE, NOT NULL,
item_no NUMBER(3),
ord_date date DEFAULT SYSDATE NOT NULL);

D. CREATE TABLE ord_details
(ord_no NUMBER(2) ,
item_no NUMBER(3),
ord_date date DEFAULT NOT NULL,
CONSTRAINT ord_uq UNIQUE (ord_no),
CONSTRAINT ord_pk PRIMARY KEY (ord_no));

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

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

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

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