Create Next App

Exam contains 287 questions

Page 10 of 48

Question 55 🔥

View the Exhibit and examine the description for the CUSTOMERS table.You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, whereCUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Which SQL statement will accomplish the task?

Which database solution meets these requirements?

A. UPDATE customersSET cust_credit_limit = NULLWHERE CUST_INCOME_LEVEL = NULL;

Highly voted

B. UPDATE customersSET cust_credit_limit = NULLWHERE cust_income_level IS NULL;

Highly voted

C. UPDATE customersSET cust_credit_limit = TO_NUMBER(NULL)WHERE cust_income_level = TO_NUMBER(NULL);

Highly voted

D. UPDATE customersSET cust_credit_limit = TO_NUMBER(' ',9999)WHERE cust_income_level IS NULL;

Highly voted

Discussion of the question

Question 56 🔥

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?

Which database solution meets these requirements?

A. ALTER TABLE students ADD PRIMARY KEY student_id;

Highly voted

B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

Highly voted

C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

Highly voted

D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

Highly voted

E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

Highly voted

Discussion of the question

Question 57 🔥

Which two statements about sub queries are true? (Choose two.)

Which database solution meets these requirements?

A. A sub query should retrieve only one row.

Highly voted

B. A sub query can retrieve zero or more rows.

Highly voted

C. A sub query can be used only in SQL query statements.

Highly voted

D. Sub queries CANNOT be nested by more than two levels.

Highly voted

E. A sub query CANNOT be used in an SQL query statement that uses group functions.

Highly voted

F. When a sub query is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the sub query should contain only one column.

Highly voted

Discussion of the question

Question 58 🔥

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?

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 59 🔥

Which describes the default behavior when you create a table?

Which database solution meets these requirements?

A. The table is accessible to all users.

Highly voted

B. Tables are created in the public schema.

Highly voted

C. Tables are created in your schema.

Highly voted

D. Tables are created in the DBA schema.

Highly voted

E. You must specify the schema when the table is created.

Highly voted

Discussion of the question

Question 60 🔥

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)

Which database solution meets these requirements?

A. It releases the storage space used by the table.

Highly voted

B. It does not release the storage space used by the table.

Highly voted

C. You can roll back the deletion of rows after the statement executes.

Highly voted

D. You can NOT roll back the deletion of rows after the statement executes.

Highly voted

E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

Highly voted

F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_051

Exam contains 287 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us