Oracle Security Interview Questions

 
1.
How to enable automatic archiving?
2.
Explain What are the steps to switch a databases archiving mode between NO ARCHIVELOG and ARCHIVELOG mode?
3.
What are roles? How can we implement roles?
4.
What are the minimum parameters should exist in the parameter file (init.ora)?
5.
Tell me What are the database administrators utilities avaliable?
6.
Can you explain What are the roles and user accounts created automatically with the database?
7.
What are the main responsibilities of a Database Administrator?
8.
Explain What are the dictionary tables used to monitor a database spaces?
9.
How to enforce security using stored procedures?
10.
Tell me What is user Account in Oracle database?
11.
What is a profile in Oracle Security?
12.
What is Tablespace Quota in Oracle Security?
13.
What is default tablespace in Oracle Security?
14.
How to prevent unauthorized use of privileges granted to a Role?
15.
What is meant by physical order and logical order in clustered index and non clustered index?
16.
What is the step for rmanbackup?
17.
Tell me What is different between view and sequence?
18.
Explain What are the benefits of distributed options in databases?
19.
Explain When will the data in the snapshot log be used?
20.
Explain snapshot log?
21.
Explain What are the options available to refresh snapshots?
22.
How to Enforce Refrencial Integrity in snapshots?
23.
What is dynamic data replication?
24.
Differentiate the simple and complex, snapshots?
25.
Do you know What are the various type of snapshots?
26.
What is snapshots?
27.
How to reduce the network traffic?
28.
Explain What is the use of ANALYZE command?
29.
How to specify the Archived log file name format and destination?
30.
How to enable automatic archiving?
31.
Explain What are the steps to switch a databases archiving mode between NO ARCHIVELOG and ARCHIVELOG mode?
32.
What are roles? How can we implement roles?
33.
What are the minimum parameters should exist in the parameter file (init.ora)?
34.
Tell me What are the database administrators utilities avaliable?
35.
Can you explain What are the roles and user accounts created automatically with the database?
36.
What are the main responsibilities of a Database Administrator?
37.
Explain What are the dictionary tables used to monitor a database spaces?
38.
How to enforce security using stored procedures?
39.
Tell me What is user Account in Oracle database?
40.
What is a profile in Oracle Security?
41.
What is Tablespace Quota in Oracle Security?
42.
What is default tablespace in Oracle Security?
43.
How to prevent unauthorized use of privileges granted to a Role?
44.
What is meant by physical order and logical order in clustered index and non clustered index?
45.
What is the step for rmanbackup?
46.
Tell me What is different between view and sequence?
47.
Explain What are the benefits of distributed options in databases?
48.
Explain When will the data in the snapshot log be used?
49.
Explain snapshot log?
50.
Explain What are the options available to refresh snapshots?
51.
How to Enforce Refrencial Integrity in snapshots?
52.
What is dynamic data replication?
53.
Differentiate the simple and complex, snapshots?
54.
Do you know What are the various type of snapshots?
55.
What is snapshots?
56.
How to reduce the network traffic?
57.
Explain What is the use of ANALYZE command?
58.
How to specify the Archived log file name format and destination?
59.
How to enable automatic archiving?
60.
Explain What are the steps to switch a databases archiving mode between NO ARCHIVELOG and ARCHIVELOG mode?
61.
What are roles? How can we implement roles?
62.
What are the minimum parameters should exist in the parameter file (init.ora)?
63.
Tell me What are the database administrators utilities avaliable?
64.
Can you explain What are the roles and user accounts created automatically with the database?
65.
What are the main responsibilities of a Database Administrator?
66.
Explain What are the dictionary tables used to monitor a database spaces?
67.
How to enforce security using stored procedures?
68.
Tell me What is user Account in Oracle database?
69.
What is a profile in Oracle Security?
70.
What is Tablespace Quota in Oracle Security?
71.
What is default tablespace in Oracle Security?
72.
How to prevent unauthorized use of privileges granted to a Role?
73.
What is meant by physical order and logical order in clustered index and non clustered index?
74.
What is the step for rmanbackup?
75.
Tell me What is different between view and sequence?
76.
Explain What are the benefits of distributed options in databases?
77.
Explain When will the data in the snapshot log be used?
78.
Explain snapshot log?
79.
Explain What are the options available to refresh snapshots?
80.
How to Enforce Refrencial Integrity in snapshots?
81.
What is dynamic data replication?
82.
Differentiate the simple and complex, snapshots?
83.
Do you know What are the various type of snapshots?
84.
What is snapshots?
85.
How to reduce the network traffic?
86.
Explain What is the use of ANALYZE command?
87.
How to specify the Archived log file name format and destination?
88.
How to enable automatic archiving?
89.
Explain What are the steps to switch a databases archiving mode between NO ARCHIVELOG and ARCHIVELOG mode?
90.
What are roles? How can we implement roles?
91.
What are the minimum parameters should exist in the parameter file (init.ora)?
92.
Tell me What are the database administrators utilities avaliable?
93.
Can you explain What are the roles and user accounts created automatically with the database?
94.
What are the main responsibilities of a Database Administrator?
95.
Explain What are the dictionary tables used to monitor a database spaces?
96.
How to enforce security using stored procedures?
97.
Tell me What is user Account in Oracle database?
98.
What is a profile in Oracle Security?
99.
What is Tablespace Quota in Oracle Security?
100.
What is default tablespace in Oracle Security?
101.
How to prevent unauthorized use of privileges granted to a Role?
102.
What is meant by physical order and logical order in clustered index and non clustered index?
103.
What is the step for rmanbackup?
104.
Tell me What is different between view and sequence?
105.
Explain What are the benefits of distributed options in databases?
106.
Explain When will the data in the snapshot log be used?
107.
Explain snapshot log?
108.
Explain What are the options available to refresh snapshots?
109.
How to Enforce Refrencial Integrity in snapshots?
110.
What is dynamic data replication?
111.
Differentiate the simple and complex, snapshots?
112.
Do you know What are the various type of snapshots?
113.
What is snapshots?
114.
How to reduce the network traffic?
115.
Explain What is the use of ANALYZE command?
116.
How to specify the Archived log file name format and destination?