CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies
Database Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM DATABASE INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

Database Interview Questions & Answers - Learning Mode

A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. Often abbreviated DB, a database is basically a collection of information organized in such a way that a computer program can quickly select desired pieces of data. We can think of a database as an electronic filing system. Traditional databases are organized by fields, records, and files.

Try Database Interview Questions & Answers - Exam Mode
Subcategories for Database Interview Questions & Answers - Learning Mode

Following are sub categories for which Interview Questions & Answers are available under Database Interview Questions & Answers - Learning Mode. Please select the appropriate sub-category:-

Clipper Interview Questions & Answers (11) Learning Mode | Exam Mode

Data Structure Interview Questions & Answers (93) Learning Mode | Exam Mode

DBA Interview Questions & Answers (190) Learning Mode | Exam Mode

Firebird Interview Questions & Answers (47) Learning Mode | Exam Mode

Hierarchical Database Model Interview Questions & Answers (12) Learning Mode | Exam Mode

Informix Interview Questions & Answers (10) Learning Mode | Exam Mode

Microsoft Access Interview Questions & Answers (35) Learning Mode | Exam Mode

MS SQL Server Interview Questions & Answers (435) Learning Mode | Exam Mode

MYSQL Interview Questions & Answers (71) Learning Mode | Exam Mode

Network Database Model Interview Questions & Answers (76) Learning Mode | Exam Mode

Object Relational Database Interview Questions & Answers (10) Learning Mode | Exam Mode

PL/SQL Interview Questions & Answers (39) Learning Mode | Exam Mode

PostgreSQL Interview Questions & Answers (18) Learning Mode | Exam Mode

Progress Interview Questions & Answers (17) Learning Mode | Exam Mode

Relational Database Interview Questions & Answers (45) Learning Mode | Exam Mode

SQL Interview Questions & Answers (283) Learning Mode | Exam Mode

SQL Server Interview Questions & Answers (164) Learning Mode | Exam Mode

Stored Procedures Interview Questions & Answers (27) Learning Mode | Exam Mode

Sybase Interview Questions & Answers (33) Learning Mode | Exam Mode

Teradata Interview Questions & Answers (37) Learning Mode | Exam Mode

1 2 3 4 5 6 Next

Sort By : Latest First | Oldest First | By Rating

Database Interview Questions & Answers - Learning Mode
Try Database Interview Questions & Answers - Exam Mode
Question: What is dblink and how use it ?

Answer:
Question: What is difference between stack and queue?

Answer: In high level programming, a stack is defined as a list or sequence of elements that is lengthned by placing new elements "on top" of existing elements and shortened by removing elements from the top of existing elements. It is an ADT with math operations of "push" and "pop". A queue is a sequence of elements that is added to by placing the new element at the rear of existing and shortened by removing elements in front of queue. It is an ADT. There is more to these terms understood in programmi Source: CoolInterview.com
Question: void main()
{
int x=5;
printf("%d,%d,%d
",x,x<<2,x<<2);
}
what is the ans. of this question and how?
please explain it.


Answer: The answer would be

5 20 20

as x = 5 so first %d gives 5

second %d will take value of x after left shifting it twice, and shifting is done after converting the values to binary, binary value of 5 (000101)will be left shifted twice to make it binary 20(0010100), so x<<2 is 20

and as left shifting does not effect the original value of x its still 5 so third %d will also show 20.

Thanks Source: CoolInterview.com
Question: What is difference between oracle8i,oracle9i and oracle 10g.

Answer: there is no correct answer but one can clearly say that they are the different versions of oracle and 8i is 1st ,9i is 2nd and 10G is the latest......! Source: CoolInterview.com
Question: What is DML Compiler?

Answer:
It translates DML statements in a query language into low-level instruction that the query evaluation engine can understand. Source: CoolInterview.com
Question: Can you take Image Backups using RMAN?

20. Can you use Back upsets created by RMAN with any other utility?


Answer: Can you take Image Backups using RMAN?

Yes. The command used to take image copy of database is,

RMAN> backup as copy database;

Can you use Back upsets created by RMAN with any other utility?

No. The backup Sets created by RMAN utility cannot be used in other utility other than RMAN.

Source: CoolInterview.com
Question: What is Data Storage - Definition Language?

Answer: The storage structures and access methods used by database system are specified by a set of definition in a special type of DDL called data storage-definition language. Source: CoolInterview.com
Question: What is Normalization? explain all the normal forms.

Answer: Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization.

1N.F:- The table should caontain scalar or atomic values.
2 N.F:- Table should be in 1N.F + No partial functional dependencies
3 N.F :-Table should be in 2 N.F + No transitive dependencies
Source: CoolInterview.com
Question: What is oracle d2k? why we use it?

Answer: It is a front end tool which consist of forms and reports and use plsql as a coding language Source: CoolInterview.com
Question: What is the difference between oracle 9i and 10g database?


Answer: Oracle 10g has many features compare to 9i like
asm,swr,addm,flaskback recovery,data pump.
Generating snap shot is much more flexible in 10 g compare to 9i.
Source: CoolInterview.com
Question: Explain about relational database management systems?

Answer: Relational database systems take the model and form of relational model. Data is represented in the form of columns and rows which are later represented by relation operators. Explicit pointers will not interfere between tables. Source: CoolInterview.com
Question: What is the meaning for data base without using technical terms?

Answer: Database IS A COLLECTION OF INTERRELATED data or information which depends on each other. Source: CoolInterview.com
Question: How we determine index require rebuilding ?

Answer:
Question: Define the "integrity rules"

Answer: There are two Integrity rules.
? Entity Integrity: States that ?Primary key cannot have NULL value?
? Referential Integrity: States that ?Foreign Key can be either a NULL value or should be Primary Key value of other relation. Source: CoolInterview.com
Question: What is Weak Entity set?

Answer: An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and primary key of its parent entity, then it is said to be Weak Entity set. Source: CoolInterview.com
Question: What is undo /rollback segment how you resize this ?

Answer:
Question: Why we use SQL server with VB6 programming instead SQl Server with Access ?

Answer: Sql server is database package used as backend to handle data where as VB6 is IDE programming language for front end programming. Access and Sql server are both work as backend to handle database.So, it is not expected to use them together. Source: CoolInterview.com
Question: My transaction take 30 min i want if my transaction data written in table after each 5 min . If transaction commit or rollback then do according work . this is done through pl/sql how?

Answer:
Question: What is Trigger?

Answer: A trigger is a database object that is attached to a table. In many aspects it is similar to a stored procedure.

A trigger is a database object that is attached to a table. In many aspects it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure." The main difference between a trigger and a stored procedure is that the former is attached to a table and is only fired when an INSERT, UPDATE or DELETE occurs. You specify Source: CoolInterview.com
Question: What is primary & unique key which type index oracle create when we make those key ?

Answer:

1 2 3 4 5 6 Next



India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0 Seconds