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