1D0-541 Exam Questions

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

Your company must choose which type of database to use for a new project. Which of the following lists three characteristics of file-based database systems?

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

Which statement best describes a procedural data manipulation language command?

Consider the following database information: domain s_id: integer domain grd: fixed length character string length 1 STUDENT_GRADE( Student_Number: s_id NOT NULL Grade: grd ) Prima...

Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the Recreation relation that will return the following data: Which SQL statement applied...

In a relational database, which term describes a single table consisting of rows and columns?

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

Which statement best describes a candidate key?

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

Which security technique limits access by unauthorized users to parts of an enterprise database?

Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?

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

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

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

Consider the relational database shown in the exhibit. What is the foreign key in this database?

Which term best defines a database system in which data records are stored with no structured relationships between the records?

Which of the following definitions best describes an atomic value?

Which database security technique prevents invalid data from being entered into the database?

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

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

The exhibit shows a table called Housing Relation. This table relates a unique student identification number with a dormitory building and a room fee for that building. The key for...

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

Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

What is a virtual table?

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest va...

Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase?

Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation...

Which statement accurately describes a characteristic of attributes?

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

What is a data dictionary?

Consider the Information Engineering diagram shown in the exhibit. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and Res_Name are all...

Which concurrency control method should be used only when conflicts between transactions rarely occur?

Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

What is a domain?

Consider the following relational algebraic expression: Which of the following SQL statements is equivalent to this relational algebraic expression?

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

Which subset of Structured Query Language (SQL) is used to perform operations such as data retrieval or deletion on the data contained in a database?

Which type of entity must reference another entity for its data to be meaningful?

The creation of intermediate entities occurs during the logical database design phase for an enterprise. It is used to resolve which types of relationships?

Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports activity and a fee for participating in that activity. A studen...

Which of the following definitions best describes an entity?

Which subset of Structured Query Language (SQL) is used to create and name database entities?

Which mechanism provides database users with controlled access to the database through the use of virtual tables?

Which relational algebraic operation is used to select specific columns (attributes) from a relation?

Which type of dependency occurs when one attribute of a composite primary key is removed and the dependency still exists?

Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known as Group_2, previously had f...

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

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