Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z




IBM DB Administration Interview Questions
Questions Answers Views Company eMail

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 1788

Where would you look for errors from the database engine?

1684

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? 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? 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 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 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 shutdown DB using RMAN? 26. How do you recover from the loss of datafile if the DB is running in NOARCHIVELOG mode? 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? 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 running in ARCHIVELOG mode? 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 restore this file? 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? 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 in ARCHIVELOG mode? 36. Do you have to restore Datafiles manually from backups if you are doing recovery using RMAN? 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 before you can take any backup. Now can you recover this datafile when you don't have any backups? 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? 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 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 with the parameters set to previous values. 16. What is a Recovery Catalog? 17. Should you place Recovery Catalog in the Same DB? 18. Can you use RMAN without Recovery catalog? 19. Can you take Image Backups using RMAN? 20. Can you use Backupsets created by RMAN with any other utility?

1 10355

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 7944

What are the ways tablespaces can be managed and how do they differ?

2 3964





hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 3541

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

912

what is the differnce between process and thread ?

1 2677

what is meant by gateway

1 1921

how will you see when the database was started using sql prompt?

2 3314

what is rebuild index??

2 3132

Post New IBM DB Administration Interview Questions



Un-Answered Questions

what is the difference between elctrefining and electrolysis?

933


How to pass workscontract sale invoice which includes WCT & VAT.

1105


if one drug is acidic in nature and the other drug is basic in nature, e.g. desloratadine is soluble in acidic environment i.e 0.1N HCL whereas Montelukast Sodium is soluble in basic environment i.e. .2% SLS. How can we choose a common media for there Dissolution?

160


if 2 coil of 1000W connect in series and 200 v is applied across it . then what is the total power of coil when coil have only resistive load .

830


I am a service man.I want to submit my income tax return by efilling.Anybody can help me to do the same with the information to submit the file?

971






write a programme to get a character and thier ASCII value

1893


Please list the types of Firewalls, Routers, Switches, Servers, you manage?

832


Name the Different classes of plants in the plant kingdom?

1276


What Kind of Report we Can see in Cost based Profitability Analysis and Accounting based Profitability Analysis ? Technical things ?

966


explanation of mesh bus bars

927


2. You are required to prepare a Profit & Loss Account for the year ending 31st December, 2007 and the Balance Sheet on that date. The Trial Balance of XYZ Ltd. for the year ended 31st December 2007 is as follows:- Trial Balance of XYZ Ltd. as on 31st Dec. 2007 Debit Balances Rs. Credit Balances Rs. Materials used 3,50,000 Sales(including 2% Sales tax) 9,18,000 Cost of Labour 1,50,000 Sale of Scrap 100 Stock, finished and work in process on 31st December, 2006 50,000 Rent received 2,000 Wages : Factory Staff 15,000 Discounts 2,750 Directors Remuneration 50,000 Recovered against fire claim re : Stock 5,000 Salaries : Clerical Staff 75,000 Capital : Equity 25,000 Insurances : Workmen’s Compensation 1,500 Preference- 9% 8,000 General, fire etc. 2,000 Creditors 1,56,000 Directors’ Life Insurance 1,500 Provision for Taxation 1,05,000 Maintenance : Buildings 1,000 Profit & Loss Account 13,750 Plant and Machinery 12,500 Rent and Rates of premises and hire of plant 20,000 Heat, Light and Power 15,000 Experimental and Laboratory Expenses 10,000 Canteen Expenses 5,000 Staff Welfare expenses 2,500 Motor Expenses 12,500 Professional Charges 2,800 Postage and Telephone 3,500 Books, Printing and Stationery 11,000 Sundry expenses 10,000 Carriage and Packing on Sales 3,300 Discounts 5,000 Debtors 1,78,000 Freehold Property 50,000 Plant and Machinery 12,500 Fixtures and Fittings – Offices 3,500 Office machinery and Equipment 3,000 Motor Car and Van 6,500 Stock of materials on 31st Dec. 2007 1,20,000 Bank 38,000 Sales Tax Paid 15,000 12,35,600 12,35,600 Depreciation is to be provided at the following rates: Plant and Machinery 10% Fixture and Fittings 05% Office Machinery, etc. 10% Motor Vans and Cars 25% The stock of finished goods and work in progress as on 31st December, 2007 was Rs. 35,000. Provide for preference dividend and ordinary dividend at 10%. The total taxation liability is estimated at Rs.1,50,000 of which Rs. 75,000 relates to the current year. Debtors include Rs. 10,000 deposited as security against government contracts. The Works Manager is paid partly by salary and partly by a commission; he is entitled to a commission of 5% on the amount by which the surplus in the factory cost exceeds 20% of the sales for the period. Charge the commission if any in the Profit and Loss Account.

1051


what is the composition of good brick ?

686


What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

4571


What is the purpose of DataNode block scanner?

173


What is the purpose of using busbar mounting fuse?

891






IBM DB Administration Interview Questions
  • Software (1)
  • C (84)
  • OOPS (37)
  • C++ General (9)
  • MFC (2)
  • COM DCOM (1)
  • VC++ AllOther (1)
  • Delphi (11)
  • PHP (16)
  • Programming Languages AllOther (31)
  • ASP (5)
  • CGI Perl (7)
  • JavaScript (6)
  • VB Script (15)
  • JSP (6)
  • Shell Script (6)
  • AJAX (1)
  • Ruby on Rails (1)
  • Scripts AllOther (2)
  • SNMP (1)
  • TCP IP (10)
  • UDP (1)
  • Protocols AllOther (3)
  • Networking Administration (28)
  • Networking Security (3)
  • Networking AllOther (9)
  • Visual Basic (5)
  • C Sharp (35)
  • ASP.NET (37)
  • VB.NET (3)
  • ADO.NET (11)
  • IIS (9)
  • Crystal Reports (3)
  • BizTalk (3)
  • Dot Net Framework (14)
  • Dot Net WindowsForms (2)
  • Dot Net General (3)
  • Dot Net AllOther (4)
  • Exchange Server (12)
  • Microsoft Related AllOther (2)
  • Oracle General (39)
  • Architecture (1)
  • Database Management (11)
  • Forms Reports (7)
  • Oracle AllOther (9)
  • SQL Server (61)
  • MySQL (3)
  • DB Architecture (1)
  • DB Administration (11)
  • DB Development (9)
  • SQL PLSQL (41)
  • Databases AllOther (7)
  • Windows Threads (2)
  • Windows General (6)
  • Windows AllOther (26)
  • Linux Commands (18)
  • Linux Threads (2)
  • Linux IPC (2)
  • Linux Socket Programming (1)
  • Linux System Calls (5)
  • Linux General (3)
  • Linux AllOther (20)
  • Unix Commands (33)
  • Unix IPC (2)
  • Unix Socket Programming (1)
  • Unix General (5)
  • Unix AllOther (11)
  • Solaris Commands (30)
  • Solaris Threads (3)
  • Solaris System Calls (2)
  • Solaris General (10)
  • Solaris AllOther (82)
  • Operating Systems General Concepts (17)
  • Data Structures (1)
  • Operating Systems AllOther (2)
  • WinRunner (10)
  • Load Runner (28)
  • QTP (176)
  • Test Director (3)
  • Rational TestSuite (4)
  • Silk Test (9)
  • Selenium (1)
  • Automation Testing AllOther (10)
  • Manual Testing (277)
  • QA Concepts (23)
  • Mobile Testing (3)
  • Test Cases (21)
  • Test Documents Reporting (2)
  • Testing AllOther (12)
  • Apache (1)
  • Servers AllOther (6)
  • COBOL (138)
  • JCL (132)
  • CICS (31)
  • DB2 (78)
  • IMS (11)
  • IDMS (1)
  • Natural (6)
  • Assembler (1)
  • QMF (2)
  • MVS (2)
  • OS390 (2)
  • VSAM (11)
  • Sysplex (1)
  • IBM MainFrame AllOther (39)
  • RPG400 (59)
  • DB400 (3)
  • COOLPLEX (1)
  • IBM AS400 AllOther (31)
  • IBM PL/1 (1)
  • Core Java (77)
  • Advanced Java (7)
  • Swing (2)
  • EJB (4)
  • Servlets (17)
  • Struts (16)
  • JDBC (11)
  • JMS (2)
  • SunOne (1)
  • J2EE (3)
  • Weblogic (30)
  • Websphere (7)
  • Java J2EE AllOther (6)
  • J2ME (1)
  • Java Related AllOther (4)
  • MQSeries (16)
  • Middleware AllOther (10)
  • HTML DHTML (3)
  • XML XSLT RSS (6)
  • Flash Action Scripting (1)
  • SOAP (1)
  • Web Related AllOther (2)
  • Teradata (41)
  • Business Objects (66)
  • Cognos (171)
  • Informatica (179)
  • Actuate (3)
  • Ab Initio (56)
  • Data Stage (147)
  • SAS (5)
  • Micro Strategy (3)
  • ETL (12)
  • Data Warehouse General (25)
  • HR Questions (24)
  • Design Patterns (6)
  • Requirements Management (1)
  • Project Planning (2)
  • Project Management (2)
  • Software Design AllOther (2)
  • CTC (1)
  • Debugging AllOther (3)
  • Clear Case (10)
  • Version Control AllOther (1)
  • Vi Editor (1)
  • Telecom Protocols (1)
  • ISDN (2)
  • Telecom General (2)
  • SAP Basis (145)
  • SAP ABAP (300)
  • SAPScript (13)
  • SAP SD (310)
  • SAP MM (56)
  • SAP QM (4)
  • SAP PP (34)
  • SAP PM (6)
  • SAP PS (1)
  • SAP FI CO (262)
  • SAP HR (32)
  • SAP CRM (37)
  • SAP SRM (2)
  • SAP APO (2)
  • SAP Business Warehouse (29)
  • SAP Security (159)
  • SAP Interfaces (2)
  • SAP Netweaver (22)
  • SAP ALE IDocs (8)
  • SAP B1 (16)
  • SAP GTS (1)
  • SAP AllOther (11)
  • CRM General (7)
  • Siebel (55)
  • ERP General (3)
  • Oracle Apps Technical (53)
  • Oracle Apps Financial (74)
  • Oracle Apps HRMS (6)
  • Oracle Apps CRM (1)
  • Oracle Apps SCM (10)
  • Oracle Apps AllOther (1)
  • ERP CRM AllOther (1)
  • VLSI (4)
  • Client Server General (4)
  • AI Algorithms (1)
  • AI AllOther (1)
  • Cryptography Algorithms (1)
  • WebMethods (16)
  • TIBCO (18)
  • BPM (1)
  • EAI AllOther (1)
  • Visual Effects (1)
  • Requirement Management (5)
  • Risk Analysis (6)
  • Estimation Analysis (4)
  • Planning & Integration (4)
  • Software Quality Analysis (3)
  • Software Integration & Release (1)
  • Program Management (4)
  • Apache Hadoop (1)
  • Micro Biology (1)
  • Bio Informatics (1)
  • Nuclear Physics (1)
  • Organic Chemistry (1)
  • Health Pharma AllOther (1)
  • Civil Engineering (3)
  • Mechanical Engineering (8)
  • Electrical Engineering (40)
  • Electronics Communications (26)
  • Chemical Engineering (2)
  • Instrumentation (4)
  • Engineering AllOther (17)
  • Business Administration (11)
  • Marketing Sales (14)
  • Banking Finance (16)
  • Human Resources (17)
  • Personnel Management (1)
  • IT Management (5)
  • Non Technical (3)
  • Business Management AllOther (12)
  • Audit (5)
  • CompanyAffairs CS (3)
  • Taxation (21)
  • Accounting General (58)
  • Accounting AllOther (93)
  • Call Centre AllOther (289)
  • Government (1)
  • UPSC General Studies (3)
  • UPSC AllOther (3)
  • SSC General Science (1)
  • SSC General Studies (6)
  • RRB (4)
  • POs (2)
  • BSRB Clerical (2)
  • Group I (4)
  • Group II History (3)
  • Group II AllOther (2)
  • Group II Political Science (1)
  • General Studies (2)
  • APPSC AllOther (10)
  • General Knowledge_Current Affairs (19)
  • Government AllOther (2)
  • Teaching (1)
  • Funny Interview Questions (5)
  • Everything Else AllOther (13)
  • English (12)
  • General Aptitude (67)
  • Puzzles (6)
  • Placement Papers (22)
  • CCNA (42)
  • CCDA (1)
  • Microsoft Certifications (6)
  • Sun Certifications (6)
  • CISA Certification (2)
  • Oracle Certifications (5)
  • ISTQB Certification (5)
  • Certifications AllOther (6)
  • H1B Visa (3)
  • USA Student Visa F1 Visa (5)
  • L1 Visa (4)
  • USA Immigration Visa (1)
  • USA Business Visa B1 Visa (2)
  • USA Dependent Visa H4 Visa (2)
  • USA AllOther Visa (2)
  • UK Visa (1)
  • Australia Visa (1)
  • Canada Visa (3)
  • C Code (8)
  • C++ Code (7)
  • J2SE Code (2)
  • J2EE Code (2)
  • C Sharp Code (1)
  • ADO.NET Code (1)
  • JSP Code (1)
  • GATE (3)
  • IIT JEE (1)
  • CAT (1)
  • OPENMAT (1)
  • ICET (2)
  • Oracle Errors (14)
  • SQLServer Errors (1)
  • Scripts Errors (2)