QUESTION: 21

You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?

REAL
BIGINT
DECIMAL
INTEGER

Answer(s): C

Reference:

https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.sql.ref.doc/ doc/r0000791.html

Reveal Solution Next Question

QUESTION: 22

Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

GRANT, COPY, BIND, RUN
BIND, EXECUTE, COPY, RUN
CREATE, COPY, RUN, EXECUTE
COPY, BINDADD, SQL, EXECUTE

Answer(s): B

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_grantpackageprivileges.html

Reveal Solution Next Question

QUESTION: 23

Which of the following can activate a trigger?

A row is inserted
A table or view is created
A check constraint is defined
A referential constraint is violated

Answer(s): D

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/db2z_triggers.html

Reveal Solution Next Question

QUESTION: 24

In which address space would a native SQL stored procedure run?

WLM
DIST
DBM1
The address space of the calling program

Answer(s): C

Reference:

http://www.ibmbigdatahub.com/blog/db2-native-sql-procedures-future-computing

Reveal Solution Next Question

Free C2090-320 Exam Braindumps (page: 7)

QUESTION: 21

Reference:

QUESTION: 22

Reference:

QUESTION: 23

Reference:

QUESTION: 24

Reference:

C2090-320 Exam Discussions & Posts