GeekInterview.com
  I am new, Sign me up!
 

Database Interview Questions


Database Interview Questions

Questions: 685
Comments: 1880
 Database Tags
 Showing Questions 1-10 of 69 Questions
[1] 2 3 4 5 6 7 Next >>
 Sponsored Links

 
 Database Interview Questions
Sorting Options :  

You have been asked to design the following database diagram:“We would like to store a list of user’s in the database with their corresponding network of friends, groups, as well as any messages 
View Question | Asked by : AMBird

Explain the lifecycle regarding validating data from start to finish? 
View Question | Asked by : ntobin

IRLM is a module of DB2 which doesA. LoggingB. Thread creationsC. Concurrency controlD. Both logging and thread creation. 
View Question | Asked by : Sha255

Functions for error trapping are contained in which section of a PL/SQL block? 
View Question | Asked by : sakthi398

“Bigger the size of a Oracle package, the better”. Do you agree? Justify. 
Latest Answer: No - I do not agreeFunctionality depends..What are you trying to do in a package depends a lot...A Package can call Views, Functions and Triggers, Update, Insert, Delete.. Purpose of a Package, For Eg.. If you create a Month End Package for a Co. It ...
Read Answers (1) | Asked by : nalamla

How does Export/Import feature differ from that of SQL Loader?  
Latest Answer: Its Different.. For Export we are exporing the data from the Database to a Dump file..i.e EXP from user datafile buffer rows compress etcfor Imprting we are importing the data from a dump file to a database..i.e  IMP fromuser touser file= commit ...
Read Answers (2) | Asked by : saeedkm

Differentiate between Controlled and Uncontrolled Redundancy 
Latest Answer: Redundancy is Direct if a value is a copy of another Indirect if the value can be derived from other values: Simplifies retrieval but complicates update Conversely integration makes retrieval slow and updates easier Data ...

Explain what are controlled and uncontrolled data redundancy? 
Latest Answer: I view this as planned and unplanned. Generally planned redundancy for performance reasons has some steps taken to ensure that there is syncronicity between the data. I am not sure if there are formal definitions or the precise meaning of the terms might ...

Describe the process of converting an extended E-R model into a relational database design. 
Latest Answer: ER Model->Logical schema->Normalization->Creating database with tables. ...
Read Answers (1) | Asked by : kh_trnh

Explain the representation of a one-to-many strong entity relationship in a relational database design. 
Latest Answer: Department-Employees  Under one Department many employees are working.Project-Employees ...
Read Answers (1) | Asked by : kh_trnh

View page [1] 2 3 4 5 6 7 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
# User Name Count
1sampra 35
2Beena 28
3christia 21
4sripri 19
5rahultripathi 18
6scott 18
7Robert 13
8malapati 13
9nancyphilips 12
10GregMark 11
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape