Here you can find Oracle Database Interview Questions and Answers.
In this Oracle Database Interview Questions and Answers section you can learn and practice Oracle Database Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any Oracle Database interview.
AllIndiaExams provides you lots Oracle Database Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Oracle Database Interview Questions and Answers as PDF files and eBooks.
You no need to worry, we have given lots of Oracle Database Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Oracle Database technical interview.
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.
What are Clusters?
Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
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.
What are the advantages of views?
Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table. Hide data complexity. Simplify commands for the user. Present the data in a different perspective from that of the base table Store complex queries.
What are the various types of queries?
The types of queries are : Normal Queries Sub Queries Co-related queries Nested queries Compound queries
What is the difference between clustered and a non-clustered index?
A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. A Nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk.
What is a Tablespace?
A database is divided into Logical Storage Unit called tablespace. A tablespace is used to grouped related logical structures together.
Why use materialized view instead of a table?
Materialized views are basically used to increase query performance since it contains results of a query. They should be used for reporting instead of a table for a faster execution.
What does ROLLBACK do?
ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction.
Compare and contrast TRUNCATE and DELETE for a table?
Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just moves the high water mark and produces a now rollback. The delete command, on the other hand, is a DML operation, which will produce a rollback and thus take longer to complete.