Sample Test

Below is a sample test that has questions very similar to those on the actual 514 exam.

1:Given that the message "QUALIFY.X" is an undefined name is returned during a precompile, which of the following is true for QUALIFY.X?

  1. It is defined as a database object.

  2. It is defined as an “undefined” name.

  3. It is not defined as a host variable in the program.

  4. It is not defined as a database object in the database.

A1: D
2:Given a table created using the statement CREATE TABLE abc.stuff (i INT), a user called XYZ is to be enabled to access data from table ABC.STUFF using an implicit schema. Assuming the necessary privileges have been granted, which of the following statements issued by user ABC will provide this result?

  1. CREATE ALIAS xyz.stuff FOR ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial