True

False

Cursor is a named Private SQL area

Cursor holds temporary results

Cursor is used for retrieving multiple rows

SQL uses implicit Cursors to retrieve rows

Select … into

Update

Create

Delete

Only when it is Committed

Only when it is Rolledback

When it is Committed or Rolledback

None of the above

GRANT

EXIT at pl/sql prompt

Alter command

System crash

Commit before a system crash

True

False

They indicate an optimized execution plan.

They may be able to be tuned to use an index

The full-table scan should be normalized from the database design

A full-table scan is always sub-optimal.

Relational

Hierarchical

Network

What is IDMS

Intergrated Data Management System

India Department of Management Studies

International Data Management System

Integrated Data Management Services

VOLUME

AREA

RECORD

PAGE

AREA

VOLUME

PAGE

RECORD

True

False

CHANGE PASSWORD USER bob OLD bobpass NEW newpass

CONNECT TO sample USER bob USING bobpass NEW newpass

CONNECT TO sample USER bob USING bobpass NEW newpass CONFIRM newpass

No DB2 command can be used to change the password of a user ID

CONTROL

BIND

EXECUTE

BINDADD

SYSCAT.VIEWS

SYSCAT.TABLES

SYSCAT.TABAUTH

SYSCAT.REFERENCES

a table is an ordered set of data records

an index always accesses data in ascending order

a view stores the data on a different tablespace

an index can be used to enforce uniqueness in a table

SYSLOGSPACE

TEMPSPACE1

USERSPACE1

SYSCATSPACE

SKIPSIZE

PREFETCHSIZE

STRIPSIZE

EXTENTSIZE

SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX(salary);

SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id, job_cat;

SELECT dept_id, job_cat, MAX(salary) FROM employees;

SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;

SUM(start_date)

COUNT(start_date)

AVG(start_date, end_date)

MIN(start_date)