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 7551

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 3284

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

Silicon,

1 4082

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

4 7113

How to Select second Maximum salary in a Table ?

Oracle,

13 15797

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

Oracle, SAH,

2 5056

what is the exact diiference between DBMS and RDBMS

Tesco,

4 8350

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 9147

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

4 9903

why we use cursors

1 3715

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 3848

how to find full database size

BirlaSoft, Consultancy,

1 5738

How to change maximise or minimise the window in forms

Oracle,

4 12405

what is joins please explain breffly ??

Adaequare, TCS,

1 5084

Un-Answered Questions { Databases }

How do I setup mysql?

907

Where is pgadmin installed?

785

How to Join tables on common columns.

1192

Which are the different character-manipulation functions in sql?

1071

What command would you use to create an index?

1057

How do you create a database in access?

968

Do you have any idea about the tcl commands?

967

What is the difference between execution of triggers and stored procedures?

1120

What is 3nf normalization form?

1121

What is the difference between delete and truncate statements?

1085

List the various privileges that a user can grant to another user?

1047

how to write date and time literals? : Sql dba

969

What is the first step in creating a database?

894

What is the full form of dba?

610

How do you identify a primary key?

1067

For More Un-Answered { Databases } Questions Click Here