1D0-541 Exam Questions

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

What is the highest normal form of the relation(s) shown in the exhibit?

What is the highest normal form of the relation(s) shown in the exhibit?

The exhibit shows a relation for a companys projects. Which candidate key(s) would best serve as the primary key for this relation?

For the Employee relation shown in the exhibit, which set of column values holds the complete tuple for the employee named James Smith?

Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called Emp_Dept that allows users to find employees and their department ID numbers....

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

Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted...

Your enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

What is the most important service provided by a database management system?

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create an intersection of the two relations with the widest var...

Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

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 proje...

Consider the table for an employee database shown in the exhibit. What is the degree of the table?

Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers?

Which term describes the management of simultaneous transactions to prevent conflicts?

Your enterprise is developing a database system that will contain highly sensitive data. Security of the data will take priority over database processing speed. Which database prot...

Consider the following SQL statement and the Orders relation shown in the exhibit: How many records should be returned?

Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to...

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 da...

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an entity-relationship (ER) diagram?

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 10...

A theta-join can be viewed as:

In which situation would the DBMS use a serial schedule to execute the transactions?

Which of the following best describes the ON DELETE CASCADE referential integrity constraint?

Your enterprise must decide whether to use a database management system. Which of the following best describes the overall functionality of a DBMS?

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

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...

Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activit...

Consider the following four database design activities: 1 - Design user views. 2 - Select a DBMS. 3 - Apply normalization. 4 - Determine entities. Which choice shows the correct or...

Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes the diagram shown...

The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all rec...

Which of the following occurs in a relation when records are added or removed?

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

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

Which process is used to prevent the current database operation from reading or writing a data item while that data item is being accessed by another operation?

Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model...

Which of the following best describes the information contained in the data dictionary (or system catalog)?

Consider the following relation definitions: STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 ) Primary Key Student_Number HOUSING( Housin...

Consider the following relation definition: STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number HOUSING(...

Which characteristic is an advantage of a database management system?

Which of the following best describes a composite key?

A relation for a construction company is shown in the exhibit. Which of the following best defines the relationship between Cust_ID and Cust_Name?

Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?

A large enterprise uses a two-tier database architecture and runs complex database processing on the client. Which term best describes the client in this system?

Consider the table shown in the exhibit. Which relational algebraic operation would return Row 3?

Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID...

Which of the following best describes the ON DELETE NO ACTION referential integrity constraint?