1D0-541 Online Practice Questions and Answers

Your enterprise has created a database and database application. The testing phase for the project has started. Which of the following best describes white-box testing of the projects software?

A. The database designer tests the software because he or she is able to make necessary changes to the underlying code for the software.

B. A user who has no knowledge of the softwares underlying code tests the software.

C. Someone other than the database designer tests the software. This person has no access to the underlying code and attempts to use the software only in ways not considered by the software designers.

D. A person tests the software and submits suggestions to the software's underlying code. This person is someone other than the database designer, but has access to the softwares underlying code.

Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

A. Durability

B. Consistency

C. Isolation

D. Atomicity

Which of the following definitions best describes an entity?

A. A single relation

B. Data about data

C. Data stored in a table column

D. An item about which information is stored

Which of the following is a characteristic of the three-tier database architecture?

A. A Web browser is used as the application server.

B. The application logic is centralized on a dedicated server.

C. A thick client is used to perform business application logic functions locally.

D. Database application logic and database functionality are integrated and reside on a common server.

Which component in the three-tier database architecture handles the data-processing and business logic?

A. Thin client

B. Fat client

C. Database server

D. Application server

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

A. SELECT * FROM Customers WHERE Satisfaction_Rate <= 80 OR Satisfaction_Rate >= 90;

B. SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);

C. SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89;

D. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);

The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task?

A. GRANT UPDATE ON Project TO Rubio, Doe; GRANT SELECT ON Project TO Temp;

B. GRANT ALL PRIVILEGES ON Project TO Rubio, Doe; GRANT UPDATE ON Project TO Temp;

C. GRANT SELECT ON Project WHERE Manager = 'Rubio'; GRANT SELECT ON Project WHERE Manager = 'Doe';

D. GRANT UPDATE ON Project WHERE Manager = 'Rubio'; GRANT UPDATE ON Project WHERE Manager = 'Doe'; GRANT SELECT ON Project TO Temp;

A theta-join can be viewed as:

A. the intersection of two relations.

B. a Cartesian product of two relations.

C. a restricted Cartesian product of two relations.

D. the Cartesian product of two union-compatible relations.

To create a view, what are the minimal privileges that a user must have for the relations used to make the view?

A. GRANT

B. REVOKE

C. SELECT

D. CREATE VIEW

Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram?

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( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num

Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement?

A. B. C. D.

Which of the following describes two desirable characteristics of a primary key?

A. A primary key should be a value that may be null and may change over time.

B. A primary key should be a value that is not null and will never change.

C. A primary key should consist of meaningful data and a value that can be changed if needed.

D. A primary key should not consist of meaningful data and a value that can be changed if needed.

Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement?

A. B. C. D.

Which of the following best describes a composite key?

A. A composite key is a primary key and foreign 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 key attributes.

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.

Which term best describes one or more database operations that are executed as a single unit?

A. Update

B. Transaction

C. Procedure

D. Singleton