1D0-441 Exam Questions

Which code segment instantiates a Statement object that can be used to create a scrollable result set?

Which of the following statements is true of JDBC URLs?

What is a domain?

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 statement best describes a procedural data manipulation language command?

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

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

Which statement is true with respect to transactions and JDBC?

What does a JDBC URL identify?

Which of the following statements is true of a Pure Java driver?

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

Which statement is true with respect to prepared statements and JDBC?

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 of the following definitions best describes an atomic value?

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

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

Consider the following code segment: 1. ResultSet rs = s.executeQuery(SELECT Student_ID, Activity + 2. FROM Activities + 3. WHERE Fee >0); 4. 5. while(rs.next()) { 6. String s_num...

What is a relational database domain?

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

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

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

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

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

Consider the following SQL statement: SELECT * FROM Orders WHERE NOT Amount < 1000 AND Sales_Rep_No = 210; Using the Orders Relation shown in the exhibit, what is the output of thi...

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 Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?

Which method of the SQLException class returns an X/OPEN SQLState error code?

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

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

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

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

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

Which characteristic is an advantage of a database management system?

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

Which statement best describes database metadata extraction using result sets?

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

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

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

Consider the code fragment shown in the exhibit. 1. PreparedStatement ps = conn.prepareStatement 2. (INSERT INTO Orders VALUES (?, ?, ?, ?, ?)); 3. 4. ps.setInt(1, 3000); 5. ps.set...

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

Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?

Consider the Stu_Act and Act_Fee relations shown in the exhibit. Which SQL statement would return the Activity Relation shown in the exhibit?

Which static member of the ResultSet class should be used to create a non-updatable scrollable result set?

Which of the following best describes the two-tier database architecture?

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 following code fragment: 1. Statement s = conn.createStatement(); 2. ResultSet rs = s.executeQuery(SELECT * FROM Orders + 3. WHERE Order_Date = '02-22-02'); 4. while(r...

What is the purpose of the JDBC SQLException class?

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

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

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