Question 1

What improvement can be made to file-based databases to overcome their limitations?

Options :

A : Implement a tabular structure.

B : Gather files in a distributed repository

C : Use a hierarchical database file system.

D : Tightly couple database structure to database application programs.

Answer: A

Question 2

Which area of database security involves maintaining access to enterprise data?

Options :

A : Theft

B : Privacy

C : Availability

D : Confidentiality

Answer: C

Question 3

Consider the following relational algebraic expression as well as the Employee and Department relations shown in the exhibit: Which of the following relations would result from the given relational algebraic expression?

Options :

A :

B :

C :

D :

Answer: D

Question 4

Consider the relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

Options :

A : SELECT * FROM Customers WHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta

B : SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta

C : SELECT * FROM Customers WHERE Satisfaction_Rate >= 80;

D : SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND NOT Sales Office = Atlanta

Answer: A

Question 5

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

Options :

A : CREATE

B : CREATE TABLE

C : CREATE DOMAIN

D : CREATE SCHEMA

Answer: D

Free 1D0-541 Mock Exam – Practice Online Confidently

Buying Options: