1D0-441 Exam Questions

What is a relational database?

Consider the following code fragment: 1. PreparedStatement ps = conn.prepareStatement( 2. SELECT * FROM Orders WHERE + 3. Customer_No = ?); 4. 5. ps.setShort(1, 1001) 6. 7. ResultS...

Consider the following code fragment: 1. PreparedStatement ps = conn.prepareStatement( 2. SELECT Order_Date, Customer_No + 3. FROM Orders WHERE + 4. Customer_No = ?); 5. 6. ps.setS...

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

What method for loading a JDBC driver facilitates version updates and is supported by both applications and applets?

Consider the following code fragment: 1. Statement s = conn.createStatement(); 2. conn.setAutoCommit(false); 3. 4. s.executeUpdate(INSERT INTO Orders VALUES (+ 5. 2029, '05-25-03',...

Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an Entity-Relationship diagram?

Consider the following code fragment: 1. Statement s = conn.createStatement(); 2. 3. s.executeUpdate(CREATE TABLE MyTable ( + 4. ColumnA CHAR(5), + 5. ColumnB CHAR(5))); 6. 7. s.ex...

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

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

Consider the three relations shown in the exhibit. Using the Dept1_Parts and Dept2_Parts relations, which of the following relational algebraic expressions would produce the Parts3...

What is a relation?

Consider the following relations shown in the exhibit. Using the Customers Relation, which of the following SQL statements would return the Customers2 Relation?

Consider the following SQL statement: SELECT * FROM Orders WHERE Order_Date > 12/14/01 AND Order_Date <= 02/02/02; Using the Orders Relation shown in the exhibit, what is the outpu...

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

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

Consider the following code fragment: 1. Statement s = conn.createStatement(); 2. conn.setAutoCommit(false); 3. 4. s.executeUpdate(INSERT INTO Orders VALUES (+ 5. 2029, '05-25-03',...

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

Which statement best describes the use of prepared statements with JDBC?

Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?

Which of the following best defines a database?

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

Consider the following code fragment: 1. Statement s = conn.createStatement(); 2. 3. s.executeUpdate(CREATE TABLE MyTable ( + 4. ColumnA CHAR(5), + 5. ColumnB CHAR(5))); 6. 7. s.ex...