1D0_541 questions • Exam prepare

Exam contains 124 questions

Page 14 of 21

Question 79 🔥

Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted when it has residents. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location andRes_Name are all represented by variable-length strings with a maximum of 20 characters. Which SQL statement best implements the relations shown in this diagram?

Which database solution meets these requirements?

A. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES RESIDENT (Building_ID) ON DELETE NO CHECK);

B. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK ON UPDATE CASCADE);

C. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK ON UPDATE CASCADE);

D. CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK ON UPDATE CASCADE);

Discussion of the question

Question 80 🔥

Which of the following best describes the two-tier database architecture?

Which database solution meets these requirements?

A. The user accesses a database server using a terminal.

B. The user interface, data-processing logic, database access and data validation functions are performed on a mainframe server.

C. The user interface and data validation functions are performed by the client whereas the data-processing logic is performed on a server.

D. The user interface and data-processing logic are performed by the client whereas the server handles database access and data validation functions.

Discussion of the question

Question 81 🔥

The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?

Which database solution meets these requirements?

A. Activity_Fee is a determinant of Activity.

B. Activity_Fee is partially dependent on the key.

C. The table contains a transitive dependency.

D. Activity_Fee is a determinant of Activity and Student_I

Discussion of the question

Question 82 🔥

Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram?

Which database solution meets these requirements?

A. 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

B. 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

C. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number 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

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

Discussion of the question

Question 83 🔥

Which term best defines a database system in which data records are stored in one or more files with no structured relationship?

Which database solution meets these requirements?

A. Flat-file database

B. Relational database

C. Distributed database

D. Object-oriented database

Discussion of the question

Question 84 🔥

Which of the following describes two desirable characteristics of a primary key?

Which database solution meets these requirements?

A. A primary key should be a value that may be null and may change over time.

B. A primary key should be a value that is not null and will never change.

C. A primary key should consist of meaningful data and a value that can be changed if needed.

D. A primary key should not consist of meaningful data and a value that can be changed if needed.

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