The user had to have knowledge of the table and index structures

Navigational data access was far slower than declarative access

Navigational access languages required the coder to embed their queries inside a procedural language shell

Navigational languages were far slower then SQL

SQL cannot support object-orientation

The same query can be written in many ways, each with vastly different execution plans

SQL syntax is too difficult for non-computer professionals to use

SQL creates excessive locks within the database

Independence of table relationships

High speed of SQL

Powerful GUI front-end

Easy to install and use

The number of CPUs on the server

The degree of parallelism on the tables

The use of bitmap indexes

The quality of the SQL optimization

Removal of data redundancy

The introduction of data redundancy

The introduction of non-first normal form relations

The introduction of SQL*Plus

A sequence will never generate duplicate values. b.The MAXVALUE of a sequence can be equal to the MINVALUE. c.It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero.

The MAXVALUE of a sequence can be equal to the MINVALUE

It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero.

When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries.

DBCLOB

GRAPHIC

VARCHAR

VARGRAPHIC

ON DELETE RESTRICT

ON DELETE NO ACTION

ON DELETE SET NO VALUE

ON DELETE CASCADE

Index

Check constraint

Referential constraint

Default constraint

Execute the LIST REMOTE DATABASES command on the server; look for an entry for the TEST_DB database

. Execute the LIST DCS DIRECTORY command on the server; look for an entry for the TEST_DB database

Execute the LIST REMOTE DATABASES command on the client; look for an entry for the TEST_DB database

Execute the LIST DCS DIRECTORY command on the client; look for an entry for the TEST_DB database

An error will occur

Data passed between the client and the server is encrypted.

User IDs and passwords are passed to the server unencrypted

User IDs and passwords are encrypted before they are passed to the server.

ID | EMPSALARY 10 | 60000 20 | 50000.00

ID | EMPSALARY 10 | 50000.00 20 | 50000.00

ID | EMPSALARY 10 | 60000.00 20 | 60000.00

.ID | EMPSALARY 10 | 60000.00 20 | 50000.00

View

Table

Schema

Buffer pool

UDT

Trigger

Package

Access plan

LIST DB DIRECTORY

LIST DCS DIRECTORY

LIST NODE DIRECTORY

LIST ACTIVE DATABASES

Package and function

Function and userexit

Procedure and package

Function and procedure

No size is specified

The buffer pool size

The page size for the table space

The extent size for the table space

The next value will be 0 and the sequence will never use the values 101 to 105.

The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.

Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.

The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

After a ROLLBACK is issued

.After the sequence is altered

After the sequence is dropped

After the current session ends

Instance

Table space

System catalog

Schema repository