최신 1z1-071 무료덤프 - Oracle Database SQL

문제1

Which three are true about system and object privileges

A. WITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC

B. Revoking a system privilege that was granted with the WITH ADMIN OPTION has a cascading effect.

C. Adding a primary key constraint to an existing table in another schema requires a system privilege

D. Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect

E. Adding a foreign key constraint pointing to a table in another schema requires the REFERENCEs object privilege

F. WITH GRANT OPTION can be used when granting an object privilege to both users and roles

정답: D,E,F

설명: (DumpTOP 회원만 볼 수 있음)

문제2

Examine the description of the PRODCTS table which contains data:

Which two are true?

A. The EXPIRY DATE column cannot be dropped.

B. The PROD NAME column cannot have a DEFAULT clause added to it.

C. The PROD_ ID column data type can be changed to VARCHAR2 (2).

D. The EXPIRY DATE column data type can be changed to TIME STAMP.

E. The PROD ID column can be renamed.

정답: D,E

설명: (DumpTOP 회원만 볼 수 있음)

문제3

Which statement is true about the INTERSECT operator used in compound queries?

A. Multiple INTERSECT operators are not possible in the same SQL statement.

B. INTERSECT is of lower precedence than UNION or UNION ALL.

C. It ignores NULLS.

D. It processes NULLS in the selected columns.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제4

Examine the description of the CUSTONERS table:

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?

A. RIGHT OUTER JOIN with self join

B. LEFT OUTER JOIN with self join

C. self Join

D. subquery

E. PULL OUTER JOIN with self join

정답: C,D

설명: (DumpTOP 회원만 볼 수 있음)

문제5

Examine the description of the PRODUCTS table:

Which three queries use valid expressions?

A. SPLECT product_id, expiry_date * 2 FROM products;

B. SELECT product_id,unit_price || "Discount", unit_price + surcharge-discount FROM products;

C. SELEGT product_id, unit_price, unit_price + surcharge FROM products;

D. SELECT ptoduct_id, (expiry_date-delivery_date) * 2 FROM products;

E. SELECT produet_id, unit_pricer, 5 "Discount",unit_price+surcharge-discount FROM products;

F. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;

정답: C,D,F

설명: (DumpTOP 회원만 볼 수 있음)

문제6

Which two statements are true about the order by clause when used with a sql statement containing a set operator such as union?

A. The first column in the first select of the compound query with the union operator is used by default to sort output in the absence of an order by clause.

B. Each select statement in the compound query must have its own order by clause.

C. Each select statement in the compound query can have its own order by clause.

D. column positions must be used in the order by clause.

E. only column names from the first select statement in the compound query are recognized.

정답: D,E

설명: (DumpTOP 회원만 볼 수 있음)

문제7

Which three statements are true about performing DML operations on a view with no Instead of triggers defined?

A. Insert statements can always be done on a table through a view.

B. WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

C. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

D. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

E. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

F. Delete statements can always be done on a table tough a view.

정답: C,D,F

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER Statement 1:
SELECT MAX (unit price*quantity) "Maximum Order FROM order items;
Statement 2:
SELECT MAX (unit price*quantity "Maximum order" FROM order items GROUP BY order id; Which two statements are true?

A. Statement 2 may return multiple rows of output.

B. Both the statement given the same output.

C. Statement 2 returns only one row of output.

D. Statement 1 returns only one row of output.

E. Both statements will return NULL if either UNIT PRICE or QUANTITY contains NULL,

정답: A,D

설명: (DumpTOP 회원만 볼 수 있음)

문제9

Examine the description or the CUSTOMERS table:

For Customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL;

C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;

D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level != NULL;

E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMONT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제10

Which two queries execute successfully?

A. SELECT prod_id, exp_date FROM products
UNION ALL
SELECT prod_id, NULL FROM new_products;

B. SELECT prod_id FROM products
UNION ALL
SELECT prod_id, prod_name FROM new_products;

C. SELECT prod_id, prod_name FROM products
INTERSECT
SELECT 100, prod_name FROM newproducts;

D. SELECT k FROM products
MINUS
SELECT prod_id FROM new_products;

E. SELECT * FROM products
UNION
SELECT * FROM new_products;

정답: A,E

설명: (DumpTOP 회원만 볼 수 있음)

문제11

Examine the description of the EMPLOYEES table:

Which statement increases each employee's SALARY by the minimum SALARY for their DEPARTM ENT_ID?

A. UPDATE employees e1
SET salary = salary+(SELECT MIN (salary)
FROM employees e2) ;

B. UPDATE employees e1
SET salary=
(SELECT e1.salary + MIN(e2.salary)
FROM employees e2
WHERE e1. department_ id = e2.department_id);

C. UPDATE employees e1
SET salary = salary +
(SELECT MIN(e1. salary)
FROM employees e2
WHERE e1.department_id = e2 .department_id);

D. UPDATE employees e1
SET salary =(SELECT e2. salary + MIN(e2.salary)
FROM employees e2
WHERE e1.department_ id = e2. department_id GROUP BY e2. department_id) ;

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제12

Which three are true about dropping columns from a table?

A. A column can be removed only if it contains no data.

B. A column that is referenced by another column in any other table cannot be dropped.

C. A primary key column cannot be dropped.

D. A column drop is implicitly committed

E. Multiple columns can be dropped simultaneously using the ALTER TABLE command.

F. A column must be set as unused before it is dropped from a table.

정답: B,C,D

설명: (DumpTOP 회원만 볼 수 있음)

문제13

Examine the description of the PRODUCT_ DETAILS table:

Which two statements are true?

A. PRODUCT_ PRICE contains the value zero by default if no value is assigned to it.

B. EXPIRY_ DATE cannot be used in arithmetic expressions.

C. PRODUCT_ ID can be assigned the PRIMARY KEY constraint.

D. EXPIRY_ DATE contains the SYSDATE by default if no date is assigned to it.

E. PRODUCT_ NAME cannot contain duplicate values.

F. PRODUCT_ PRICE can be used in an arithmetic expression even if it has no value stored in it.

정답: B,C

설명: (DumpTOP 회원만 볼 수 있음)

문제14

Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

A. The first column in the last SELECT of the compound query

B. The first VARCHAR2 column in the first SELECT of the compound query

C. The first NUMBER column in the first SELECT of the compound query

D. The first NUMBER or VARCHAR2 column in the last SELECTof the compound query

E. The first column in the first SELECT of the compound query

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

문제15

Examine this statement,which executes successfully:
In which order are the rows displayed?

A. sorted by DEPARTMENT_NAME

B. sorted by AVGSAL

C. sorted by DEPARTMENT_NAME and MAXSAL

D. Sorted by MAXSAL

E. sorted by DEPARTMENT_NAME and AVGSAL

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

문제16

Which two statements are true about the DUAL table?

A. It can be used to display only constants or pseudo columns.

B. It can display multiple rows and columns.

C. It consists of a single row and single column of VARCHAR2 data type.

D. It can display multiple rows but only a single column.

E. It can be accessed by any user who has the SELECT privilege in any schema

F. It can be accessed only by the SYS user.

정답: C,E

설명: (DumpTOP 회원만 볼 수 있음)

문제17

Examine these statements executed in a single Oracle session:
CREATE TABLE product (pcode NUMBER(2),pname VARCHAR2(20));
INSERT INTO product VALUES(1,'pen');
INSERT INTO product VALUES (2,'pencil');
INSERT INTO product VALUES(3,'fountain pen');
SAVEPOINT a;
UPDATE product SET pcode=10 WHERE pcode =1;
COMMIT;
DELETE FROM product WHERE pcode =2;
SAVEPOINT b;
UPDATE product SET pcode=30 WHERE pcode =3;
SAVEPOINT c;
DELETE FROM product WHERE pcode =10;
ROLLBACK TO SAVEPOINT b;
COMMIT;
Which three statements are true?

A. The code for fountain pen is 3

B. The code for pen is 1.

C. The code for pen is 10.

D. There is no row containing pencil.

E. There is no row containing pen

F. There is no row containing fountain pen.

정답: C,D,E

설명: (DumpTOP 회원만 볼 수 있음)

문제18

Which two are true?

A. FLOOR returns the largest positive integer less than or equal to a specified number.

B. FLOOR returns the largest integer less than or equal to a specified number.

C. CONCAT joins two character strings together.

D. INSTR finds the offset within a string of a single character only.

E. CONCAT joins two or more character strings together.

F. INSTR finds the offset within a character string, starting from position 0.

정답: B,E

설명: (DumpTOP 회원만 볼 수 있음)

최신 1z1-071 무료덤프 - Oracle Database SQL

우리와 연락하기

유용한 링크

최신 업데이트