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.

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?

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