Cyber Security Interview Questions (part- 2)
9) What is Rollback Segment?
The database contains at least one Rollback Segments to move back exchanges and information recuperation.
10) What is the diverse kind of Segments?
Information Segment(for putting away User Data), Index Segment (for putting away list), Rollback Segment and Temporary Segment.
11) What are the archive log and No file log mode?
We all realize that re-try logs put away the re-try data and re-try log documents are in a roundabout fashion. Oracle Database gives you a chance to spare filled gatherings of re-try log records to at least one disconnected goals, referred to by and large as the chronicled re-try log. The way toward transforming re-try log documents into filed re-try log records is called filing. The foundation procedure ARCn mechanizes filing tasks when programmed documenting is empowered. The database begins various archiver forms as expected to guarantee that the documenting of filled re-try logs do not fall behind. No file log implies chronicle log are not produced and re-try are overwritten
Visit Oracle DBA training to get practical information on logs
12) What everything is available in the common pool?
The common pool bit of the SGA contains three noteworthy territories:
library cache(contains parsed sql statements,cursor information,execution plans)
lexicon store (contains reserve — client account information, privileges information, datafile, segment and degree data)
supports for parallel execution messages
control structure.
13) What is a hot backup?
If the database must be ready for action 24 hours every day, seven days seven days, at that point you must choose the option to perform conflicting reinforcements of the entire database. A reinforcement of online information documents is called an online reinforcement. This necessitates you run your database in ARCHIVELOG mode.
14) which sees is accustomed to finding the securing in the database?
v$lock, v$session, v$process
visit Oracle Certification centre to get the working of these process
15) You have numerous examples running on a similar UNIX box. How might you figure out which shared memory and semaphores are related with which occurrence?
There are two different ways
SQL> oradebug setmypid
SQL> oradebug ipc
SQL>oradebug tracfile_name
Another route is to utilize
$ORACLE_HOME/receptacle/sysresv
16) What is Database file ?
A database file is an information structure that improves the speed of information recovery tasks on a database table at the expense of slower composes and expanded capacity space.By default, Oracle makes B-tree records.
Visit OnlineITGuru to get the dumps for DBA Certification
