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

문제1

Which three items does a direction of a relationship contain?

A. a cardinality

B. label

C. a unique identifier

D. an attribute

E. an optionality

F. an entity

정답: A,B,E

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

문제2

Which two statements are true about the COUNT function?

A. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.

B. COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column.

C. COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column

D. It can only be used for NUMBER data types.

E. COUNT(*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.

정답: C,E

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

문제3

.No user-defined locks are used in your database.
Which three are true about Transaction Control Language (TCL)?

A. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.

B. COMMIT ends the transaction and makes all its changes permanent.

C. ROLLBACK without the TO SAVEPOINT clause undoes alt the transaction's changes, releases its locks, and erases all its savepoints.

D. ROLLBACK to SAVEPOTNT undoes the transaction's changes made since the named savepoint and then ends the transaction.

E. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.

F. COMMIT erases all the transaction's savepoints and releases its locks.

정답: B,C,F

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

문제4

Which three statements are true about an ORDER BY clause?

A. An ORDER BY clause can perform a binary sort

B. An ORDER BY clause can perform a linguistic sort

C. By default an ORDERBY clause sorts rows in ascending order

D. An ORDR BY clause will always precede a HAVI NG clause if both are used in the same top-level

E. An ORDER BY clause always sorts NULL values last.

정답: A,B,C

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

문제5

Examine the description of the ORDERS table:

Which three statements execute successfully?

A. SELECT * FROM orders ORDER BY order_ id
UNION
SELECT * FROM invoices;

B. SELECT order_ id, invoice_ data order_ date FROM orders
MINUS
SELECT invoice_ id, invoice_ data FROM invoices ORDER BY invoice_ id;

C. (SELECT * FROM orders
UNION ALL
SELECT* FROM invoices) ORDER BY order _id;

D. SELECE order _id, order _ date FRON orders
LNTERSECT
SELECT invoice_ id, invoice_ id, order_ date FROM orders

E. SELECT * FROM orders ORDER BY order_ id
INTERSEOT
SELECT * FROM invoices ORDER BY invoice_ id;

F. SELECT * FROM orders
MINUS
SELECT * FROM INVOICES ORDER BY 1

G. SELECT order_ id, order_ data FROM orders
UNION ALL
SELECT invoice_ id, invoice_ data FROM invoices ORDER BY order_ id;

정답: A,C,G

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

문제6

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 회원만 볼 수 있음)

문제7

You want to write a query that prompts for two column names and the WHERE condition each time It is executed in a session but only prompts for the table name the first time it is executed. The variables used in your query are never undefined in your session . Which query can be used?

A. SELECT &col1, &col2
FROM &&table
WHERE &condition;

B. SELECT &col1, &col2
FROM "&table"
WHERE &condition;

C. SELECT&&col1, &&col2
FROM &table
WHERE &&condition;

D. SELECT &&col1,&&col2
FROM &table
WHERE &&condition= &&cond;

E. SELECT'&co11','&&co12'
FROM &table
WHERE'&&condition' ='&cond';

정답: A

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

문제8

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week Which query can be used?

A. SELECT emp_id,NEXT_DAY(ADD_MONTHS(hite_date,6),'MONDAY') FROM employees;

B. SELECT emp_id,NEXT_DAY(ADD_MONTHS(hire_date,6),1) FROM employees;

C. SELECT emp_id,NEXT_DAY(MONTHS_BETWEEN(hire_date,SYSDATE),6) FROM employees;

D. SELECT emp_id,ADD_MONTHS(hire_date,6), NEXT_DAY('MONDAY') FROM employees;

정답: A

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

문제9

Examine the description of the ORDER_ITEMS table:

Examine this incomplete query:
SELECT DISTINCT quantity * unit_price total_paid FROM order_items ORDER BY <clause>; Which two can replace <clause> so the query completes successfully?

A. quantity

B. quantity, unit_price

C. quantity * unit_price

D. product_id

E. total_paid

정답: B,C

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

문제10

Which two are true about creating tables in an Oracle database?

A. The same table name can be used for tables in different schemas.

B. A primary key constraint is manadatory.

C. Creating an external table will automatically create a file using the specified directory and file name.

D. A system privilege is required.

E. A create table statement can specify the maximum number of rows the table will contain.

정답: A,D

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

문제11

You and your colleague Andrew have these privileges on the EMPLOYEE_RECORDS table:
1. SELECT
2. INSERT
3. UPDATE
4. DELETE
You connect to the database instance an perform an update to some of the rows in EMPLOYEE_RECORDS, but don't commit yet.
Andrew connects to the database instance and queries the table
No othet user are accessing the table
Which two statements ate true at this point?

A. Andrew will be able to see the changes you habe made

B. Andrew will be unable to see the changes you have made

C. Andrew will be unable to perform any INSERT, UPDATE of DELETE on the teble

D. Andrew will be able to SELECT from the table, but be unable to modify any existing rows.

E. Andrew will be able to modify any rows in the table that have not been modified by your transaction

정답: B,E

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

문제12

Examine the description of the transactions table:
Which two SQL statements execute successfully?

A. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;

B. SELECT customer_id CUSTID, transaction_date TRANS_DATE,amount+100 DUES FROM transactions;

C. SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

D. SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;

E. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;

정답: A,B

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

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

우리와 연락하기

유용한 링크

최신 업데이트