1D0-541 Free Practice Test

Consider the Project relation shown in the exhibit as well as the following SQL statement:

DELETE FROM Project WHERE Cust_Name = Acme;
Which of the following tables shows the Project relation after execution of this SQL statement?

1. A.
2. B.
3. C.
4. D.

Correct Answer: A

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?

1. A. SELECT Course_Code FROM Registration;
2. B. SELECT *FROM RegistrationWHERE Registration_ID = 1003 AND Registration_ID = 1005;
3. C. SELECT *FROM RegistrationWHERE Course_Code = 'A4343';
4. D. SELECT Registration_ID, Student_ID, First_Name, Last_Name FROM RegistrationWHERE Course_Code = 'A4343';

Correct Answer: C

Which of the following definitions applies to all types of databases?

1. A. Data that is stored as tables
2. B. Software that manipulates data
3. C. Data that is stored in a structured manner
4. D. Data records that are stored sequentially in a file

Correct Answer: C