|
Question |
Rating |
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 |