Choose the correct statements for creating a table?
Names are case sensitive.
Names must not be oracle server reserve word.
Table names and column names need not be start with a letter.
We cannot use a column alias in a WHERE clause
Table may also called as
Relation
Entity
Records
Fields
The process of modeling data into relational tables is called normalization.
True
False
Which of the following are Data manipulation language commands(DML)?
Select
Insert
Update
Create
Delete
Alter
At what situation you will create Index?
The column contain wide range of values.
The column contain large number of Null values.
The table is large.
Columns which are not frequently used.
Which operation code allows you to update only specified fields on a record?
EXFMT
UPDAT
EXCPT
WRITE
In RPG, how would you reverse the sign of a numeric field?
Z-SUB
MULT -1
0 SUB
all the above
What is the maximum number of files that can be specified in a RPG400 program?
40
60
100
50
What is the value of RESULT after the following process: C Z-ADD3 T 20 C MOVEL'ABCDEF' STRING 10 C 2 SUBSTSTRING:T RESULT 90
CD
BC
DE
EF
CPF4131 message indicates a level check error?