Slightbook.com Slightbook.com

Oracle Interview questions


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