Job Seekers   Employers
dbapool: Authors | Submissions | Contact Us
   Forgot password? | Sign up
  Home   Discussion Forum   Articles   Interview Questions   FAQs   Scripts   Rewards   Analyzer   White Papers   Blog   Certification   Downloads   Tools


Interview
 
Going for an interview?
 

You may be a good DBA, you know that but not the person who is interviewing you. Interview is a demonstration of your technical and interpersonal skills. Before going to interview, make sure you know the stuff that you have written on your resume.

Below is a brief list of some commonly asked questions. We are in the process to add more questions soon. If you have question and want to contribute then please do so by clicking here.



 
   Interview Questions Views
 What does 'i' refer to in Oracle 9i ?
     -By: mily on Mar 10, 2010
41
  What is the differences between oracle 9i and 10g versions of RMAN ?
     -By: rk on Mar 09, 2010
95
 How to invoke the Cron scheduler manually?what is the shell script for that?
     -By: anil on Mar 08, 2010
90
 How to alter a tablespace in read only mode?
     -By: suri on Mar 05, 2010
135
  How is automatic extension of data files enabled?
     -By: suri on Mar 05, 2010
111
 How to check out the extent management for tablespace after creation?
     -By: suri on Mar 05, 2010
91
 How can i get the information about all the data files in a database?
     -By: suri on Mar 05, 2010
67
 How can i get the information about all the data files in a database?
     -By: suri on Mar 05, 2010
49
 Can objects be dropped when the tablespace is in offline mode?
     -By: suri on Mar 05, 2010
71
 Can i drop the default temporary tablespace?
     -By: suri on Mar 05, 2010
73
 Can we decrease the data file size, when it contains data more than the specified size?
     -By: suri on Mar 05, 2010
58
 How can a new data file be added to a tablespace?
     -By: suri on Mar 05, 2010
53
  Can we assign a same name to data files of two different tablespaces?
     -By: suri on Mar 05, 2010
64
 Try to create temporary tablespaces with all possible options?
     -By: suri on Mar 05, 2010
50
 Can a tablespace be renamed?
     -By: suri on Mar 05, 2010
71
 What happens when you make a tablespace offline immediate?
     -By: suri on Mar 05, 2010
69
 Try to create tablespaces with different database block sizes?
     -By: suri on Mar 05, 2010
47
 Can permanent objects be created in a temporary tablespace?
     -By: suri on Mar 05, 2010
45
 Can system and sysaux tablespaces be taken offline?
     -By: suri on Mar 04, 2010
89
 how we can identify the oracle version
     -By: suri on Mar 03, 2010
125
 How to estimate the long running processes in oracle and how can we expect the time to complete that?
     -By: anil on Mar 01, 2010
157
 how can i check this password file, and make modifications on it if possible
     -By: Fang on Feb 22, 2010
283
 please tell how to solve this sql plus is telling oracle is not avialable but services running
     -By: gopi on Feb 17, 2010
294
 in my system it tells oracle is not available how to solve ?
     -By: gopi on Feb 17, 2010
216
 What is deadlock ? how to resolve this issue
     -By: rk on Feb 16, 2010
272
 What are the mandatory background process in Oracle RAC ? Plz explain
     -By: rk on Feb 10, 2010
359
 why we write pl/sql create or replace procudure or fuction why not drop and recreate
     -By: veeru on Feb 06, 2010
249
 why we write pl/sql create or replace procudure or fuction why not drop
     -By: veeru on Feb 06, 2010
137
 how do we secure our database if it is on public ip
     -By: veeru on Feb 06, 2010
221
 how do we handle ora-00600 if we don't have oracle support
     -By: veeru on Feb 06, 2010
222
 How to retrieve records from more than one database in a single select statement
     -By: kdsharma on Feb 05, 2010
209
 sequence are used to generate primary key values
     -By: kdsharma on Feb 03, 2010
112
 you can use sequence
     -By: faiz on Feb 02, 2010
120
 what is meant by hwm
     -By: indu on Jan 29, 2010
218
 hi pls what is oracle and features
     -By: nikky on Jan 20, 2010
220
 what is ORA-01034? I FOUND THIS ERROR.. HOW CAN I SOLVE THIS ERROR?
     -By: sabeer on Jan 18, 2010
328
 hi my dear frnd...I am giving Oracle 9i fundamental exam. . . so can u plz send me some latest dumps on my mail id i.e akila4@gmail.com
     -By: Akila on Jan 14, 2010
153
 hi my dear frnd...m giving sql 1Z0-007 so can u plz send me som latest sql dumps on my id i.e mtabinda@gmail.com
     -By: tabi on Jan 12, 2010
99
 can any one send me the recent dumps of 1Z007 my email id :sowmyareddymandhala@gmail.com
     -By: baby on Jan 08, 2010
124
 The DBA has set a value of 2 for the parameter SESSIONS_PER_USER in the users profile but can still see that the user is able to run 5 sessions when logged on.What could be the reason?
     -By: Sravan on Jan 05, 2010
373
 What are the Different Possibilities to remove High Water Mark(HWM)?
     -By: raja on Jan 04, 2010
359
 What is front end in the sense of ORACLE database?
     -By: kunal on Dec 20, 2009
561
 hi, everybody I want one scenario(Error)which come in real time invironment for oracle database.
     -By: kunal on Dec 17, 2009
423
 hi, HOW MANY TABLES CREATED IN ORACLE SPOOL.. IS THERE ANY LIMIT LIKE TABLE COLUMNS MAXIMUM 256.. if limit , HAVE SQLSERVERDB ALSO LIMT Regards MURTHY
     -By: bulli on Dec 12, 2009
368
 Where by- refres to Single row function Having - refres to Multiple row function.
     -By: Dudlawar on Dec 07, 2009
246
 Where by- refres to Single row function Having - refres to Multiple row function.
     -By: Dudlawar on Dec 07, 2009
192
 i have production database i don't have enough space i need to increase my SGA size without shutdown the database(10g).is it possible?
     -By: Tonu on Dec 05, 2009
494
 why java invented?
     -By: japet on Dec 04, 2009
259
 How to check statistics of particular object(table, index) available or not.
     -By: mohan on Nov 28, 2009
411
 hi, i am persuing oracle 10g sql and pl/sql. pls send me all practise material on my id sweet.sonal01@gmail.com
     -By: sona on Nov 21, 2009
262
 which parameter restart the database automatically with out manually restart.
     -By: sh on Nov 21, 2009
603
 hi what are the tools used for 10g pl sql.
     -By: neelu on Nov 20, 2009
335
 hi, what is an oracle and its architecture.
     -By: neelu on Nov 19, 2009
456
 hi, hello i am persuing oracle 10g pl sql and i want all practise material for all this . pls send me on my id neelima.gg@gmail.com
     -By: neelu on Nov 19, 2009
213
 Hi My jamshed waryah i want to write the oraacle eximes 1z0 047 the Oca oracle SQL expert exim. If some one has the update the dumps please send me. jamshedwaryah@live.com
     -By: waryahjee on Nov 18, 2009
157
 how to view which index is working in a table when we have 5 indexes on one table, plz tell me what is the process.
     -By: raghu on Nov 16, 2009
387
 what are the types of check point
     -By: mohan on Nov 09, 2009
615
 HI i am executing a query on the database.but it is running slow ,what are the require steps need to be to be taken to run the query faster.(i was create indexes on where clause columns)
     -By: mohan on Nov 08, 2009
458
 hello i am ravi persuing oracle DBA 9i and i want all practise material for all this and specially dba fund I dumps pls send me on my id vandamguys@gmail.com
     -By: sammykiller on Nov 06, 2009
221
 Hi i need the oracle dums exames 1z0 047. And my email address is jamshed_waryah@yahoo.com. Please help me with it.
     -By: waryahjee on Oct 30, 2009
214
 Hi Guys and girls. I need the oracle 10g OCA Dums please help to find dums and done exames.eximes 1z0 047. If some one have send me. Thanks jamshed malik.
     -By: waryahjee on Oct 30, 2009
212
 hi this bobby how can i change the owner of the table
     -By: bobby on Oct 30, 2009
384
 i wan to know that which Oracle Certificate will be best than other,,,,,,,i wan to give OCP test....but i hav only the knowledge of SQL(Standard Query Language)......can i clear the exam....because i
     -By: Ram on Oct 30, 2009
190
 please give the steps foe database creation in oracle9i.after creation of database why we start the database by scopefile
     -By: cool boy on Oct 14, 2009
348
 Hi All, Can you tell me which OS Certification is good for ORACLE DBA?
     -By: prash on Oct 12, 2009
407
 how do we find the size of a table?
     -By: mutyam on Oct 05, 2009
883
 what is the difference between refresh and clone?
     -By: mutyam on Oct 05, 2009
674
 hi i need to do oca developer which book is good and practise papers
     -By: loke on Sep 22, 2009
354
 please fwd the answers
     -By: sri on Sep 19, 2009
388
 Working of Cumulative & Differential Backup ...?
     -By: KrunalDesai on Sep 17, 2009
579
 Hi i have upgarded n oracle 10g(10.2.0.1) to 10.2.0.4 but i am not able to open database i am geeting error instance terminated..but when i issue startup upgrade database is up,please update me
     -By: sudhir on Sep 15, 2009
483
 how can i create an auto increment column on 10g
     -By: Fang on Sep 13, 2009
533
 how can i create an auto increment column on 10g
     -By: Fang on Sep 13, 2009
311
 Hello y'all am a student and i need to get the Oracle DBA dumps and any materials that can help.Please help!email:stevosine@aol.com
     -By: Big Steve on Sep 04, 2009
358
 Streams pool is 10g new feature .This can be enabled by streams_pool_size=some value. & It can be very useful for the replication environment where the information( Data+Event) moves in the form
     -By: Dudlawar on Sep 02, 2009
360
 Streams pool is 10g new feature .This can be enabled by streams_pool_size=some value. & It can be very useful for the replication environment where the information( Data+Event) moves in the form
     -By: Dudlawar on Sep 02, 2009
253
 i have a 9i and 10g database in my system when itry to connect which database it will connect if it will connect to10g so how i will connect to 9i
     -By: navya on Aug 26, 2009
494
 
     -By: navya on Aug 26, 2009
220
 How to Detect and Remove Row migration and Row chaining.Please help me and Provide me All the neccesary steps.
     -By: tana on Aug 11, 2009
837
 How to Detect and Remove Row migration and Row chaining.Please help me and Provide me All the neccesary steps.
     -By: tana on Aug 11, 2009
428
 Hot backup generates more redo than normal why?
     -By: sree on Aug 10, 2009
910
 Hello everyone, can you name some of the better study books for preparing for OCA 10g certification?
     -By: azm on Jul 26, 2009
512
 what is scn number. which view is used to show current scn of oracle database
     -By: anu on Jul 25, 2009
993
 i want to do my OCA please send me paper1-SQL pdf copy on my mail id-sunil_yadav1432003@yahoo.co.in
     -By: sunil on Jul 24, 2009
392
 Hi Everyone, please give me dumps for fundamental 1 my email id abeyrathnac@yahoo.com
     -By: cha on Jul 18, 2009
495
 if one datafile is get corrupted then database will get crash.then we are unable to take logical export.
     -By: mohan on Jul 16, 2009
734
 If one datafile is corrupted in my database,while exporting it will export that datafile ? what will happen in 9i & 10g? what error it will show
     -By: rk on Jul 08, 2009
769
 How to check materialized view space usage ?
     -By: rk on Jun 24, 2009
990
 How to check materialized space usage ?
     -By: rk on Jun 24, 2009
587
 What is cluster in oracle? How many Types of cluster in oracle? Is cluster help in performace issue?
     -By: Somu on Jun 15, 2009
1007
 What is the main difference between REDOLOG file and ARCHIVELOG file?
     -By: Somu on Jun 13, 2009
1002
 Can u tell me the jobs performed by a database developer and also its qualities
     -By: mickey on Jun 12, 2009
601
 HOW CAN WE IDENTIFY MY DATABASE IS RAC CONFIGURED BY USING CONTROL FILE? I MEAN TO ASK THAT IS THERE ANY ENTRIES FOR RAC IN CONTROL FILE OF RAC CONFIGURE INSTANCE?
     -By: pratap on Jun 04, 2009
988
 WHAT IS FAN IN ORACLE REAL APPLICATION CLUSTER DATABASE? WHAT IS THE USAGE IN RAC DATABASE?
     -By: pratap on Jun 04, 2009
834
 Hi....... how to enable archive process in RAC configured database?
     -By: pratap on Jun 04, 2009
662
 Hi............... WHAT IS MAJOR DIFFERENCE BETWEEN EXPORT / IMPORT AND DATAPUMP IN ORACLE 10G DATABASE?
     -By: pratap on Jun 03, 2009
1122
 Hi........ HOW MANY TYPES OF LOCK ARE THERE? HOW TO CHECK THE OBJECT LOCK FROM DATABASE LEVEL? HOW TO CHECK THE MEMORY LOCK FROM DATABASE LEVEL? CAN ANY BODY HELP ME......
     -By: pratap on Jun 03, 2009
679
 While taking a backup with export,we are using "compress=y" parameter.it si for the compressing the data Internally how it will works ?
     -By: rk on Jun 02, 2009
762
 i want to load data with EM but when i type my os username and password on the load data page it give me an error (wrong password for user). but i'm sure of my username and passw.
     -By: Fang on May 29, 2009
531
 when i am executing a sql procedure related to workflow i unable to getting the output.what the cause. can any body help me . sql>exec sys.<procedure>
     -By: pratap on May 29, 2009
448
 hi indi i ask abt default tables,for this u gave the script. I run the script,but i did't get the tables.plz give me the perfect script.
     -By: sh on May 29, 2009
457
 when i am executing a sql procdure related to worklow i unable to getting output.what the cause. can any body help me .
     -By: pratap on May 29, 2009
398
 tablespace have two files,but both files have data.i want to export data from one file to another file.what is the procedure.plz helpme and give ur email id.
     -By: sh on May 28, 2009
649
 what are clusters?
     -By: nag on May 27, 2009
724
 what are the functions of dba
     -By: nag on May 27, 2009
850
 i need latest 10g interview questions?
     -By: saran on May 27, 2009
1167
 if the tablespace have 2 datafiles i want to drop first datafile,its possible plz help me
     -By: sh on May 27, 2009
675
 i create database in my home pc i need default tables(emp,salgrade,dept),what is the path to get,plz help me.
     -By: sh on May 27, 2009
493
 What is the query to determine the table size of a database in Oracle?
     -By: rk on May 26, 2009
636
 Whats the difference between SGA_MAX_SIZE AND SGA_TARGET in Oracle database 10gR2 and previous releases?
     -By: rakesh r a on May 23, 2009
770
 What is the difference between statspack and AWR report ?
     -By: rk on May 22, 2009
725
 can anybody post sql server dba interview questions..
     -By: nani on May 15, 2009
457
 What is Oracle’s flagship database?
     -By: azhar on May 13, 2009
621
 What is Oracle’s flagship database?
     -By: kamal on May 06, 2009
541
 When data base is in consistent condition what should be the mode of data base?
     -By: fanny on May 03, 2009
690
 What is the minimum entry that must be made in the pfile, or in other words, what is the minimum number of parameters that must be entered in a pfile while creating it?
     -By: BB on Apr 16, 2009
799
 can we convert database from oracle10XE to oracle9i? if possible plz explain.
     -By: sh on Apr 13, 2009
701
 what is the maximum size of smallfile tablespace
     -By: mohan on Apr 11, 2009
838
 if i create a tablespace with AUTOEXTEND ON then what is the size of next extent after tablespace get filled up
     -By: mohan on Apr 11, 2009
791
 How to raise TAR for oracle support?(step by step answer is required)
     -By: mutyam on Apr 06, 2009
769
 If HOSTNAME not found msg show in Unix. How it resolve?
     -By: prash on Apr 06, 2009
672
 how to create a database link between to databases with in a same box(require expalnation and example)
     -By: mohan on Mar 31, 2009
809
 sorry my question is why we are not running pupbld.sql as sys level,why we running it in system/manager level
     -By: mohan on Mar 31, 2009
616
 why we runing script pupbld.sql after connecting to system/manager
     -By: mohan on Mar 27, 2009
692
 can we save data in database without any tablespace
     -By: sh on Mar 26, 2009
901
 which transactions(committed or uncommitted) are written by logwriter into redologbuffer or esle both.
     -By: sh on Mar 15, 2009
852
 What is inline view
     -By: at on Mar 09, 2009
879
 hi, if production database is lost or any table then how can i recover the databae and table.plz help me
     -By: sh on Mar 09, 2009
872
 after installation we create a os user to install oracle with dba privilege. and his home directory is /oraeng/app/oracle/product/10.2.0.but when i am installing linux that os user is not opened in
     -By: mohan on Mar 03, 2009
619
 what the numbers represent ...9.2.0.6?
     -By: mutyam on Mar 01, 2009
936
 What is PCTFREE & PCTUSED?
     -By: mutyam on Mar 01, 2009
1123
 What is checkpoint?
     -By: mutyam on Mar 01, 2009
1055
 If a user comes up with a complaint that he does not have access to a particular table How do you check and rectify the issue?
     -By: mutyam on Mar 01, 2009
810
 What are the major steps involved to upgrade a database within release....such as 9.2.0.4to 9.2.0.6?
     -By: mutyam on Mar 01, 2009
697
 How do you know which user has which privileges?
     -By: mutyam on Mar 01, 2009
888
 How to go for the help on Opatch
     -By: mutyam on Mar 01, 2009
686
 How to apply the patch?
     -By: mutyam on Mar 01, 2009
918
 How to rollback the opatch
     -By: mutyam on Mar 01, 2009
691
 Types of Patches? Contents of a Patch?
     -By: mutyam on Mar 01, 2009
768
 Which default Database roles are created when you create a Database?
     -By: mutyam on Mar 01, 2009
755
 .How do you kill a process in Unix
     -By: mutyam on Mar 01, 2009
704
 How do you apply the rdbms patches
     -By: mutyam on Mar 01, 2009
614
 How do you find out what patches have been applied on database?
     -By: mutyam on Mar 01, 2009
750
 How do you create the user?
     -By: mutyam on Mar 01, 2009
594
 How to check the existing privileges and grant to the users and procedure to follow?
     -By: mutyam on Mar 01, 2009
593
 How can you control the access of a user to the database?
     -By: mutyam on Mar 01, 2009
598
 What is the difference between instance and database?
     -By: mutyam on Mar 01, 2009
764
 where RDBMS patch logs are located? ORACLE_HOME/.patch_storage
     -By: mutyam on Mar 01, 2009
526
 If row chaining and row migration is there how do you address that issue?
     -By: mutyam on Mar 01, 2009
633
 what is crash recovery which background process will take care of that?
     -By: mutyam on Mar 01, 2009
703
 Say the user complains that he is not able to login to the dabase, I mean it’s just hanging .. From where do you start debugging?
     -By: mutyam on Mar 01, 2009
621
 How do you increase the tablespace size
     -By: mutyam on Mar 01, 2009
611
 What is the use of SYSAUX tablespace
     -By: mutyam on Mar 01, 2009
819
 How do you determine howmuch virtual memory is being utilized?
     -By: mutyam on Mar 01, 2009
673
 How to know which process is consuming more CPU resources?
     -By: mutyam on Mar 01, 2009
765
 Explain the difference between a hot backup and a cold backup?
     -By: mutyam on Mar 01, 2009
544
 What is the use of utlrp.sql?
     -By: mutyam on Mar 01, 2009
647
 what is the architecture of oracle9i?
     -By: mutyam on Mar 01, 2009
592
 how to remove or rename users and groups in linux(linux command).
     -By: machi on Feb 22, 2009
701
 dba_free_space
     -By: sac on Feb 12, 2009
731
 what is the difference between ORACLE_HOME,ORACLE_BASE
     -By: mohan on Feb 07, 2009
981
 Tell me how many stages I mean paper's in oca and ocp paper's
     -By: shweta on Feb 06, 2009
561
 What are the checklist has to do if the result of the query is slow and how to increase the performance to get the result Fast?.
     -By: Prak on Feb 03, 2009
766
 
     -By: haq on Jan 30, 2009
373
 Could anyone please help me with the latest FEE structure of OCA and OCAP 10G DBA.
     -By: shari on Jan 25, 2009
605
 i have two databases in one box.now i want create database link between this two databases,how to create it
     -By: mohan on Jan 24, 2009
744
 hi friends plz help me i am attending my first interview on dba up now i was worked as programer i want change my trake to oracle dba and i was put experience 2+ what are the questions i will pha
     -By: mohan on Jan 19, 2009
768
 hi its nitin here, i am working on oracle report, i want to know how to convert PDF format report into Excel format using Oracle Report Builder tool.
     -By: nity on Jan 19, 2009
507
 Can we find out the password of any user in a database?
     -By: Harsha on Jan 01, 2009
1316
 what is the min size of S.G.A
     -By: buggi on Dec 30, 2008
1246
 morning, please where can i download the oracle Client software?? i' m also searching some pdf for a best tunning of RMAN.. thanks,
     -By: willdba on Dec 30, 2008
636
 What is bootstrap ?
     -By: Harsha on Dec 28, 2008
959
 1)Can a database have a block size of 11k ? 2)If we create no standard block size tablespace then can the data be sorted in standard block size temp tablespace ? tablespace blocksize is 16k and temp
     -By: Harsha on Dec 24, 2008
773
 Renaming database can be done by taking a trace backup of control file and recreating it by making some changes in that ....
     -By: Harsha on Dec 19, 2008
758
 How to find the blocksize of operating system LINUX n WINDOWS ??
     -By: Harsha on Dec 19, 2008
985
 what is the minimum size for creating a tablespace ?
     -By: Harsha on Dec 19, 2008
946
 While creating new datafile in a tablespace is the .DBF extension complusary ???
     -By: Harsha on Dec 19, 2008
773
 how to know the database size?
     -By: babi on Dec 16, 2008
1182
 What is the steps for degrade the database from 10g to 9i?
     -By: kattu on Dec 01, 2008
964
 Dear All, I am about to appear in SQL Paper on 9i. I need help from u people if u can give me useful tips and topics to concentrate more than i will be very thankful to all of you.
     -By: ishi on Nov 30, 2008
663
 how to import the database
     -By: sudhi on Nov 29, 2008
1065
 how to show the user privileges without logging the user account?(means how to show from dba side)
     -By: soku on Nov 24, 2008
854
 How to connect remote oracle database server?
     -By: soku on Nov 24, 2008
939
 
     -By: santanu on Nov 20, 2008
472
 what is database incarnation?
     -By: parox on Nov 20, 2008
1236
 How to know whether my database is running with spfile or pfile?
     -By: Sheela on Nov 18, 2008
1191
 Hi, this is syed khalid ali,i have one question that is ,Is it possible to clone different plat forms like Linux to window ,we can transport the tablespace in different platform in this condition why
     -By: feroz on Nov 15, 2008
768
 How to take export at two different mount point, with size limit at each location ?
     -By: raj on Nov 10, 2008
835
 When i type emctl start dbconsole i get the following error; Unable to determine local host from URL Repository_URL what can i do?
     -By: Fang on Nov 04, 2008
735
 how to import a table in a database having different tablespace than source database from where the table had been exported to dump file?
     -By: joni on Nov 04, 2008
769
 how to create sub table in main table.please tell me query Thanks in anticipation
     -By: shamshul on Oct 30, 2008
737
 what's the target DB, and how can i know the name of my target database?
     -By: Fang on Oct 30, 2008
836
 emctrl start dbconsole i get the following error: Environment variable Oracle_sid not defined. please define it.
     -By: Fang on Oct 13, 2008
896
 
     -By: MANOJ SINGH on Oct 06, 2008
562
 ORDER OF BACKGROUND PROCESSES DURING DB STARTUP
     -By: radhu on Oct 02, 2008
1550
 When create ORA-600 error? please explain in details.
     -By: prash on Sep 29, 2008
1323
 if db is in archive mode then filled redolog data goes into archive loc, if db is in no archive mode then where it goes?
     -By: radhu on Sep 22, 2008
1215
 Checkpoint Not Complete error show in Alert.log file, How to resolve this error?
     -By: prash on Sep 22, 2008
1268
 Identify the steps to put a database in Archive Log Mode.
     -By: soku on Sep 19, 2008
1095
 Try to drop online redo log file and online redo log group.
     -By: soku on Sep 19, 2008
1041
 What is the status if an online current redolog file is lost?
     -By: soku on Sep 19, 2008
1087
 Can different sizes be specified for the different log groups?
     -By: soku on Sep 19, 2008
841
 How can a log member be droped?
     -By: soku on Sep 19, 2008
942
 Try to relocate the log members to another destination.
     -By: soku on Sep 19, 2008
740
 When does a log member show an INVALID status?
     -By: soku on Sep 19, 2008
853
 Try to resize all online redolog files to 5m
     -By: soku on Sep 19, 2008
773
 Try to mutiplex the existing control file.
     -By: soku on Sep 19, 2008
750
 Try to start the database without any controlfiles.What happens?
     -By: soku on Sep 19, 2008
955
 What are the oracle managed files?
     -By: soku on Sep 19, 2008
835
 try to rename the database?
     -By: soku on Sep 19, 2008
951
 try to add a log member to an existing group?
     -By: soku on Sep 19, 2008
613
 What is the minimum size with which a logfile can be created?
     -By: soku on Sep 19, 2008
743
 How can we see the controlfile location?
     -By: soku on Sep 19, 2008
785
 What are the views available to see the information about log files?
     -By: soku on Sep 19, 2008
674
 Truncate the EMP table,releasing the space?Now how many extents does the table hold?
     -By: soku on Sep 19, 2008
725
 Can the value of initial_extent and min_extents be changed for a tablespace?
     -By: soku on Sep 19, 2008
660
 Can the value of initial_extent be changed,after a segment is created?
     -By: soku on Sep 19, 2008
604
 Can PCTFREE,PCTUSED be assigned for tablespace?
     -By: soku on Sep 19, 2008
762
 How many freelists will be allocated when you create a segment?
     -By: soku on Sep 19, 2008
662
 How can we specify automatic space management for a tablespace?
     -By: soku on Sep 19, 2008
703
 Which view is available to see the header information of a datafile?
     -By: soku on Sep 19, 2008
728
 Can I manage the space with in a segment automatically?
     -By: soku on Sep 19, 2008
561
 Can we allocate an extent in a specific datafile for a segment in a tablespace?
     -By: soku on Sep 19, 2008
601
 Write a query to show the details of storage information of segments created?
     -By: soku on Sep 19, 2008
614
 Can a tablespace be coalesced manually?
     -By: soku on Sep 19, 2008
705
 Where can the free space information for tablespaces be found?
     -By: soku on Sep 18, 2008
672
 What are the views available to see the information about default storage parameters of segments, datafiles and tablespaces etc?
     -By: soku on Sep 18, 2008
559
 List different types of extent management?
     -By: soku on Sep 18, 2008
697
 Can a segment span across multiple tablespaces?
     -By: soku on Sep 18, 2008
597
 What are the default storage parameters when a new tablespace is created?
     -By: soku on Sep 18, 2008
621
 Try to change a tablesapce to temporary, which already has some tables?
     -By: soku on Sep 18, 2008
578
 Try to create table in temporary tablespace whose contents are permanent?
     -By: soku on Sep 18, 2008
567
 When extents are allocated to a temporary segment in a temporary tablespce, which defalut storage parameter determines the size of the additional extent allocated?
     -By: soku on Sep 18, 2008
530
 What size should INITIAL and NEXT be when defining default storage for a temporarytablespace?
     -By: soku on Sep 18, 2008
556
 What is :ON COMMIT DELETE ROWS"?
     -By: soku on Sep 18, 2008
645
 Create a temporary segment in tablespace user_data using uniform extent sizes of 10kb?
     -By: soku on Sep 18, 2008
519
 How is unused space released from a table?
     -By: soku on Sep 18, 2008
660
 Can I drop the default temporary tablespace?
     -By: soku on Sep 18, 2008
615
 How are the extents allocated manually to a table?
     -By: soku on Sep 18, 2008
557
 Try to add the constraints to a temporary table?
     -By: soku on Sep 18, 2008
556
 How can the constraints be disabled?
     -By: soku on Sep 18, 2008
562
 What are the different available data types?
     -By: soku on Sep 18, 2008
588
 Which views are available to get the information about temporary segments?
     -By: soku on Sep 18, 2008
528
 Can Indexes and views be created on temporary segments?
     -By: soku on Sep 18, 2008
550
 Try to create the temporary segment?
     -By: soku on Sep 18, 2008
501
 Purge all the objects in recyle bin in the tablespace USERS?
     -By: soku on Sep 18, 2008
536
 Can I purge only the recyle bin for a particular user in given tablespace?
     -By: soku on Sep 18, 2008
509
 What are the options of FLASHBACK TABLE?
     -By: soku on Sep 18, 2008
592
 Explore the view v$UNDOSTAT.
     -By: soku on Sep 18, 2008
556
 Explore the view DBA_UNDO_EXTENTS.
     -By: soku on Sep 18, 2008
530
 Can flashback query results be seen from different sessions?
     -By: soku on Sep 18, 2008
527
 Which package is used to perform the the flashback query operations?
     -By: soku on Sep 18, 2008
540
 Can I use flashback querry for DDL operations?
     -By: soku on Sep 18, 2008
545
 What is the default value for UNDO_RETENTION?
     -By: soku on Sep 18, 2008
590
 Find out different views for undo management?
     -By: soku on Sep 18, 2008
524
 Can I assign new undo tablespace to the instance?
     -By: soku on Sep 18, 2008
483
 What is the segment type for the undo segments created in an Undo Tablespace?
     -By: soku on Sep 18, 2008
512
 Can I create undo tablespace at the time of database creation?
     -By: soku on Sep 18, 2008
484
 Try creating a rollback segment in Undo tablespace?
     -By: soku on Sep 18, 2008
497
 How do i set the Instance in auotmatic Undo management Mode?
     -By: soku on Sep 18, 2008
480
 Can I use both undo tablespace and rollback segments in a database?
     -By: soku on Sep 18, 2008
508
 How can a role will be granted to a user?
     -By: soku on Sep 18, 2008
528
 What are the different types of privileges?
     -By: soku on Sep 18, 2008
554
 What are the views available to see the information about profiles?
     -By: soku on Sep 18, 2008
476
 How can a profile be assigned to a user?
     -By: soku on Sep 18, 2008
487
 How can a user`s account be locked?
     -By: soku on Sep 18, 2008
557
 In USER_TS_QUOTAS what does "-1" indicate?
     -By: soku on Sep 18, 2008
581
 Is it possible to have quota on different tablespaces for a user?
     -By: soku on Sep 18, 2008
496
 which views are available to see the user infromation?
     -By: soku on Sep 18, 2008
500
 How can a user be dropped?
     -By: soku on Sep 18, 2008
538
 Try to create a user with OS authentication?
     -By: soku on Sep 18, 2008
566
 Which view is available to see the quotas assigned to a user?
     -By: soku on Sep 18, 2008
487
 What are default privileges available to a user?
     -By: soku on Sep 18, 2008
517
 Can a user change his/her own password?
     -By: soku on Sep 18, 2008
523
 Which is the default tablespace that is assigned to a new user when created?
     -By: soku on Sep 18, 2008
492
 Can you assign a same name to data files of two different tablespaces?
     -By: soku on Sep 18, 2008
510
 How can a new data file be added to a tablespace?
     -By: soku on Sep 18, 2008
481
 Can you decrease the data file size,when it contains data more than the specified size?
     -By: soku on Sep 18, 2008
497
 Can I drop the default temporary tablespace?
     -By: soku on Sep 18, 2008
506
 Can objects be dropped when tablespace is in offline mode?
     -By: soku on Sep 18, 2008
503
 How can I get the information about all data files in database?
     -By: soku on Sep 18, 2008
488
 How can you obtain the tablespace information?
     -By: soku on Sep 18, 2008
470
 Check out extent management for tablespace after creation
     -By: soku on Sep 18, 2008
457
 How is automatic extension of data files enabled?
     -By: soku on Sep 18, 2008
468
 How to alter a tablespace in READ ONLY mode?
     -By: soku on Sep 18, 2008
485
 Can a tablespace be renamed?
     -By: soku on Sep 18, 2008
544
 Try to create temporary tablespaces with all possible options?
     -By: soku on Sep 18, 2008
488
 What happens when u make a tablespace offline immediate?
     -By: soku on Sep 18, 2008
512
 How to create the tablespaces with different database block sizes?
     -By: soku on Sep 18, 2008
475
 Can permanent objects be created in a Tenporary tablespace?
     -By: soku on Sep 18, 2008
479
 Can SYSTEM and SYSAUX tablespaces be taken OFFLINE?
     -By: soku on Sep 18, 2008
589
 What type of information will be available in udump,cdump and bdump destinations?
     -By: soku on Sep 16, 2008
563
 What happens when u try to start the database with out control files?
     -By: soku on Sep 16, 2008
531
 How can we start the database using pfile, which is not in a default directory?
     -By: soku on Sep 16, 2008
493
 How do u see the background process at the DB level?
     -By: soku on Sep 16, 2008
542
 How to create the default permanent tablespace for the database?
     -By: soku on Sep 16, 2008
518
 Can we change the instance name after creation of database?
     -By: soku on Sep 16, 2008
575
 Can the instance name and database name be different?
     -By: soku on Sep 16, 2008
554
 Can we change the database block size after the database creation?
     -By: soku on Sep 16, 2008
508
 Which tablespace is default for non-essential schema objects?
     -By: soku on Sep 16, 2008
487
 Display the oracle version.
     -By: soku on Sep 16, 2008
577
 Identify the name and size of the data files, online redolog files and control files
     -By: soku on Sep 16, 2008
490
 Can u take backup of datafiles and archivelog files in one shot?
     -By: soku on Sep 16, 2008
556
 Try to make complete recovery through RMAN?
     -By: soku on Sep 16, 2008
532
 How many types of backups can you do by using RMAN?
     -By: soku on Sep 16, 2008
638
 Try to unregister the database?
     -By: soku on Sep 16, 2008
539
 How to see background process while taking backup through RMAN?
     -By: soku on Sep 16, 2008
571
 While taking backup through RMAN, What does %d,%t,%s,%p,%u indicate?
     -By: soku on Sep 16, 2008
543
 If an object is lost. Can you recover it through RMAN?
     -By: soku on Sep 16, 2008
560
 If a datafile is lost in a tablespace. How can you recover it?
     -By: soku on Sep 16, 2008
574
 which of the view is used for RMAN performance monitoring?
     -By: soku on Sep 16, 2008
580
 Can you duplex the backup copies in RMAN?
     -By: soku on Sep 16, 2008
542
 How to find out the configuration of RMAN using SHOW ALL?
     -By: soku on Sep 16, 2008
486
 How to find out the configuration of RMAN using SHOW ALL?
     -By: soku on Sep 16, 2008
475
 What does the list backup command do?
     -By: soku on Sep 16, 2008
528
 Can we take the backup and restore of control file automatically using RMAN without synchronizing the catalog?
     -By: soku on Sep 16, 2008
505
 is it possible to take an incremental backup through RMAN?
     -By: soku on Sep 16, 2008
466
 What are the views available to see the information about RMAN?
     -By: soku on Sep 16, 2008
455
 How to display and set the ORACLE_SID and ORACLE_HOME in UNIX?
     -By: soku on Sep 15, 2008
537
 How to display and set the ORACLE_SID and ORACLE_HOME in UNIX?
     -By: soku on Sep 15, 2008
507
 How to kill the user session?
     -By: soku on Sep 15, 2008
536
 Syntax and Explain startup process? Syntax and Explain shutdown process?
     -By: soku on Sep 15, 2008
471
 How many primary keys are in table?
     -By: soku on Sep 15, 2008
529
 what is consistent Read?
     -By: soku on Sep 15, 2008
535
 What is oratab file? Where it is use?
     -By: soku on Sep 15, 2008
583
 Explain the explain plan?
     -By: soku on Sep 15, 2008
574
 What is the purpose of DBLink?
     -By: soku on Sep 15, 2008
570
 How to show which background process are start when the Oracle server start in Linux?
     -By: soku on Sep 15, 2008
505
 Why did you use TOAD?
     -By: soku on Sep 15, 2008
603
 What is crontab?
     -By: soku on Sep 15, 2008
576
 what is pfile and spfile? Explain the difference between them?
     -By: soku on Sep 15, 2008
519
 How to show the tablespace size?
     -By: soku on Sep 15, 2008
492
 How to export the full database?
     -By: soku on Sep 15, 2008
528
 How to tune the database?
     -By: soku on Sep 15, 2008
568
 How to show the size of the database?
     -By: soku on Sep 15, 2008
533
 How to show the which users are connected to database?
     -By: soku on Sep 15, 2008
531
 Is there any scenario for Hot Backup? If there Please Explain
     -By: soku on Sep 15, 2008
513
 Explain the Index Architecture?
     -By: soku on Sep 15, 2008
550
 Why partitioning?
     -By: soku on Sep 15, 2008
496
 How to connect the Remote database server that is located at another location?
     -By: soku on Sep 15, 2008
497
 Suppose DBWR is not working, How to identify?
     -By: soku on Sep 15, 2008
605
 what are 20 new features of Oracle compare to 9i?
     -By: soku on Sep 15, 2008
511
 How to SQL Tuning?Explian Steps
     -By: prash on Sep 12, 2008
641
 How to take a Backup on tape in RMAN?
     -By: prash on Sep 11, 2008
581
 Hi siva, Could u please provide the ANSWERS for ur interview qns which were posted on AUG-09, 2008?
     -By: radhu on Sep 11, 2008
523
 Hi All, i have query with me for any DBA(Sybase), my question is how to fine out the top 10 max size used tables in a database(sybase). i know that by using sp_spaceused <table_name>.we c
     -By: sree on Aug 31, 2008
522
 As here we are getting DBA interview question , can any say from where i cant get in same way PL/SQL interview question
     -By: rame on Aug 30, 2008
528
 Hi, this is praveen, select 1 from dual union select 'a' from dual please give the answer
     -By: praveen on Aug 28, 2008
549
 One user say I am not connected to Database, but other user connected to database. How is DBA resolve this problem?
     -By: prash on Aug 27, 2008
676
 exp username/password@tnsname exp=filename.dmp owner=ownername imp=filename.log imp username/password@tnsname exp=filename.dmp fromuser=name touser=name imp=filename.log
     -By: jagari on Aug 27, 2008
503
 startup normal or startup
     -By: jagari on Aug 27, 2008
583
 What U mean by snapshot in oracle?
     -By: Pundaleek.C on Aug 25, 2008
726
 how many groups max number of redolog can oracle 9i & 10g can have at a time?
     -By: parox on Aug 20, 2008
725
 What is the difference between sysdate & distinct sysdate. if i use select sysdate from dual will show current date & time.& select distinct sysdate from dual will show current date &am
     -By: rk on Aug 20, 2008
642
 How to calculate the size of DB_BLOCK_SIZE, DB_BLOCK_BUFFERS, SHARED_POOL_SIZE and SORT_AREA_SIZE these parameters in creation of 8K & 16K Database?
     -By: Pundaleek.C on Aug 16, 2008
732
 i am performing hot backup when i keep the tablespace in begin backup mode excesss of redo is more? i want to know why the generation of redologs are more?plz post the answer.
     -By: yaazdani on Aug 16, 2008
663
 which file is excuted first when the system start?
     -By: on Aug 16, 2008
886
 which file is executed file when the system start
     -By: on Aug 16, 2008
582
 Accidentally pfile delete and haven’t spfile. I don’t have pfile backup also. How can recover pfile?
     -By: prash on Aug 14, 2008
785
 catalalog database corrupted,no backup.How ill you recover?
     -By: siva on Aug 13, 2008
789
 Snapshot old error occurs rarely, Increase undo & undo ret time isn't a good idea for rare appearance of this error.How ill u solve this?
     -By: siva on Aug 10, 2008
655
 Anyone reply this urgent interview quest,In production database emp table is dropped,u know this after 1 hour,How ill u recover this emp table? database in archive mode.
     -By: siva on Aug 10, 2008
760
 In statspack report,the physical read is High,how ill you solve?
     -By: siva on Aug 10, 2008
672
 How to recover Read-only tablespace datafiles?
     -By: siva on Aug 09, 2008
669
 during database startup,all mandatory background process started in which order?
     -By: siva on Aug 09, 2008
675
 hi dear frds,anyone tell me what is the pre-requirement of installing oracle 9i on linux?
     -By: siva on Aug 08, 2008
581
 During the installation,login root user and set kernel para. It is possible to login oracle user without shut down?
     -By: siva on Aug 08, 2008
576
 hi dear frds,How ill you determined the column(eg:emp_id) availaible in the particular partioning?
     -By: siva on Aug 08, 2008
508
 what is the difference between TOAD and MATERIALIZED VIEW?
     -By: siva on Aug 08, 2008
631
 DBAPOOL frds,how ill you determined migrated rows? & chained rows?
     -By: siva on Aug 08, 2008
522
 hi dear frds,what is the maximum number of undo segments created in undo tablespace?
     -By: siva on Aug 08, 2008
548
 DBAPOOL frds,this is frequent int.question:Existing users fine, New user's can't connect to the database,why?(listener,maxuser is not a problem)(oracle 9i db)
     -By: siva on Aug 08, 2008
536
 hi dbapool frds,what is semapores & semapore=1000 what ill happen?
     -By: siva on Aug 08, 2008
528
 In the scenario,you get the error in unable to extend in non-system tablespace,ther is no space in disk and datafile size reached 2gb,hoe to resolve this(oracle 9i db)
     -By: siva on Aug 08, 2008
544
 i know the use of nid,but i dont know in which situation we ill change the dbname and dbid?
     -By: siva on Aug 08, 2008
528
 hi dbapool frds,during database startup which backround process run first?why?
     -By: siva on Aug 08, 2008
517
 hi frds,i faced this int.question,how ill u enable archivemode without downtime?(except session level)
     -By: siva on Aug 08, 2008
581
 Using top command show more cpu utilization,how ill u determined which user process cause this?
     -By: siva on Aug 08, 2008
575
 how ill you see all databases names in the server? (ps -ef|grep pmon) only show the database names which instance started.
     -By: siva on Aug 08, 2008
556
 1.anyone changed the listener location,whether its affect the database or not? 2.I have 8x,9x,10x home in server,it is possible to use single listener for all the 3 home's?
     -By: siva on Aug 08, 2008
531
 I faced these int.questions 1.Database is hang due to archive location 100% filled,what is the immediate solution? 2.Datafile disk corrupted,how ill you recover these datafiles?
     -By: siva on Aug 08, 2008
560
 1.Having 4 controlfiles,one of the controlfile size is increased,why?
     -By: siva on Aug 08, 2008
630
 Suppose yesterday users fire query that time data retrieve faster but today users fire query data retrieval very slow. How resolve this problem? Plz explain this was asking me in an Interview question
     -By: prash on Aug 06, 2008
664
 Hello Frnds, My UNDO Tablespace size extended to 10 gb & Temp Tablespace size extended to 9GB. why that is extended to that much & plz give me the script to reset the tablespace size
     -By: Pundaleek.C on Aug 02, 2008
586
 if my archieve denstination is full what to do?
     -By: mummy on Jul 31, 2008
737
 how to check the how many users are connected? at os(linux) level?
     -By: mummy on Jul 31, 2008
701
 how to i change locally managed tablspace to dictionary mgmt tbs? give the syntax
     -By: abdul on Jul 28, 2008
696
 how to i find out which undo is in active state?give the syntax
     -By: abdul on Jul 28, 2008
628
 Is there is a possibilities to drop a datafile n oracle 9i?if it means give me the syntax
     -By: abdul on Jul 28, 2008
560
 how to i trace out which table in which datafile?plz..give me the solution in detail..
     -By: abdul on Jul 28, 2008
605
 What are the steps for Migration from 9i to 10g Oracle DB?
     -By: prash on Jul 28, 2008
679
 is it adding the another datafile or resize the exsisting datafile? waht is advisable? and how to resize the datafile?
     -By: mummy on Jul 28, 2008
516
 how to lock the table in oracle?plz give me the syntax..
     -By: abdul on Jul 28, 2008
665
 how to add the datafile?
     -By: mummy on Jul 28, 2008
568
 how to findout the redolog file size?if relog files are completely filledup what we've to do?
     -By: mummy on Jul 28, 2008
564
 Hi All, Compare Oracle to any other database that you know. Why would you prefer to work on one and not on the other?
     -By: hari on Jul 24, 2008
565
 Hi experts, could u any one tell me about exact meaning of "Grid computing" in oracle10g. when we will used in realtime Environement.
     -By: hari on Jul 24, 2008
603
 What is difference between catalog and nocatalog in rman?
     -By: prash on Jul 24, 2008
687
 Suppose one user say I'm not connected to application i.e. SAP or Oracle Apps ERP that time what should I check as DBA.
     -By: prash on Jul 23, 2008
575
 What is Jinitiator when it activates?what ar jar files,class files? BY SYED AHMED ZAMA
     -By: yaazdani on Jul 23, 2008
511
 HOW TO MONITOR DATABASE SIZE AT WHAT SITUATION WE SHOULD INCREASE THE DATABASE SIZE?INERVIEW QUEST BY SYED AHMED ZAMA
     -By: yaazdani on Jul 23, 2008
628
 WHAT IS SQL ENGINE?ANYBODY DESCRIBE THE FLOW OF QUERY WITH THE HELP OF ARCHITECTURE
     -By: yaazdani on Jul 23, 2008
549
 what is balance loader how it perform?wht are the steps to implement it BY SYED AHMED ZAMA
     -By: yaazdani on Jul 23, 2008
520
 what is fixed sga how can u define it?its an interview question by SYED AHMED ZAMA
     -By: yaazdani on Jul 23, 2008
585
 how can we do performance tuning how many types of tuning are there being a dba what precautions should be taken
     -By: yaazdani on Jul 23, 2008
575
 Suppose user not connected to database what is solution for that?
     -By: prash on Jul 22, 2008
639
 one user want to connect 4 database how can he connect
     -By: pattu on Jul 18, 2008
722
 In oracle9i which script is executed when databse is mounted?????
     -By: shilpa on Jul 14, 2008
792
 what is the command to see all the users
     -By: 3628800 on Jul 12, 2008
865
 hi all, please help in solving this issue i am performing db cloning through rman manually for the first time i succesfully clone the db for the second time onward i am getting following error.
     -By: ruhisdba on Jul 09, 2008
692
 
     -By: imran on Jul 08, 2008
499
 I have three controlfiles in my database,one of the controlfile is corrupted during database is in functional, suddenly my database is shutdown,during next startup oracle send me the error,i have th
     -By: imran on Jul 08, 2008
761
 I have three controlfiles in my database,one of the controlfile is corrupted during database is in functional, suddenly my database is shutdown,during next startup oracle send me the error,i have th
     -By: imran on Jul 08, 2008
579
 I want to search and delete a text file on Liunx and Unix in one command what is that command? This question asked me in an Interview.
     -By: prash on Jul 08, 2008
663
 How would you check that standby database is running fine and currently synched with primary database??
     -By: balaji on Jul 04, 2008
752
 how to install the oracle9i on redhot unix machine?
     -By: mummy on Jul 03, 2008
679
 In which dictionary table OR sql script the oracle error code resides ? In which path i get it
     -By: rk on Jul 03, 2008
653
 how to run the script at os(linux) level means which cmd is used to run the script?
     -By: mummy on Jun 29, 2008
656
 how to findout database is running or not at os level?i am working at lunix machine..Pl..give me ansr?
     -By: mummy on Jun 29, 2008
674
 
     -By: sambasiva on Jun 28, 2008
483
 What is difference between Oracle9i and Oracle10g?
     -By: prash on Jun 26, 2008
1071
 What is merging a partition?
     -By: positive on Jun 26, 2008
719
 What is splitting a partition?
     -By: positive on Jun 26, 2008
621
 Where do you find information about partitioned tables?
     -By: positive on Jun 26, 2008
674
 What are the various stages while processing a SQL statement?
     -By: positive on Jun 26, 2008
664
 Can a user created new connect to the database?
     -By: positive on Jun 26, 2008
645
 What is fine-grained access control?
     -By: positive on Jun 26, 2008
658
 What are the uses of fine-grained access control?
     -By: positive on Jun 26, 2008
572
 What is needed to create a VPD?
     -By: positive on Jun 26, 2008
630
 What is Oracle Database Vault?
     -By: positive on Jun 26, 2008
668
 How is the performance of disk group comparable to raw disks?/Are disk groups a good alternative to raw disks? The files distributed across the set of disks in a disk group are striped or distribut
     -By: positive on Jun 26, 2008
533
 
     -By: ravi on Jun 24, 2008
452
 can we use resetlogs after full recovery?
     -By: geet on Jun 22, 2008
785
 How to find the size of an Index ?
     -By: rk on Jun 22, 2008
824
 Suppose only one Control file in my database, if it is corrupted how to recover it ?
     -By: rk on Jun 22, 2008
777
 What is MTTR,MTBF and PGA_ARRREGATE_TARGET_SIZE ?
     -By: rk on Jun 19, 2008
682
 How do u split the dump file into many file each of 2GB size ?
     -By: rk on Jun 19, 2008
690
 Can we resize Sys datafile during db is up and running ?
     -By: rk on Jun 19, 2008
735
 What is Soft parse and Hard Parse ?
     -By: rk on Jun 19, 2008
777
 One user has to connect 4 databases, how do you connect ?
     -By: rk on Jun 19, 2008
697
 While Exporting data, corrupted block will also exported or not ? what it will show error
     -By: rk on Jun 18, 2008
680
 How to resize System Global Area (SGA_MAX_SIZE) ?
     -By: rk on Jun 18, 2008
729
 after cloning what about dbid and db name?
     -By: Reddy on Jun 18, 2008
704
 what is incarnation of databse?
     -By: Reddy on Jun 18, 2008
713
 
     -By: joe on Jun 16, 2008
461
 
     -By: joe on Jun 16, 2008
476
 what are the daily activities for 1 year Experienced Oracle 10g DBA
     -By: Shahid on Jun 15, 2008
880
 can any one tell me how to see answer of interview question? so I can verify my answer right or wrong .
     -By: poorni on Jun 13, 2008
686
 how i can create a clone database?
     -By: bandhu on Jun 08, 2008
831
 IN oracle 8i temp table always show high water mark level ? can we Coalesce it ?
     -By: jay on Jun 07, 2008
636
 can any one tell me how to see answer of interview question? so I can verify my answer right or wrong .
     -By: jay on Jun 07, 2008
591
 What is difference between schema and user ?
     -By: rk on Jun 05, 2008
872
 How you are taking Control file Hot back up ? plz give me steps
     -By: rk on Jun 04, 2008
720
 If control file is corrupted then how you will recover it ? plz give me the steps. (dont give recreating control file steps)
     -By: rk on Jun 04, 2008
691
 What is the significance of incarnation and DBID in the RMAN backups ? What are the steps which needs to be performed in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library
     -By: shanthi on Jun 01, 2008
678
 What is configure command ? When do you use this ? Give me the steps for setting up the physical stand by database with RMAN ? Give me the steps for changing the DBID in a cloned environment ?
     -By: shanthi on Jun 01, 2008
589
 What is the difference between cumulative incremental and differential incremental backups ? How do you enable the autobackup for the controlfile using RMAN ?
     -By: shanthi on Jun 01, 2008
631
 How do you verify the integrity of the image copy in RMAN environment ? How do you enable the encryption for RMAN backups ? What is backup set ?
     -By: shanthi on Jun 01, 2008
551
 List atleast 6 advantages of RMAN backups compare to traditional hot backups ? How do you identikit the block corruption in RMAN database ? How do you fix this ?
     -By: shanthi on Jun 01, 2008
620
 Give me some of the RMAN catalog view names which contains the catalog information ? What is oracle wallet ? Tell me about the encryption options available with RMAN ?
     -By: shanthi on Jun 01, 2008
557
 Give me some of the RMAN catalog view names which contains the catalog information ? What is oracle wallet ? Tell me about the encryption options available with RMAN ?
     -By: shanthi on Jun 01, 2008
517
 What is auxiliary channel in RMAN? When do you need this ? How do you identify what are the all the target databases that are being backed-up with RMAN database ? Give me some of the RMAN catalog
     -By: shanthi on Jun 01, 2008
542
 How do you identify the expired,active,obsolete backups ? Which RMAN command you use ? What is channel ? How do you enable the parallel backups with RMAN ? What is auxiliary channel in RMAN? When
     -By: shanthi on Jun 01, 2008
573
 What is FRA ? When do you use this ? How do you clone the database using RMAN software ? Give me the brief steps ? when do you use crosscheck command ? How do you setup the RMAN tape backups ?
     -By: shanthi on Jun 01, 2008
540
 What is recovery catalog ? Why do you need this ? How do you install the RMAN recovery catalog ? Can you skip specific tables when using RMAN DUPLICATE feature ?
     -By: shanthi on Jun 01, 2008
584
 Tell me about the steps required to enable the RMAN backup for a target database ? What is the difference between obsolete RMAN backups and expired RMAN backups ?
     -By: shanthi on Jun 01, 2008
532
 What is db_recovery_file_dest ? When do you need to set this value ? Give me the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the db ?
     -By: shanthi on Jun 01, 2008
531
 Give me the steps for recovery with missing online redo logs? Give me the steps for recovery of missing data file? Give me the steps for physical standby database creation?
     -By: shanthi on Jun 01, 2008
581
 Give me the steps for CANCEL based recovery from the full database from hot backup. ? Give me the steps for recovery with missing archived redo logs? Give me the steps for recovery with missing on
     -By: shanthi on Jun 01, 2008
519
 Give me the steps for TIME based recovery from the full database from hot backup. ? Give me the steps for SCN based recovery from the full database from hot backup. ?
     -By: shanthi on Jun 01, 2008
534
 When do you recommend hot backup? What are the pre-reqs? How do you generate the begin backup script? Give me the steps for recovering the full database from cold backup?
     -By: shanthi on Jun 01, 2008
543
 What is RAID? What is RAID0? What is RAID1? What is RAID 10? What is the difference between physical and logical backups?
     -By: shanthi on Jun 01, 2008
585
 What are things which play major role in designing the backup strategy? What are RTO, MTBF, and MTTR? What are the various tape backup solutions available in the market
     -By: shanthi on Jun 01, 2008
537
 19. Can you take Image Backups using RMAN? 20. Can you use Backupsets created by RMAN with any other utility?
     -By: shanthi on Jun 01, 2008
535
 16. What is a Recovery Catalog? 17. Should you place Recovery Catalog in the Same DB? 18. Can you use RMAN without Recovery catalog?
     -By: shanthi on Jun 01, 2008
539
 41. Have you faced any emergency situation. Tell us how you resolved it? 42. At one time you lost parameter file accidentally and you don't have any backup. How you will recreate a new parameter file
     -By: shanthi on Jun 01, 2008
571
 40. Some datafiles were there on a secondary disk and that disk has become damaged and it will take some days to get a new disk. How will you recover from this situation? 41. Have you faced any emerg
     -By: shanthi on Jun 01, 2008
529
 38. How do you recover from the loss of a controlfile if you have backup of controlfile? 39. Only some blocks are damaged in a datafile. Can you just recover these blocks if you are using RMAN?
     -By: shanthi on Jun 01, 2008
584
 37. A database is running in ARCHIVELOG mode since last one month. A datafile is added to the database last week. Many objects are created in this datafile. After one week this datafile gets damaged b
     -By: shanthi on Jun 01, 2008
575
 36. Do you have to restore Datafiles manually from backups if you are doing recovery using RMAN?
     -By: shanthi on Jun 01, 2008
567
 34. What is Cancel Based, Time based and Change Based Recovery? 35. Some user has accidentally dropped one table and you realize this after two days. Can you recover this table if the DB is running
     -By: shanthi on Jun 01, 2008
559
 31. You loss controlfile how do you recover from this? 32. The current logfile gets damaged. What you can do now? 33. What is a Complete Recovery?
     -By: shanthi on Jun 01, 2008
525
 30. You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you re
     -By: shanthi on Jun 01, 2008
556
 29. How do you recover from the loss of datafile if the DB is running in ARCHIVELOG mode?
     -By: shanthi on Jun 01, 2008
554
 28. You lost some datafiles and you don't have any full backup and the database was running in NOARCHIVELOG mode. What you can do now? 29. How do you recover from the loss of datafile if the DB is
     -By: shanthi on Jun 01, 2008
532
 27. You loss one datafile and it does not contain important objects. The important objects are there in other datafiles which are intact. How do you proceed in this situation?
     -By: shanthi on Jun 01, 2008
542
 25. Can you start and shutdown DB using RMAN? 26. How do you recover from the loss of datafile if the DB is running in NOARCHIVELOG mode?
     -By: shanthi on Jun 01, 2008
511
 . You want to retain only last 3 backups of datafiles. How do you go for it in RMAN? 24. Which is more efficient Incremental Backups using RMAN or Incremental Export? 25. Can you start and shutd
     -By: shanthi on Jun 01, 2008
532
 Where RMAN keeps information of backups if you are using RMAN without Catalog? 22. You have taken a manual backup of a datafile using o/s. How RMAN will know about it? 23. You want to retain only
     -By: shanthi on Jun 01, 2008
501
 13. How RMAN improves backup time? 14. Can you take Offline backups using RMAN? 15. How do you see information about backups in RMAN? 21. Where RMAN keeps information of backups if you are using
     -By: shanthi on Jun 01, 2008
525
 10. Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode? 11. Why do you take tablespaces in Backup mode? 12. What is the advantage of RMAN utility
     -By: shanthi on Jun 01, 2008
510
 7. Where should you place Archive logfiles, in the same disk where DB is or another disk? 8. Can you take online backup of a Control file if yes, how? 9. What is a Logical Backup?
     -By: shanthi on Jun 01, 2008
515
 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
     -By: shanthi on Jun 01, 2008
517
 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?
     -By: shanthi on Jun 01, 2008
525
 Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running i
     -By: shanthi on Jun 01, 2008
494
 Others How does one use the import/export utilities? (for DBA) Can one resize tablespaces and data files? (for DBA) Can one monitor how fast a table is imported? Can one modify data as it loads into
     -By: shanthi on Jun 01, 2008
506
 9 how to estimate the size of SGA???? 10 What is your typical day like? 11 Do you consider yourself a development DBA or a production DBA and why? 12 Different audit Oracle & Sybase 13 setup s
     -By: shanthi on Jun 01, 2008
554
 5. What would you do when the ASE server's performance is bad ? 6. What do you do, when tempdb is full ? 7. About Replication server setup & sync ? 8- How you handle problem ticket?
     -By: shanthi on Jun 01, 2008
492
 2. What should you do when you find a stacktrace in the server errorlog ? 3. What do you do when the server can't start due to a corrupt master database ? 4. How do you BCP only a certain set of row
     -By: shanthi on Jun 01, 2008
482
 1. Explain how you would restore a database using RMAN to Point in Time? 2. How does Oracle guarantee data integrity of data changes? 3. Which environment variables are absolutely critical in order
     -By: shanthi on Jun 01, 2008
501
 Is It possible to rename the database name. If so how?
     -By: ms on May 27, 2008
744
 How do you make sure that database is Consistent state ?
     -By: rk on May 26, 2008
669
 what is the difference between the locks and latches?
     -By: mummy on May 24, 2008
679
 what is mean by sqlner.ora? pl give me the breif explanation?
     -By: mummy on May 24, 2008
603
 How to configure the 10g SGA?
     -By: mummy on May 24, 2008
647
 what is mean by alertlog file?what will maintain in alrtlog file?
     -By: mummy on May 24, 2008
581
 what are the mandatory background processers for the oracle 10g ASM?
     -By: mummy on May 24, 2008
564
 How do you check the Performance of an database during peak hours?
     -By: rk on May 24, 2008
646
 iwant to take RMAN backup..without catalogdatabase is it possible to take targetdatabase backup?If it is possible where can i store the backup of targetdatabase ?
     -By: mummy on May 22, 2008
560
 What is Database link create command? plz write steps?
     -By: prash on May 22, 2008
607
 what is the purpose of MAXLOGHISTORY ?
     -By: kumar on May 21, 2008
606
 what is a profile?
     -By: prash on May 21, 2008
590
 What is a Database Link?
     -By: prash on May 21, 2008
600
 what are the Configuration parameters in RMAN backup?
     -By: mummy on May 19, 2008
639
 what is mean by MRM in DATAGAURD? why we put int MRM? When we put in MRM? tell me indetail.....
     -By: mummy on May 19, 2008
719
 what are the major differences between physical standby and logical standby?
     -By: mummy on May 19, 2008
619
 How many Standby databases are there? what are they?
     -By: mummy on May 19, 2008
601
 How will you maximizing SQL*Loder performance
     -By: robin on May 16, 2008
667
 is there any other option to re-organise the DB except exp/imp ?
     -By: mummy on May 14, 2008
657
 why we are rebuilding the indexes?
     -By: mummy on May 14, 2008
743
 what is mean by fragmentation?
     -By: mummy on May 14, 2008
726
 In Form 6i How Can U Use Bultings "OHOST" & "OS_COMMAND" Pl.Reply Me. With Example
     -By: rk on May 13, 2008
553
 what is the best option of starting a dbase.
     -By: frankky on May 13, 2008
655
 What is the basic function of glogin.sql file.
     -By: robin on May 13, 2008
582
 explain about segment space management
     -By: suri on May 12, 2008
666
 plz send me the syntax of IMPORT and Export comand in oracle 9i
     -By: khubeb on May 08, 2008
640
 If I issue the SQL query in Oracle Database what happen in SGA?
     -By: prash on May 08, 2008
727
 i had created a user 'u1' and grant it by connect/resource, then i want to select the table emp scott..select * from scott.emp; error: ORA 0942 table or view does not exist.
     -By: khubeb on May 07, 2008
600
 what is the procedure for taking RMAN cold backup ?
     -By: rk on Apr 30, 2008
826
 Which is the path of ORATAB file? we can edit manually ?
     -By: rk on Apr 30, 2008
764
 what is Rule Based Optimizer and Cost Based Optimizer?
     -By: bobby on Apr 29, 2008
752
 What is lock ? How many types of locks are there ?
     -By: rk on Apr 22, 2008
931
 what are the modes of optimizer?
     -By: rk on Apr 22, 2008
771
 what is isolation in oracle?
     -By: rk on Apr 22, 2008
788
 While the database is up and running can we kill smon?If i kill SMON what happens?
     -By: rk on Apr 22, 2008
873
 The tablespace in begin backup mode can we do DML operations and what happend on that time ?
     -By: rk on Apr 22, 2008
705
 how many user are connected in my database and which is running applicatin how can i see.
     -By: skumar,bihar on Apr 21, 2008
791
 what is diff between scn and checkpoints.
     -By: skumar,bihar on Apr 21, 2008
838
 what is diff between dict. managed tablespace and locally managed tablespaces.
     -By: skumar,bihar on Apr 21, 2008
700
 When querying the dba_undo_extents i found huge no. of extents in UNEXPIRED STATUS. What does it mean. I hope this extents are having UNDO DATA for a completed transaction. How can i get those extents
     -By: Mr.Doubt on Apr 18, 2008
661
 If Redolog misses in a db what will happen ? the db is running in archive or No archive log mode.
     -By: rk on Apr 12, 2008
734
 how to take a backup of database through rman could u tell me or mail me on my mail id Thanks, Manoj
     -By: manoj on Apr 11, 2008
696
 em it gives the so many error messages. May I to create the User tablespace in the importing system?
     -By: Pundaleek.C on Apr 09, 2008
621
 I have exported FULL Backup & before exporting I also given the following grant option to the exporting user GRANT EXP_FULL_DATABASE TO SCOTT; When I am importing the full backup in another sys
     -By: Pundaleek.C on Apr 09, 2008
615
 What is grid computing?
     -By: Ratnaker on Apr 08, 2008
832
 What is materialized view?
     -By: bobby on Apr 07, 2008
852
 How would you eliminate row migration and row chaining?
     -By: bobby on Apr 07, 2008
1683
 I Have an a one table which contains lots of records (i.e, 1,45,084 records), whenever I try to update some of columns on that table it takes lots time for bulk records (means more than 10 reocrds). W
     -By: Pundaleek.C on Apr 01, 2008
757
 How to clone a database from hotbackup/rman ?
     -By: Sarfaraz Karim on Mar 26, 2008
832
 i hav got only passing score in the iz007 oracle first paper. should i take test again to improve my score or not
     -By: vij on Mar 24, 2008
669
 server process
     -By: skumar,bihar on Mar 22, 2008
754
 suppose my table name is emp. in this table 10 rows will be same. i would like 1 row will be update & 9 rows will be deleted from table. pl tell me argently.
     -By: rehan on Mar 17, 2008
867
 suppose my table name is emp. in this table 10 rows will be same. i would like 1 row will be update & 9 rows will be deleted from table. pl tell me argently.
     -By: rehan on Mar 17, 2008
725
 Which BACKGROUND PROCESS is read from datafiles?
     -By: Harihar on Mar 14, 2008
974
 Is it possible to carry export and import on standby database ?
     -By: Bala on Mar 03, 2008
1036
 How can we see the DB instance startup time?
     -By: Bala on Mar 02, 2008
1077
 How can we get data from oracle into excel spreadsheet ?
     -By: Bala on Mar 02, 2008
984
 Please provide me simple and correct steps to rename a database instance. Thanks in advance.
     -By: Bala on Mar 02, 2008
922
 Can we create synonyms on materialized view and normal view
     -By: Passion@ora on Feb 29, 2008
827
 I have two same hot backup of one tablespace , one is taken using usermanaged method and cataloged in RMAN, other is taken by RMAN. While recovery which one will be used?
     -By: Passion@ora on Feb 29, 2008
756
 How to clone 24 X 7 databases? I have one 24 X 7 database, without closing this database can I clone it.
     -By: Passion@ora on Feb 29, 2008
807
 what is derived artificial primary key and how it is set??
     -By: Passion@ora on Feb 29, 2008
707
 If the DBWR writes modified blocks to datafiles which Process pull data ?
     -By: Passion@ora on Feb 28, 2008
840
 How can we clone a Database without creating the text based control file ?
     -By: Passion@ora on Feb 28, 2008
803
 how many index's can be created on a single table?
     -By: Pundaleek.C on Feb 28, 2008
1001
 If you provide more information will help us to answer to better.
     -By: Mohammed Taj on Feb 24, 2008
669
  How to check since when our database is up without login into Oracle? you can't check without login but you can check oracle services at system level. 2. Significance of SGA_TARGET & SGA_MAX
     -By: Mohammed Taj on Feb 24, 2008
769
 I Need Some Question's Ans: - 1. How to check since when our database is up without login into Oracle? 2. Significance of SGA_TARGET & SGA_MAX_SIZE. 3. You are given a datafile, how to f
     -By: Monu on Feb 23, 2008
749
 hi, i want to install oracle 10g on redhat 4 but iam unable to complete it succesfully bcoz though the partitions for linux are correct the problem with the oracle installation comes for me actu
     -By: bindu on Feb 23, 2008
682
 We were using Oracle 9i on Linux RH4 platform. Recently the database has been upgraded to 10g. Oracle service is not getting started automatically after taking cold backup by running the shell script
     -By: Ammu on Feb 23, 2008
653
 Hi guru's i want to create a non-partitioned table from a huge partitioned table, in a step by step manner, if you know any doc which shows please let me know. Thanks in advance
     -By: chandu on Feb 13, 2008
779
 what is PRAGMA AUTONOMOUS TRANSACTION, can U give me a example?
     -By: Pundaleek.C on Feb 13, 2008
837
 what is PRAGMA AUTONOMOUS TRANSACTION, can U give me a example?
     -By: Pundaleek.C on Feb 13, 2008
904
 Assume that my database size is 800gb, then what is my SGA size? thanks prasad
     -By: jogi on Feb 06, 2008
1158
 i created an index on a large table and i want to know whether the indexes are working or not?
     -By: Pundaleek.C on Feb 05, 2008
984
 One of my tablespace has 5 datafiles.While that tablespace is in backup mode whether all the datafiles header will get freezed?Im using oracle 9i.
     -By: jothi on Jan 26, 2008
981
 insert into emp_1(empno,ename)values(100,sri_ram'); write a query all enames contains _(underscore) as one of the character
     -By: bala on Jan 23, 2008
868
 what is difference between ALL,ANY command in SQL?with examples.
     -By: bala on Jan 21, 2008
1085
 when the control will be increased?
     -By: goms on Jan 14, 2008
1054
 well if u want to get all the numbers which have 3 digits only like 100,333,221 or any number in three digit only u can use length function suppose if u want to retrieve data of all employess earning
     -By: jayesh on Jan 11, 2008
821
 specifically type the code of exam like 1zo-007 in google for better results or if u want to search in the particular site then refer to www.actualtests.com www.testking.com log on to the site and
     -By: jayesh on Jan 10, 2008
745
 sql statement>> generate all the 3-digit no from emp(scott) table ;send answer for this
     -By: bala on Jan 07, 2008
820
 sql statement>> generate all the 3-digit no;send answer for this
     -By: bala on Jan 07, 2008
785
 how can I create sequence for generating value 1,-1,1,-1....?
     -By: jayesh on Jan 07, 2008
972
 what is the purpose of dbwr?
     -By: goms on Jan 06, 2008
1036
 how to prepare for interview?
     -By: goms on Jan 04, 2008
1249
 what is incremental backup?
     -By: goms on Jan 04, 2008
1094
 what are the most frequently asked interview questions for dba?
     -By: goms on Jan 04, 2008
1241
 how to get old OCA papers?
     -By: chow on Jan 04, 2008
1098
 in oracle9i,what is meaning of i ?
     -By: balaji on Jan 04, 2008
1200
 how to get other question about sql exam of ocp
     -By: balaji on Jan 04, 2008
812
 How we will findout total size of Database
     -By: skumar,bihar on Jan 03, 2008
1223
 Tell me top five waitevents
     -By: skumar,bihar on Dec 30, 2007
1095
 What is the difference between cold and hot backup?
     -By: Shalu on Dec 23, 2007
1014
 table is having single column, can we drop column if so what will happen?
     -By: shashikant on Dec 22, 2007
1073
 What is RMAN Backup? What is NetBackup?
     -By: Amit on Dec 19, 2007
1206
 On my Database Archive Log files are generated more in the month ending time, to prevent this situation what should i do., should i incrase the redo log group, or increase the archive log destination.
     -By: Raj on Dec 19, 2007
981
 Interview Question? Q.If the user complains the the db is responding slowly. What could be the precise answer.
     -By: Maddy on Dec 16, 2007
1339
 
     -By: Maddy on Dec 16, 2007
677
 When the current redo log file is correpted, how we can check whether the correption only affected to a single member or all/how to find the correpted member?...tnx
     -By: samad on Dec 14, 2007
1084
 Recently i modify some parameters with scope to both spfile & pfile. after modify parameters i got two errors like : ORA-02097: parameter cannot be modified because specified value is invalid OR
     -By: Avnish on Dec 13, 2007
898
 how can i get information that provide me sql query that is executed, OS machine, Username in database,Time of executed sql query & Program through which query is executed?
     -By: Avnish on Dec 12, 2007
886
 what are the steps for oracle 8i uninstalling to oracle 9i installation ?
     -By: shashikant on Dec 11, 2007
820
 how to convert oracle 8i enterprise edition to oracle 8i standard edition ?
     -By: shashikant on Dec 11, 2007
758
 wat is the command to see the exact contents by date or day of alert log? i.e i want to grep the particular date content. here i used tail -f <path> | -i grep <path>
     -By: balu on Dec 07, 2007
849
 how to disable the particular job in dbms_jobs scheduller in oracle level?
     -By: balu on Dec 07, 2007
928
 i want to import the dumpfile( windows) to unix box?how to do?can any one has answer?
     -By: bujji on Dec 05, 2007
904
 Hii all . I have droped tablespace without option including...so the datafiles didnt get deleted .how do i delete datafiles which belonged to tablespace that i dropped..also when i import the databas
     -By: binu on Dec 04, 2007
885
 Please tell me what exactly is written in the redolog buf fer, changed data means the old data or the new data, exact meaning of redo entries....
     -By: Kaiz on Dec 04, 2007
852
 hi all users are complaining response is very slow?how do one can analyse statspack to fix this problem?can i have the elimination method to analyse statspack? thanks in advance manjula
     -By: bujji on Dec 03, 2007
875
 hi friends,, I always get confused with the owner of a table .I have created a table emp as sysdba .I do not know what is the owner of this table here?could anyone tell me ...Thanks for your time .
     -By: binu on Dec 02, 2007
887
 Should we take the backup of undo tablespace ? what is nthe answer if our database is in archivelog mode or in noarchivelog mode??
     -By: Jha on Nov 26, 2007
934
 How it is possible to saving of data in datafiles without commiting?
     -By: Jha on Nov 14, 2007
1170
 what is the hotbackup & recovery procedure \oracle8i&windowsNT SANTHANAM.
     -By: santhanam on Nov 01, 2007
1041
 Hi to all, my question is How to find whether the database is running through PFILE or SPFILE.
     -By: maddy on Oct 25, 2007
1301
 Hi, I have a quest. How to find the number of instances running in a system ( server ). What command should I use to find in LINUX and What's the command in Windows
     -By: maddy on Oct 25, 2007
1133
 hi, how do i set serveroutput to on without explicitely giving "set serveroutput on".
     -By: sravanthi on Oct 23, 2007
993
 hi, how do i set serveroutput to on without explicitely giving "set serveroutput on"
     -By: sravanthi on Oct 23, 2007
899
 What's the difference between " A Production Database and A Developmental Database " ?
     -By: maddy on Oct 23, 2007
1209
 What is the command to know the down & up time databases at a time with single command?
     -By: sreedhar on Oct 20, 2007
1242
 Yes you can have an SID of length upto 8 characters
     -By: Vijay on Oct 04, 2007
1097
 Sorry,My question is wrong.How can i mount my database when it is in exclusive mode?
     -By: jothi on Oct 04, 2007
1029
 How can i open a database when it is mounted in EXCLUSIVE mode
     -By: jothi on Oct 04, 2007
1081
 How Can we change Oracle SID length 2 or 4? is it fixed 3?
     -By: canara on Oct 01, 2007
1082
  I have performed incomplete recovery two times and then set incarnation level. Now i found that my database does not contain any old tables which belong to old incarnation so please tell
     -By: abhang on Sep 28, 2007
1019
 You know DBWR writes data blocks from buffer cache to datafiles correct. How does data blocks come into buffer cache from datafiles?
     -By: TPSingh on Sep 26, 2007
1095
 if current redolog files r corrupted,wht r all steps dba should do first n after,the database will work r not?
     -By: sha on Sep 13, 2007
1276
 i created an index and i want to know the status for fragmentation.
     -By: reddu on Sep 11, 2007
1272
 how to get other question about sql exam of ocp
     -By: pinal on Sep 05, 2007
1083
 What happens if my rdbms directory is renamed under ORACLE_HOME and even bdump is not defined?
     -By: sai on Sep 02, 2007
1171
 If bdump location is not defined in my parameter file what will be the default location for the alertlog file?
     -By: sai on Sep 02, 2007
1108
 Suppose if your database is crashed, What are all the things you will check?
     -By: sai on Sep 02, 2007
1369
 what happens if give incremental level 1 backup if i have n backups in rman?
     -By: nani on Aug 31, 2007
1016
 hi what r the checkings a dba should do if client says that he is not connecting to database?
     -By: nani on Aug 31, 2007
1082
 what is the difference between PL/SQL table and Explicit cursor ?
     -By: Vishal on Aug 30, 2007
1060
 What is the difference between NoResetlogs and Resetlog during recovery process???
     -By: jothi on Aug 29, 2007
1493
 please send me sample resume of oracle 11i apps dba
     -By: vinay on Aug 27, 2007
1016
 what is the function of extent management local space management auto;
     -By: karan on Aug 23, 2007
1039
 Hi friends, i have certification in 9i inb dba track. Pls suggest me 10g interview question. its a urgent.
     -By: Harish on Aug 18, 2007
1102
 what is the format of redo log files
     -By: raj on Aug 18, 2007
1304
 how to take rman backup?what is procedure or steps to followed while taking rmanbackup?in what order we use those rman commands?
     -By: puppy on Aug 14, 2007
1110
 how will u configure mirroring of database
     -By: puppy on Aug 14, 2007
1195
 Please ellaborate the Question
     -By: chandu on Aug 14, 2007
941
 What is called buffer hit ratio,cache miss?
     -By: jothi on Aug 12, 2007
1246
 Is it possible to do logical backup(export&import) a indexed table?is the procedure is as same as normal table?
     -By: jothi on Aug 10, 2007
1059
 Hie there I wanted to know wat are the categories of the Oracle9i backkup. thanks in advance
     -By: on Aug 02, 2007
1084
 What is row migration and row chaining? Prasad Jogi
     -By: jogi on Jul 24, 2007
1258
 guys tell me where is rman situated?
     -By: pintu on Jul 19, 2007
1344
 What are the maintanence activities that we do in NOMOUNT phase of the database startup?
     -By: kiran on Jul 02, 2007
1435
 What is the process of creating the a stats pack report right from analyzing the table thru analyze command?
     -By: kiran on Jul 02, 2007
1170
 what is the privilege that we give to the users to restrict the access of some schema objects like tabels,views etc?
     -By: kiran on Jul 02, 2007
1132
 Can we change Oracle SID length 2 or 4? is it fixed 3?
     -By: Gajanand on Jun 14, 2007
1518
 How to set passwordfile? where is the location of passwordfile?
     -By: apoorvi on Jun 09, 2007
1665
 create user <username> identified externally user will be created but problem is how login is possible without password. pls give detail practical steps.
     -By: apoorvi on Jun 09, 2007
1312
 If we have already created database and then we have to change the database name. let me know the steps to change it.
     -By: vinay on Jun 02, 2007
1504
 what is the difference between PL/SQL table and Explicit cursor
     -By: saketh on May 30, 2007
1474
 
     -By: deepu on May 23, 2007
982
 I have some tables which have ROW Migration\ROW Chaining problem and prone to increase the execution time to store the data into that perticular tables.Give me the solution pls,if you can. waiting fo
     -By: vipin on May 21, 2007
1351
 How can be find size of a table in a tablespace and how can find out daily growth of a table
     -By: nitin on May 11, 2007
1706
 Dear friends, i am facing some problems in my Oracle 9i(release 2) database: 1). A Query takes only 5 sec. in morning and the same query takes upto 10 min. after noon. I have checked the physical r
     -By: Harish on May 01, 2007
1677
 what is the simplest way to collect database statistics?
     -By: Harish on Apr 27, 2007
1978
 How to clone the database?
     -By: Harish on Apr 27, 2007
2056
 When an Update statement is slow, what will we do?
     -By: Harish on Apr 27, 2007
1789
 Explain the definition of a "star schema".
     -By: Harish on Apr 27, 2007
1502
 what are Oracle Client and Server installations?
     -By: murari on Apr 27, 2007
1430
 Can we maintain Recovery catalog into same database?
     -By: Gajanand on Apr 18, 2007
1469
 what are the benefits of Recovery Catalog ?
     -By: Gajanand on Apr 18, 2007
1411
 What is the Difference Between Traditional Backups (like tablespace bigin backup and export) and RMAN backups ?
     -By: Gajanand on Apr 18, 2007
1464
 what is default optimizer
     -By: chakri on Apr 17, 2007
1511
 what is the Configuration Difference between OLTP and Dataware house Oracle Database?
     -By: Gajanand on Apr 17, 2007
1322
 What is OERR utility
     -By: Jha on Apr 13, 2007
1456
 How to take backup directly into the tape drive?
     -By: Ratnaker on Apr 13, 2007
1668
 where the SQL/PLSQL error codes reside
     -By: Amit on Apr 13, 2007
1566
 What is Stream pool in oracle 10g?
     -By: Ratnaker on Apr 13, 2007
2991
 what is different between round function and trim function?
     -By: chanchu on Apr 11, 2007
1484
 SELECT ename FROM emp WHERE deptno = 20; You will get multiple rows here.I want all Employee_Name to be displayed in one row with comma seperated. Like SMITH,JONES,SCOTT,...........
     -By: bunty on Apr 10, 2007
1569
 What is the default optimizer in Oracle 10g?
     -By: vasu on Apr 07, 2007
1531
 how can we drop database in oracle 9i Thanks Naveen
     -By: jack on Apr 03, 2007
1749
 What about data of table? How will transfer data from original table to new table ?
     -By: MR on Apr 02, 2007
1491
 How can we decide which user issued a last Query for this day in Database level and OS Level?
     -By: chandu on Mar 30, 2007
1649
 How we can switch our database readonly to read/write without using shutdown option
     -By: khan on Mar 29, 2007
1529
 How we can switch Database Read only to Read/write with out shutdown the database
     -By: khan on Mar 29, 2007
1407
 how can we know that which file we r using in a database SPFILE R PFILE?
     -By: vinay on Mar 26, 2007
1580
 if ARCn process is not working properly and our database is in archievelog mode, then what will happen to our database? it will run r not? Give reason ?
     -By: vinay on Mar 26, 2007
1489
 If any of our back-ground process(mandatory) is not working properly then what will happen to our database? Can we use our database?
     -By: vinay on Mar 26, 2007
1465
 Can we use Non-standard block size in temporary tales?
     -By: vinay on Mar 25, 2007
1345
 real time interview question why do we use oracle instead of ms access. please differentiate it technically
     -By: SUKHI on Mar 25, 2007
1499
 How do you measure CPU Utilization?
     -By: sabbu on Mar 22, 2007
1741
 When you issue SQL statement at SQL prompt, what happens internally?
     -By: sabbu on Mar 22, 2007
1470
 what is defferent between oracle 9i/ 10 why we need to change its version ?
     -By: mukeshpandey on Mar 22, 2007
1566
 what is high water mark in oracle
     -By: SUKHI on Mar 18, 2007
1958
 how do we check that which table belongs to particular tablespace
     -By: SUKHI on Mar 18, 2007
1514
 when do we use list partitioning on tables. can we use indexes in temp tables
     -By: SUKHI on Mar 18, 2007
1262
 when do we manually allocate extents .
     -By: SUKHI on Mar 18, 2007
1471
 Hello friends this is Arif here.I have completed MCA on 2004.i had been working in call centre.but i want to change my career to DBA.so,any one guide me for my career in DBA.
     -By: Planet on Mar 12, 2007
1365
 Why do we need Virtual IP in Oracle 10G RAC?
     -By: Rajesh on Mar 12, 2007
1480
 How recyclebin works in Oracle 10G? how long an database objects remain in recyclebin?
     -By: Rajesh on Mar 12, 2007
1456
 Can we have OCR & Voting Disk on ASM. Give reasons.
     -By: Rajesh on Mar 12, 2007
1284
 What is the simplest command to create a database
     -By: Rajesh on Mar 12, 2007
1702
 Can anyone tell me the main difference between the Checkpoint and SCN. How does that work in reality
     -By: rsreddy28 on Mar 03, 2007
1681
 why do we add online redo group and when do we do it in real time .
     -By: SUKHI on Mar 03, 2007
1327
 Explain me the concept of datatype number which carries precision with it. Ex: Number(2,2) I thought the maxium it can allocate is 99.99 Please explain me as iam struck in basics only
     -By: bujji on Mar 02, 2007
1177
 Compare and contrast TRUNCATE and DELETE for a table.
     -By: jeegar on Mar 01, 2007
1569
 why pctused parameter cant be used while creating an index?
     -By: Jayanta on Feb 28, 2007
1456
 what are the limitations of bit mapped index?
     -By: Jayanta on Feb 28, 2007
1466
 why oracle returns the error snapshot too old?
     -By: Jayanta on Feb 28, 2007
1617
 what is the use of maxlogfiles parameter?
     -By: Jayanta on Feb 28, 2007
1381
 What is the difference between Hot and Cold backup?
     -By: dbapool Editor on Mar 01, 2007
1340
 guys please post question here from the real interview
     -By: SUKHI on Feb 27, 2007
1612
 what is use of decode funtion in sql
     -By: SUKHI on Feb 27, 2007
1426
 how do we create data dictionary
     -By: SUKHI on Feb 27, 2007
1641
 what's the use of control file
     -By: SUKHI on Feb 27, 2007
1668
 When data base is started and arcvhiedlog is on this is hot back up if archivedog is not started this cold back the cold backup is very important because i hv faced a problem when hot backup dont work
     -By: kamesh on Feb 18, 2007
1360
 When a query is sent to the database and an index is not being used, what type of execution is taking place?
     -By: VJ on Feb 17, 2007
1563
 If all the control files have been corrupted and we have a binary file old backup of control file which is taken 5 hours before. in this condition which type of recovery is possible?
     -By: amit on Feb 17, 2007
1576
 hi.. I want to give OCA exam (10g).. But i am not able to purchase a book for it.. And i dont have exact idea of which kind of questions are asked and in how much detail they cover oracel in OCA que
     -By: dipali on Feb 09, 2007
1736
 Backup done when the database is up and running is hot backup.Backup done when the database is down (is its shut down ).In production database since it cannot be shutdown , hotbackups are taken . One
     -By: asu on Feb 07, 2007
1485
 How do you measure table fragmentation?
     -By: sabbu on Feb 07, 2007
1847
 Difference between lock and latches?
     -By: sabbu on Feb 07, 2007
2799
 what is the difference between hotbackup and coldbackup?
     -By: sabbu on Feb 07, 2007
1513
 please describe difference between where by and having clause
     -By: SUKHI on Jan 31, 2007
1616
 what are the daily activities of dba
     -By: SUKHI on Jan 31, 2007
2369
 why do we switch from pfile to spfile and when do we use spfile
     -By: SUKHI on Jan 31, 2007
1739
 what is checkpoint?
     -By: Jayanta on Jan 27, 2007
2023
 Can you use a commit statement within a database trigger?
     -By: Nikki on Jan 22, 2007
2138
 What is the difference between TRUNCATE and DELETE?
     -By: Nikki on Jan 22, 2007
1858
 DESCRIBE THE ORACLE ADCHITECTURE
     -By: SUKHI on Jan 21, 2007
2413
 What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
     -By: VJ on Jan 21, 2007
1635
 Compare Oracle to any other database that you know. Why whould you prefer to work on one and not on the other?
     -By: dbapool Editor on Jan 15, 2007
1775
 What is written in Redo Log Files?
     -By: dbapool Editor on Jan 15, 2007
2273
 How many maximum Redo Logfiles one can have in a Database?
     -By: dbapool Editor on Jan 15, 2007
2387
 Is it possible to disable the parameter while running reports?
     -By: dbapool Editor on Jan 15, 2007
1794
 Where would you look for errors from the database engine?
     -By: dbapool Editor on Jan 15, 2007
2077
 How do you switch from an init.ora file to a spfile?
     -By: dbapool Editor on Jan 15, 2007
2350
 What is a request Sets? How to create a request Set?
     -By: dbapool Editor on Jan 15, 2007
1792
 How to register a table or view or synonym from backend?
     -By: dbapool Editor on Jan 15, 2007
2208
 Where does the SCN resides (system change number) ?
     -By: dbapool Editor on Jan 15, 2007
3397
 What is mutating trigger? How do you avoid mutating trigger?
     -By: dbapool Editor on Jan 15, 2007
2722
 How can we change the owner of a table?
     -By: dbapool Editor on Jan 15, 2007
5535



 





  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor