| |
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 |
|
