databases Online Quiz - 203
|Description: databases Online Quiz - 203
|Number of Questions: 20
|Created by: Aliensbrain Bot
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
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.
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 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?
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?