Oracle Database Architecture Interview Questions

 
1.
What is an Oracle Rollback Segment?
2.
What are the uses of Oracle Rollback Segment?
3.
What are Oracle Schema Objects?
4.
What is an Oracle Data Block?
5.
Can objects of the same Schema reside in different tablespaces?
6.
What is the use of Oracle Control File?
7.
Can a View based on another View in Oracle?
8.
What is the function of Redo Log in Oracle?
9.
Describe the different type of Integrity Constraints supported by ORACLE?
10.
What is an Oracle Data Dictionary?
11.
What is an Oracle SYSTEM tablespace and when is it Created?
12.
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?
13.
How to define Data Block size in Oracle?
14.
What is an Integrity Constrains in Oracle?
15.
Can a Tablespace hold objects from different Schemes in Oracle?
16.
What is an oracle database schema?
17.
What is an Oracle Data Segment?
18.
What is an Oracle Rollback Segment?
19.
What are the uses of Oracle Rollback Segment?
20.
What are Oracle Schema Objects?
21.
What is an Oracle Data Block?
22.
Can objects of the same Schema reside in different tablespaces?
23.
What is the use of Oracle Control File?
24.
Can a View based on another View in Oracle?
25.
What is the function of Redo Log in Oracle?
26.
Describe the different type of Integrity Constraints supported by ORACLE?
27.
What is an Oracle Data Dictionary?
28.
What is an Oracle SYSTEM tablespace and when is it Created?
29.
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?
30.
How to define Data Block size in Oracle?
31.
What is an Integrity Constrains in Oracle?
32.
Can a Tablespace hold objects from different Schemes in Oracle?
33.
What is an oracle database schema?
34.
What is an Oracle Data Segment?
35.
What is an Oracle Rollback Segment?
36.
What are the uses of Oracle Rollback Segment?
37.
What are Oracle Schema Objects?
38.
What is an Oracle Data Block?
39.
Can objects of the same Schema reside in different tablespaces?
40.
What is the use of Oracle Control File?
41.
Can a View based on another View in Oracle?
42.
What is the function of Redo Log in Oracle?
43.
Describe the different type of Integrity Constraints supported by ORACLE?
44.
What is an Oracle Data Dictionary?
45.
What is an Oracle SYSTEM tablespace and when is it Created?
46.
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?
47.
How to define Data Block size in Oracle?
48.
What is an Integrity Constrains in Oracle?
49.
Can a Tablespace hold objects from different Schemes in Oracle?
50.
What is an oracle database schema?
51.
What is an Oracle Data Segment?
52.
What is an Oracle Rollback Segment?
53.
What are the uses of Oracle Rollback Segment?
54.
What are Oracle Schema Objects?
55.
What is an Oracle Data Block?
56.
Can objects of the same Schema reside in different tablespaces?
57.
What is the use of Oracle Control File?
58.
Can a View based on another View in Oracle?
59.
What is the function of Redo Log in Oracle?
60.
Describe the different type of Integrity Constraints supported by ORACLE?
61.
What is an Oracle Data Dictionary?
62.
What is an Oracle SYSTEM tablespace and when is it Created?
63.
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?
64.
How to define Data Block size in Oracle?
65.
What is an Integrity Constrains in Oracle?
66.
Can a Tablespace hold objects from different Schemes in Oracle?
67.
What is an oracle database schema?
68.
What is an Oracle Data Segment?