Submit a question
Home
Database
Home
SQL Tuning
Ajax
ASP.Net
Bluetooth
CSS
C
C#
C++
Cobol
Computer Architecture
Data Structure
Data WareHousing
Database
Ejb
HR
Html
J2ee
J2ME
Java
JavaScript
JMS
JSP
Linux
Networking
Object Oriented(OOPS)
Operating System
PeopleSoft
PERL
Pl/Sql
Python
PHP
Puzzles
SAP-ABAP
Sql
Siebel
Struts
VB.NET
VB
UNIX
Xml
Submit a question
Link
Privacy - policy
Java Download
Login Form
Username
Password
Remember Me
Forgot your password?
Forgot your username?
Create an account
Database interview questions
Filter
Display #
5
10
15
20
25
30
50
100
All
#
Article Title
Hits
1
How does one coalesce free space ? (for DBA)
156
2
How does one prevent tablespace fragmentation? (for DBA)
116
3
Where can one find the high water mark for a table? (for DBA)
109
4
What is COST-based approach to optimization ?
111
5
What does COMMIT do ?
121
6
How are extents allocated to a segment? (for DBA)
110
7
Can one rename a database user (schema)? (for DBA)
107
8
Define Transaction ?
116
9
What is Read-Only Transaction ?
117
10
What is a deadlock ? Explain .
73
11
What does a Control file Contain ?
98
12
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
108
13
What is Index Cluster ?
109
14
When does a Transaction end ?
118
15
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION
86
16
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION
88
17
How does one create a new database? (for DBA)
95
18
What database block size should I use? (for DBA)
81
19
What are the different approaches used by Optimizer in choosing an execution plan ?
92
20
What does ROLLBACK do ?
116
21
What are the types of synonyms?
101
22
What is a private synonym?
110
23
What is a public synonym?
100
24
What are synonyms used for?
91
25
What is an Oracle index?
92
26
How are the index updates?
104
27
What is a Tablespace?
91
28
What is Rollback Segment ?
107
29
What are the Characteristics of Data Files ?
99
30
How to define Data Block size ?
91
31
What are Clusters ?
125
32
What is an Integrity Constrains ?
108
33
What is an Index ?
96
34
What is an Extent ?
98
35
What is a View ?
84
36
What is Table ?
83
37
Can a view based on another view?
112
38
What are the advantages of views?
89
39
What is an Oracle sequence?
86
40
What is a synonym?
81
41
What is schema?
100
42
What are Schema Objects?
93
43
Can objects of the same schema reside in different tablespaces?
113
44
Can a tablespace hold objects from different schemes?
117
45
What is Oracle table?
89
46
What is an Oracle view?
101
47
What is Partial Backup ?
105
48
What is Mirrored on-line Redo Log ?
103
49
What is Full Backup ?
89
50
Can a View based on another View ?
120
51
What are the components of physical database structure of Oracle database?
98
52
What are the components of logical database structure of Oracle database?
93
53
What is a tablespace?
94
54
What is SYSTEM tablespace and when is it created?
98
55
What is Database?
89
Related links
Related Links:
Related Images
Related Links: