ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
 Categories  >>  Software  >>  Databases       
 
  Oracle (1591)   SQL Server (704)   MS Access (13)   MySQL (135)   Postgre (4)
  Sybase (13)   DB Architecture (1)   DB Administration (145)   DB Development (41)   SQL PLSQL (451)
  Databases AllOther (56)
 
Suggest New Category 
 


 

View Page with Answers
  Question  Asked @ Answers Views     select
 
What column differentiates the V$ views to the GV$ views and how?  1  409
Give the stages of instance startup to a usable state where normal users may access it.  0  184
What command would you use to create a backup control file?  1  285
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.  3  866
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?  0  132
Give two examples of referential integrity constraints.  1  340
What type of index should you use on a fact table?  1  355
Give the two types of tables involved in producing a star schema and the type of data theyhold.  1  254
Give the reasoning behind using an index.  2  584
Compare and contrast TRUNCATE and DELETE for a table.  4  934
Where would you look for errors from the database engine? IBM  0  267
Give two examples of how you might determine the structure of the table DEPT.  2  715
Explain the difference between a data block, an extent and a segment.  1  744
How do you switch from an init.ora file to a spfile? TCS   2  1853
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?  2  629
E-Mail New Answers        Answer Selected Questions       
 
Prev    1   ... 14   ... 27   ... 40   ... 53   ... 66   ... 79   ... 92   ... 105   ... 118    130   [131]    132  ... 144   ... 157   ... 170   ... 183    Next
 
 
 Programming Languages interview questions   Programming Languages Interview Questions  Scripts interview questions   Scripts Interview Questions  Networking interview questions   Networking Interview Questions
 Microsoft Related interview questions   Microsoft Related Interview Questions  Databases interview questions   Databases Interview Questions  Operating Systems interview questions   Operating Systems Interview Questions
 Testing interview questions   Testing Interview Questions  Servers interview questions   Servers Interview Questions  MainFrame interview questions   MainFrame Interview Questions
 Java Related interview questions   Java Related Interview Questions  Middleware interview questions   Middleware Interview Questions  Web Related interview questions   Web Related Interview Questions
 Data Warehouse interview questions   Data Warehouse Interview Questions  HR Questions interview questions   HR Questions Interview Questions  Software Design interview questions   Software Design Interview Questions
 Debugging interview questions   Debugging Interview Questions  Version Control interview questions   Version Control Interview Questions  Editors interview questions   Editors Interview Questions
 Telecom interview questions   Telecom Interview Questions  ERP CRM interview questions   ERP CRM Interview Questions  Embedded Systems interview questions   Embedded Systems Interview Questions
 Client Server interview questions   Client Server Interview Questions  Artificial Intelligence interview questions   Artificial Intelligence Interview Questions  Cryptography interview questions   Cryptography Interview Questions
 EAI interview questions   EAI Interview Questions  Multimedia interview questions   Multimedia Interview Questions  Software Development Life Cycle interview questions   Software Development Life Cycle Interview Questions
 Image Processing interview questions   Image Processing Interview Questions
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause? 68  
How to do performance tunning a database in DB2 V8.2 UDB in linux 186  
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards 114  
Which is the best place or learning center for MS SQL?????In Bangladesh????? 87  
please explain.. DB architecture ... 43  
what are corelated subqueries 95  
where the connection string store in the database 115 HCL
Can XML be used to access data? 189  
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks 15  
how to make an oracle object 148  
What is Data model and how to prepare a data model.? 200 TCS
How do you Implement SSIS Packages in your Project? 64  
TILL WHAT LEVEL OF SECURITY BO SUPPORTS? 93  
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons. 274  
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode. 2  
From the database level, how can you tell under which time zone a database is operating? 21  
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan. 255  
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure 91  
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues? 104  
WHAT IS CARDINALITIES OF JOIN? 334  
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com