Logo 
Search:

oracle Interview FAQs

Submit Interview FAQ
Home » Interview FAQs » oracleRSS Feeds
Oracle
Comments: 0

In Oracle, how can you find out what tables and views you own?

By selecting from USER_CATALOG or CAT. The name of the data dictionary object will vary by implementation, but all versions have basically the same information about objects such as tables and views.
Posted By:Shruti Sharma      Posted On: Dec 21

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

  1  2  3