Logo 
Search:

Interview FAQs

Submit Interview FAQ
Home » Interview FAQsRSS Feeds
Oracle
Comments: 0

What types of information are stored in the data dictionary?

Database design, user statistics, processes, objects, growth of objects, performance statistics, stored SQL code, database security.
Posted By:Shruti Sharma      Posted On: Dec 21

Oracle
Comments: 0

How can you use performance statistics?

Performance statistics suggest ways to improve database performance by modifying database parameters and streamlining SQL, which may also include the use of indexes and an evaluation of their efficiency.
Posted By:Shruti Sharma      Posted On: Dec 21

Oracle
Comments: 0

What are some database objects?

Tables, indexes, synonyms, clusters, views.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

What are some common hindrances of general performance?

Common performance pitfalls include

- Insufficient shared memory
- Limited number of available disk drives
- Improper usage of available disk drives
- Running large batch loads that are unscheduled
- Failing to commit or rollback transacti...
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

What happens during a full-table scan?

A table is read row by row instead of using an index that points to specific rows.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

How can you avoid a full-table scan?

A full-table scan can be avoided by creating an index or rearranging the conditions in an SQL statement that are indexed.
Posted By:Shruti Sharma      Posted On: Dec 21

  4  5  6  7  8  9  10  11  12  13  14