Slightbook.com Slightbook.com

Oracle Interview questions


Total available count: 35
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?
27
What is an oracle schema?
28
What is a synonyms?
29
What is synonyms and give an example of synonyms?
30
What are the things synonyms can do?
31
What is public synonyms and private synonyms?
32
Explain briefly oracle instance memory structure?
33
What is SGA?
34
What are the data structures does SGA contains?
35
What are Database Buffers?