CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

IBM Analytics: Platform Analytics C2090-616 Syllabus Exam Questions Answers

Page: 2 / 2
Total 63 questions
Get C2090-616 Full Access Download C2090-616 PDF

DB2 11.1 Fundamentals for LUW Questions and Answers

Question 5

The DDL statement is used to create table T1:

CREATE TABLEt1 (

c1 INTEGER,

c2 INTEGER NOT NULL,

c1 DECIMAL(11,2),

c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP

)

Which of the following INSERT statements will execute successfully?

Options:

A.

INSERT INTO t1 VALUES (100)

B.

INSERT INTO t1 (c1, c2) VALUES (100)

C.

INSERT INTO t1 (c1, c3) VALUES (‘100’, ‘100.00’)

D.

INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)

Question 6

Which three facilities are used to control authorization in DB2?

Options:

A.

privileges, db2ssh, LBAC credentials

B.

privileges, authority levels, certificates

C.

db2ssh, trusted contexts, authority levels

D.

privileges, authority levels, LBAC credentials

Question 7

Which of the following statements about stored procedures is TRUE?

Options:

A.

Stored procedures can be written in SQL PL, but not in the PL/SQL dialect

B.

The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database

C.

There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures

D.

Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

Question 8

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

Options:

A.

NOT NULL

B.

Foreign key

C.

Primary key

D.

Informational constraint

Page: 2 / 2
Total 63 questions
Get C2090-616 Full Access Download C2090-616 PDF