|
Question |
Rating |
View Answer |
 |
What is function overloading?an example of function overloading in oracle? |
|
View Answer |
 |
With SQL, how can you return the number of records in the ‘Persons’ table? a) SELECT COLUMNS (*) FROM Persons b) SELECT COLUMNS () FROM Persons c) SELECT COUNTS () FROM Persons d) SELECT COUNTS (*) FROM Persons |
|
View Answer |
 |
The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; What does this mean? |
|
View Answer |
 |
Name the parts of the database buffer pool. |
|
View Answer |
 |
How many control files are required to create a database? |
|
View Answer |
 |
How many codds rule should oracle satisfies
|
|
View Answer |
 |
What is the prefix for dynamic performance views? |
|
View Answer |
 |
When you issue the command ALTER SYSTEM ENABLE RESTRICTED SESSION, what happens to the users who are connected to the database?
|
|
View Answer |
 |
What is the difference between procedure and stored procedure? |
|
View Answer |
 |
How to get a calender in date field in oracle forms?
|
|
View Answer |
 |
What is the use of INCTYPE option in EXP command ? |
|
View Answer |
 |
You have specified the LOGFILE clause in the CREATE DATABASE command as follows. What happens if the size of the log file redo0101.log, which already exists, is 10MB? |
|
View Answer |
 |
Which command should be issued before you can execute the CREATE DATABASE command? |
|
View Answer |
 |
What is pseudo columns ? Name them? |
|
View Answer |
 |
What is mouse navigate property of button? |
|
View Answer |
 |
What is OCI. What are its uses? |
|
View Answer |
 |
How would you drop a tablespace if the tablespace were not empty? |
|
View Answer |
 |
What is a datafile? |
|
View Answer |
 |
What are Drawback of cursor? |
|
View Answer |
 |
List components of an Oracle instance? |
|
View Answer |