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