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

syntex of insert

7 7547

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 3283

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

Silicon,

1 4081

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

4 7106

How to Select second Maximum salary in a Table ?

Oracle,

13 15784

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

Oracle, SAH,

2 5051

what is the exact diiference between DBMS and RDBMS

Tesco,

4 8348

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 9146

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

4 9901

why we use cursors

1 3714

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

1 3280

How to truncate a table first before running a package?

1 3847

how to find full database size

BirlaSoft, Consultancy,

1 5736

How to change maximise or minimise the window in forms

Oracle,

4 12402

what is joins please explain breffly ??

Adaequare, TCS,

1 5081

Un-Answered Questions { Databases }

Explain the necessary techniques to control deadlocks?

910

What do you mean by flat file database?

916

How view is related to data independence?

982

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

995

What are the 5 major parts of a database system?

945

What is difference between mysqli and pdo?

935

How to define a specific record type?

1085

Explain an integrity constrains?

1152

Explain do view contain data?

1016

What is sql or structured query language?

1157

How to provide login information for a new odbc dsn?

1052

How do I change primary key in pgadmin?

829

Explain odi architecture?

621

What is a schema in oracle?

1019

What is SQL Tuning Advisor in Oracle?

1184

For More Un-Answered { Databases } Questions Click Here