Answer Posted / mohan
views must contain data
| Is This Answer Correct ? | 0 Yes | 19 No |
Post New Answer View All Answers
How does Oracle guarantee data integrity of data changes?
What is connection pool in oracle?
How to load data from external tables to regular tables?
What is Library Cache in Oracle?
How do we represent comments in oracle?
what is dynamic SGA and static SGA
How to get a create statement for an existing table?
How to view the data files in the current database?
Give the various exception types.
What is a proxy object?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is data block in Oracle?
How to define a record variable to store a table row?
Explain what are the advantages of views?
Why do you use stored procedures and state some of its disadvantages?