1Z0-051：最新的Oracle認證1Z0-051考題，Oracle Database: SQL Fundamentals I認證

問題1
You created an ORDERS table with the following description:
Exhibit:

You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID column.
Which statement is true in this scenario?

A. The primary key constraint can be created only a the time of table creation

B. You cannot add a primary key constraint if data exists in the column

C. You cannot have two constraints on one column

D. You can add the primary key constraint even if data exists, provided that there are no duplicate values

正確答案: D

問題2
See the Exhibits and examine the structures of PRODUCTS, SALES and CUSTOMERS table:

You issue the following query:

Which statement is true regarding the outcome of this query?

A. It produces an error because a column used in the NATURAL join cannot have a qualifier

B. It executes successfully

C. It produces an error because all columns used in the NATURAL join should have a qualifier

D. It produces an error because the NATURAL join can be used only with two tables

正確答案: A

說明：（僅 PDFExamDumps 成員可見）

問題3
What is true about sequences?

A. Once created, a sequence is linked to a specific table.

B. Only the DBA can control which sequence is used by a certain table.

C. Once created, a sequence belongs to a specific schema.

D. Once created, a sequence is automatically used in all INSERT and UPDATE statements.

E. Once created, a sequence is automatically available to all users.

正確答案: C

問題4
Which four are types of functions available in SQL? (Choose 4)

A. integer

B. date

C. translation

D. conversion

E. calendar

F. character

G. string

H. numeric

正確答案: B,D,F,H

說明：（僅 PDFExamDumps 成員可見）

問題5
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
NEW_EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
NAME VARCHAR2(60)
Which MERGE statement is valid?

A. MERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES(e.employee_id, e.first_name ||', '||e.last_name);

B. MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees VALUES (e.employee_id, e.first_name ||', '||e.last_name);

C. MERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET c.name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES (e.employee_id, e.first_name ||', '||e.last_name);

D. MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET c.name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT VALUES (e.employee_id, e.first_name ||', '||e.last_name);

正確答案: C

說明：（僅 PDFExamDumps 成員可見）

問題6
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?

A. GRANT select ON dept TO PUBLIC;

B. GRANT QUERY ON dept TO ALL_USERS

C. GRANT select ON dept TO ALL_USERS;

D. GRANT select ON dept TO ALL;

正確答案: A

說明：（僅 PDFExamDumps 成員可見）

問題7
Top N analysis requires _____ and _____. (Choose two.)

A. an ORDER BY clause

B. an inline view and an outer query

C. a GROUP BY clause

D. only an inline view

E. the use of rowid

正確答案: A,B

說明：（僅 PDFExamDumps 成員可見）

問題8
What does the FORCE option for creating a view do?

A. creates a view even if the underlying parent table has constraints

B. creates a view in another schema even if you don't have privileges

C. creates a view with constraints

D. creates a view regardless of whether or not the base tables exist

正確答案: D

說明：（僅 PDFExamDumps 成員可見）

問題9
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;

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

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

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

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

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

正確答案: C

說明：（僅 PDFExamDumps 成員可見）

問題10
You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:
CUST_IDNUMBER(4)NOT NULL CUST_NAMEVARCHAR2(100)NOT NULL CUST_ADDRESSVARCHAR2(150) CUST_PHONEVARCHAR2(20)
Which SELECT statement accomplishes this task?

A. SELECT cust_name, cust_address FROM customers;

B. SELECT id, name, address, phone FROM customers;

C. SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;

D. SELECT name, address FROM customers;

E. SELECT * FROM customers

正確答案: A

說明：（僅 PDFExamDumps 成員可見）

問題11
You issue the following command to drop the PRODUCTS table:
SQL>DROP TABLE products;
What is the implication of this command? (Choose all that apply.)

A. All views and synonyms will remain but they are invalidated

B. All data in the table are deleted but the table structure will remain

C. The pending transaction in the session is committed

D. All data along with the table structure is deleted

E. All indexes on the table will remain but they are invalidated

正確答案: A,C,D

最新的Oracle Database: SQL Fundamentals I - 1Z0-051免費考試真題

專業認證

品質保證

輕松通過

免費試用