Create Next App

Exam contains 339 questions

Page 2 of 57

Question 7 🔥

You need to design a student registration database that contains several tables storing academic information.The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key.You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table.Which statement creates the foreign key?

Which database solution meets these requirements?

A. CREATE TABLE student_grades (student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY students(student_id));

Highly voted

B. CREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id));

Highly voted

C. CREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES students(student_id));

Highly voted

D. CREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id));

Highly voted

Discussion of the question

Question 8 🔥

Here is the structure and data of the CUST_TRANS table:Exhibit:Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table.Which three SQL statements would execute successfully? (Choose three.)

Which database solution meets these requirements?

A. SELECT transdate + '10' FROM cust_trans;

Highly voted

B. SELECT * FROM cust_trans WHERE transdate = '01-01-07';

Highly voted

C. SELECT transamt FROM cust_trans WHERE custno > '11';

Highly voted

D. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';

Highly voted

E. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;

Highly voted

Discussion of the question

Question 9 🔥

View the Exhibit for the structure of the student and faculty tables.You need to display the faculty name followed by the number of students handled by the faculty at the base location.Examine the following two SQL statements:Which statement is true regarding the outcome?

Which database solution meets these requirements?

A. Only statement 1 executes successfully and gives the required result.

Highly voted

B. Only statement 2 executes successfully and gives the required result.

Highly voted

C. Both statements 1 and 2 execute successfully and give different results.

Highly voted

D. Both statements 1 and 2 execute successfully and give the same required result.

Highly voted

Discussion of the question

Question 10 🔥

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 11 🔥

Which three statements/commands would cause a transaction to end? (Choose three.)

Which database solution meets these requirements?

Discussion of the question

Question 12 🔥

Evaluate the following SQL statement:Which statement is true regarding the outcome of the above query?

Which database solution meets these requirements?

A. It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

Highly voted

B. It produces an error because positional notation cannot be used in the order by clause with set operators.

Highly voted

C. It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.

Highly voted

D. It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_061

Exam contains 339 questions

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

Company

Product

Resources

Follow us