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 7534

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 3277

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

Silicon,

1 4080

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

4 7100

How to Select second Maximum salary in a Table ?

Oracle,

13 15763

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

Oracle, SAH,

2 5043

what is the exact diiference between DBMS and RDBMS

Tesco,

4 8339

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 9141

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

4 9894

why we use cursors

1 3707

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

1 3274

How to truncate a table first before running a package?

1 3846

how to find full database size

BirlaSoft, Consultancy,

1 5731

How to change maximise or minimise the window in forms

Oracle,

4 12395

what is joins please explain breffly ??

Adaequare, TCS,

1 5077

Un-Answered Questions { Databases }

What's new in sql management studio for sql server? : sql server management studio

1065

How can I compare two mysql databases?

967

Explain natural key?

1135

What is raid, and how it can influence database performance?

1056

What are the applications of database management system?

891

What is the usage of control file in oracle?

1088

Explain about the hierarchical model of the database?

1116

What is the difference between nvl function, ifnull function, and isnull function?

1107

How triggers can be used in mysql?

1017

how you can get the list of largest tables in a database? : Sql server administration

1053

How to get each name only once from an employee table?

1116

What are the different kinds of ssrs reports?

214

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2362

What is the largest component inside a field?

1128

What authentication modes does sql server support?

1098

For More Un-Answered { Databases } Questions Click Here