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

문제1

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

A. The foreign key constraint will be disabled.

B. The primary key constraint will be enabled and IMMEDIATE.

C. The foreign key constraint will be enabled and IMMEDIATE.

D. The primary key constraint will be enabled and DEFERRED.

E. The foreign key constraint will be enabled and DEFERRED.

정답: B,C

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

문제2

Examine the description of the EMPLOYEES table:

Which statement will execute successfully, returning distinct employees with non-null first names?

A. SELECT first_ name, DISTINCT last_ name FROM employees WHERE first_ name < > NULL;

B. SELECT first_ name, DISTNCT last_ name FROM employees WHERE first_ name IS NOT NULL;

C. SELECT DISTINCT * FROM employees WHERE first_ name IS NOT NULL;

D. SELECT Distinct * FROM employees WHERE first_ name < > NULL;

정답: C

문제3

Examine the description of the EMPLOYEES table:

Which two queries return rows for employees whose manager works in a different department?

A. SELECT emp.*
FROM employees emp
WHERE NOT EXISTS (
SELECT NULL
FROM employees mgr
WHERE emp.manager id = mgr.employee_ id
AND emp.department_id<>mgr.department_id
);

B. SELECT emp. *
FROM employees emp
WHERE manager_ id NOT IN (
SELECT mgr.employee_ id
FROM employees mgr
WHERE emp. department_ id < > mgr.department_ id
);

C. SELECT emp. *
FROM employees emp
RIGHT JOIN employees mgr
ON emp.manager_ id = mgr. employee id
AND emp. department id <> mgr.department_ id
WHERE emp. employee_ id IS NOT NULL;

D. SELECT emp.*
FROM employees emp
LEFT JOIN employees mgr
ON emp.manager_ id = mgr.employee_ id
AND emp. department id < > mgr. department_ id;

E. SELECT emp. *
FROM employees emp
JOIN employees mgr
ON emp. manager_ id = mgr. employee_ id
AND emp. department_ id<> mgr.department_ id;

정답: A,E

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

문제4

Which two statements are true regarding the UNION ALL operators?

A. The number of columns selected in each SELECT statement must be identical

B. The names of columns selected in each SELECT statement must be identical.

C. Duplicates are eliminated automatically by the UNION ALL operator

D. NULLS are not ignored during duplicate checking.

E. The output is sorted by the UNION ALL operator.

정답: A,D

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

문제5

Which three statements are true about Structured Query Language (SQL)?

A. It best supports relational databases

B. It provides independence for logical data structures being manipulated from the underlying physical data storage

C. It guarantees atomicity, consistency, isolation, and durability (ACID) features

D. It is the only language that can be used for both relational and object-oriented databases

E. It is used to define encapsulation and polymorphism for a relational table

F. It requires that data be contained in hierarchical data storage

정답: A,B

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

문제6

Which two are true about multiple table INSERT statements?

A. The conditional INSERT ALL statement inserts rows into a single table by aggregating source rows.

B. The conditional INSERT FIRST statement always inserts a row into a single table.

C. They always use subqueries.

D. They can transform a row from a source table into multiple rows in a target table.

E. The unconditional INSERT ALL statement must have the same number of columns in both the source and target tables.

정답: D,E

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

문제7

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?

A. The WHERE clause can be used to exclude rows before dividing them into groups.

B. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns.

C. The WHERE clause can be used to exclude rows after dividing them into groups

D. The HAVING clause can be used with aggregating functions in subqueries.

E. Aggregating functions and columns used in HAVING clauses must be specified in these SELECT list of a query.

정답: A,E

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

문제8

Examine the command to create the BOOKS table.
SQL> create table books(book id CHAR(6) PRIMARY KEY,
title VARCHAR2(100) NOT NULL,
publisher_id VARCHAR2(4),
author_id VARCHAR2 (50));
The BOOK ID value 101 does not exist in the table.
Examine the SQL statement.
insert into books (book id title, author_id values
('101','LEARNING SQL','Tim Jones')

A. It executes successfully only if NULL is explicitly specified in the INSERT statement.

B. It executes successfully onlyif NULL PUBLISHER ID column name is added to the columns list and NULL is explicitly specified In the INSERT statement.

C. It executes successfully only NULL PUBLISHER_ID column name is added to the columns list in the INSERT statement.

D. It executes successfully and the row is inserted with a null PLBLISHER_ID.

정답: D

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

문제9

Which two statements are true?

A. Neither CASE nor DECODE is a function.

B. DECODE is a function and CASE is not.

C. CASE is a function and DECODE is not.

D. All conditions evaluated using CASE can also be evaluated using DECODE.

E. Both CASE and DECODE are functions.

F. AIl conditions evaluated using DECODE can also be evaluated using CASE.

정답: B,F

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

문제10

Examine this SQL statement
DELETE FROM employees e
WHERE EXISTS
(SELECT' dummy'
FROM emp history
WHERE employee_ id= e. employee id);
Which two are true?

A. The subquery is executed for every row in the EMPLOYEES table.

B. The subquery is executed before the DELETE statement is executed.

C. All existing rows in the EMPLOYEES table are deleted,

D. The DELETE statement executes successfully even if the subquery selects multiple rows.

E. The subquery is not a correlated subquery.

정답: B,D

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

문제11

The PROD_ID column is the foreign key in the SALES table.Which references the PRODUCTS table.
Similarly,the CUST_ID and TIME_ID columns are Also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_sales(prod_id, I cust_id, order_date DEFAULT SYSDATE)
AS SELECT I prod_id,cust_id,time_id FROM sales.
Which statement is true regarding the above command?

A. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.

B. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.

C. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause I do not match.

D. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table

정답: C

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

문제12

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

문제13

Examine this query:
SELECT employee_id, first_name, salary
FROM employees
WHERE hiredate > 61*
Which two methods should yours to prevent prompting for hire date value when this queries executed?

A. Use the DEFINE command before executing the query

B. Execute the SET VERIFY ON command before executing the query.

C. Replace 's1' with &1'in the query:

D. Execute the SET VERIFY OFF command before executing the query.

E. Use the UNDEFINE command before executing the query.

F. Store the query in a script and pass the substitution value to the script when executing it.

정답: A,D

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

문제14

You execute this command:
TRUNCATE TABIE depts;
Which two are true?

A. It drops any triggers defined on the table.

B. It always retains the space used by the removed rows.

C. It retains the indexes defined on the table.

D. It retains the integrity constraints defined on the table,

E. A ROLLBACK statement can be used to retrieve the deleted data.

F. A FLASHBACK TABLE statement can be used to retrieve the deleted data.

정답: C,D

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

문제15

Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name
FROM customers
WHERE countryid=10
UNION
SELECT custid CUSTNO, cust_last_name
FROM customers
WHERE countryid=30
Identify three ORDER BY clauses, any one of which can complete the query successfully.

A. ORDERBY2, 1

B. ORDER BY"CUST NO"

C. ORDER BY CUSTNO

D. ORDER BY 2, cust_id

E. ORDER BY "Last Name"

정답: A,D,E

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

문제16

Which three statements are true about Oracle synonyms?

A. A synonym can be available to all users .

B. A synonym cannot be created for a PL /SQL package.

C. A SEQUENCE can have a synonym.

D. A synonym created by one user can refer to an object belonging to another user.

E. Any user can drop a PUBLIC synonym.

정답: A,C,D

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

문제17

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;

정답: B,E

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

문제18

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two character.
Which query can be used?

A. SELECT * FROM customers WHERE city LIKE'D %';

B. SELECT * FROM customers WHERE city LIKE'D_';

C. SELECT * FROM customers WHERE city ='%D_';

D. SELECT * FROM customers WHERE city ='D_%';

정답: D

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

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

우리와 연락하기

유용한 링크

최신 업데이트