1D0_541 questions • Exam prepare

Exam contains 124 questions

Page 10 of 21

Question 55 🔥

What is the highest normal form of the relation(s) shown in the exhibit?

Which database solution meets these requirements?

A. Second normal form

B. First normal form

C. Boyce-Codd normal form

D. Third normal form

E. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num

F. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num Foreign Key Class_Num References STUDENT

G. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key StudenMMumber STU_CLASS( Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num

Discussion of the question

Question 56 🔥

Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known asGroup_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2?

Which database solution meets these requirements?

A. REVOKE INSERT, UPDATE, DELETE ON Employees FROM Group_2;

B. REVOKE UPDATE FOR Employees FROM Group_2;

C. REVOKE INSERT, UPDATE, DELETE ON Employees FOR Group_2;

D. REVOKE UPDATE, DELETE FOR Employees FROM Group_2;

Discussion of the question

Question 57 🔥

Which type of dependency occurs when one attribute of a composite key is removed and the dependency still exists?

Which database solution meets these requirements?

A. 1:1

B. Transitive

C. Functional

D. Partial functional

Discussion of the question

Question 58 🔥

Which relational algebraic operation is used to select specific columns (attributes) from a relation?

Which database solution meets these requirements?

A. Union

B. Difference

C. Projection

D. Intersection

Discussion of the question

Question 59 🔥

Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?

Which database solution meets these requirements?

A. INSERT INTO Atlanta_Customers VALUES( SELECT * FROM Customer s WHERE Sales_Office = Atlanta

B. INSERT INTO Atlanta_Customers SELECT * FROM Customers WHERE Sales_Office = Atlanta

C. INSERT INTO Atlanta_Customers SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers WHERE Sales_Office = Atlanta

D. INSERT INTO Atlanta_Customers SELECT Cust_No, Cust_Name, Sales_Office, Sales_Rep_No FROM Customers WHERE Sales_Office = Atlanta

Discussion of the question

Question 60 🔥

Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?

Which database solution meets these requirements?

A. Union

B. Intersection

C. Natural join

D. Cartesian product

Discussion of the question

Ready to Pass Your Certification Test

ciw 1D0_541

Exam contains 124 questions

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

Company

Product

Resources

Follow us