Tag: databases

You are developing some code to handle transaction processing. Which signifies the beginning of a new transaction ?

An object in Oracle contains many columns, The object requires segments to be stored in areas of the database other than the data dictionary ?

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.