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)
82
2
How does one prevent tablespace fragmentation? (for DBA)
67
3
Where can one find the high water mark for a table? (for DBA)
61
4
What is COST-based approach to optimization ?
66
5
What does COMMIT do ?
73
6
How are extents allocated to a segment? (for DBA)
61
7
Can one rename a database user (schema)? (for DBA)
62
8
Define Transaction ?
72
9
What is Read-Only Transaction ?
66
10
What is a deadlock ? Explain .
39
11
What does a Control file Contain ?
50
12
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
56
13
What is Index Cluster ?
60
14
When does a Transaction end ?
67
15
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION
44
16
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION
45
17
How does one create a new database? (for DBA)
46
18
What database block size should I use? (for DBA)
39
19
What are the different approaches used by Optimizer in choosing an execution plan ?
46
20
What does ROLLBACK do ?
64
21
What are the types of synonyms?
56
22
What is a private synonym?
61
23
What is a public synonym?
53
24
What are synonyms used for?
47
25
What is an Oracle index?
44
26
How are the index updates?
58
27
What is a Tablespace?
50
28
What is Rollback Segment ?
54
29
What are the Characteristics of Data Files ?
54
30
How to define Data Block size ?
44
31
What are Clusters ?
70
32
What is an Integrity Constrains ?
58
33
What is an Index ?
45
34
What is an Extent ?
53
35
What is a View ?
47
36
What is Table ?
48
37
Can a view based on another view?
63
38
What are the advantages of views?
42
39
What is an Oracle sequence?
42
40
What is a synonym?
39
41
What is schema?
54
42
What are Schema Objects?
42
43
Can objects of the same schema reside in different tablespaces?
64
44
Can a tablespace hold objects from different schemes?
64
45
What is Oracle table?
46
46
What is an Oracle view?
48
47
What is Partial Backup ?
52
48
What is Mirrored on-line Redo Log ?
55
49
What is Full Backup ?
48
50
Can a View based on another View ?
67
51
What are the components of physical database structure of Oracle database?
53
52
What are the components of logical database structure of Oracle database?
53
53
What is a tablespace?
53
54
What is SYSTEM tablespace and when is it created?
51
55
What is Database?
44
Related links
Related Links:
Related Images
Related Links: