databases Online Quiz - 202
Description: databases Online Quiz - 202 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
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
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.
Analytic functions compute an aggregate value based on a group of rows and return a single row for each group.
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.
You use comments in a SQL statement to pass hints to the Oracle optimizer
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
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;