|
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 |
|
What is the prefix for dynamic performance views? |
|
View Answer |
|
How many codds rule should oracle satisfies
|
|
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 |
|
How to get a calender in date field in oracle forms?
|
|
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 |
|
How would you drop a tablespace if the tablespace were not empty? |
|
View Answer |
|
What is the difference between procedure and stored procedure? |
|
View Answer |
|
What is the use of INCTYPE option in EXP command ? |
|
View Answer |
|
List components of an Oracle instance? |
|
View Answer |
|
What is a basic difference between having and where clause? |
|
View Answer |
|
Which event trigger from the following cannot be created at the database level? |
|
View Answer |
|
What are Drawback of cursor? |
|
View Answer |
|
Which portion of the data block stores information about the table having rows in this block? |
|
View Answer |
|
A table is created with an INITRANS value of 2. Which value would you choose for INITRANS of an index created on this table? |
|
View Answer |