최신Oracle Database 12c: SQL Fundamentals - 1z1-061무료샘플문제
문제1
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제2
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?
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?
정답: C
문제3
Which three SQL statements would display the value 1890.55 as $1, 890.55? (Choose three.)
Which three SQL statements would display the value 1890.55 as $1, 890.55? (Choose three.)
정답: A,B,E
문제4
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?
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?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제5
You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE.
Examine the sample output:
Which query will provide the required output?
You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE.
Examine the sample output:
Which query will provide the required output?
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.
There is only one customer with the cus_last_name column having value Roberts.
Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?
View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.
There is only one customer with the cus_last_name column having value Roberts.
Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?
정답: B
문제7
Evaluate the following SQL commands:
The command to create a table fails. Identify the two reasons for the SQL statement failure?
Evaluate the following SQL commands:
The command to create a table fails. Identify the two reasons for the SQL statement failure?
정답: A,C
설명: (KoreaDumps 회원만 볼 수 있음)
문제8
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?
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?
정답: C
문제9
You own a table called EMPLOYEES with this table structure:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
What happens when you execute this DELETE statement?
DELETE employees;
You own a table called EMPLOYEES with this table structure:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
What happens when you execute this DELETE statement?
DELETE employees;
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제10
The SQL statements executed in a user session as follows:
Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)
The SQL statements executed in a user session as follows:
Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)
정답: C,D
문제11
Which three statements are true about the ALTER TABLE .... DROP COLUMN ....
command?
Which three statements are true about the ALTER TABLE .... DROP COLUMN ....
command?
정답: B,C,D
문제12
View the Exhibit and examine the structure of the CUSTOMERS table .Which statement would display the highest credit limit available in each income level in each city in the CUSTOMERS table?
View the Exhibit and examine the structure of the CUSTOMERS table .Which statement would display the highest credit limit available in each income level in each city in the CUSTOMERS table?
정답: D
문제13
You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'. Which WHERE clause could be used in the SELECT statement to get the required output?
You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'. Which WHERE clause could be used in the SELECT statement to get the required output?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)