Which datatype you use to store a large block of text data having size around 3,500 characters in length ?

Which of the following are transactional control commands? A.COMMIT B.UPDATE C.SAVEPOINT D.SET TRANSACTIONS

The scale of a numeric value is the total length allowed for values.

Having no duplicate or redundant data in a database and having everything in the database normalized is always the best way to go.

If you have committed several transactions and have several more transactions that have not been committed and you issue a rollback command, all your transactions for the same session will be undone.

A SAVEPOINT actually saves transactions after a specified amount of transactions have executed.

The AVG function returns an average of all rows from a select column including any NULL values.

You must also use the GROUP BY clause whenever using the HAVING clause.

The HAVING clause tells the GROUP BY which groups to include.

The main reason for a composite index is for aggregate function usage in an index.

What type of join would you use to return records from one table, regardless of the existence of associated records in the related table?

Which of the following statements about roles are true?

Which of the following dictionary views gives information about the position of a column in a primary key?

Which of the following is the transaction control that prevents more than one user from updating data in a table?

Which of the following methods should you use to increase the number of nullable columns for a table?

Once defined, how long will a variable remain defined in SQL*Plus?

Which of the following product will not accept remote database request?

Which of the following does DB2 Configuration Advisor recommend?

What is the prefix key for executing an OS command in the DB2 CLP?

Which of the following tool allows you to display data of a table?