Slightbook.com Slightbook.com

Oracle Interview questions


Total available count: 26
Subject - Databases
Subsubject - Oracle
1
What is oracle database ?
2
Explain oracle grid architecture?
3
What is storage virtualization?
4
What are the several tools for interacting with the oracle database using sql?
5
How does Oracle work?
6
What contains oracle physical database structure?
7
What is a Tablespace?
8
What are data blocks?
9
What is a view?
10
What are materialized views?
11
Explain sequence generator in oracle?
12
What are Job Queue Processes?
13
What is DML?
14
What is USING Clause and give example?
15
What are temporal data types in Oracle?
16
How do we create privileges in Oracle?
17
What is the difference between rename and alias?
18
What are different Oracle database objects?
19
What is difference between UNIQUE and PRIMARY KEY constraints?
20
What is difference between SQL and SQL*PLUS?
21
How will you delete duplicating rows from a base table?
22
When you use WHERE clause and when you use HAVING clause?
23
How you will avoid your query from using indexes?
24
Difference between an implicit & an explicit cursor.?
25
What is hash cluster?
26
What is a deadlock? Explain?