What are the steps involved in Database Shutdown ?1 3316
What is Restricted Mode of Instance Startup ?1 2687
What are the different modes of mounting a Database with the Parallel Server ?1 4775
What is Full Backup ?3 3180
Can Full Backup be performed when the database is open ?1 2796
What is Partial Backup ?2 4939
What is On-line Redo Log?2 2817
What is Mirrored on-line Redo Log ?2 2413
What is Archived Redo Log ?3 2540
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?2 4877
What is Log Switch ?2 3952
what is difference between 1.append to media 2.overright the existing media when we take back up in sql server20001006
What are the different methods of backing up oracle database ?1 2256
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
Explain the classification of Database Management System?
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 in project? 6. How do you kill the job process using windows environment? 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
i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: firstname.lastname@example.org
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?
With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
dear sir please provide what question will be asked in bank it officer interview
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?
Write about Transaction Management in Oracle 9i?
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?
hello to all i want code for like this site "Submit Question" page.please give answers thanks.
How to handle data if f table are more than one and each table contain thousands of entries?