1D0-541 Exam Questions

A foreign key maps to a:

What is a candidate key?

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

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

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?

Which of the following statements is true of the Connection interface?

With regard to databases, what is normalization?

Which statement represents a valid batch update command?

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

Which method of the ResultSet class should be used to extract data of SQL data types CHAR and VARCHAR?

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 method of the SQLException class returns a vendor-specific error code?

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?

Which of the following best defines a database?

What is a relation?

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