1D0-541 Practice Exam Questions with Answers CIW v5 Database Design Specialist Certification

GRANT UPDATE ON Project TO Rubio, Doe;

GRANT SELECT ON Project TO Temp;

GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;

GRANT UPDATE ON Project TO Temp;

GRANT SELECT ON Project

WHERE Manager = 'Rubio';

GRANT SELECT ON Project

WHERE Manager = 'Doe';

GRANT UPDATE ON Project

WHERE Manager = 'Rubio';

GRANT UPDATE ON Project

WHERE Manager = 'Doe';

GRANT SELECT ON Project TO Temp;

Management of data redundancy, increased data integrity, increased data dependence, and increased application program flexibility.

Consistency of data, adherence to standards, managed concurrency, and increased software complexity.

Increased data access, increased data backup and recovery, data sharing, and consistency of data.

Increased datasecurity, increased data integrity, increased data independence, and decreased data separation.

INSERT INTO Atlanta_Customers

VALUES( SELECT * FROM

Customer s WHERE Sales_Office =

Atlanta

INSERT INTO Atlanta_Customers

SELECT * FROM Customers

WHERE Sales_Office = Atlanta

INSERT INTO Atlanta_Customers SELECTCust_No,

Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers

WHERE Sales_Office = Atlanta

INSERT INTO Atlanta_Customers SELECT Cust_No,

Cust_Name, Sales_Office, Sales_Rep_No FROM Customers

WHERE Sales_Office = Atlanta

No normal form

Second normal form

First normal form

Third normal form

If a parent key is deleted, any child keys referenced by the parent key are automatically deleted.

If any child key references a parent key, the record containing the parent key cannot be deleted.

If a parent key is deleted,all child keys are automatically set to a specified value.

If a parent key is deleted, no test is made for referential integrity.

Employee. Dept_ID

Dept_Mngr

Dept_Name

Department. Dept_ID

1:1

1:N

N:1

M:N

Fat client

Enterprise client

Thin client

Terminal client

S_Date and E_Date

ProjJD

ltem_Num and E_Date

Proj_ID and Item_Num

Lock

Deadlock

Time stamp

Transaction

A set of normalized relations

A reviewed entity-relationship (ER) model

An entity-relationship (ER) model with no redundant data

A set of denormalized relations

The user accesses a database server using a terminal.

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

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

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

File locking

User authorization

Parity checks

Integrity controls

Rollback

Deadlock

Dirty read

No problem has occurred.

Data files are owned and maintained by the users.

Database administration is simplified.

A standard method can be used to access the database.

Data is decentralized.

SELECT Activity FROM Recreation;

SELECT DISTINCT Activity FROM Recreation;

SELECT Activity FROM Recreation

WHERE NOT LIKE Activity;

SELECT Activity FROM Recreation

WHERE DISTINCT Activity;

SELECT*FROM Customers,

Employees WHERE Sales_Rep_No = Cust_No;

SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM

Customers, Employees WHERE Customers.Sales_Rep_No =

Employees.Sales_Rep_No;

SELECT Cust_No, Cust_Name, Emp_Name, Emp_Loc FROM

Customers, Employees WHERE Employees.Sales_Rep_No =

Customers.Sales_Rep_No;

SELECT * FROM Customers, Employees WHERE

Customers.Sales_Rep_No = Employees.Sales_Rep_No;

A normalized set of data applicable to a particular relation

A combination of attributes for a relation

A definition of permissible values for one or more attributes

A set of permissible values for one or more relations

An update anomaly would occur.

An insertion anomaly would occur.

A deletion anomaly would occur.

Both an insertion anomaly and a deletion anomaly would occur.

Provides support for a data manipulation language

Allows users to store data in a distributed data repository

Provides support for data formatting language commands

Translates procedural commands into non-procedural commands

Boyce-Codd normal form

First normal form

Second normal form

Third normal form

Repetition of data, application program flexibility, and data centralization

Incompatibility of files, tabular data structures, and data dependence

Separation of data, repetition of data, and data independence

Application program inflexibility, data dependence, and separation of data

SELECT *FROM

Dept1_Parts

EXCEPT(SELECT

PartJD FROM

Dept2_Parts);

SELECT * FROM

Dept1_Parts MINUS

(SELECT Part_ID

FROM Dept2_Parts);

SELECT*FROM

Dept1_Parts

DIFFERENCE

(SELECT Part_ID

FROM Dept2_Parts);

SELECT*FROM

Dept1_Parts WHERE

Part_ID NOT IN

(SELECT Part_ID FROM

Dept2_Parts);

DELETE * FROM Customers

WHERE Sales_Office = New York;

DELETE FROM Customers WHERE Sales_Office = ew

York?WHERE Sales_Office = ?ew York?

DELETE * FROM Customers WHERE Sales_Office = ew

York?WHERE Sales_Office = ?ew York?

DELETE FROM Customers WHERE Sales_Office NOT LIKE ew York? WHERESales_Office NOT LIKE ?ew York?

Activity_Fee is a determinant of Activity.

Activity_Fee is partially dependent on the key.

The table contains a transitive dependency.

Activity_Fee is a determinant of Activity and Student_ID.

Union

Intersection

Natural join

Cartesian product

Locking

Time stamps

Optimistic

Serialization

Weak

Strong

Foreign

Primary

Flat-file database

Relational database

Distributed database

Object-oriented database

Theft

Privacy

Availability

Confidentiality

1,2,3,4

3,4,1,2

4,3,1,2

4,2,3,1

1NF

1NFand2NF

1NF,2NFand3NF

1NF,2NF,3NFandBCNF