[2026] Oracle Database 12c: SQL Fundamentals - 1z1-061 무료 시험 문제

문제1

View the Exhibit and evaluate the structure and data in the CUST_STATUS table.

You issue the following SQL statement:

Which statement is true regarding the execution of the above query?

A. It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null.

B. It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.

C. It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function.

D. It produces an error because the AMT_SPENT column contains a null value.

정답: A

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

문제2

What is true regarding sub queries?

A. The inner query always sorts the results of the outer query

B. The outer query always sorts the results of the inner query

C. The outer query must return a value to the outer query

D. The inner query returns a value to the outer query

E. The inner query must always return a value or the outer query will give an error

정답: D

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

문제3

View the Exhibit and examine the description for the CUSTOMERS table.

You want to update the CUST_INCOME_LEVEL and CUST_CREDIT_LIMIT columns for the customer with the CUST_ID 2360. You want the value for the CUST_INCOME_LEVEL to have the same value as that of the customer with the CUST_ID 2560 and the CUST_CREDIT_LIMIT to have the same value as that of the customer with CUST_ID
2566.
Which UPDATE statement will accomplish the task?

A. UPDATE customersSET (cust_income_level, cust_credit_limit)
(SELECTcust_income_level, cust_credit_limitFROM customersWHERE cust_id IN(2560,
2 566)WHERE cust_id=2360;

B. UPDATE customersSET cust_income_level = (SELECT cust_income_levelFROM customersWHERE cust_id = 2560),cust_credit_limit = (SELECT cust_credit_limitFROM customersWHERE cust_id = 2566)WHERE cust_id=2360;

C. UPDATE customersSET (cust_income_level, cust_credit_limit)
(SELECTcust_income_level, cust_credit_limitFROM customersWHERE cust_id=2560 OR cust_id=2566)WHERE cust_id=2360;

D. UPDATE customersSET (cust_income_level, cust_credit_limit)
(SELECTcust_income_level, cust_credit_limitFROM customersWHERE cust_id=2560 AND cust_id=2566)WHERE cust_id=2360;

정답: B

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

문제4

Examine the data in the ORD_ITEMS table:

Evaluate the following query:

Which statement is true regarding the outcome of the above query?

A. It gives an error because all the aggregate functions used in the having clause must be specified in the select list.

B. It gives an error because the having clause should be specified after the group by clause.

C. It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

D. It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.

정답: D

문제5

What is true about updates through a view?

A. When you update a view group functions are automatically computed.

B. You cannot update a view with group functions.

C. When you update a view only the constraints on the underlying table will be in effect.

D. When you update a view the constraints on the views always override the constraints on the underlying tables.

정답: B

문제6

Evaluate the SQL statement:
SELECT LPAD (salary, 10, '*')
FROM EMP
WHERE EMP_ID = 1001;
If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?

A. 17000.00

B. 17000*****

C. an error statement

D. ****170.00

E. **17000.00

정답: E

문제7

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:

and examine the structure of CUSTOMRS AND SALES tables:
Evaluate the following SQL statement:
Exhibit:

Which statement is true regarding the execution of the above UPDATE statement?

A. It would not execute because two tables cannot be used in a single UPDATE statement

B. It would execute and restrict modifications to only the column specified in the SELECT statement

C. It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement

D. It would not execute because the SELECT statement cannot be used in place of the table name

정답: B

문제8

View the Exhibit and examine the structure of CUSTOMERS and SALES tables.

Evaluate the following SQL statement:
UPDATE (SELECT prod_id, cust_id, quantity_sold, time_id
FROM sales)
SET time_id = '22-MAR-2007'
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_last_name = 'Roberts' AND
credit_limit = 600);
Which statement is true regarding the execution of the above UPDATE statement?

A. It would not execute because two tables cannot be used in a single UPDATE statement.

B. It would not execute because the SELECT statement cannot be used in place of the table name.

C. It would execute and restrict modifications to only the columns specified in the SELECT statement.

D. It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.

정답: C

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

문제9

See the Exhibit and examine the structure and data in the INVOICE table:
Exhibit:

Which two SQL statements would execute successfully? (Choose two.)

A. SELECT MAX(inv_date), MIN(cust_id) FROM invoice;

B. SELECT MAX(AVG(SYSDATE - inv_date)) FROM invoice;

C. SELECT (AVG(inv_date) FROM invoice;

D. SELECT AVG(inv_date - SYSDATE), AVG(inv_amt) FROM invoice;

정답: A,D

문제10

You need to create a table for a banking application. One of the columns in the table has the following requirements:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column should be stored in a format such that it can be easily added and subtracted with date data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30 days.
4) The interest has to be calculated for the number of days an individual has taken a credit for.
Which data type would you use for such a column in the table?

A. INTERVAL DAY TO SECOND

B. INTERVAL YEAR TO MONTH

C. NUMBER

D. DATE

E. TIMESTAMP

정답: A

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

문제11

Which two statements are true about constraints? (Choose two.)

A. The UNIQUE constraint does not permit a null value for the column.

B. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

C. The NOT NULL constraint ensures that null values are not permitted for the column.

D. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE
constraints.

정답: C,D

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

문제12

View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables.
You need to generate a report showing the promo name along with the customer name for all products that were sold during their promo campaign and before 30th October 2007.
You issue the following query:

Which statement is true regarding the above query?

A. It produces an error because equijoin and nonequijoin conditions cannot be used in the same SELECT statement.

B. It produces an error because the join order of the tables is incorrect.

C. It executes successfully but does not give the required result.

D. It executes successfully and gives the required result.

정답: C

문제13

View the Exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement?
(Choose two.)

A. finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'

B. listing of customers who do not have a credit limit and were born before 1980

C. finding the number of customers, in each city, whose marital status is 'married'

D. listing of those customers whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'

E. finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

정답: D,E

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

문제14

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

Which two statements are true regarding data type conversion in expressions used in queries?

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

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

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

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

E. inv_amt ='0255982': requires explicit conversion

정답: B,C

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

Oracle Database 12c: SQL Fundamentals - 1z1-061무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트