You are developing some code to handle transaction processing. Which signifies the beginning of a new transaction ?
set transaction
Opening a new session
commit
savepoint
An object in Oracle contains many columns, The object requires segments to be stored in areas of the database other than the data dictionary ?
Sequence
View
Synonym
Table
Which datatype you use to store a large block of text data having size around 3,500 characters in length ?
CLOB
BLOB
BFILE
VARCHAR2
Which of the following are transactional control commands? A.COMMIT B.UPDATE C.SAVEPOINT D.SET TRANSACTIONS
COMMIT
UPDATE
SAVEPOINT
SET TRANSACTIONS
The scale of a numeric value is the total length allowed for values.
True
False
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.