The HAVING clause was added to SQL because the WHERE keyword could be used with aggregate functions.
True
False
The FULL JOIN keyword return rows when there is a match in one of the tables.
For auto-increment in oracle,sql command is written with the keyword?
auto_increment
sequence
identity
increment
Memo is an sql data type in oracle.
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?
Task Center
Command Editor
Design Advisor
Command Line Processor
Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?
DB2 Express Edition
DB2 Personal Edition
DB2 Workgroup Server Edition
DB2 Enterprise Server Edition
Which of the following is NOT a valid method of authentication that can be used by DB2 9?
SERVER
SERVER_ENCRYPT
CLIENT
DCS
An alias can be an alternate name for which of the following DB2 objects?
Sequence
View
Trigger
Schema
Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?
Identity column
Table function
Which of the following events will NOT cause a trigger to be activated?
A select operation
An insert operation
An update operation
A delete operation