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.

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

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?

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

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

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?