|
Question |
Rating |
View Answer |
|
What is Relational Algebra in case of DBMS? |
|
View Answer |
|
What is Transaction Manager in case of DBMS? |
|
View Answer |
|
What are the options available to refresh snapshots? |
|
View Answer |
|
What is Data Independence? |
|
View Answer |
|
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode? |
|
View Answer |
|
What is a Checkpoint in case of DBMS and When does it occur? |
|
View Answer |
|
Where would you look for errors from the database engine? |
|
View Answer |
|
What is an object group? |
|
View Answer |
|
A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check? |
|
View Answer |
|
What is System Change Number (SCN)? |
|
View Answer |
|
When do you use data parameter type? |
|
View Answer |
|
How will you enforce security using stored procedures? |
|
View Answer |
|
What is Transparent DBMS? |
|
View Answer |
|
What is the use of ANALYZE command? |
|
View Answer |
|
What is system.coordination_operation? |
|
View Answer |
|
You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal? |
|
View Answer |
|
What is database Auditing? |
|
View Answer |
|
What is a difference between pre-select and pre-query? |
|
View Answer |
|
Describe what redo logs are. |
|
View Answer |
|
What is a View? How it is related to Data Independence? |
|
View Answer |