Oracle Faq

S/No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

Question About versions? How to find out the versions What is Oracle Server? What is Oracle Instance? What is Oracle database? What is SGA and its components? What is shared pool? Components of shared pool? What is parsed statements? Abt Database buffer cache? What is Redo log buffer cache? Purspose of Redo log buffer cache? Abt Java Pool? Abt Large Pool? Primary purpose? Five mandatory background processes? PMON purpose? SMON purpose? DBWR purpose? LGWR purpose? CKPT purpose? When does LGWR write? When does DBWR write? What is Server Process? What is User Process? What is Connection? Types of files in the Database? Major types of tablespaces? Control files and its contents? Redo log files? And its purpose? What happens when logswitch occurs? What happens when logswitch occurs, If it is Archive log enabled? If it is no archive log mode? What is Parameter file? And its contents? Differenet parameters and its naming conventions? Default locations of parameter files? Default precedence of parameter files? Is it mandatory that parameter file will be in /dbs? To bring up the database only with pfile? If Oracle SID is not set, can you bring up the database? PGA? Logical structure of database? Physical structure? Can we have one segment spanned across multiple tablespaces? How to create spfile from pfile? How to increase the database buffer cache, when using pfile?

Answer Combination of Instance and database

datafiles NO

46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83

How to increase the database buffer cache, when using spfile? What happens when using scope=spfile? If we don’t specify scope, what happens? Different phases of startup? What happens in nomount, mount and open phases? Different modes of open? Different phases of shutdown? And what happens in those phases? What happens in restricted mode? In which modes, database will be shutdown cleanly? What are all the options we have to monitor the database? Why do we use the userdump? What is the method to show the parameter? Data has not been added to the alert log file for the past 4 days. What is the problem? How to enable the user trace? Password file authentication? How to do that? Steps to create the database? v$pwfile_users? Installation steps? In how many types we can create the database? Steps to create the database manually? What does catalog_sql create? What does catalog_proc create? dba_tables, users_tables, all_tables? How to multiplexing using SPfile? Multiplexing using pfile? Redolog files purpose? And its conditions? To force the checkpoint? fast_mttr_start_target? Types of table spaces? Types of non system tablespaces? About space management? About undo tablespace? About temporary tablespace? About default tablespace? About read only tablespace? Can we increase/reduce the size of the tablespace? How? Steps to move the datafile? Dropping the tablespace?

Reduce the size upto hightwater mark

84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120

File is growing when it is in the autoextend mode. How to reduce the size? v$dba_tablespaces? Difference between local managed and dictionary managed? What is segment? What is extent? Size of the blocksize? Can we resize the blocksize?

Table space should be exported or create the new tablespace

Yes, but database may be corrupted. It is not recommended

pct free, pct used? Methods to manage undo data? Difference between system and nonsystem? Where is Undo information located? How to create temporary table? How to re-organize the table? What are the conditions after reorganizing the table? What is Index? And its contents? Difference between truncate and delete and drop table? How to delete the data with dependent data? How to add a column to the table? How to drop the column in the table? How to view table information? Types of indexes? Differences between bitmap and b-tree indexes? Peculiar nature for the table and index? How to rebuild the index? What are the conditions to rebuild the index online? How to drop the index? How to identify the unused indexes? How to view index information? What is data integrity? Some of the constraints? What do you do if error comes because of constraints while dataloading? How to set the password? Alter user or create user About password management? About resource limits? Why do we use profiles? What is schema? Named collection of objects Difference between object privilege and system privilege?