Interview Questions.

Q1. What Is A Profile In Oracle Security?

Profile is facts contain that precise modules.

Q2. Explain When Will The Data In The Snapshot Log Be Used?Refer

snapshort log is used updated statistics for grasp desk and if any recored is up to date after certen duration to refer the master desk accumulate the image log. Due to the fact tha desk length may be very big it take lot of time. Therefore via united statesthe photo log.

Q3. How To Enable Automatic Archiving?

Shutdown the database with normal/emmidiate/tractional

regulate/include the parameter log_archive_start=real, 

log_archive_dest= (vicinity to which the redo log record group is archived), log_archive_format=(in which format you want to apper the archive log file)

begin up the database.

Q4. What Are The Database Administrators Utilities Available?

So many database utilities are to be had:

SQLPLUS

RMAN

TKPROF

SQLLODAR

EXP,IMP AND EXPDP,IMPDP

EXPLAN PLAN

LSNRCTL

Q5. What Is Default Tablespace In Oracle Security?

Its the tablespace in to which the objects created with the aid of a person move.Default tablespace can alloted to a user even as growing he user or also can be modified after creating the user. The default desk space of a person is gadget tablespace until cited specfically while creating the person.

Q6. Can You Explain What Are The Roles And User Accounts Created Automatically With The Database?

DBA - function Contains all database gadget privileges.

SYS person account - The DBA role will be assigned to this account. All of the basetables and perspectives for the database's dictionary are save in this schema and are manipulated handiest by way of ORACLE.

SYSTEM person account - It has all of the gadget privileges for the database and further tables and perspectives that show administrative facts and internal tables and perspectives utilized by oracle equipment are created the usage of this username.

Q7. What Is The Use Of Analyze Command?

To carry out this sort of function on an index,table, or cluster:

to acquire statisties about item utilized by the optimizer and keep them within the data dictionary.

To delete facts approximately the object used by object from the data dictionary.

To validate the structure of the item.

To discover migrated and chained rows of the desk or cluster.

Q8. Explain Snapshot Log?

It is a desk that continues a record of changes to the master desk in a image. It is saved in the equal database as grasp table and is only to be had for simple snapshots. It must be created earlier than creating snapshots.

Q9. What Are The Main Responsibilities Of A Database Administrator?

Depending at the employer and the branch, this role can both be exceptionally specialised or distinctly numerous. The number one position of the Database Administrator is to adminster, expand, keep and put in force the rules and processes important to make certain the safety and integrity of the corporate database. Sub roles within the Database Administrator type may also encompass security, architecture, warehousing and/or business evaluation.

Other primary roles will encompass:

Deciding the h/w devices to be used

Deciding the person and records to be utilized by person.

Deciding the facts content material facts base gadget.

Deciding the information dictionary include the information in records.

Deciding the validation take a look at on records.

Deciding the backup and recuperation.

Monitoring the reaction to be changing surroundings.

Q10. What Is Different Between View And Sequence?

A view is a logical table based totally on a desk or any other view.  A view comprise no records itself but it's far like a window  thru which statistics from tables may be perspectives and changed. 

A series is a person created database object that can be shared by multiple user to generate precise integers.

Q11. What Are The Minimum Parameters Should Exist In The Parameter File (init.Ora)?

DB NAME - Must set to a textual content string of no extra than 8 characters and it'll be saved in the datafiles,redo log documents and manage files and manipulate file while database creation.

DB_DOMAIN - It is string that specifies the community domain wherein the database is created. The international database call is recognized through putting these parameters(DB_NAME & DB_DOMAIN)

CONTORL FILES - List of manipulate filenames of the database.If name isn't cited then default name could be used.

DB_BLOCK_BUFFERS - To decide the no of buffers within the buffer cache in SGA.

PROCESSES - To decide wide variety of running device tactics that may be linked to ORACLE concurrently. The price have to be five (heritage technique) and further 1 for each person.

ROLLBACK_SEGMENTS - List of rollback segments an ORACLE instance acquires at database startup.

Also optionally  LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and LICENSE_MAX_USERS.

Q12. How To Enforce Security Using Stored Procedures?

Don't furnish consumer get admission to at once to tables within the utility.

Instead supply the capability to get right of entry to the methods thataccess the tables.When procedure finished it'll execute the privilege of methods owner. Users can not get admission to tables besides via the procedure.

Q13. Explain What Are The Steps To Switch A Databases Archiving Mode Between No Archivelog And Archivelog Mode?

To check database is wherein mode:

Conn sys/sys as sysdba

choose log_mode from v$database

To set database in Archivelog mode:

shutdown immediately;

startup mount;

adjust database archivelog;

 adjust database open;

To set database in NoArchivelog Mode:

shutdown instant;

startup mount;

modify database noarchivelog;

modify database open;

Q14. What Is Tablespace Quota In Oracle Security?

Amount of tablespace that may be utilized by a consumer for developing his personal database objects is called talespace quota.Its a manner of restricting using memory or disk space by way of user or restricting him by means of giving a set disk area.

Q15. What Is Snapshots?

Snapshot is not anything but a consistent facts for master desk if any chance the master desk snapshot is fetch the up to date records for grasp desk.

Q16. What Is The Step For Rman Backup?

RMAN is an Oracle tool for taking the backup and recovering the databases. You can copy, repair, and get better datafiles, control files and archived redo logs (all 3 files or any individual record). It has command line application as well as GUI-based totally Enterprise Manager Backup. Here we're discussing the command line application. 

For instance, we've got TEST and PROD databases. Here TEST is the catalog database and PROD is the target database for which the backup needs to be taken. You may additionally loose your backup when you have your catalog and target databases on the identical field and the container crashes .So it's far continually advisable to preserve a separate database for RMAN catalog . 

Create  databases. One for RMAN catalog(Test) and one goal(PROD). Both the Databases ought to be archive log mode(for protection).

Q17. Explain What Are The Dictionary Tables Used To Monitor A Database Spaces?

DBA_DATA_FILES is view to show the distance for the tablespace if you want the calulate the space of the database the all tablespace length is the database length.

Q18. What Are Roles? How Can We Implement Roles?

If a user desires to deliver some privileges to some other person or a group of customers then they may create role and they provide this function to the users.Permit the privileges be 'insert' and 'replace' on 'emp' table then rather than specifying them by way of their names they will create function which inturn consists of those techniques. This position is similarly given to the users.

If in futher if he wants to take away a few privilege given to the customers, he can simply alter the role and take away that unique privilege inclusive of he can eliminate replace from this created position..

Later the customers cant do updations on that emp table.But nevertheless can insert the values into that desk.

Hence Roles are the very best manner to provide and manipulate commonplace privileges wished by way of specific corporations of database customers.Creating roles and assign each position to group of users will simplify the activity of assigning privileges to person customers.

Q19. How To Specify The Archived Log File Name Format And Destination?

By placing the subsequent values in init.Ora report:

LOG_ARCHIVE_FORMAT = arch %S/s/T/tarc

(%S - Log collection number and is zero left paded,%s - Log sequence number now not padded. %T - Thread quantity lef-0-paded and %t - Thread wide variety not padded).

The record call created is arch 0001 are if %S is used.

LOG_ARCHIVE_DEST = course.

Q20. Do You Know What Are The Various Type Of Snapshots?

Snapshots is 3 styles of complite,fast and pressure.

Q21. How To Enforce Refrencial Integrity In Snapshots?

Time the references to occur when master tables aren't in use.Peform the reference the manually immdiately locking the master tables. We can join tables in snopshots with the aid of developing a complicated snapshots with the intention to primarily based on the master tables.

Q22. What Is Meant By Physical Order And Logical Order In Clustered Index And Non Clustered Index?

It is imply it's far primary key column.

Q23. How To Prevent Unauthorized Use Of Privileges Granted To A Role?

By creating a Role with a password

Q24. Explain What Are The Benefits Of Distributed Options In Databases?

Database on other servers may be up to date and people tractions can be grouped collectively with others in a logical unit.

Database uses a two section dedicate.

Q25. Differentiate The Simple And Complex, Snapshots?

A easy photo is based totally on a query that doesn't consists of GROUP BY clauses, CONNECT BY clauses, JOINs, sub-query or snashot of operations.

 A complicated snapshots include atleast anybody of the above.

Q26. How To Reduce The Network Traffic?

Replication of facts in distributed surroundings. 

Using snapshots to replicate information.

Using far off technique calls.

Q27. Tell Me What Is User Account In Oracle Database?

An user account is not a physical structure in Database however it is having crucial dating to the items in the database and can be having sure privileges

Q28. What Is Dynamic Data Replication?

Dynamic facts replication is feture of oracle actualy the to greater database ex:- this is manufacturing database and different database with and synconoze with the manufacturing databse throuth the dynamic replication. If any exchange the proction database the symaltantinasly trade the opposite database the replication. The benefite the the consumer can get entry to any were ether prodction or syn with other database.

Q29. Explain What Are The Options Available To Refresh Snapshots?

COMPLETE - Tables are completely regenerated the use of the photo's query and the grasp tables whenever the photograph referenced.

FAST - If easy image used then a image log may be used to send the adjustments to the photograph tables.

FORCE - Default cost. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.