C2090-730 DB2 9 Family Fundamentals Exam (Exam 5)

C2090-730 DB2 9 Family Fundamentals Exam (Exam 5)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • When a client using the SERVER_ENCRYPT authentication type connects to a server us...

  • A programmer wants to generate values for a numeric ID column in their EXPENSE tab...

  • The following SQL statements were executed in sequence:CREATE DISTINCT TYPE salary...

  • Which of the following provides a logical grouping of database objects?

  • Given the following DDL for the PARTS table:CREATE TABLE parts(part_no INT(9) NOT ...

  • Which of the following is a characteristic of a sequence?

  • A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seque...

  • A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq S...

  • An Alias can be an alternate name for which DB2 object?

  • Which of the following objects contains control structures that are considered the...

  • Which of the following commands is used to retrieve database names from the local ...

  • Which of the following are types of routine objects?

  • A stored procedure object is created into which DB2 object?

  • The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY (col1)); ...

  • A number of applications issue the following SQL statement:SELECT d.deptno, e.empn...

  • Given the following statements:CREATE TABLE tab1 (col1 INT);CREATE TABLE tab2 (col...

  • Given the following function:CREATE FUNCTION emplist ()RETURNS TABLE ( id CHAR(6),...

  • Given the following query:SELECT last_name, first_name, age, hire_dateFROM employe...

  • Which of the following will DELETE all of the rows from table T03?

  • Given the following table definitions:EMPLOYEEID NAME DEPTID01 Smith 1002 Bossy 20...

starstarstarstar_borderstar_border
Nov. 29, 2016
review by shiny s (@jyothi)
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    help_outline
    20 questions
    dvr
    2 completed
    remove_red_eye
    11 views
    people
    1 takers
    folder
    IBM

  • C2090-730 DB2 9 Family Fundamentals Exam (Exam 5) QR code

Ratings

starstarstarstar_borderstar_border
ratings