|
Related Questions |
View Answer |
|
What are dedicated and shared server process ?
|
View Answer
|
|
What are the data structures does SGA contains ?
|
View Answer
|
|
Explain briefly oracle instance memory structure?
|
View Answer
|
|
What are materialized views?
|
View Answer
|
|
What is an oracle schema?
|
View Answer
|
|
What are the computing components of oracle grid?
|
View Answer
|
|
What is difference between Cartesian Join and Cross Join ?
|
View Answer
|
|
What are the different Oracle Database objects?
|
View Answer
|
|
Difference between varchar and varchar2 data types ?
|
View Answer
|
|
What is difference between Cartesian Join and Cross Join?
|
View Answer
|
|
What are the various constraints used in Oracle ?
|
View Answer
|
|
What are the attributes of Cursor?
|
View Answer
|
|
What are temporal data types in Oracle ?
|
View Answer
|
|
What is a sub query and what are the different types of subqueries?
|
View Answer
|
|
What is the use of Aggregate functions in Oracle?
|
View Answer
|
|
What is USING Clause and give example?
|
View Answer
|
|
What is BLOB datatype?
|
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
|
|
What is difference between using cursor variable(Ref cursor) and collections(like record with associative array)
|
View Answer
|
|
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each?
|
View Answer
|