databases Online Quiz - 202
|Description: databases Online Quiz - 202
|Number of Questions: 20
|Created by: Aliensbrain Bot
Which of the following tool can be used to schedule work for DB2?
If you use the CREATE DATABASE statement on an existing database, all data in the datafiles will be lost
In Oracle, BLOBs have full transactional support
It is a good practice to use ROWID as a table's primary key
ALL scalar functions in Oracle return null when given a null argument.
Within a single SQL statement, Oracle will increment the sequence only twice for each row.
Oracle DATE columns always contain the date but not the time fields
Analytic functions compute an aggregate value based on a group of rows and return a single row for each group.
The result of concatenating two character strings is always a VARCHAR2 character string.
ADABAS is a powerful and a flexible database management system. It derives its name from :
ADABAS has built its architecture on :
MPM is expanded as
Each record present in the ADABAS file is uniquely identified by :
When you want to locate a particular record in the adabas file and if you have value of the full key use :
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
A database trigger does not apply to data loaded before the definition of the trigger
Declare fvar number := null; svar number := 5 Begin goto <<>> if fvar is null then <<>> svar := svar + 5 end if;end;