|
Question |
Rating |
View Answer |
|
Describe the different type of Integrity Constraints supported by ORACLE ? |
|
View Answer |
|
Explain in brief oracle database objects. |
|
View Answer |
|
What are the Characteristics of Data Files |
|
View Answer |
|
Describe Oracle architecture in brief. |
|
View Answer |
|
What are the Large object types supported by Oracle? |
|
View Answer |
|
what is the differnece between materialized view and snapshot |
|
View Answer |
|
what is the difference between SID and Global Database Name ? |
|
View Answer |
|
Physical database structure |
|
View Answer |
|
What is SQL Loader? Explain the files used by SQL Loader to load file. i.e Loader control file, Input datafile, Log File, Bad File, Discard file |
|
View Answer |
|
Explain different types of segment. Data segment, Index segment, Rollback segment and temporary segment. |
|
View Answer |
|
What is the physical and logical structure of oracle? |
|
View Answer |
|
What are the Large object types supported by Oracle?
|
|
View Answer |
|
Explain the types of data files used by the oracle RDBMS. |
|
View Answer |
|
What is the function of SMON? |
|
View Answer |
|
SGA definition files |
|
View Answer |
|
What is SYSTEM tablespace and when is it Created? |
|
View Answer |
|
Explain SGA memory structures: Shared Pool, Database buffer Cache, Redo log Cache, Large Pool Java Pool. |
|
View Answer |
|
What is a Data Dictionary ? |
|
View Answer |
|
Explain the categories of oracle processes i.e. user, data writing processes, logging processes and monitoring processes. |
|
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 |