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

Oracle (3253)
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

syntex of insert

7 7736

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 3430

What are the mandatory setups in setting up a PO in oracle

Silicon,

1 4169

is it sufficient to normalize a database up to 3NF?

4 7305

How to Select second Maximum salary in a Table ?

Oracle,

13 16206

Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?

Oracle, SAH,

2 5156

what is the exact diiference between DBMS and RDBMS

Tesco,

4 8527

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

Cap Gemini, TCS,

1 9209

how many no of table can be join in a sql query.

4 10087

why we use cursors

1 3792

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 3348

How to truncate a table first before running a package?

1 3917

how to find full database size

BirlaSoft, Consultancy,

1 5802

How to change maximise or minimise the window in forms

Oracle,

4 12552

what is joins please explain breffly ??

Adaequare, TCS,

1 5195

Un-Answered Questions { Databases }

What is offset and limit in sql?

1105

Why truncate is faster than delete?

1165

What are the built in functions in sql server?

1030

List out the differences between global and local temp tables in sql server?

1117

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

637

What is indexing explain it with an example?

1074

Why rdbms is called relational?

974

What is a natural key in sybase?

1135

what are the oracle forms services components include?

1086

What is the file extension for sql database?

1071

What is sqlexception in java?

1039

What is temporary Interface( Yellow Interface) ?

616

Mention how can you determine what protocol is being used for interconnect traffic?

What is difference between excel and access?

1033

Is mongodb distributed database?

For More Un-Answered { Databases } Questions Click Here