CIW 1D0-541 Exam Questions Free Practice Test

Viewing page 1 out of 4 pages

Viewing questions 1-10 out of questions

Questions # 1:

Which type of relational integrity is violated if a primary key in a database has a null value?

Options:

Entity integrity

Domain integrity

Domain constraints

Referential integrity

Expert Solution

Questions # 2:

Consider the table for an employee database shown in the exhibit. What is the degree of the table?

Question # 2

Options:

Expert Solution

Questions # 3:

Consider the Information Engineering diagram shown in the exhibit. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and Res_Name are all represented by variable-length strings with a maximum of 20 characters.

Which SQL statement best implements the RESIDENT relation shown in this diagram?

Question # 3

Options:

CREATE TABLE RESIDENT (

R_ID INTEGER NULL PRIMARY KEY,

Room_Num FLOAT,

Res_Name VARCHAR,

Building_ID INTEGER NULL,

FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

CREATE TABLE RESIDENT (

R_ID INTEGER NOT NULL PRIMARY KEY,

Room_Num BINARY,

Res_Name VARCHAR (20),

Building_ID INTEGER NOT NULL,

FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

CREATE TABLE RESIDENT (

R_ID INTEGER NOT NULL PRIMARY KEY,

Room_Num INTEGER,

Res_Name VARCHAR (20),

Building_ID INTEGER NOT NULL);

CREATE TABLE RESIDENT (

R_ID INTEGER NOT NULL PRIMARY KEY,

Room_Num INTEGER,

Res_Name VARCHAR (20),

Building_ID INTEGER NOT NULL,

FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

Expert Solution

Questions # 4:

The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

Question # 4

Options:

Only an update anomaly would occur.

An insertion anomaly would occur.

A deletion anomaly would occur.

An update anomaly and a deletion anomaly would occur.

Expert Solution

Questions # 5:

Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?

Question # 5

Options:

Information Engineering (IE) data model

Corporate data model

Database requirements model

ERD model

Expert Solution

Questions # 6:

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

Question # 6

Options:

Third normal form

Second normal form

No normal form

First normal form

Expert Solution

Questions # 7:

Which database security technique prevents invalid data from being entered into the database?

Options:

File locking

User authorization

Parity checks

Integrity controls

Expert Solution

Questions # 8:

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

Options:

CREATE

CREATE TABLE

CREATE DOMAIN

CREATE SCHEMA

Expert Solution

Questions # 9:

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

Question # 9

Options:

SELECT * FROM Customers

WHERE Satisfaction_Rate <= 80

OR Satisfaction_Rate >= 90;

SELECT * FROM Customers WHERE

Satisfaction_Rate IN (80 AND 90);

SELECT *FROM Customers

WHERE Satisfaction_Rate >= 80

AND Satisfaction_Rate <= 89;

SELECT * FROM

Customers WHERE

Satisfaction_Rate

BETWEEN (80, 90);

Expert Solution

Questions # 10:

Which of the following is a characteristic of the three-tier database architecture?

Options:

A Web browser is used as the application server.

The application logic is centralized on a dedicated server.

A thick client is used to perform business application logic functions locally.

Database application logic and database functionality are integrated and reside on a common server.

Expert Solution

Viewing page 1 out of 4 pages

Viewing questions 1-10 out of questions

Pass the CIW CIW Web Development Series 1D0-541 Questions and answers with CertsForce