[2026] Oracle Database SQL - 1z0-071 무료 시험 문제

문제1

Examine the description of the EMPLOYEES table:

Which query is valid?

A. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

B. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

D. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

정답: D

문제2

View the Exhibit and examine the descriptions of the DEPT and LOCATIOMS tables.

You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.
Which SQL statement would you execute to accomplish the task?

A. UPDATE dept d
SET city = (SELECT city
FROM locations l
WHERE d.location_id = l.location_id);

B. UPDATE dept d
SET city = ALL (SELECT city
FROM locations l
WHERE d.location_id = l.location_id);

C. UPDATE dept d
SET city = ANY (SELECT city FROM locations l);

D. UPDATE dept d
SET city = (SELECT city FROM locations l)
WHERE d.location_id = l.location_id;

정답: A

문제3

View and Exhibit and examine the structure and data in the INVOICE table.

Which two statements are true regarding data type conversion in query expressions? (Choose two.)

A. inv_amt = '0255982' : requires explicit conversion

B. inv_date > '01-02-2008' : uses implicit conversion

C. inv_date = '15-february-2008' :uses implicit conversion

D. inv_no BETWEEN '101' AND '110' : uses implicit conversion

E. CONCAT(inv_amt, inv_date) : requires explicit conversion

정답: C,D

문제4

Which statements are true? (Choose all that apply.)

A. The data dictionary views can consist of joins of dictionary base tables and user-defined tables.

B. Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base tables from the data dictionary

C. The data dictionary is created and maintained by the database administrator.

D. Both USER_OBJECTS and CAT views provide the same information about all the objects that are owned by the user.

E. The usernames of all the users including the database administrators are stored in the data dictionary.

F. The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a constraint applies.

정답: B,E,F

문제5

Examine this partial query:

Examine this output:

Which GROUP BY clause must be added so the query returns the results shown?

A. GROUP BY CUBE(ch.channel_type, t.month, co.country_code);

B. GROUP BY ch.channel_type, t.month, co.country_code;

C. GROUP BY ch.channel_type, ROLLUP(t.month, co.country_code);

D. GROUP BY ch.channel_type, t.month, ROLLUP(co.country_code);

정답: D

문제6

Evaluate the following SQL statement:
SELECT product_name || 'it's not available for order'
FROM product_information
WHERE product_status = 'obsolete';
You received the following error while executing the above query:
ERROR:
ORA-01756: quoted string not properly terminated
What would you do to execute the query successfully?

A. Enclose the character literal string in the SELECT clause within the double quotation marks.

B. Use escape character to negate the single quotation mark inside the literal character string in the SELECT clause.

C. Use Quote (q) operator and delimiter to allow the use of single quotation mark in the literal character string.

D. Do not enclose the character literal string in the SELECT clause within the single quotation marks.

정답: C

문제7

Which two statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

A. The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query.

B. The HAVING clause can be used with aggregate functions in subqueries.

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

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

E. The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table.

정답: B,C

문제8

Examine thestructure of the BOOKS_TRANSACTIONS table:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?

A. SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE
FEE" FROM BOOKS_TRANSACTIONS;

B. SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE
FEE" FROM BOOKS_TRANSACTIONS;

C. SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM BOOKS_TRANSACTIONS;

D. SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;

정답: A

문제9

Which task can be performed by using a single Data Manipulation Language (OML) statement?

A. adding a column with a default value when inserting a row into a table

B. removing all data only from one single column on which a unique constraint is defined

C. removing all data only from one single column on which a primary key constraint is defined

D. adding a column constraint when inserting a row into a table

정답: B

문제10

You executed the following CREATE TABLE statement that resulted in an error:
SQL> CREATE TABLE employees(emp_id NUMBER(10) PRIMARY KEY, ename
VARCHAR2(20), email NUMBER(3) UNIQUE, address VARCHAR2(500), phone
VARCHAR2(20), resume LONG, hire_date DATE, remarks LONG, dept_id
NUMBER(3) CONSTRAINT emp_dept_id_fk REFERENCES departments (dept_id),
CONSTRAINT ename_nn NOY NULL(ename));
Identify two reasons for the error.

A. The FOREIGN KEY keyword is missing in the constraint definition

B. The NOT NULL constraint on the ENAME column must be defined as the column level

C. FOREIGN KEY defined on the DEPT_ID column must be at the table level only

D. The PRIMARY KEY constraint in the EMP_ID column must have a name and must be defined at the table level only

E. Only one LONG column can be used per table

정답: B,E

문제11

The ORDERS table has a primary key constraint on the ORDER_ID column.
The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table.
The constraint is defined with ON DELETE CASCADE.
There are rows in the ORDERS table with an ORDER_TOTAL of less than 1000.
Which three DELETE statements execute successfully?

A. DELETE * FROM orders WHERE order_total < 1000;

B. DELETE FROM orders;

C. DELETE FROM orders WHERE order_total < 1000;

D. DELETE order_id FROM orders WHERE order_total < 1000;

E. DELETE orders WHERE order_total < 1000;

정답: D,E

문제12

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

A. By default, EM express is available for a database after database creation.

B. You cannot start up or shut down a database Instance by using EM express.

C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D. You can create and configure pluggable databases by using EM express.

E. You can use EM express to manage multiple databases running on the same server.

정답: A

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

문제13

Which three statements are true regarding group functions? (Choose three.)

A. They can be passed as an argument to another group function.

B. They can be used only with a SQL statement that has the GROUP BY clause.

C. They can be used on only one column in the SELECT clause of a SQL statement.

D. They can be used along with the single-row function in the SELECT clause of a SQL statement.

E. They can be used on columns or expressions.

정답: A,D,E

문제14

Evaluate this query:
SQL> SELECT TRUNC(ROUND(156.00,-1),-1)
FROM DUAL;
What will be the result?

A. 150

B. 16

C. 200

D. 100

E. 160

정답: E

문제15

Which two statements are true about the SET VERIFY ON command? (Choose two.)

A. It displays values for variables used only in the WHERE clause of a query

B. It can be used in SQL Developer and SQL*Plus

C. It displays values for variables created by the DEFINE command

D. It displays values for variables prefixed with &&

E. It can be used only in SQL*Plus

정답: B,C

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

Oracle Database SQL - 1z0-071무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트