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 7741

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 3436

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

Silicon,

1 4172

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

4 7317

How to Select second Maximum salary in a Table ?

Oracle,

13 16216

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

Oracle, SAH,

2 5161

what is the exact diiference between DBMS and RDBMS

Tesco,

4 8531

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 9213

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

4 10102

why we use cursors

1 3796

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

1 3352

How to truncate a table first before running a package?

1 3923

how to find full database size

BirlaSoft, Consultancy,

1 5805

How to change maximise or minimise the window in forms

Oracle,

4 12557

what is joins please explain breffly ??

Adaequare, TCS,

1 5204

Un-Answered Questions { Databases }

What is mysqli procedural?

1008

What is isnull() operator?

1095

What is user in sql?

1082

Explain “not null constraint” in sql server?

1092

Which database server is best?

1140

How many databases should a dba manage?

702

What do you mean by cql and how to execute cql commands in neo4j?

Write the syntax for stuff function in an sql server?

1078

Explain difference between cross join and full outer join?

1070

Explain the working of foreign key?

1143

What is sql server and ase?

1072

What is difference between group by and partition by?

1136

How do I restart mysql on windows?

1015

How do I remove all records from a table?

1121

Why join is faster than subquery?

1171

For More Un-Answered { Databases } Questions Click Here