Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Explain about Normalization?

Infosys,

1027

What are triggers? How do you invoke a trigger on demand?

Hexaware,

1262

Explain about Joins?

Infosys,

955

What are the purpose of Normalisation?

HCL,

1017

Difference between group by clause and having clause in SQL?

Flextronics,

941

What are the types of subscriptions in SQL Server replication?

HCL,

982

Â Explain what is sql override for a source taLle in a mapping?

Informatica,

966

What are the characteristics of modern DBMS?

Ericsson,

1051

How to change the system date and time from SQL Plus Terminal ?

MCN Solutions,

1180

Define DML and DCL statements?

Hexaware, NIIT,

1 1600

What is function of ROLLUP ?

HCL,

1056

Where do we generally create INDEX?

Ernst Young, Thomson Reuters,

1 3064

What do you mean by 'normalization'?

Ernst Young, Thomson Reuters,

1025

Define Unique Key?

HCL,

968

Difference between aggregate functions of sql?

EXL,

1056

Un-Answered Questions { Databases }

Why cursor variables are easier to use than cursors?

1041

How do I open sybase control center?

916

Why do we need view in sql?

951

Which date function is used to find the difference between two dates?

546

what are bind variables?

1034

Explain what are called fat clients and fat servers?

997

How many joins in sql server?

918

What is data model in database?

852

Can you always create a cache of a report?

160

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

1996

What is acid property in dbms?

927

What is dba software?

596

What is sqlerrd?

938

What are databases what are the uses of databases?

877

Explain in brief about Microsoft SQL server?

1036

For More Un-Answered { Databases } Questions Click Here