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
 How to check materialized view space usage ?
     -By: rk on Jun 24, 2009 		130
 How to check materialized space usage ?
     -By: rk on Jun 24, 2009 		59
 What is cluster in oracle? How many Types of cluster in oracle? Is cluster help in performace issue?
     -By: Somu on Jun 15, 2009 		282
 What is the main difference between REDOLOG file and ARCHIVELOG file?
     -By: Somu on Jun 13, 2009 		219
 Can u tell me the jobs performed by a database developer and also its qualities
     -By: mickey on Jun 12, 2009 		140
 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 		286
 WHAT IS FAN IN ORACLE REAL APPLICATION CLUSTER DATABASE? WHAT IS THE USAGE IN RAC DATABASE?
     -By: pratap on Jun 04, 2009 		194
 Hi....... how to enable archive process in RAC configured database?
     -By: pratap on Jun 04, 2009 		139
 Hi............... WHAT IS MAJOR DIFFERENCE BETWEEN EXPORT / IMPORT AND DATAPUMP IN ORACLE 10G DATABASE?
     -By: pratap on Jun 03, 2009 		252
 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 		142
 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 		160
 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 		139
 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 		105
 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 		122
 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 		83
 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 		161
 what are clusters?
     -By: nag on May 27, 2009 		167
 what are the functions of dba
     -By: nag on May 27, 2009 		164
 i need latest 10g interview questions?
     -By: saran on May 27, 2009 		242
 if the tablespace have 2 datafiles i want to drop first datafile,its possible plz help me
     -By: sh on May 27, 2009 		154
 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 		103
 What is the query to determine the table size of a database in Oracle?
     -By: rk on May 26, 2009 		153
 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 		168
 What is the difference between statspack and AWR report ?
     -By: rk on May 22, 2009 		160
 can anybody post sql server dba interview questions..
     -By: nani on May 15, 2009 		127
 What is Oracle’s flagship database?
     -By: azhar on May 13, 2009 		173
 What is Oracle’s flagship database?
     -By: kamal on May 06, 2009 		189
 When data base is in consistent condition what should be the mode of data base?
     -By: fanny on May 03, 2009 		259
 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 		414
 can we convert database from oracle10XE to oracle9i? if possible plz explain.
     -By: sh on Apr 13, 2009 		332
 what is the maximum size of smallfile tablespace
     -By: mohan on Apr 11, 2009 		406
 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 		349
 How to raise TAR for oracle support?(step by step answer is required)
     -By: mutyam on Apr 06, 2009 		359
 If HOSTNAME not found msg show in Unix. How it resolve?
     -By: prash on Apr 06, 2009 		322
 how to create a database link between to databases with in a same box(require expalnation and example)
     -By: mohan on Mar 31, 2009 		389
 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 		310
 why we runing script pupbld.sql after connecting to system/manager
     -By: mohan on Mar 27, 2009 		335
 can we save data in database without any tablespace
     -By: sh on Mar 26, 2009 		452
 which transactions(committed or uncommitted) are written by logwriter into redologbuffer or esle both.
     -By: sh on Mar 15, 2009 		457
 What is inline view
     -By: at on Mar 09, 2009 		493
 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 		431
 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 		330
 what the numbers represent ...9.2.0.6?
     -By: mutyam on Mar 01, 2009 		534
 What is PCTFREE & PCTUSED?
     -By: mutyam on Mar 01, 2009 		531
 What is checkpoint?
     -By: mutyam on Mar 01, 2009 		555
 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 		436
 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 		362
 How do you know which user has which privileges?
     -By: mutyam on Mar 01, 2009 		454
 How to go for the help on Opatch
     -By: mutyam on Mar 01, 2009 		318
 How to apply the patch?
     -By: mutyam on Mar 01, 2009 		440
 How to rollback the opatch
     -By: mutyam on Mar 01, 2009 		306
 Types of Patches? Contents of a Patch?
     -By: mutyam on Mar 01, 2009 		346
 Which default Database roles are created when you create a Database?
     -By: mutyam on Mar 01, 2009 		341
 .How do you kill a process in Unix
     -By: mutyam on Mar 01, 2009 		346
 How do you apply the rdbms patches
     -By: mutyam on Mar 01, 2009 		272
 How do you find out what patches have been applied on database?
     -By: mutyam on Mar 01, 2009 		318
 How do you create the user?
     -By: mutyam on Mar 01, 2009 		286
 How to check the existing privileges and grant to the users and procedure to follow?
     -By: mutyam on Mar 01, 2009 		265
 How can you control the access of a user to the database?
     -By: mutyam on Mar 01, 2009 		280
 What is the difference between instance and database?
     -By: mutyam on Mar 01, 2009 		354
 where RDBMS patch logs are located? ORACLE_HOME/.patch_storage
     -By: mutyam on Mar 01, 2009 		207
 If row chaining and row migration is there how do you address that issue?
     -By: mutyam on Mar 01, 2009 		283
 what is crash recovery which background process will take care of that?
     -By: mutyam on Mar 01, 2009 		296
 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 		286
 How do you increase the tablespace size
     -By: mutyam on Mar 01, 2009 		259
 What is the use of SYSAUX tablespace
     -By: mutyam on Mar 01, 2009 		357
 How do you determine howmuch virtual memory is being utilized?
     -By: mutyam on Mar 01, 2009 		271
 How to know which process is consuming more CPU resources?
     -By: mutyam on Mar 01, 2009 		305
 Explain the difference between a hot backup and a cold backup?
     -By: mutyam on Mar 01, 2009 		239
 What is the use of utlrp.sql?
     -By: mutyam on Mar 01, 2009 		264
 what is the architecture of oracle9i?
     -By: mutyam on Mar 01, 2009 		275
 how to remove or rename users and groups in linux(linux command).
     -By: machi on Feb 22, 2009 		342
 dba_free_space
     -By: sac on Feb 12, 2009 		405
 what is the difference between ORACLE_HOME,ORACLE_BASE
     -By: mohan on Feb 07, 2009 		567
 Tell me how many stages I mean paper's in oca and ocp paper's
     -By: shweta on Feb 06, 2009 		319
 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 		441
 
     -By: haq on Jan 30, 2009 		189
 Could anyone please help me with the latest FEE structure of OCA and OCAP 10G DBA.
     -By: shari on Jan 25, 2009 		382
 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 		454
 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 		473
 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 		281
 Can we find out the password of any user in a database?
     -By: Harsha on Jan 01, 2009 		911
 what is the min size of S.G.A
     -By: buggi on Dec 30, 2008 		821
 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 		389
 What is bootstrap ?
     -By: Harsha on Dec 28, 2008 		599
 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 		473
 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 		467
 How to find the blocksize of operating system LINUX n WINDOWS ??
     -By: Harsha on Dec 19, 2008 		636
 what is the minimum size for creating a tablespace ?
     -By: Harsha on Dec 19, 2008 		606
 While creating new datafile in a tablespace is the .DBF extension complusary ???
     -By: Harsha on Dec 19, 2008 		497
 how to know the database size?
     -By: babi on Dec 16, 2008 		763
 What is the steps for degrade the database from 10g to 9i?
     -By: kattu on Dec 01, 2008 		685
 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 		455
 how to import the database
     -By: sudhi on Nov 29, 2008 		705
 how to show the user privileges without logging the user account?(means how to show from dba side)
     -By: soku on Nov 24, 2008 		605
 How to connect remote oracle database server?
     -By: soku on Nov 24, 2008 		636
 
     -By: santanu on Nov 20, 2008 		286
 what is database incarnation?
     -By: parox on Nov 20, 2008 		825
 How to know whether my database is running with spfile or pfile?
     -By: Sheela on Nov 18, 2008 		796
 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 		526
 How to take export at two different mount point, with size limit at each location ?
     -By: raj on Nov 10, 2008 		564
 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 		495
 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 		529
 how to create sub table in main table.please tell me query Thanks in anticipation
     -By: shamshul on Oct 30, 2008 		507
 what's the target DB, and how can i know the name of my target database?
     -By: Fang on Oct 30, 2008 		564
 emctrl start dbconsole i get the following error: Environment variable Oracle_sid not defined. please define it.
     -By: Fang on Oct 13, 2008 		660
 
     -By: MANOJ SINGH on Oct 06, 2008 		400
 ORDER OF BACKGROUND PROCESSES DURING DB STARTUP
     -By: radhu on Oct 02, 2008 		1167
 When create ORA-600 error? please explain in details.
     -By: prash on Sep 29, 2008 		993
 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 		964
 Checkpoint Not Complete error show in Alert.log file, How to resolve this error?
     -By: prash on Sep 22, 2008 		962
 Identify the steps to put a database in Archive Log Mode.
     -By: soku on Sep 19, 2008 		830
 Try to drop online redo log file and online redo log group.
     -By: soku on Sep 19, 2008 		758
 What is the status if an online current redolog file is lost?
     -By: soku on Sep 19, 2008 		791
 Can different sizes be specified for the different log groups?
     -By: soku on Sep 19, 2008 		591
 How can a log member be droped?
     -By: soku on Sep 19, 2008 		669
 Try to relocate the log members to another destination.
     -By: soku on Sep 19, 2008 		497
 When does a log member show an INVALID status?
     -By: soku on Sep 19, 2008 		586
 Try to resize all online redolog files to 5m
     -By: soku on Sep 19, 2008 		529
 Try to mutiplex the existing control file.
     -By: soku on Sep 19, 2008 		512
 Try to start the database without any controlfiles.What happens?
     -By: soku on Sep 19, 2008 		676
 What are the oracle managed files?
     -By: soku on Sep 19, 2008 		575
 try to rename the database?
     -By: soku on Sep 19, 2008 		651
 try to add a log member to an existing group?
     -By: soku on Sep 19, 2008 		398
 What is the minimum size with which a logfile can be created?
     -By: soku on Sep 19, 2008 		499
 How can we see the controlfile location?
     -By: soku on Sep 19, 2008 		543
 What are the views available to see the information about log files?
     -By: soku on Sep 19, 2008 		455
 Truncate the EMP table,releasing the space?Now how many extents does the table hold?
     -By: soku on Sep 19, 2008 		507
 Can the value of initial_extent and min_extents be changed for a tablespace?
     -By: soku on Sep 19, 2008 		439
 Can the value of initial_extent be changed,after a segment is created?
     -By: soku on Sep 19, 2008 		383
 Can PCTFREE,PCTUSED be assigned for tablespace?
     -By: soku on Sep 19, 2008 		509
 How many freelists will be allocated when you create a segment?
     -By: soku on Sep 19, 2008 		430
 How can we specify automatic space management for a tablespace?
     -By: soku on Sep 19, 2008 		456
 Which view is available to see the header information of a datafile?
     -By: soku on Sep 19, 2008 		476
 Can I manage the space with in a segment automatically?
     -By: soku on Sep 19, 2008 		356
 Can we allocate an extent in a specific datafile for a segment in a tablespace?
     -By: soku on Sep 19, 2008 		368
 Write a query to show the details of storage information of segments created?
     -By: soku on Sep 19, 2008 		378
 Can a tablespace be coalesced manually?
     -By: soku on Sep 19, 2008 		467
 Where can the free space information for tablespaces be found?
     -By: soku on Sep 18, 2008 		442
 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 		356
 List different types of extent management?
     -By: soku on Sep 18, 2008 		451
 Can a segment span across multiple tablespaces?
     -By: soku on Sep 18, 2008 		379
 What are the default storage parameters when a new tablespace is created?
     -By: soku on Sep 18, 2008 		392
 Try to change a tablesapce to temporary, which already has some tables?
     -By: soku on Sep 18, 2008 		367
 Try to create table in temporary tablespace whose contents are permanent?
     -By: soku on Sep 18, 2008 		343
 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 		336
 What size should INITIAL and NEXT be when defining default storage for a temporarytablespace?
     -By: soku on Sep 18, 2008 		344
 What is :ON COMMIT DELETE ROWS"?
     -By: soku on Sep 18, 2008 		427
 Create a temporary segment in tablespace user_data using uniform extent sizes of 10kb?
     -By: soku on Sep 18, 2008 		324
 How is unused space released from a table?
     -By: soku on Sep 18, 2008 		403
 Can I drop the default temporary tablespace?
     -By: soku on Sep 18, 2008 		391
 How are the extents allocated manually to a table?
     -By: soku on Sep 18, 2008 		339
 Try to add the constraints to a temporary table?
     -By: soku on Sep 18, 2008 		335
 How can the constraints be disabled?
     -By: soku on Sep 18, 2008 		343
 What are the different available data types?
     -By: soku on Sep 18, 2008 		354
 Which views are available to get the information about temporary segments?
     -By: soku on Sep 18, 2008 		331
 Can Indexes and views be created on temporary segments?
     -By: soku on Sep 18, 2008 		340
 Try to create the temporary segment?
     -By: soku on Sep 18, 2008 		298
 Purge all the objects in recyle bin in the tablespace USERS?
     -By: soku on Sep 18, 2008 		326
 Can I purge only the recyle bin for a particular user in given tablespace?
     -By: soku on Sep 18, 2008 		298
 What are the options of FLASHBACK TABLE?
     -By: soku on Sep 18, 2008 		366
 Explore the view v$UNDOSTAT.
     -By: soku on Sep 18, 2008 		318
 Explore the view DBA_UNDO_EXTENTS.
     -By: soku on Sep 18, 2008 		324
 Can flashback query results be seen from different sessions?
     -By: soku on Sep 18, 2008 		315
 Which package is used to perform the the flashback query operations?
     -By: soku on Sep 18, 2008 		307
 Can I use flashback querry for DDL operations?
     -By: soku on Sep 18, 2008 		325
 What is the default value for UNDO_RETENTION?
     -By: soku on Sep 18, 2008 		354
 Find out different views for undo management?
     -By: soku on Sep 18, 2008 		312
 Can I assign new undo tablespace to the instance?
     -By: soku on Sep 18, 2008 		292
 What is the segment type for the undo segments created in an Undo Tablespace?
     -By: soku on Sep 18, 2008 		298
 Can I create undo tablespace at the time of database creation?
     -By: soku on Sep 18, 2008 		295
 Try creating a rollback segment in Undo tablespace?
     -By: soku on Sep 18, 2008 		283
 How do i set the Instance in auotmatic Undo management Mode?
     -By: soku on Sep 18, 2008 		300
 Can I use both undo tablespace and rollback segments in a database?
     -By: soku on Sep 18, 2008 		289
 How can a role will be granted to a user?
     -By: soku on Sep 18, 2008 		316
 What are the different types of privileges?
     -By: soku on Sep 18, 2008 		334
 What are the views available to see the information about profiles?
     -By: soku on Sep 18, 2008 		273
 How can a profile be assigned to a user?
     -By: soku on Sep 18, 2008 		284
 How can a user`s account be locked?
     -By: soku on Sep 18, 2008 		333
 In USER_TS_QUOTAS what does "-1" indicate?
     -By: soku on Sep 18, 2008 		346
 Is it possible to have quota on different tablespaces for a user?
     -By: soku on Sep 18, 2008 		304
 which views are available to see the user infromation?
     -By: soku on Sep 18, 2008 		295
 How can a user be dropped?
     -By: soku on Sep 18, 2008 		337
 Try to create a user with OS authentication?
     -By: soku on Sep 18, 2008 		344
 Which view is available to see the quotas assigned to a user?
     -By: soku on Sep 18, 2008 		292
 What are default privileges available to a user?
     -By: soku on Sep 18, 2008 		290
 Can a user change his/her own password?
     -By: soku on Sep 18, 2008 		300
 Which is the default tablespace that is assigned to a new user when created?
     -By: soku on Sep 18, 2008 		273
 Can you assign a same name to data files of two different tablespaces?
     -By: soku on Sep 18, 2008 		311
 How can a new data file be added to a tablespace?
     -By: soku on Sep 18, 2008 		285
 Can you decrease the data file size,when it contains data more than the specified size?
     -By: soku on Sep 18, 2008 		303
 Can I drop the default temporary tablespace?
     -By: soku on Sep 18, 2008 		308
 Can objects be dropped when tablespace is in offline mode?
     -By: soku on Sep 18, 2008 		292
 How can I get the information about all data files in database?
     -By: soku on Sep 18, 2008 		295
 How can you obtain the tablespace information?
     -By: soku on Sep 18, 2008 		277
 Check out extent management for tablespace after creation
     -By: soku on Sep 18, 2008 		265
 How is automatic extension of data files enabled?
     -By: soku on Sep 18, 2008 		280
 How to alter a tablespace in READ ONLY mode?
     -By: soku on Sep 18, 2008 		307
 Can a tablespace be renamed?
     -By: soku on Sep 18, 2008 		342
 Try to create temporary tablespaces with all possible options?
     -By: soku on Sep 18, 2008 		282
 What happens when u make a tablespace offline immediate?
     -By: soku on Sep 18, 2008 		288
 How to create the tablespaces with different database block sizes?
     -By: soku on Sep 18, 2008 		278
 Can permanent objects be created in a Tenporary tablespace?
     -By: soku on Sep 18, 2008 		282
 Can SYSTEM and SYSAUX tablespaces be taken OFFLINE?
     -By: soku on Sep 18, 2008 		346
 What type of information will be available in udump,cdump and bdump destinations?
     -By: soku on Sep 16, 2008 		344
 What happens when u try to start the database with out control files?
     -By: soku on Sep 16, 2008 		338
 How can we start the database using pfile, which is not in a default directory?
     -By: soku on Sep 16, 2008 		307
 How do u see the background process at the DB level?
     -By: soku on Sep 16, 2008 		345
 How to create the default permanent tablespace for the database?
     -By: soku on Sep 16, 2008 		317
 Can we change the instance name after creation of database?
     -By: soku on Sep 16, 2008 		342
 Can the instance name and database name be different?
     -By: soku on Sep 16, 2008 		348
 Can we change the database block size after the database creation?
     -By: soku on Sep 16, 2008 		315
 Which tablespace is default for non-essential schema objects?
     -By: soku on Sep 16, 2008 		289
 Display the oracle version.
     -By: soku on Sep 16, 2008 		349
 Identify the name and size of the data files, online redolog files and control files
     -By: soku on Sep 16, 2008 		313
 Can u take backup of datafiles and archivelog files in one shot?
     -By: soku on Sep 16, 2008 		344
 Try to make complete recovery through RMAN?
     -By: soku on Sep 16, 2008 		310
 How many types of backups can you do by using RMAN?
     -By: soku on Sep 16, 2008 		396
 Try to unregister the database?
     -By: soku on Sep 16, 2008 		317
 How to see background process while taking backup through RMAN?
     -By: soku on Sep 16, 2008 		338
 While taking backup through RMAN, What does %d,%t,%s,%p,%u indicate?
     -By: soku on Sep 16, 2008 		320
 If an object is lost. Can you recover it through RMAN?
     -By: soku on Sep 16, 2008 		332
 If a datafile is lost in a tablespace. How can you recover it?
     -By: soku on Sep 16, 2008 		344
 which of the view is used for RMAN performance monitoring?
     -By: soku on Sep 16, 2008 		356
 Can you duplex the backup copies in RMAN?
     -By: soku on Sep 16, 2008 		313
 How to find out the configuration of RMAN using SHOW ALL?
     -By: soku on Sep 16, 2008 		291
 How to find out the configuration of RMAN using SHOW ALL?
     -By: soku on Sep 16, 2008 		268
 What does the list backup command do?
     -By: soku on Sep 16, 2008 		310
 Can we take the backup and restore of control file automatically using RMAN without synchronizing the catalog?
     -By: soku on Sep 16, 2008 		300
 is it possible to take an incremental backup through RMAN?
     -By: soku on Sep 16, 2008 		279
 What are the views available to see the information about RMAN?
     -By: soku on Sep 16, 2008 		266
 How to display and set the ORACLE_SID and ORACLE_HOME in UNIX?
     -By: soku on Sep 15, 2008 		338
 How to display and set the ORACLE_SID and ORACLE_HOME in UNIX?
     -By: soku on Sep 15, 2008 		307
 How to kill the user session?
     -By: soku on Sep 15, 2008 		354
 Syntax and Explain startup process? Syntax and Explain shutdown process?
     -By: soku on Sep 15, 2008 		298
 How many primary keys are in table?
     -By: soku on Sep 15, 2008 		334
 what is consistent Read?
     -By: soku on Sep 15, 2008 		340
 What is oratab file? Where it is use?
     -By: soku on Sep 15, 2008 		346
 Explain the explain plan?
     -By: soku on Sep 15, 2008 		362
 What is the purpose of DBLink?
     -By: soku on Sep 15, 2008 		352
 How to show which background process are start when the Oracle server start in Linux?
     -By: soku on Sep 15, 2008 		303
 Why did you use TOAD?
     -By: soku on Sep 15, 2008 		358
 What is crontab?
     -By: soku on Sep 15, 2008 		350
 what is pfile and spfile? Explain the difference between them?
     -By: soku on Sep 15, 2008 		311
 How to show the tablespace size?
     -By: soku on Sep 15, 2008 		317
 How to export the full database?
     -By: soku on Sep 15, 2008 		322
 How to tune the database?
     -By: soku on Sep 15, 2008 		335
 How to show the size of the database?
     -By: soku on Sep 15, 2008 		323
 How to show the which users are connected to database?
     -By: soku on Sep 15, 2008 		305
 Is there any scenario for Hot Backup? If there Please Explain
     -By: soku on Sep 15, 2008 		301
 Explain the Index Architecture?
     -By: soku on Sep 15, 2008 		335
 Why partitioning?
     -By: soku on Sep 15, 2008 		292
 How to connect the Remote database server that is located at another location?
     -By: soku on Sep 15, 2008 		295
 Suppose DBWR is not working, How to identify?
     -By: soku on Sep 15, 2008 		344
 what are 20 new features of Oracle compare to 9i?
     -By: soku on Sep 15, 2008 		310
 How to SQL Tuning?Explian Steps
     -By: prash on Sep 12, 2008 		430
 How to take a Backup on tape in RMAN?
     -By: prash on Sep 11, 2008 		353
 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 		322
 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 		358
 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 		335
 Hi, this is praveen, select 1 from dual union select 'a' from dual please give the answer
     -By: praveen on Aug 28, 2008 		385
 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 		485
 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 		333
 startup normal or startup
     -By: jagari on Aug 27, 2008 		393
 What U mean by snapshot in oracle?
     -By: Pundaleek.C on Aug 25, 2008 		523
 how many groups max number of redolog can oracle 9i & 10g can have at a time?
     -By: parox on Aug 20, 2008 		523
 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 		454
 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 		553
 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 		476
 which file is excuted first when the system start?
     -By: on Aug 16, 2008 		640
 which file is executed file when the system start
     -By: on Aug 16, 2008 		406
 Accidentally pfile delete and haven’t spfile. I don’t have pfile backup also. How can recover pfile?
     -By: prash on Aug 14, 2008 		551
 catalalog database corrupted,no backup.How ill you recover?
     -By: siva on Aug 13, 2008 		568
 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 		470
 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 		549
 In statspack report,the physical read is High,how ill you solve?
     -By: siva on Aug 10, 2008 		463
 How to recover Read-only tablespace datafiles?
     -By: siva on Aug 09, 2008 		455
 during database startup,all mandatory background process started in which order?
     -By: siva on Aug 09, 2008 		504
 hi dear frds,anyone tell me what is the pre-requirement of installing oracle 9i on linux?
     -By: siva on Aug 08, 2008 		391
 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 		377
 hi dear frds,How ill you determined the column(eg:emp_id) availaible in the particular partioning?
     -By: siva on Aug 08, 2008 		326
 what is the difference between TOAD and MATERIALIZED VIEW?
     -By: siva on Aug 08, 2008 		436
 DBAPOOL frds,how ill you determined migrated rows? & chained rows?
     -By: siva on Aug 08, 2008 		351
 hi dear frds,what is the maximum number of undo segments created in undo tablespace?
     -By: siva on Aug 08, 2008 		379
 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 		355
 hi dbapool frds,what is semapores & semapore=1000 what ill happen?
     -By: siva on Aug 08, 2008 		324
 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 		359
 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 		338
 hi dbapool frds,during database startup which backround process run first?why?
     -By: siva on Aug 08, 2008 		322
 hi frds,i faced this int.question,how ill u enable archivemode without downtime?(except session level)
     -By: siva on Aug 08, 2008 		376
 Using top command show more cpu utilization,how ill u determined which user process cause this?
     -By: siva on Aug 08, 2008 		381
 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 		354
 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 		339
 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 		349
 1.Having 4 controlfiles,one of the controlfile size is increased,why?
     -By: siva on Aug 08, 2008 		409
 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 		473
 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 		420
 if my archieve denstination is full what to do?
     -By: mummy on Jul 31, 2008 		527
 how to check the how many users are connected? at os(linux) level?
     -By: mummy on Jul 31, 2008 		473
 how to i change locally managed tablspace to dictionary mgmt tbs? give the syntax
     -By: abdul on Jul 28, 2008 		510
 how to i find out which undo is in active state?give the syntax
     -By: abdul on Jul 28, 2008 		455
 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 		400
 how to i trace out which table in which datafile?plz..give me the solution in detail..
     -By: abdul on Jul 28, 2008 		424
 What are the steps for Migration from 9i to 10g Oracle DB?
     -By: prash on Jul 28, 2008 		465
 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 		358
 how to lock the table in oracle?plz give me the syntax..
     -By: abdul on Jul 28, 2008 		480
 how to add the datafile?
     -By: mummy on Jul 28, 2008 		398
 how to findout the redolog file size?if relog files are completely filledup what we've to do?
     -By: mummy on Jul 28, 2008 		393
 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 		396
 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 		400
 What is difference between catalog and nocatalog in rman?
     -By: prash on Jul 24, 2008 		487
 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 		401
 What is Jinitiator when it activates?what ar jar files,class files? BY SYED AHMED ZAMA
     -By: yaazdani on Jul 23, 2008 		342
 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 		432
 WHAT IS SQL ENGINE?ANYBODY DESCRIBE THE FLOW OF QUERY WITH THE HELP OF ARCHITECTURE
     -By: yaazdani on Jul 23, 2008 		361
 what is balance loader how it perform?wht are the steps to implement it BY SYED AHMED ZAMA
     -By: yaazdani on Jul 23, 2008 		339
 what is fixed sga how can u define it?its an interview question by SYED AHMED ZAMA
     -By: yaazdani on Jul 23, 2008 		400
 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 		389
 Suppose user not connected to database what is solution for that?
     -By: prash on Jul 22, 2008 		435
 one user want to connect 4 database how can he connect
     -By: pattu on Jul 18, 2008 		540
 In oracle9i which script is executed when databse is mounted?????
     -By: shilpa on Jul 14, 2008 		594
 what is the command to see all the users
     -By: 3628800 on Jul 12, 2008 		613
 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 		497
 
     -By: imran on Jul 08, 2008 		342
 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 		573
 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 		423
 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 		470
 How would you check that standby database is running fine and currently synched with primary database??
     -By: balaji on Jul 04, 2008 		537
 how to install the oracle9i on redhot unix machine?
     -By: mummy on Jul 03, 2008 		489
 In which dictionary table OR sql script the oracle error code resides ? In which path i get it
     -By: rk on Jul 03, 2008 		472
 how to run the script at os(linux) level means which cmd is used to run the script?
     -By: mummy on Jun 29, 2008 		464
 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 		493
 
     -By: sambasiva on Jun 28, 2008 		327
 What is difference between Oracle9i and Oracle10g?
     -By: prash on Jun 26, 2008 		845
 What is merging a partition?
     -By: positive on Jun 26, 2008 		525
 What is splitting a partition?
     -By: positive on Jun 26, 2008 		448
 Where do you find information about partitioned tables?
     -By: positive on Jun 26, 2008 		486
 What are the various stages while processing a SQL statement?
     -By: positive on Jun 26, 2008 		471
 Can a user created new connect to the database?
     -By: positive on Jun 26, 2008 		465
 What is fine-grained access control?
     -By: positive on Jun 26, 2008 		444
 What are the uses of fine-grained access control?
     -By: positive on Jun 26, 2008 		399
 What is needed to create a VPD?
     -By: positive on Jun 26, 2008 		428
 What is Oracle Database Vault?
     -By: positive on Jun 26, 2008 		459
 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 		358
 
     -By: ravi on Jun 24, 2008 		300
 can we use resetlogs after full recovery?
     -By: geet on Jun 22, 2008 		581
 How to find the size of an Index ?
     -By: rk on Jun 22, 2008 		604
 Suppose only one Control file in my database, if it is corrupted how to recover it ?
     -By: rk on Jun 22, 2008 		572
 What is MTTR,MTBF and PGA_ARRREGATE_TARGET_SIZE ?
     -By: rk on Jun 19, 2008 		487
 How do u split the dump file into many file each of 2GB size ?
     -By: rk on Jun 19, 2008 		504
 Can we resize Sys datafile during db is up and running ?
     -By: rk on Jun 19, 2008 		530
 What is Soft parse and Hard Parse ?
     -By: rk on Jun 19, 2008 		556
 One user has to connect 4 databases, how do you connect ?
     -By: rk on Jun 19, 2008 		495
 While Exporting data, corrupted block will also exported or not ? what it will show error
     -By: rk on Jun 18, 2008 		499
 How to resize System Global Area (SGA_MAX_SIZE) ?
     -By: rk on Jun 18, 2008 		534
 after cloning what about dbid and db name?
     -By: Reddy on Jun 18, 2008 		504
 what is incarnation of databse?
     -By: Reddy on Jun 18, 2008 		510
 
     -By: joe on Jun 16, 2008 		312
 
     -By: joe on Jun 16, 2008 		321
 what are the daily activities for 1 year Experienced Oracle 10g DBA
     -By: Shahid on Jun 15, 2008 		642
 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 		492
 how i can create a clone database?
     -By: bandhu on Jun 08, 2008 		626
 IN oracle 8i temp table always show high water mark level ? can we Coalesce it ?
     -By: jay on Jun 07, 2008 		449
 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 		415
 What is difference between schema and user ?
     -By: rk on Jun 05, 2008 		671
 How you are taking Control file Hot back up ? plz give me steps
     -By: rk on Jun 04, 2008 		499
 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 		516
 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 		491
 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 		431
 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 		468
 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 		391
 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 		454
 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 		385
 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 		344
 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 		373
 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 		389
 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 		366
 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 		386
 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 		361
 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 		368
 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 		387
 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 		349
 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 		346
 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 		363
 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 		400
 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 		356
 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 		351
 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 		362
 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 		377
 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 		361
 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 		389
 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 		379
 36. Do you have to restore Datafiles manually from backups if you are doing recovery using RMAN?
     -By: shanthi on Jun 01, 2008 		384
 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 		359
 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 		349
 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 		359
 29. How do you recover from the loss of datafile if the DB is running in ARCHIVELOG mode?
     -By: shanthi on Jun 01, 2008 		352
 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 		348
 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 		334
 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 		333
 . 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 		345
 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 		319
 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 		327
 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 		325
 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 		335
 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 		325
 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 		323
 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 		315
 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 		338
 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 		365
 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 		322
 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 		309
 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 		326
 Is It possible to rename the database name. If so how?
     -By: ms on May 27, 2008 		556
 How do you make sure that database is Consistent state ?
     -By: rk on May 26, 2008 		487
 what is the difference between the locks and latches?
     -By: mummy on May 24, 2008 		487
 what is mean by sqlner.ora? pl give me the breif explanation?
     -By: mummy on May 24, 2008 		417
 How to configure the 10g SGA?
     -By: mummy on May 24, 2008 		436
 what is mean by alertlog file?what will maintain in alrtlog file?
     -By: mummy on May 24, 2008 		405
 what are the mandatory background processers for the oracle 10g ASM?
     -By: mummy on May 24, 2008 		371
 How do you check the Performance of an database during peak hours?
     -By: rk on May 24, 2008 		446
 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 		385
 What is Database link create command? plz write steps?
     -By: prash on May 22, 2008 		431
 what is the purpose of MAXLOGHISTORY ?
     -By: kumar on May 21, 2008 		406
 what is a profile?
     -By: prash on May 21, 2008 		414
 What is a Database Link?
     -By: prash on May 21, 2008 		435
 what are the Configuration parameters in RMAN backup?
     -By: mummy on May 19, 2008 		452
 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 		486
 what are the major differences between physical standby and logical standby?
     -By: mummy on May 19, 2008 		415
 How many Standby databases are there? what are they?
     -By: mummy on May 19, 2008 		411
 How will you maximizing SQL*Loder performance
     -By: robin on May 16, 2008 		493
 is there any other option to re-organise the DB except exp/imp ?
     -By: mummy on May 14, 2008 		468
 why we are rebuilding the indexes?
     -By: mummy on May 14, 2008 		546
 what is mean by fragmentation?
     -By: mummy on May 14, 2008 		509
 In Form 6i How Can U Use Bultings "OHOST" & "OS_COMMAND" Pl.Reply Me. With Example
     -By: rk on May 13, 2008 		388
 what is the best option of starting a dbase.
     -By: frankky on May 13, 2008 		461
 What is the basic function of glogin.sql file.
     -By: robin on May 13, 2008 		402
 explain about segment space management
     -By: suri on May 12, 2008 		456
 plz send me the syntax of IMPORT and Export comand in oracle 9i
     -By: khubeb on May 08, 2008 		474
 If I issue the SQL query in Oracle Database what happen in SGA?
     -By: prash on May 08, 2008 		540
 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 		441
 what is the procedure for taking RMAN cold backup ?
     -By: rk on Apr 30, 2008 		637
 Which is the path of ORATAB file? we can edit manually ?
     -By: rk on Apr 30, 2008 		576
 what is Rule Based Optimizer and Cost Based Optimizer?
     -By: bobby on Apr 29, 2008 		559
 What is lock ? How many types of locks are there ?
     -By: rk on Apr 22, 2008 		749
 what are the modes of optimizer?
     -By: rk on Apr 22, 2008 		580
 what is isolation in oracle?
     -By: rk on Apr 22, 2008 		599
 While the database is up and running can we kill smon?If i kill SMON what happens?
     -By: rk on Apr 22, 2008 		653
 The tablespace in begin backup mode can we do DML operations and what happend on that time ?
     -By: rk on Apr 22, 2008 		528
 how many user are connected in my database and which is running applicatin how can i see.
     -By: skumar,bihar on Apr 21, 2008 		590
 what is diff between scn and checkpoints.
     -By: skumar,bihar on Apr 21, 2008 		650
 what is diff between dict. managed tablespace and locally managed tablespaces.
     -By: skumar,bihar on Apr 21, 2008 		519
 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 		488
 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 		561
 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 		521
 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 		449
 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 		462
 What is grid computing?
     -By: Ratnaker on Apr 08, 2008 		635
 What is materialized view?
     -By: bobby on Apr 07, 2008 		676
 How would you eliminate row migration and row chaining?
     -By: bobby on Apr 07, 2008 		1069
 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 		586
 How to clone a database from hotbackup/rman ?
     -By: Sarfaraz Karim on Mar 26, 2008 		647
 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 		514
 server process
     -By: skumar,bihar on Mar 22, 2008 		580
 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 		712
 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 		560
 Which BACKGROUND PROCESS is read from datafiles?
     -By: Harihar on Mar 14, 2008 		778
 Is it possible to carry export and import on standby database ?
     -By: Bala on Mar 03, 2008 		825
 How can we see the DB instance startup time?
     -By: Bala on Mar 02, 2008 		882
 How can we get data from oracle into excel spreadsheet ?
     -By: Bala on Mar 02, 2008 		807
 Please provide me simple and correct steps to rename a database instance. Thanks in advance.
     -By: Bala on Mar 02, 2008 		734
 Can we create synonyms on materialized view and normal view
     -By: Passion@ora on Feb 29, 2008 		641
 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 		578
 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 		618
 what is derived artificial primary key and how it is set??
     -By: Passion@ora on Feb 29, 2008 		528
 If the DBWR writes modified blocks to datafiles which Process pull data ?
     -By: Passion@ora on Feb 28, 2008 		662
 How can we clone a Database without creating the text based control file ?
     -By: Passion@ora on Feb 28, 2008 		618
 how many index's can be created on a single table?
     -By: Pundaleek.C on Feb 28, 2008 		801
 If you provide more information will help us to answer to better.
     -By: Mohammed Taj on Feb 24, 2008 		494
  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 		591
 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 		570
 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 		508
 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 		477
 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 		617
 what is PRAGMA AUTONOMOUS TRANSACTION, can U give me a example?
     -By: Pundaleek.C on Feb 13, 2008 		660
 what is PRAGMA AUTONOMOUS TRANSACTION, can U give me a example?
     -By: Pundaleek.C on Feb 13, 2008 		665
 Assume that my database size is 800gb, then what is my SGA size? thanks prasad
     -By: jogi on Feb 06, 2008 		956
 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 		799
 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 		793
 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 		718
 what is difference between ALL,ANY command in SQL?with examples.
     -By: bala on Jan 21, 2008 		909
 when the control will be increased?
     -By: goms on Jan 14, 2008 		869
 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 		674
 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 		590
 sql statement>> generate all the 3-digit no from emp(scott) table ;send answer for this
     -By: bala on Jan 07, 2008 		669
 sql statement>> generate all the 3-digit no;send answer for this
     -By: bala on Jan 07, 2008 		631
 how can I create sequence for generating value 1,-1,1,-1....?
     -By: jayesh on Jan 07, 2008 		793
 what is the purpose of dbwr?
     -By: goms on Jan 06, 2008 		873
 how to prepare for interview?
     -By: goms on Jan 04, 2008 		1054
 what is incremental backup?
     -By: goms on Jan 04, 2008 		908
 what are the most frequently asked interview questions for dba?
     -By: goms on Jan 04, 2008 		1047
 how to get old OCA papers?
     -By: chow on Jan 04, 2008 		926
 in oracle9i,what is meaning of i ?
     -By: balaji on Jan 04, 2008 		1003
 how to get other question about sql exam of ocp
     -By: balaji on Jan 04, 2008 		638
 How we will findout total size of Database
     -By: skumar,bihar on Jan 03, 2008 		1040
 Tell me top five waitevents
     -By: skumar,bihar on Dec 30, 2007 		899
 What is the difference between cold and hot backup?
     -By: Shalu on Dec 23, 2007 		845
 table is having single column, can we drop column if so what will happen?
     -By: shashikant on Dec 22, 2007 		906
 What is RMAN Backup? What is NetBackup?
     -By: Amit on Dec 19, 2007 		1017
 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 		820
 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 		1143
 
     -By: Maddy on Dec 16, 2007 		517
 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 		885
 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 		720
 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 		714
 what are the steps for oracle 8i uninstalling to oracle 9i installation ?
     -By: shashikant on Dec 11, 2007 		664
 how to convert oracle 8i enterprise edition to oracle 8i standard edition ?
     -By: shashikant on Dec 11, 2007 		595
 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 		674
 how to disable the particular job in dbms_jobs scheduller in oracle level?
     -By: balu on Dec 07, 2007 		738
 i want to import the dumpfile( windows) to unix box?how to do?can any one has answer?
     -By: bujji on Dec 05, 2007 		721
 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 		725
 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 		682
 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 		712
 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 		710
 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 		772
 How it is possible to saving of data in datafiles without commiting?
     -By: Jha on Nov 14, 2007 		981
 what is the hotbackup & recovery procedure \oracle8i&windowsNT SANTHANAM.
     -By: santhanam on Nov 01, 2007 		873
 Hi to all, my question is How to find whether the database is running through PFILE or SPFILE.
     -By: maddy on Oct 25, 2007 		1134
 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 		967
 hi, how do i set serveroutput to on without explicitely giving "set serveroutput on".
     -By: sravanthi on Oct 23, 2007 		824
 hi, how do i set serveroutput to on without explicitely giving "set serveroutput on"
     -By: sravanthi on Oct 23, 2007 		728
 What's the difference between " A Production Database and A Developmental Database " ?
     -By: maddy on Oct 23, 2007 		1017
 What is the command to know the down & up time databases at a time with single command?
     -By: sreedhar on Oct 20, 2007 		1044
 Yes you can have an SID of length upto 8 characters
     -By: Vijay on Oct 04, 2007 		935
 Sorry,My question is wrong.How can i mount my database when it is in exclusive mode?
     -By: jothi on Oct 04, 2007 		851
 How can i open a database when it is mounted in EXCLUSIVE mode
     -By: jothi on Oct 04, 2007 		886
 How Can we change Oracle SID length 2 or 4? is it fixed 3?
     -By: canara on Oct 01, 2007 		890
  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 		862
 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 		923
 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 		1099
 i created an index and i want to know the status for fragmentation.
     -By: reddu on Sep 11, 2007 		1082
 how to get other question about sql exam of ocp
     -By: pinal on Sep 05, 2007 		896
 What happens if my rdbms directory is renamed under ORACLE_HOME and even bdump is not defined?
     -By: sai on Sep 02, 2007 		964
 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 		919
 Suppose if your database is crashed, What are all the things you will check?
     -By: sai on Sep 02, 2007 		1137
 what happens if give incremental level 1 backup if i have n backups in rman?
     -By: nani on Aug 31, 2007 		829
 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 		893
 what is the difference between PL/SQL table and Explicit cursor ?
     -By: Vishal on Aug 30, 2007 		886
 What is the difference between NoResetlogs and Resetlog during recovery process???
     -By: jothi on Aug 29, 2007 		1127
 please send me sample resume of oracle 11i apps dba
     -By: vinay on Aug 27, 2007 		824
 what is the function of extent management local space management auto;
     -By: karan on Aug 23, 2007 		870
 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 		908
 what is the format of redo log files
     -By: raj on Aug 18, 2007 		1100
 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 		908
 how will u configure mirroring of database
     -By: puppy on Aug 14, 2007 		1004
 Please ellaborate the Question
     -By: chandu on Aug 14, 2007 		749
 What is called buffer hit ratio,cache miss?
     -By: jothi on Aug 12, 2007 		1052
 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 		873
 Hie there I wanted to know wat are the categories of the Oracle9i backkup. thanks in advance
     -By: on Aug 02, 2007 		898
 What is row migration and row chaining? Prasad Jogi
     -By: jogi on Jul 24, 2007 		1078
 guys tell me where is rman situated?
     -By: pintu on Jul 19, 2007 		1141
 What are the maintanence activities that we do in NOMOUNT phase of the database startup?
     -By: kiran on Jul 02, 2007 		1247
 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 		994
 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 		950
 Can we change Oracle SID length 2 or 4? is it fixed 3?
     -By: Gajanand on Jun 14, 2007 		1307
 How to set passwordfile? where is the location of passwordfile?
     -By: apoorvi on Jun 09, 2007 		1476
 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 		1127
 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 		1320
 what is the difference between PL/SQL table and Explicit cursor
     -By: saketh on May 30, 2007 		1282
 
     -By: deepu on May 23, 2007 		803
 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 		1162
 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 		1515
 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 		1480
 what is the simplest way to collect database statistics?
     -By: Harish on Apr 27, 2007 		1755
 How to clone the database?
     -By: Harish on Apr 27, 2007 		1812
 When an Update statement is slow, what will we do?
     -By: Harish on Apr 27, 2007 		1553
 Explain the definition of a "star schema".
     -By: Harish on Apr 27, 2007 		1309
 what are Oracle Client and Server installations?
     -By: murari on Apr 27, 2007 		1248
 Can we maintain Recovery catalog into same database?
     -By: Gajanand on Apr 18, 2007 		1280
 what are the benefits of Recovery Catalog ?
     -By: Gajanand on Apr 18, 2007 		1219
 What is the Difference Between Traditional Backups (like tablespace bigin backup and export) and RMAN backups ?
     -By: Gajanand on Apr 18, 2007 		1258
 what is default optimizer
     -By: chakri on Apr 17, 2007 		1296
 what is the Configuration Difference between OLTP and Dataware house Oracle Database?
     -By: Gajanand on Apr 17, 2007 		1135
 What is OERR utility
     -By: Jha on Apr 13, 2007 		1254
 How to take backup directly into the tape drive?
     -By: Ratnaker on Apr 13, 2007 		1442
 where the SQL/PLSQL error codes reside
     -By: Amit on Apr 13, 2007 		1334
 What is Stream pool in oracle 10g?
     -By: Ratnaker on Apr 13, 2007 		1876
 what is different between round function and trim function?
     -By: chanchu on Apr 11, 2007 		1286
 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 		1390
 What is the default optimizer in Oracle 10g?
     -By: vasu on Apr 07, 2007 		1313
 how can we drop database in oracle 9i Thanks Naveen
     -By: jack on Apr 03, 2007 		1549
 What about data of table? How will transfer data from original table to new table ?
     -By: MR on Apr 02, 2007 		1300
 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 		1420
 How we can switch our database readonly to read/write without using shutdown option
     -By: khan on Mar 29, 2007 		1318
 How we can switch Database Read only to Read/write with out shutdown the database
     -By: khan on Mar 29, 2007 		1214
 how can we know that which file we r using in a database SPFILE R PFILE?
     -By: vinay on Mar 26, 2007 		1398
 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 		1261
 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 		1243
 Can we use Non-standard block size in temporary tales?
     -By: vinay on Mar 25, 2007 		1130
 real time interview question why do we use oracle instead of ms access. please differentiate it technically
     -By: SUKHI on Mar 25, 2007 		1299
 How do you measure CPU Utilization?
     -By: sabbu on Mar 22, 2007 		1494
 When you issue SQL statement at SQL prompt, what happens internally?
     -By: sabbu on Mar 22, 2007 		1282
 what is defferent between oracle 9i/ 10 why we need to change its version ?
     -By: mukeshpandey on Mar 22, 2007 		1349
 what is high water mark in oracle
     -By: SUKHI on Mar 18, 2007 		1706
 how do we check that which table belongs to particular tablespace
     -By: SUKHI on Mar 18, 2007 		1297
 when do we use list partitioning on tables. can we use indexes in temp tables
     -By: SUKHI on Mar 18, 2007 		1070
 when do we manually allocate extents .
     -By: SUKHI on Mar 18, 2007 		1241
 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 		1166
 Why do we need Virtual IP in Oracle 10G RAC?
     -By: Rajesh on Mar 12, 2007 		1252
 How recyclebin works in Oracle 10G? how long an database objects remain in recyclebin?
     -By: Rajesh on Mar 12, 2007 		1234
 Can we have OCR & Voting Disk on ASM. Give reasons.
     -By: Rajesh on Mar 12, 2007 		1060
 What is the simplest command to create a database
     -By: Rajesh on Mar 12, 2007 		1452
 Can anyone tell me the main difference between the Checkpoint and SCN. How does that work in reality
     -By: rsreddy28 on Mar 03, 2007 		1447
 why do we add online redo group and when do we do it in real time .
     -By: SUKHI on Mar 03, 2007 		1117
 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 		995
 Compare and contrast TRUNCATE and DELETE for a table.
     -By: jeegar on Mar 01, 2007 		1386
 why pctused parameter cant be used while creating an index?
     -By: Jayanta on Feb 28, 2007 		1246
 what are the limitations of bit mapped index?
     -By: Jayanta on Feb 28, 2007 		1235
 why oracle returns the error snapshot too old?
     -By: Jayanta on Feb 28, 2007 		1369
 what is the use of maxlogfiles parameter?
     -By: Jayanta on Feb 28, 2007 		1160
 What is the difference between Hot and Cold backup?
     -By: dbapool Editor on Mar 01, 2007 		1153
 guys please post question here from the real interview
     -By: SUKHI on Feb 27, 2007 		1388
 what is use of decode funtion in sql
     -By: SUKHI on Feb 27, 2007 		1221
 how do we create data dictionary
     -By: SUKHI on Feb 27, 2007 		1400
 what's the use of control file
     -By: SUKHI on Feb 27, 2007 		1411
 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 		1128
 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 		1335
 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 		1307
 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 		1510
 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 		1257
 How do you measure table fragmentation?
     -By: sabbu on Feb 07, 2007 		1561
 Difference between lock and latches?
     -By: sabbu on Feb 07, 2007 		2114
 what is the difference between hotbackup and coldbackup?
     -By: sabbu on Feb 07, 2007 		1263
 please describe difference between where by and having clause
     -By: SUKHI on Jan 31, 2007 		1380
 what are the daily activities of dba
     -By: SUKHI on Jan 31, 2007 		1996
 why do we switch from pfile to spfile and when do we use spfile
     -By: SUKHI on Jan 31, 2007 		1476
 what is checkpoint?
     -By: Jayanta on Jan 27, 2007 		1730
 Can you use a commit statement within a database trigger?
     -By: Nikki on Jan 22, 2007 		1833
 What is the difference between TRUNCATE and DELETE?
     -By: Nikki on Jan 22, 2007 		1586
 DESCRIBE THE ORACLE ADCHITECTURE
     -By: SUKHI on Jan 21, 2007 		2095
 What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
     -By: VJ on Jan 21, 2007 		1371
 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 		1505
 What is written in Redo Log Files?
     -By: dbapool Editor on Jan 15, 2007 		1954
 How many maximum Redo Logfiles one can have in a Database?
     -By: dbapool Editor on Jan 15, 2007 		2035
 Is it possible to disable the parameter while running reports?
     -By: dbapool Editor on Jan 15, 2007 		1506
 Where would you look for errors from the database engine?
     -By: dbapool Editor on Jan 15, 2007 		1745
 How do you switch from an init.ora file to a spfile?
     -By: dbapool Editor on Jan 15, 2007 		2000
 What is a request Sets? How to create a request Set?
     -By: dbapool Editor on Jan 15, 2007 		1507
 How to register a table or view or synonym from backend?
     -By: dbapool Editor on Jan 15, 2007 		1889
 Where does the SCN resides (system change number) ?
     -By: dbapool Editor on Jan 15, 2007 		2884
 What is mutating trigger? How do you avoid mutating trigger?
     -By: dbapool Editor on Jan 15, 2007 		2335
 How can we change the owner of a table?
     -By: dbapool Editor on Jan 15, 2007 		4610



 





  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor
Confio Software