Placement papers on Oracle - Set 6

Placement papers on Oracle - Set 6

1. Following SQL clauses supported in the link property sheet ?

WHERE and START WITH
WHERE and HAVING
WHERE, START WITH and HAVING
START WITH and HAVING
View Answer / Hide Answer


2. Built_in procedure is used to get IMAGES in Forms 4.5 is ___________________

READ_FILE
READ_IMAGE_FILE
GET_FILE
GET_IMAGE_FILE
View Answer / Hide Answer


3. Find Odd one of the following statements ?

Poplist
List of values
Combo box
Tlist
View Answer / Hide Answer


4. COMMENT statements within SQL statements ___________________

Asterisk(*) in column ?
ANSI SQL style statements(?)
C-Style comments (/*??*/)
All the above
View Answer / Hide Answer


5. By using the _______ , time for insert increases.

Index
Cluster
Control file
Data file
View Answer / Hide Answer


6. What is maximum count of columns a table can have?

64
256
255
254
View Answer / Hide Answer


7. “Views are automatically updated when base tables are updated”

True
False
View Answer / Hide Answer


8. ”Trigger can also be written for the view”

True
False
View Answer / Hide Answer