[ORACLE-SQL] ExamTopics 71~80
![[ORACLE-SQL] ExamTopics 71~80](/assets/img/study_Oracle/2022-11-19-%5BORACLE-SQL%5D_ExamTopics_71~80/logo.png){kind=logo}
1z0-071 Examtopics 71~80번 문제를 풀어보자.
1차 x/x
- Prob. 71 ⭕
- Prob. 72 ❌
- Prob. 73 ⭕❌
- Prob. 74 ⭕❌
- Prob. 75 ⭕❌
- Prob. 76 ⭕❌
- Prob. 77 ⭕❌
- Prob. 78 ⭕❌
- Prob. 79 ⭕❌
- Prob. 80 ⭕❌
Prob. 71 ⭕
Examine this statement:
On which two columns of the table will an index be created automatically? (Choose two.)
A. ORDER_ID
B. ORDER_TOTAL
C. ORDER_DATE
D. PRODUCT_ID
E. STATUS
F. SERIAL_NO
정답 및 해설 보기
Answer : A, F
해설 :
INDEX 는 기본적으로 하나의 칼럼 당 하나의 인덱스를 생성할 수 있다.
또한 PK, UNIQUE 가 지정된 칼럼일 경우, 자동으로 인덱스가 생성된다.
1차 시도 : A, F 맞음
Prob. 72 ❌
Examine this partial query:
Examine this output:
Which GROUP BY clause must be added so the query returns the results shown?
A. GROUP BY ch.channel_type, ROLLUP(t.month, co.country_code);
B. GROUP BY ch.channel_type, t.month, ROLLUP(co.country_code);
C. GROUP BY CUBE(ch.channel_type, t.month, co.country_code);
D. GROUP BY ch.channel_type, t.month, co.country_code;
정답 및 해설 보기
Answer : A
해설 :
ROLLUP 함수를 사용하여 칼럼을 감싸면, 인자가 된 칼럼의 각 소계, 합계가 나오게 된다.
그리고 ROLLUP 으로 감싸지지 않은 남은 칼럼은 합계가 나오지 않으므로, 해당 문제의 결과를 출력하는 답은 A이다.
1차 시도 : D 틀림
Prob. 73 ⭕❌
Examine the description of the EMPLOYEES table:
Which statement will execute successfully, returning distinct employees with non-null first names?
A. SELECT first_name, DISTINCT last_name FROM employees WHERE first_name <> NULL;
B. SELECT first_name, DISTINCT last_name FROM employees WHERE first_name IS NOT NULL;
C. SELECT DISTINCT * FROM employees WHERE first_name IS NOT NULL;
D. SELECT DISTINCT * FROM employees WHERE first_name <> NULL;
정답 및 해설 보기
Answer :
해설 :
1차 시도 :
Prob. 74 ⭕❌
Examine the description of the BRICKS table:
Examine the description of the BRICKS_STAGE table:
Which two queries execute successfully? (Choose two.)
A.
B.
C.
D.
E.
정답 및 해설 보기
Answer :
해설 :
1차 시도 :
Prob. 75 ⭕❌
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:
Which two statements are true? (Choose two.)
A. Employees 100 and 200 will have the same SALARY as before the update command.
B. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200.
C. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100.
D. Employees 100 and 200 will have the same JOB_ID as before the update command.
E. Employee 100 will have SALARY set to the same value as the SALARY of employee 200.
F. Employee 200 will have SALARY set to the same value as the SALARY of employee 100.
정답 및 해설 보기
Answer :
해설 :
1차 시도 :
Prob. 76 ⭕❌
Examine these two queries and their output:
SELECT deptno, dname FROM dept;
SELECT emame, job, deptno FROM emp ORDER BY deptno;
Now examine this query:
How many rows will be displayed?
A. 64
B. 6
C. 3
D. 12
정답 및 해설 보기
Answer :
해설 :
1차 시도 :
Prob. 77 ⭕❌
You want to return the current date and time from the user session, with a data type of TIMESTAMP WITH TIME ZONE.
Which function will do this?
A. SYSDATE
B. CURRENT_TIMESTAMP
C. LOCALTIMESTAMP
D. CURRENT_DATE
정답 및 해설 보기
Answer :
해설 :
1차 시도 :
Prob. 78 ⭕❌
You have been tasked to create a table for a banking application. One of the columns must meet three requirements:
1) Be stored in a format supporting date arithmetic without using conversion functions
2) Store a loan period of up to 10 years
3) Be used for calculating interest for the number of days the loan remains unpaid
Which data type should you use?
A. INTERVAL YEAR TO MONTH
B. TIMESTAMP WITH TIMEZONE
C. INTERVAL DAY TO SECOND
D. TIMESTAMP WITH LOCAL TIMEZONE
E. TIMESTAMP
정답 및 해설 보기
Answer :
해설 :
1차 시도 :
Prob. 79 ⭕❌
정답 및 해설 보기
Answer :
해설 :
1차 시도 :
Prob. 80 ⭕❌
정답 및 해설 보기
Answer :
해설 :
1차 시도 :
