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 restore this file?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
Hi how to import oracle sequence in Informatica? Please
write stored procedure code that will import oracle sequence
in Informatica SP transformation as per below scenario
Oracle table product list
Pro_id, pro_name, price
101, LED Lights,200
102, 20 watt CFL Lights, 145
103, 30 watt CFL lights,155
Now a new flat file with new product list needs to be added
to oracle table product list with oracle sequence
flat file product list has two column
20 watt tube light ,45
30 watt tube light ,60
when All datafiles related to a Tablespace are removed ?
How can we check whether A S M instance is up or down?
1. Difference between Lookup and join?
2. Difference between funnel and join?
3. What type of load you have used in your project?
4. What type of data warehouse schema you have
fallowed in you project?
5. How many fact tables and dimension tables is their
6. How do you kill the job process using windows
7. Difference between sequence file and dataset?
8. What is delta load and subsequent load?
9. By using which stages you have implemented the SCD
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
Does any body has ORACLE Certification latest Dumps on 1)
Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet
Application Developer, 4) OCA, 5) OCP 8i to 10g DBA
Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if
any body has please send it to email@example.com
what is the difference between filters and conditions?
dear all,Greetings of the day..
i have a small query plz rply if u knw..
i have done MBA Hr and B.sc microbiology.
i am very much interested in it industry,so i am planing to
go with oracle HRMS module,can it be work out??
1. What is Container?
2. Tell me about your project?
3. Which container you are used in your project?
4. What is Surrogate key?
5. How you are implemented it?
6. Difference between Server job and Parallel job?
7. What is your Target Database?
8. What is Source System?
9. Difference between Join and Lookup?
10. Are you maintaining historical data? What is the
logic used to maintained to historical data?
11. Do you have documents for mapping?
please provide what question will be asked in CWE in bank it
Explain the Normalized Relations?
Write about Transaction Management in Oracle 9i?
What are the Roles and responsibilities of database
What types of questions are asked in NIC(Natinal
Informatics Centre)'s interview?If any one has any
information about this,I would be very thankful to
i have a web page and in this page i create 3 textbax and a
"summit" button do you have any html code for add text velue
in my web page like link summation(form) sites.