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

문제1

View the Exhibit and examine the data in the PRODUCTS table.

Which statement would add a column called PRICE, which cannot contain NULL?

A. ALTER TABLE products
ADD price NUMBER(8,2) NOT NULL;

B. ALTER TABLE products
ADD price NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL.

C. ALTER TABLE products
ADD price NUMBER(8,2) DEFAULT 0 NOT NULL;

D. ALTER TABLE products
ADD price NUMBER(8,2) DEFAULT NOT NULL;

정답: C

문제2

Examine the following query:

What is the output of this query?

A. It displays 5 percent of the products with the lowest amount sold.

B. It displays the first 5 percent of the rows from the SALES table.

C. It results in an error because the ORDER BY clause should be the last clause.

D. It displays 5 percent of the products with the highest amount sold.

정답: A

문제3

View the Exhibit and examine the data in the PROMOTIONStable.

PROMO_BEGIN_DATEis stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the POSTcategory that were launched before January 1, 2000.
Which SQL statement would you use?

A. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';

B. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';

C. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';

D. SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category LIKE 'P%' AND promo_begin_date < '1-JANUARY-00';

정답: C

문제4

A subquery is called a single-row subquery when _______.

A. The inner query returns one or more values and the outer query returns a single value.

B. The inner query returns a single value to the outer query.

C. The inner query uses an aggregating function and returns one or more values.

D. There is only one subquery in the outer query and the inner query returns one or more values

정답: B

문제5

Which three statements are true regarding the data types?

A. The value for a CHAR data type column is blank-padded to the maximum defined column width.

B. The BLOB data type column is used to store binary data in an operating system file.

C. The minimum column width that can be specified for a varchar2 data type column is one.

D. ATIMESTAMP data type column stores only time values with fractional seconds.

E. Only one LONG column can be used per table.

정답: A,C,E

문제6

Which statement is true regarding the UNION operator?

A. Null values are not ignored during duplicate checking.

B. By default, the output is not sorted.

C. The number of columns selected in all select statements need not be the same.

D. Names of all columns must be identical across all select statements.

정답: A

문제7

Which three statements indicate the end of a transaction? (Choose three.)

A. after a SELECT statement is issued

B. after a ROLLBACK is issued

C. after a CREATE statement is issued

D. after a COMMIT is issued

E. after a SAVEPOINT is issued

정답: B,C,D

문제8

Which two are true about transactions in the Oracle Database? (Choose two.)

A. A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction.

B. DML statements always start new transactions.

C. An uncommitted transaction is automatically committed when the user exits SQL*Plus.

D. DDL statements automatically commit only data dictionary updates caused by executing the DDL.

E. A session can see uncommitted updates made by the same user in a different session.

정답: A,E

문제9

Which two statements are true regarding subqueries? (Choose two.)

A. A subquery can appear on either side of a comparison operator.

B. Only two subqueries can be placed at one level.

C. A subquery can retrieve zero or more rows.

D. There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.

E. A subquery can be used only in SQL query statements.

정답: A,C

문제10

Which two statements execute successfully? (Choose two.)

A.

B.

C.

D.

E.

정답: A,D

문제11

Which statement adds a column called SALARY to the EMPLOYEES table having 100 rows, which cannot contain null?

A. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL;

B. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) DEFAULT NOT NULL;

C. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) DEFAULT 0 NOT NULL;

D. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) NOT NULL;

정답: C

문제12

The BOOKS_TRANSACTIONS table exists in your database. Examine the SQL statement:
SQL>SELECT * FROM books_transactions ORDER BY 3;
What is the outcome on execution?

A. Rows are displayed in the order that they are stored in the table only for the first three rows.

B. The execution tails unless the numeral 3 in the order by clause is replaced by a column name,

C. Rows are displayed sorted in ascending order of the values in the third column in the table.

D. Rows are displayed in the order that they are stored in the table only for the three rows with the lowest values in the key column.

정답: C

문제13

The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted.
You only want to display details of rows where START_DATE is within the last 25 months.
Which WHERE clause can be used?

A. WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25

B. WHERE TO_NUMBER(start_date - SYSDATE) <= 25

C. WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25

D. WHERE ADD_MONTHS(start_date, 25) <= SYSDATE

정답: B

문제14

You execute this query:

What is the result?

A. It generates an error.

B. It executes successfully but does not return any result.

C. It returns the date for the first Monday of the next month.

D. It returns the date for the last Monday of the current month.

정답: C

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

우리와 연락하기

유용한 링크

최신 업데이트