Create Next App

Exam contains 124 questions

Page 4 of 21

Question 19 🔥

Which of the following best describes a composite key?

Which database solution meets these requirements?

A. A composite key is a primary key that consists of the first two attributes of a relation.

Highly voted

B. A composite key is a primary or foreign key defined by its parent keys.

Highly voted

C. A composite key is a foreign key that consists of the same attributes as the primary key from a related table.

Highly voted

D. A composite key is a primary or foreign key that consists of two or more attributes of a relation.

Highly voted

Discussion of the question

Question 20 🔥

Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

Which database solution meets these requirements?

A. UPDATE Recreation SET Activity, Activity_Fee (Tennis,100) WHERE Student_ID = 1003;

Highly voted

B. UPDATE TABLE Recreation ALTER COLUMN ACTIVITY SET ACTIVITY = Tennis', Activity_Fee = 100 WHERE Student__ID = 1003 AND Activity = wimming?AND Activity = ?wimming?

Highly voted

C. UPDATE Recreation SET Activity = Tennis', Activity_Fee = 100 WHERE Student_ID = 1003 AND Activity = 'Swimming';

Highly voted

D. DELETE Activity FROM Recreation WHERE Student_ID = 1003; INSERT INTO Recreation VALUES (1003, Tennis', 100);

Highly voted

Discussion of the question

Question 21 🔥

Which statement is used to define a named group of related tables, views, domains and other database objects?

Which database solution meets these requirements?

A. CREATE

Highly voted

B. CREATE TABLE

Highly voted

C. CREATE DOMAIN

Highly voted

D. CREATE SCHEMA

Highly voted

Discussion of the question

Question 22 🔥

NULL) Primary Key Class_Num -Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?

Which database solution meets these requirements?

A. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_ID

Highly voted

B. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT

Highly voted

C. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING Foreign Key BUILDING(Building_ID) references RESIDENT (Building_ID) RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT

Highly voted

D. BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key Building_ID RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key R_ID Foreign Key Building_ID references BUILDING(Building_ID)

Highly voted

Discussion of the question

Question 23 🔥

Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING andRESIDENT?

Which database solution meets these requirements?

A. 1:1

Highly voted

B. 1:N

Highly voted

C. N:1

Highly voted

D. M:N

Highly voted

Discussion of the question

Question 24 🔥

What is a data dictionary?

Which database solution meets these requirements?

A. A system catalog containing user data

Highly voted

B. An area of the database that is directly accessible by the user

Highly voted

C. Data that is stored in tables and is only accessible by the DBMS

Highly voted

D. Metadata that is stored in tables and is only accessible by the DBMS

Highly voted

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