1D0-541 Practice Exam Questions and Answers

A.  

Views

B.  

Concurrency

C.  

Locking

D.  

Integrity controls

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.

A.  

Parallelism

B.  

Serialization

C.  

Database control

D.  

Concurrency control

A.  

Customer X Sales_Rep

B.  

(Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No (Sales_Rep X Customer))

C.  

(Customer X Sales_Rep) л Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No

D.  

Customer.Sales_Rep_No = Sales.sales_Rep_No (Customer X Sales_Rep)

A.  

Thin client

B.  

Fat client

C.  

Database server

D.  

Application server

A.  

Locking

B.  

Time stamps

C.  

Optimistic

D.  

Serialization

A.  

SELECT Activity FROM Recreation;

B.  

SELECT DISTINCT Activity FROM Recreation;

C.  

SELECT Activity FROM Recreation

WHERE NOT LIKE Activity;

D.  

SELECT Activity FROM Recreation

WHERE DISTINCT Activity;

A.  

UPDATE Recreation SET Activity,

Activity_Fee (‘Tennis’,100) WHERE

Student_ID = 1003;

B.  

UPDATE TABLE Recreation ALTER COLUMN ACTIVITY

SET ACTIVITY =‘Tennis', Activity_Fee = 100 WHERE

Student__ID = 1003 AND Activity = wimming?AND Activity=

?wimming?

C.  

UPDATE Recreation SET Activity =

‘Tennis', Activity_Fee = 100 WHERE

Student_ID = 1003 AND Activity =

'Swimming';

D.  

DELETE Activity FROM

Recreation WHERE

Student_ID = 1003; INSERT

INTO Recreation VALUES (1003,‘Tennis', 100);

A.  

SELECT *

FROM Dept1_Parts

AND

(SELECT *

FROM Dept2_Parts);

B.  

SELECT *

FROM Dept1_Parts

INTERSECTION

(SELECT *

FROM Dept2_Parts);

C.  

SELECT *

FROM Dept1_Parts

WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

D.  

SELECT *

FROM Dept1_Parts

WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

A.  

S_Date and E_Date

B.  

ProjJD

C.  

ltem_Num and E_Date

D.  

Proj_ID and Item_Num

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

A.  

1:1

B.  

1:N

C.  

N:1

D.  

M:N

A.  

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

B.  

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

C.  

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

D.  

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

A.  

Logical

B.  

Physical

C.  

Conceptual

D.  

Implementation

A.  

The process of reducing the cardinality of a relation

B.  

The process of organizing and refining relations

C.  

The process of duplicating data to reduce the number of tables

D.  

The process of limiting data stored in a table to a specific range of values

A.  

Data Control Language

B.  

Data Definition Language

C.  

Data Formatting Language

D.  

Data Manipulation Language

A.  

1NF

B.  

1NFand2NF

C.  

1NF,2NFand3NF

D.  

1NF,2NF,3NFandBCNF

A.  

SELECT Course_Code

FROM Registration;

B.  

SELECT*FROM

Registration WHERE

Registration_ID = 1003 AND

Registration_ID = 1005;

C.  

SELECT*FROM Registration

WHERE Course_Code =‘A4343';

D.  

SELECT Registration_ID, Student_ID, First_Name, Last_Name