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
 plz send me the syntax of IMPORT and Export comand in oracle 9i
     -By: khubeb on May 08, 2008
19
 If I issue the SQL query in Oracle Database what happen in SGA?
     -By: prash_OCP on May 08, 2008
30
 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
37
 what is the procedure for taking RMAN cold backup ?
     -By: rk on Apr 30, 2008
142
 Which is the path of ORATAB file? we can edit manually ?
     -By: rk on Apr 30, 2008
104
 what is Rule Based Optimizer and Cost Based Optimizer?
     -By: bobby on Apr 29, 2008
109
 What is lock ? How many types of locks are there ?
     -By: rk on Apr 22, 2008
235
 what are the modes of optimizer?
     -By: rk on Apr 22, 2008
153
 what is isolation in oracle?
     -By: rk on Apr 22, 2008
153
 While the database is up and running can we kill smon?If i kill SMON what happens?
     -By: rk on Apr 22, 2008
166
 The tablespace in begin backup mode can we do DML operations and what happend on that time ?
     -By: rk on Apr 22, 2008
118
 how many user are connected in my database and which is running applicatin how can i see.
     -By: skumar,bihar on Apr 21, 2008
141
 what is diff between scn and checkpoints.
     -By: skumar,bihar on Apr 21, 2008
133
 what is diff between dict. managed tablespace and locally managed tablespaces.
     -By: skumar,bihar on Apr 21, 2008
79
 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
101
 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
164
 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
133
 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
100
 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
112
 What is grid computing?
     -By: Ratnaker on Apr 08, 2008
181
 What is materialized view?
     -By: bobby on Apr 07, 2008
192
 How would you eliminate row migration and row chaining?
     -By: bobby on Apr 07, 2008
143
 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
188
 How to clone a database from hotbackup/rman ?
     -By: Sarfaraz Karim on Mar 26, 2008
225
 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
178
 server process
     -By: skumar,bihar on Mar 22, 2008
190
 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
327
 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
172
 Which BACKGROUND PROCESS is read from datafiles?
     -By: Harihar on Mar 14, 2008
338
 Is it possible to carry export and import on standby database ?
     -By: Bala on Mar 03, 2008
433
 How can we see the DB instance startup time?
     -By: Bala on Mar 02, 2008
470
 How can we get data from oracle into excel spreadsheet ?
     -By: Bala on Mar 02, 2008
402
 Please provide me simple and correct steps to rename a database instance. Thanks in advance.
     -By: Bala on Mar 02, 2008
355
 Can we create synonyms on materialized view and normal view
     -By: Passion@ora on Feb 29, 2008
241
 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
229
 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
239
 what is derived artificial primary key and how it is set??
     -By: Passion@ora on Feb 29, 2008
173
 If the DBWR writes modified blocks to datafiles which Process pull data ?
     -By: Passion@ora on Feb 28, 2008
282
 How can we clone a Database without creating the text based control file ?
     -By: Passion@ora on Feb 28, 2008
209
 how many index's can be created on a single table?
     -By: Pundaleek.C on Feb 28, 2008
332
 If you provide more information will help us to answer to better.
     -By: Mohammed Taj on Feb 24, 2008
158
  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
234
 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
200
 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
147
 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
146
 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
277
 what is PRAGMA AUTONOMOUS TRANSACTION, can U give me a example?
     -By: Pundaleek.C on Feb 13, 2008
300
 what is PRAGMA AUTONOMOUS TRANSACTION, can U give me a example?
     -By: Pundaleek.C on Feb 13, 2008
213
 Assume that my database size is 800gb, then what is my SGA size? thanks prasad
     -By: jogi on Feb 06, 2008
528
 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
451
 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
441
 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
382
 what is difference between ALL,ANY command in SQL?with examples.
     -By: bala on Jan 21, 2008
531
 when the control will be increased?
     -By: goms on Jan 14, 2008
505
 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
355
 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
263
 sql statement>> generate all the 3-digit no from emp(scott) table ;send answer for this
     -By: bala on Jan 07, 2008
343
 sql statement>> generate all the 3-digit no;send answer for this
     -By: bala on Jan 07, 2008
296
 how can I create sequence for generating value 1,-1,1,-1....?
     -By: jayesh on Jan 07, 2008
419
 what is the purpose of dbwr?
     -By: goms on Jan 06, 2008
492
 how to prepare for interview?
     -By: goms on Jan 04, 2008
614
 what is incremental backup?
     -By: goms on Jan 04, 2008
518
 what are the most frequently asked interview questions for dba?
     -By: goms on Jan 04, 2008
642
 how to get old OCA papers?
     -By: chow on Jan 04, 2008
522
 in oracle9i,what is meaning of i ?
     -By: balaji on Jan 04, 2008
600
 how to get other question about sql exam of ocp
     -By: balaji on Jan 04, 2008
289
 How we will findout total size of Database
     -By: skumar,bihar on Jan 03, 2008
591
 Tell me top five waitevents
     -By: skumar,bihar on Dec 30, 2007
508
 What is the difference between cold and hot backup?
     -By: Shalu on Dec 23, 2007
496
 table is having single column, can we drop column if so what will happen?
     -By: shashikant on Dec 22, 2007
516
 What is RMAN Backup? What is NetBackup?
     -By: Amit on Dec 19, 2007
609
 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
461
 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
677
 
     -By: Maddy on Dec 16, 2007
236
 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
500
 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
351
 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
359
 what are the steps for oracle 8i uninstalling to oracle 9i installation ?
     -By: shashikant on Dec 11, 2007
330
 how to convert oracle 8i enterprise edition to oracle 8i standard edition ?
     -By: shashikant on Dec 11, 2007
278
 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
349
 how to disable the particular job in dbms_jobs scheduller in oracle level?
     -By: balu on Dec 07, 2007
371
 i want to import the dumpfile( windows) to unix box?how to do?can any one has answer?
     -By: bujji on Dec 05, 2007
392
 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
398
 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
358
 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
370
 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
357
 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
423
 How it is possible to saving of data in datafiles without commiting?
     -By: Jha on Nov 14, 2007
630
 what is the hotbackup & recovery procedure \oracle8i&windowsNT SANTHANAM.
     -By: santhanam on Nov 01, 2007
556
 Hi to all, my question is How to find whether the database is running through PFILE or SPFILE.
     -By: maddy on Oct 25, 2007
796
 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
641
 hi, how do i set serveroutput to on without explicitely giving "set serveroutput on".
     -By: sravanthi on Oct 23, 2007
507
 hi, how do i set serveroutput to on without explicitely giving "set serveroutput on"
     -By: sravanthi on Oct 23, 2007
416
 What's the difference between " A Production Database and A Developmental Database " ?
     -By: maddy on Oct 23, 2007
648
 What is the command to know the down & up time databases at a time with single command?
     -By: sreedhar on Oct 20, 2007
685
 Yes you can have an SID of length upto 8 characters
     -By: Vijay on Oct 04, 2007
630
 Sorry,My question is wrong.How can i mount my database when it is in exclusive mode?
     -By: jothi on Oct 04, 2007
543
 How can i open a database when it is mounted in EXCLUSIVE mode
     -By: jothi on Oct 04, 2007
538
 How Can we change Oracle SID length 2 or 4? is it fixed 3?
     -By: canara on Oct 01, 2007
563
  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
546
 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
590
 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
755
 i created an index and i want to know the status for fragmentation.
     -By: reddu on Sep 11, 2007
731
 how to get other question about sql exam of ocp
     -By: pinal on Sep 05, 2007
588
 What happens if my rdbms directory is renamed under ORACLE_HOME and even bdump is not defined?
     -By: sai on Sep 02, 2007
617
 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
581
 Suppose if your database is crashed, What are all the things you will check?
     -By: sai on Sep 02, 2007
749
 what happens if give incremental level 1 backup if i have n backups in rman?
     -By: nani on Aug 31, 2007
511
 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
561
 what is the difference between PL/SQL table and Explicit cursor ?
     -By: Vishal on Aug 30, 2007
552
 What is the difference between NoResetlogs and Resetlog during recovery process???
     -By: jothi on Aug 29, 2007
595
 please send me sample resume of oracle 11i apps dba
     -By: vinay on Aug 27, 2007
477
 what is the function of extent management local space management auto;
     -By: karan on Aug 23, 2007
535
 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
584
 what is the format of redo log files
     -By: raj on Aug 18, 2007
725
 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
548
 how will u configure mirroring of database
     -By: puppy on Aug 14, 2007
625
 Please ellaborate the Question
     -By: chandu on Aug 14, 2007
399
 What is called buffer hit ratio,cache miss?
     -By: jothi on Aug 12, 2007
646
 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
529
 Hie there I wanted to know wat are the categories of the Oracle9i backkup. thanks in advance
     -By: on Aug 02, 2007
548
 What is row migration and row chaining? Prasad Jogi
     -By: jogi on Jul 24, 2007
712
 guys tell me where is rman situated?
     -By: pintu on Jul 19, 2007
741
 What are the maintanence activities that we do in NOMOUNT phase of the database startup?
     -By: kiran on Jul 02, 2007
868
 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
628
 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
573
 Can we change Oracle SID length 2 or 4? is it fixed 3?
     -By: Gajanand on Jun 14, 2007
922
 How to set passwordfile? where is the location of passwordfile?
     -By: apoorvi on Jun 09, 2007
1061
 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
761
 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
937
 what is the difference between PL/SQL table and Explicit cursor
     -By: saketh on May 30, 2007
918
 
     -By: deepu on May 23, 2007
478
 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
805
 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
1131
 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
1093
 what is the simplest way to collect database statistics?
     -By: Harish on Apr 27, 2007
1335
 How to clone the database?
     -By: Harish on Apr 27, 2007
1366
 When an Update statement is slow, what will we do?
     -By: Harish on Apr 27, 2007
1128
 Explain the definition of a "star schema".
     -By: Harish on Apr 27, 2007
935
 what are Oracle Client and Server installations?
     -By: murari on Apr 27, 2007
860
 Can we maintain Recovery catalog into same database?
     -By: Gajanand on Apr 18, 2007
885
 what are the benefits of Recovery Catalog ?
     -By: Gajanand on Apr 18, 2007
822
 What is the Difference Between Traditional Backups (like tablespace bigin backup and export) and RMAN backups ?
     -By: Gajanand on Apr 18, 2007
849
 what is default optimizer
     -By: chakri on Apr 17, 2007
911
 what is the Configuration Difference between OLTP and Dataware house Oracle Database?
     -By: Gajanand on Apr 17, 2007
740
 What is OERR utility
     -By: Jha on Apr 13, 2007
828
 How to take backup directly into the tape drive?
     -By: Ratnaker on Apr 13, 2007
1020
 where the SQL/PLSQL error codes reside
     -By: Amit on Apr 13, 2007
933
 What is Stream pool in oracle 10g?
     -By: Ratnaker on Apr 13, 2007
803
 what is different between round function and trim function?
     -By: chanchu on Apr 11, 2007
891
 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
998
 What is the default optimizer in Oracle 10g?
     -By: vasu on Apr 07, 2007
905
 how can we drop database in oracle 9i Thanks Naveen
     -By: jack on Apr 03, 2007
1139
 What about data of table? How will transfer data from original table to new table ?
     -By: MR on Apr 02, 2007
927
 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
1004
 How we can switch our database readonly to read/write without using shutdown option
     -By: khan on Mar 29, 2007
950
 How we can switch Database Read only to Read/write with out shutdown the database
     -By: khan on Mar 29, 2007
816
 how can we know that which file we r using in a database SPFILE R PFILE?
     -By: vinay on Mar 26, 2007
978
 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
852
 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
831
 Can we use Non-standard block size in temporary tales?
     -By: vinay on Mar 25, 2007
770
 real time interview question why do we use oracle instead of ms access. please differentiate it technically
     -By: SUKHI on Mar 25, 2007
905
 How do you measure CPU Utilization?
     -By: sabbu on Mar 22, 2007
1040
 When you issue SQL statement at SQL prompt, what happens internally?
     -By: sabbu on Mar 22, 2007
871
 what is defferent between oracle 9i/ 10 why we need to change its version ?
     -By: mukeshpandey on Mar 22, 2007
914
 what is high water mark in oracle
     -By: SUKHI on Mar 18, 2007
1192
 how do we check that which table belongs to particular tablespace
     -By: SUKHI on Mar 18, 2007
905
 when do we use list partitioning on tables. can we use indexes in temp tables
     -By: SUKHI on Mar 18, 2007
671
 when do we manually allocate extents .
     -By: SUKHI on Mar 18, 2007
823
 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
770
 Why do we need Virtual IP in Oracle 10G RAC?
     -By: Rajesh on Mar 12, 2007
823
 How recyclebin works in Oracle 10G? how long an database objects remain in recyclebin?
     -By: Rajesh on Mar 12, 2007
812
 Can we have OCR & Voting Disk on ASM. Give reasons.
     -By: Rajesh on Mar 12, 2007
669
 What is the simplest command to create a database
     -By: Rajesh on Mar 12, 2007
1027
 Can anyone tell me the main difference between the Checkpoint and SCN. How does that work in reality
     -By: rsreddy28 on Mar 03, 2007
1024
 why do we add online redo group and when do we do it in real time .
     -By: SUKHI on Mar 03, 2007
740
 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
651
 Compare and contrast TRUNCATE and DELETE for a table.
     -By: jeegar on Mar 01, 2007
995
 why pctused parameter cant be used while creating an index?
     -By: Jayanta on Feb 28, 2007
843
 what are the limitations of bit mapped index?
     -By: Jayanta on Feb 28, 2007
809
 why oracle returns the error snapshot too old?
     -By: Jayanta on Feb 28, 2007
907
 what is the use of maxlogfiles parameter?
     -By: Jayanta on Feb 28, 2007
761
 What is the difference between Hot and Cold backup?
     -By: dbapool Editor on Mar 01, 2007
767
 guys please post question here from the real interview
     -By: SUKHI on Feb 27, 2007
917
 what is use of decode funtion in sql
     -By: SUKHI on Feb 27, 2007
798
 how do we create data dictionary
     -By: SUKHI on Feb 27, 2007
915
 what's the use of control file
     -By: SUKHI on Feb 27, 2007
924
 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
737
 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
899
 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
857
 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
1062
 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
811
 How do you measure table fragmentation?
     -By: sabbu on Feb 07, 2007
1038
 Difference between lock and latches?
     -By: sabbu on Feb 07, 2007
1143
 what is the difference between hotbackup and coldbackup?
     -By: sabbu on Feb 07, 2007
783
 please describe difference between where by and having clause
     -By: SUKHI on Jan 31, 2007
917
 what are the daily activities of dba
     -By: SUKHI on Jan 31, 2007
1322
 why do we switch from pfile to spfile and when do we use spfile
     -By: SUKHI on Jan 31, 2007
948
 what is checkpoint?
     -By: Jayanta on Jan 27, 2007
1176
 Can you use a commit statement within a database trigger?
     -By: Nikki on Jan 22, 2007
1113
 What is the difference between TRUNCATE and DELETE?
     -By: Nikki on Jan 22, 2007
1021
 DESCRIBE THE ORACLE ADCHITECTURE
     -By: SUKHI on Jan 21, 2007
1410
 What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
     -By: VJ on Jan 21, 2007
883
 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
979
 What is written in Redo Log Files?
     -By: dbapool Editor on Jan 15, 2007
1311
 How many maximum Redo Logfiles one can have in a Database?
     -By: dbapool Editor on Jan 15, 2007
1352
 Is it possible to disable the parameter while running reports?
     -By: dbapool Editor on Jan 15, 2007
944
 Where would you look for errors from the database engine?
     -By: dbapool Editor on Jan 15, 2007
1121
 How do you switch from an init.ora file to a spfile?
     -By: dbapool Editor on Jan 15, 2007
1269
 What is a request Sets? How to create a request Set?
     -By: dbapool Editor on Jan 15, 2007
916
 How to register a table or view or synonym from backend?
     -By: dbapool Editor on Jan 15, 2007
1144
 Where does the SCN resides (system change number) ?
     -By: dbapool Editor on Jan 15, 2007
1890
 What is mutating trigger? How do you avoid mutating trigger?
     -By: dbapool Editor on Jan 15, 2007
1494
 How can we change the owner of a table?
     -By: dbapool Editor on Jan 15, 2007
2892



 





  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor
Confio Software