|
Question |
Rating |
View Answer |
|
What are the advantages of DBMS? |
|
View Answer |
|
What are the disadvantage in File Processing System? |
|
View Answer |
|
What is a Database system? |
|
View Answer |
|
What is role transition and when does it happen ? |
|
View Answer |
|
What are the different types of indexes available in Oracle ? |
|
View Answer |
|
Name the architectural components of RMAN ? |
|
View Answer |
|
What is a control file ? |
|
View Answer |
|
List out some major environment variable used in installation ? |
|
View Answer |
|
What are advantages of using SPFILE over PFILE ? |
|
View Answer |
|
What is System Change Number (SCN)? |
|
View Answer |
|
Difference between SGA and PGA ? |
|
View Answer |
|
What are the components of SGA? |
|
View Answer |
|
How can you determine if an index needs to be dropped and rebuilt? |
|
View Answer |
|
A user selects from a sequence and gets back two values, his select is? |
|
View Answer |
|
How can you find out how many users are currently logged into the database? How can you find their operating system id? |
|
View Answer |
|
If you have an example table, what is the best way to get sizing data for the production table implementation? |
|
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 |
|
How can you tell if a database object is invalid? |
|
View Answer |
|
What causes the "snapshot too old" error? How can this be prevented or mitigated? |
|
View Answer |
|
You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not? |
|
View Answer |