Analytic functions compute an aggregate value based on a group of rows and return a single row for each group.
True
False
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 :
Adjusting DAta BAse System
Adaptable DAta BAse System
Altering DAta BAse System
Amending DAta BAse System
ADABAS has built its architecture on :
Inverted List Model
Relational Model
Hierarchical Model
Object Oriented Model
MPM is expanded as
Multi Processing Mode
Mega Processing Monitor
Multi Processing Monitor
Mega Processing Mode
Each record present in the ADABAS file is uniquely identified by :
RABN
ISN
FIN
MIN
When you want to locate a particular record in the adabas file and if you have value of the full key use :
READ
FIND
GET
PUT
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
Primary key access
Access via unique index
Table access by ROWID
Full table scan