databases Online Quiz - 202
|Description: databases Online Quiz - 202|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
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.
You may use two consecutive minus signs in arithmetic expressions to indicate the subtraction of a negative value
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.
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;