2026년 Oracle Database 12c: SQL Fundamentals 시험을 앞두고 학습 시간 확보가 어려우신가요? KoreaDumps의 1z0-061 연습문제 340문항은 핵심 위주로 구성되어 틈새 시간만으로도 충분히 대비하실 수 있습니다.

Oracle 1z0-061 시험 개요:

Oracle 1z0-061 시험 요강 주제:

Oracle Database 12c: SQL Fundamentals에 대해 알아야 할 모든 것

최신 Oracle Database 1z0-061 무료샘플문제

문제 #1

You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?

A. Option B
B. Option A
C. Option D
D. Option C

문제 #2

The COMMISSION column shows the monthly commission earned by the employee.
Exhibit

Which two tasks would require sub queries or joins in order to be performed in a single step? (Choose two.)

A. finding the total commission earned by the employees in department 10
B. listing the employees whose annual commission is more than 6000
C. listing the departments whose average commission is more that 600
D. finding the number of employees who earn a commission that is higher than the average commission of the company
E. listing the employees who earn the same amount of commission as employee 3
F. listing the employees who do not earn commission and who are working for department
20 in descending order of the employee ID

문제 #3

You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table.
Which query will generate the required result?

A. Option B
B. Option A
C. Option D
D. Option C

문제 #4

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

A. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;
B. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
C. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK
customer_name IS NOT NULL;
D. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
E. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn
NOT NULL;
F. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;

문제 #5

Which two statements are true regarding single row functions? (Choose two.)

A. Arguments can only be column values or constant
B. They accept only a single argument
C. They always return a single result row for every row of a queried table
D. They can return a data type value different from the one that is referenced
E. They can be nested only to two levels

질문과 대답: