최신 9i DBA 1Z0-007 무료샘플문제:
1. Examine the description of the STUDENTS table:
Which two aggregate functions are valid on the START_DATE column? (Choose two)
A) AVG (start_date, end_date)
B) MIN (start_date)
C) SUM (start_date)
D) COUNT (start_date)
E) MAXIMUM (start_date)
F) AVG (start_date)
2. Examine the data in the EMPLOYEES table.
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.
Evaluate this DELETE statement:
DELETE employee_id, salary, job_id FROM employees WHERE dept_id = 90;
Why does the DELETE statement fail when you execute it?
A) You cannot specify column names in the DELETE clause of the DELETE statement.
B) There is no row with dept_id 90 in the EMPLOYEES table.
C) You cannot delete the JOB_ID column because it is a NOT NULL column.
D) You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
3. Which two are character manipulation functions? (Choose two.)
A) TRUNC
B) REPLACE
C) TRIM
D) TO_DATE
E) MOD
F) CASE
4. Which best describes an inline view?
A) a subquery that is part of the FROM clause of another query
B) a subquery that can contain an ORDER BY clause
C) a schema object
D) another name for a view that contains group functions
5. Which two are true about aggregate functions? (Choose two.)
A) You can use aggregate functions on a table, only by grouping the whole table as one single group.
B) You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
C) You cannot group the rows of a table by more than one column while using aggregate functions.
D) You can use aggregate functions in any clause of a SELECT statement.
E) You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
F) You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
질문과 대답:
| 질문 # 1 정답: B,D | 질문 # 2 정답: A | 질문 # 3 정답: B,C | 질문 # 4 정답: A | 질문 # 5 정답: D,E |
1507 개 고객 리뷰
품질과 가치ITCertKR 의 높은 정확도를 보장하는 최고품질의 덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.
테스트 및 승인ITCertKR 의 덤프는 모두 엘리트한 전문가들이 실제시험문제를 분석하여 답을 작성한 만큼 시험문제의 적중률은 아주 높습니다.
쉽게 시험패스ITCertKR의 테스트 엔진을 사용하여 시험을 준비한다는것은 첫 번째 시도에서 인증시험 패스성공을 의미합니다.
주문하기전 체험ITCertKR의 각 제품은 무료 데모를 제공합니다. 구입하기로 결정하기 전에 덤프샘플문제로 덤프품질과 실용성을 검증할수 있습니다.
