1D0-441 Exam Questions

A foreign key maps to a:

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

Which pair of relational algebraic operations requires union compatibility?

Which static member of the ResultSet class should be used to create an updatable result set?

Which method of the Statement interface could be used to delete data from a database?

Which JDBC interface is used to extract information about the database schema?

Consider the Entity-Relation 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 relat...

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

Consider the following domain description: domain Student_ID: integer domain Grade: fixed length character string length 1 To meet business needs, you must add enterprise constrain...

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

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

Consider the following SQL statement: SELECT * FROM Orders WHERE Order_Date LIKE %02 ORDER BY Sales_Rep_No, Amount DESC; Using the Orders Relation shown in the exhibit, which of th...

Consider the following stored procedure: CREATE PROCEDURE showFees AS SELECT Fee FROM ACTIVITY WHERE Fee > 0 Which Java code segment will correctly utilize this stored procedure?

Which Statement interface methods are used to execute a SQL select query?

What is the purpose of the batch update feature in JDBC 2.0?

With regard to databases, what is normalization?

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

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

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

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

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

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

A government agency provides driving licenses for various types of motor vehicles. A requirement for a particular license may be possession of another type of motor vehicle license...

Consider the Project relation shown in the exhibit. Also consider the following SQL statement: DELETE FROM Project WHERE Cust_Name = Acme; Which of the following tables shows the P...

Consider the following relation definitions: domain s_id: integer domain grd: fixed length character string length 1 STUDENT_GRADE( Student_Number: s_id Grade: grd ) Primary Key St...

Which statement represents a valid batch update command?

Which of the transaction ACID properties are violated when lost updates occur?

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?

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

Which JDBC driver solution is most likely to complicate deployment and compatibility?

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

Which of the following statements is true of JDBC URLs?

Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?

Which method of the SQLException class returns a vendor-specific error code?

What is a virtual table?

Which of the following best describes a composite key?

Consider the following statement: CREATE DOMAIN COUNT AS INTEGER CHECK (COUNT <= 600 And COUNT > -1); The CHECK clause in this statement is an application of what?

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

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: Bowling Racquetball Handbal...

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 relations shown in the exhibit. Which of the following SQL statements would input data from the Customers relation into the Atlanta_Customers relation?

Assuming that conn references a valid and open connection to the database, which code segment will insert values into the Employees relation?

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

Consider the following code fragment: 1. PreparedStatement ps = conn.prepareStatement 2. (INSERT INTO Orders VALUES (?, ?, ?, ?, ?)); 3. 4. ps.setInt(1, 4000); 5. ps.setString(2, 0...

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

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

Consider the following information that describes a database: domain s_id: integer domain grd: fixed length character string length 1 STUDENT_GRADE( Student_Number: s_id NOT NULL G...

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

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 type of relational integrity is violated if a primary key in a database has a null value?