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

문제1

You need to create a table named ORDERS that contain four columns:
1 . AN ORDER_ID column of number data type
2 . A CUSTOMER_ID column of number data type
3 . AN ORDER_STATUS column that contains a character data type
4 . A DATE_ORDERED column to contain the date the order was placed.
When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead.
Which statement accomplishes this?

A. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

B. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

C. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

D. CREATE OR REPLACE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

E. CREATE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8),
order_status NUMBER (10), date_ordered DATE = SYSDATE);

F. CREATE OR REPLACE TABLE orders (order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

정답: C

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

문제2

See the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and ITEMS tables:

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 the CREATE TABLE command:
Exhibit:

Which statement is true regarding the above command?

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

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 get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table

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

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

문제3

View the Exhibit and examine the structure of the CUSTOMERS table.
You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10, 000.
Evaluate the following two queries:

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

A. Only the second query gives the correct result.

B. Both execute successfully but do not give the required result.

C. Only the first query gives the correct result.

D. Both execute successfully and give the same result.

정답: C

문제4

Evaluate the following SQL commands:

The command to create a table fails. Identify the two reasons for the SQL statement failure?

A. You cannot use the BETWEEN clause in the condition of a CHECK constraint.

B. You cannot use the NEXTVAL sequence value as a DEFAULT value for a column.

C. You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the FOREIGN KEY.

D. You cannot use SYSDATE in the condition of a check constraint.

정답: B,D

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

문제5

View the Exhibit and examine the structure of the PRODUCTS tables.
You want to generate a report that displays the average list price of product categories where the average list price is less than half the maximum in each category.
Which query would give the correct output?

A. SELECT prod_category, avg(prod_list_price)FROM productsGROUP BY
prod_categoryHAVING avg(prod_list_price) > ANY(SELECT max(prod_list_price)/2FROM productsGROUP BY prod_category);

B. SELECT prod_category, avg(prod_list_price)FROM productsGROUP BY
prod_categoryHAVING avg(prod_list_price) > ANY(SELECT max(prod_list_price)/2FROM products);

C. SELECT prod_category, avg(prod_list_price)FROM productsGROUP BY
prod_categoryHAVING avg(prod_list_price) < ALL(SELECT max(prod_list_price)/2FROM productsGROUP BY prod_category);

D. SELECT prod_category, avg(prod_list_price)FROM productsHAVING
avg(prod_list_price) < ALL(SELECT max(prod_list_price)/2FROM productsGROUP BY prod_category);

정답: C

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

문제6

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

You need to generate a report in the following format:
CATEGORIES
---------------------------------------------
5MP Digital Photo Camera's category is Photo
Y Box's category is Electronics
Envoy Ambassador's category is Hardware
Which two queries would give the required output? (Choose two.)

A. SELECT prod_name || q'''s category is ' || prod_category CATEGORIES FROM products;

B. SELECT prod_name || q'\'s\' || ' category is ' || prod_category CATEGORIES FROM products;

C. SELECT prod_name || q'<'s >' || 'category is ' || prod_category CATEGORIES FROM products;

D. SELECT prod_name || q'['s ]'category is ' || prod_category CATEGORIES FROM products;

정답: B,C

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

문제7

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

The PROJ_TASK_DETAILS table stores information about tasks involved in a project and the relation between them.
The BASED_ON column indicates dependencies between tasks. Some tasks do not depend on the completion of any other tasks.
You need to generate a report showing all task IDs, the corresponding task ID they are dependent on, and the name of the employee in charge of the task it depends on.
Which query would give the required result?

A. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p JOIN proj_task_details dON (p.based_on = d.task_id);

B. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p FULL OUTER JOIN proj_task_details d ON (p.based_on = d.task_id);

C. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p LEFT OUTER JOIN proj_task_details d ON (p.based_on = d.task_id);

D. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p JOIN proj_task_details dON (p.task_id = d.task_id);

정답: C

문제8

Which statement is true regarding transactions? (Choose all that apply.)

A. A transaction can consist only of a set of DML and DDL statements.

B. A transaction can consist of only a set of queries or DML or DDL statements.

C. A part or an entire transaction can be undone by using ROLLBACK command.

D. A part or an entire transaction can be made permanent with a COMMIT.

E. A transaction consists of a set of DML or DCL statements.

정답: C,E

문제9

Examine the structure of the MARKS table:
Exhibit:

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

A. SELECT student_name, subject1FROM marksWHERE subject1 > AVG(subject1);

B. SELECT student_name, SUM(subject1)FROM marksWHERE student_name LIKE 'R%';

C. SELECT SUM(subject1+subject2+subject3)FROM marksWHERE student_name IS NULL;

D. SELECT SUM(DISTINCT NVL(subject1, 0)), MAX(subject1)FROM marksWHERE
subject1 > subject2;

정답: C,D

문제10

View the Exhibit and examine the structure of the CUSTOMERS and GRADES tables:

You need to display names and grades of customers who have the highest credit limit.
Which two SQL statements would accomplish the task? (Choose two.)

A. SELECT custname, gradeFROM customers, gradesWHERE (SELECT
MAX(cust_credit_limit)FROM customers) BETWEEN startval and endval;

B. SELECT custname, gradeFROM customers, gradesWHERE (SELECT
MAX(cust_credit_limit)FROM customers) BETWEEN startval and endvalAND
cust_credit_limit BETWEEN startval AND endval;

C. SELECT custname, gradeFROM customers , gradesWHERE cust_credit_limit IN (SELECT MAX(cust_credit_limit)FROM customers)AND MAX(cust_credit_limit) BETWEEN startval AND endval;

D. SELECT custname, gradeFROM customers, gradesWHERE cust_credit_limit = (SELECT MAX(cust_credit_limit)FROM customers)AND cust_credit_limit BETWEEN startval AND endval;

정답: B,D

문제11

View the Exhibit and examine the structure of the PROMOTIONS table. Using the PROMOTIONS table, you need to display the names of all promos done after January 1,
2001, starting with the latest promo. Which query would give the required result? (Choose all that apply.)

A. . SELECT promo_name. promo_begin_date FROM promotionsWHERE
promo_begin_date > '01-JAN-01' ORDER BY 1DESC:

B. . SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begiii_date > '01-JAN-01' ORDER BY 2 DESC;

C. . SELECT promo_name. promo_begiii_date FROM promotionsWHERE
promo_begin_date > '01-JAN-01' ORDER BY promo_name DESC:

D. . SELECT promo_name, promo_begin_date "START DATE" FROM promotionsWHERE promo_begin_date > '01-JAN-01' ORDER BY "START DATE" DESC;

정답: B,D

문제12

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

A. AWR Compare Period report

B. Active Session History (ASH) report

C. Taking a new snapshot and comparing it with a preserved snapshot

D. Compare Period ADDM report

정답: A

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

문제13

Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00, -1), -1)
FROM DUAL;
What would be the outcome?

A. 150

B. 16

C. 200

D. 100

E. 160

정답: E

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

문제14

What is true about sequences?

A. A sequence always increments by 1.

B. The minimum value of an ascending sequence defaults to 1.

C. The start value of the sequence is always 1.

D. The maximum value of descending sequence defaults to 1.

정답: B

문제15

What is true about the WITH GRANT OPTION clause?

A. It allows privileges on specified columns of tables.

B. It is required syntax for object privileges.

C. It is used to grant an object privilege on a foreign key column.

D. It allows a grantee DBA privileges.

E. It allows the grantee to grant object privileges to other users and roles.

정답: E

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

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

우리와 연락하기

유용한 링크

최신 업데이트