TechieClues

Oracle - Interview Questions & Answers

Common/Basics SQL Questions,please read DBMS Basics, before come into this section.
1. List the various Oracle database objects?
1. TABLES
2. VIEWS
3. INDEXES
4. SYNONYMS
5. SEQUENCES
6. TABLESPACES
2. What is a synonym? What are its various types?
A synonym can be called as an alias for a table, view, sequence or program unit. It is basically of two types:
Private - Only the owner can access it.
Public - Can be accessed by any database user.
3. What is schema?
A schema is collection of database objects of a user.
4. What are Schema Objects?
Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages and database links.
5. What is Oracle table?
A table is the basic unit of data storage in an Oracle database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
6. What is an Oracle view?
A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
7. What are the different type of Segments?
Data Segment, Index Segment, Rollback Segment and Temporary Segment.
8. What is an Index Segment?
Each Index has an Index segment that stores all of its data.
9. What is an Index?
An Index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.
10. What is a View?
A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
Questions & Answers
Database Management (DBMS)