C2090-616 Free Questions – DB2 11.1 Fundamentals for LUW V10.02 – PassQuestion Free Questions To Test Online

1. Which of the following statements about stored procedures is TRUE?

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

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

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

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

2. Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

A ROLLBACK command executed just after the COMMIT command cancels that COMMIT

Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command

It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT

It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed

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

NOT NULL

Foreign key

Primary key

Informational constraint

4. Which edition of DB2 LUW has been discontinued in v11.1?

DB2 Developer Edition

DB2 Express Server Edition

DB2 Enterprise Server Edition

DB2 Connect Enterprise Server Edition

5. Which three facilities are used to control authorization in DB2?

privileges, db2ssh, LBAC credentials

privileges, authority levels, certificates

db2ssh, trusted contexts, authority levels

privileges, authority levels, LBAC credentials

6. What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser

An error is returned

An entry is mane in SYSCAT.TABAUTH

The REVOKE statement succeeds with no effect

All privileges are granted to user MYUSER on MYTABLE

7. Which of the following editions of DB2 include support for Federation with Oracle database?

DB2 Express-C

DB2 Developer Edition

DB2 Enterprise Server Edition

DB2 Workgroup Server Edition

8. You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data size on disk to a minimum is a priority?
Which of the following editions would be best meet the described needs?

DB2 Express-C

DB2 Enterprise Server Edition

DB2 Workgroup Server Edition

DB2 Advanced Enterprise Server Edition

9. Which database object can be locked explicitly?

Row

View

Index

Table

10. Which of the following is TRUE about indexes on column organized tables?

No indexes are allowed

Indexes are only allowed on numeric columns

Indexes are automatically created to enforce unique constraints

An index is only allowed on the synopsis table supporting a column organized table

C2090-616 Free Questions – DB2 11.1 Fundamentals for LUW V10.02

C2090-616 Free Questions – DB2 11.1 Fundamentals for LUW V10.02

Leave a Reply Cancel reply