最新的Oracle 1z1-061免費考試真題

問題1

Which two statements are true regarding constraints?

A. A foreign key cannot contain null values.

B. A column with the unique constraint can contain null values.

C. A constraint is enforced only for the insert operation on a table.

D. A constraint can be disabled even if the constraint column contains data.

E. All constraints can be defined at the column level as well as the table level.

正確答案: B,D

說明：（僅 Fast2test 成員可見）

問題2

The STUDENT_GRADES table has these columns:
STUDENT_ID. NUMBER(12)
SEMESTER_END. DATE
GPA. NUMBER(4, 3)
The registrar has asked for a report on the average grade point average (GPA), sorted from the highest grade point average to each semester, starting from the earliest date.
Which statement accomplish this?

A. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY
semester_end DESC, gpa DESC;

B. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY
semester_end, gpa DESC

C. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end DESC;

D. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end ASC;

E. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end ASC;

F. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY
semester_end, gpa ASC

正確答案: B

問題3

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:

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

A. UPDATE promotionsSET promo_cost = promo_cost+ 100WHERE
TO_CHAR(promo_end_date, 'yyyy') > '2000';

B. UPDATE promotionsSET promo_cost = promo_cost+ 100WHERE promo_end_date > TO_DATE(SUBSTR('01-JAN-2000', 8));

C. SELECT TO_CHAR(promo_begin_date, 'dd/month')FROM promotionsWHERE
promo_begin_date IN (TO_DATE('JUN 01 98'), TO_DATE('JUL 01 98'));

D. SELECT promo_begin_dateFROM promotionsWHERE TO_CHAR(promo_begin_date,
'mon dd yy')='jul 01 98';

正確答案: A,D

問題4

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?

A. WHERE prod_id LIKE '%\_D123%' ESCAPE '\_'

B. WHERE prod_id LIKE '%\_D123%' ESCAPE '\'

C. WHERE prod_id LIKE '%_D123%' ESCAPE '%_'

D. WHERE prod_id LIKE '%_D123%' ESCAPE '_'

正確答案: B

說明：（僅 Fast2test 成員可見）

問題5

Which three statements are true about multiple-row sub queries? (Choose three.)

A. They cannot contain a subquery within a subquery.

B. They can return multiple columns as well as rows.

C. They can contain a subquery within a sub query.

D. They can return only one column but multiple rows.

E. They can contain group functions and the GROUP BY clause, but not the HAVING clause.

F. They can contain group functions and GROUP BY and HAVING clauses.

正確答案: B,C,F

問題6

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4, 3)
The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest.
Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?

A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

B. SELECT student_id, gpa FROM student_grades ORDER BY gpa;

C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;

D. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;

F. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;

正確答案: D

說明：（僅 Fast2test 成員可見）

問題7

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?

A. SELECT last_name, department_name, location_id FROM employees , departments ;

B. SELECT employees.last_name, departments.department_name,
departments.location_id FROM employees e, departments D WHERE e.department_id
= d.department_id;

C. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id =d.department_id;

D. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id =manager_id;

正確答案: C

說明：（僅 Fast2test 成員可見）

問題8

Evaluate the SQL statement
DROP TABLE DEPT:
Which four statements are true of the SQL statement? (Choose four.)

A. All pending transactions are committed.

B. All indexes based on the DEPT table are dropped.

C. All views based on the DEPT table are deleted.

D. All data in the table is deleted, and the table structure is also deleted.

E. All synonyms based on the DEPT table are deleted.

F. All data in the table is deleted, but the structure of the table is retained.

G. You cannot roll back this statement.

正確答案: A,B,D,G

說明：（僅 Fast2test 成員可見）

問題9

Which statement is true regarding the default behavior of the order by clause?

A. NULL values are not considered at all by the sort operation.

B. Only those columns that are specified in the select list can be used in the order by clause.

C. In a character sort, the values are case-sensitive.

D. Numeric values are displayed from the maximum to the minimum value if they have decimal positions.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題10

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID NUMBER\
SAL NUMBER
MGR_ID NUMBER . References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER . Foreign key to DEPARTMENT_ID column of the. .
DEPARTMENTS table
You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table.
Which two statements regarding the EMP_ID_SEQ sequence are true? (Choose two.)

A. The EMP_ID_SEQ sequence is dropped automatically when you drop the
EMPLOYEE_ID column.

B. You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.

C. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.

D. The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.

E. The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.

F. Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.

正確答案: D,F

說明：（僅 Fast2test 成員可見）

問題11

Consider these three statements:
create synonym s1 for employees; create public synonym s1 for departments; select * from s1; Which of the following statements is correct?

A. The second statement will fail because an object S1 already exists.

B. The third statement will show the contents of the table S1, if such a table exists in the current schema.

C. The third statement will show the contents of EMPLOYEES.

D. The third statement will show the contents of DEPARTMENTS.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題12

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure?
(Choose two.)

A. The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4, 000 characters.

B. The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.

C. The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.

D. The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.

正確答案: A,D

說明：（僅 Fast2test 成員可見）

最新的Oracle Database 12c: SQL Fundamentals - 1z1-061免費考試真題

聯系我們

站內鏈接

最新更新