|
Question |
Rating |
View Answer |
|
List out some major environment variable used in installation ? |
|
View Answer |
|
What is Distributed database? |
|
View Answer |
|
What is an Index? How it is implemented in Oracle Database? |
|
View Answer |
|
What are Stored Procedures, in case of DBMS? And what are the advantages of using them? |
|
View Answer |
|
Explain materialized views and how they are used? |
|
View Answer |
|
What is meant by Proactive, Retroactive and Simultaneous Update, in case of DBMS? |
|
View Answer |
|
If the DEFAULT and TEMPORARY tablespace clauses are left out of a CREATE USER command what happens? Is this bad or good? Why? |
|
View Answer |
|
How do you communicate with an RDBMS? |
|
View Answer |
|
When should more than one DB writer process be used? How many should be used? |
|
View Answer |
|
What is a control file ? |
|
View Answer |
|
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE. |
|
View Answer |
|
What is role transition and when does it happen ? |
|
View Answer |
|
Describe the three levels of Data Abstraction? |
|
View Answer |
|
What are the Primitive Operations, common to all record management systems? |
|
View Answer |
|
What are the built-ins that are used for setting the LOV properties at runtime? |
|
View Answer |
|
Define the Integrity Rules? |
|
View Answer |
|
What are the different types of indexes available in Oracle ? |
|
View Answer |
|
What are the database administrators utilities available? |
|
View Answer |
|
What are Partial, Alternate, Artificial, Compound and Natural Key in case of DBMS? |
|
View Answer |
|
What is Data Storage - Definition Language? |
|
View Answer |