DB2 11.1 Fundamentals for LUW Free Sample Questions

NOT NULL

Foreign key

Primary key

Informational constraint

Cloudant

DB2 on Cloud

dashDB for analytics

dashDB for transactions

DB2HADR

DB2 pureScale

DB2 Express-C

DS2 Database Partitioning Feature

Easy scalability

Management of very large data sets

Continuously available dataset solution

Increased throughput of many concurrent short running queries

Faster response time of long-running or complex queries with I/O spread across many computers

it ranks the rows in each WORKDEPT by SALARY

it groups all rows by WORKDEPT, then ranks all rows in the complete result set by SALARY

it generates a blank output line after each group of rows with the same WORKDEPT, and ranks these groups by SALARY

it tells the optimizer to physically partition the EMPLOYEE table by the WORKDEPT column for runtime execution, and ranks each WORKDEPT by SALARY

SQLADM

CONNECT

DATAACESS

ACCESSCTRL

Direct Standard Edition

Enterprise Server Edition

Workgroup Server Edition

DB2 Direct Advanced Edition

Advanced Enterprise Server Edition

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

DBADM

SYSADM

SECADM

SYSCTRL

SYSMAINT

COMMIT

SAVEPOINT

ROLLBACK WORK

UPDATE TERMINATE