Tag: databases

The HAVING clause was added to SQL because the WHERE keyword could be used with aggregate functions.

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?

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?

Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?

Which of the following is NOT a valid method of authentication that can be used by DB2 9?

An alias can be an alternate name for which of the following DB2 objects?

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

Which of the following events will NOT cause a trigger to be activated?