Home Database
Database interview questions
Filter     Display # 
# 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: