|
Question |
Rating |
View Answer |
|
What is SYSTEM tablespace and when is it Created? |
|
View Answer |
|
Describe the different type of Integrity Constraints supported by ORACLE ? |
|
View Answer |
|
What is a Data Dictionary ? |
|
View Answer |
|
What does a Control file Contain ? |
|
View Answer |
|
What is the use of Redo Log Information ? |
|
View Answer |
|
What is the function of Redo Log ? |
|
View Answer |
|
what is the differnece between materialized view and snapshot |
|
View Answer |
|
What is the diff b/w BTREE INDEX and BITMAP INDEX |
|
View Answer |
|
What are the Large object types supported by Oracle? |
|
View Answer |
|
What are the Characteristics of Data Files |
|
View Answer |
|
what is the difference between SID and Global Database Name ? |
|
View Answer |
|
Explain in brief oracle database objects. |
|
View Answer |
|
SGA definition files |
|
View Answer |
|
Explain the types of data files used by the oracle RDBMS. |
|
View Answer |
|
Explain the areas of memory used by oracle, i.e. Software code area, system global area (SGA), program global area(PGA), sort area. |
|
View Answer |
|
What are the Back ground processes in Oracle? |
|
View Answer |
|
Explain the categories of oracle processes i.e. user, data writing processes, logging processes and monitoring processes. |
|
View Answer |
|
Physical database structure |
|
View Answer |
|
What is the physical and logical structure of oracle? |
|
View Answer |
|
Explain the methods provided by SQL Loader. |
|
View Answer |