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

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

Indecomm,

7 8433

write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

KPIT,

1 4521

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000

TCS,

4 7091

what is the diffrence between core dba and apps dba?

Cap Gemini,

2569

Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).

1 3944

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

TCS,

4 8286

how to get last monday of a month?

Multifonds,

2 6469

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

BirlaSoft,

1 5884

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

IBM,

2182

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

iGate, Wipro,

14 22241

write a query to remove duplicate records without using primary key column?

ABCO,

2 9390

What Is The Difference Between Primary Key & Super Key

Accenture,

3 7465

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

HCL, Wipro,

2241

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 6542

what is d diff between grant,commit,rollback n savepoint

1 8365

Un-Answered Questions { Databases }

How many joins can you have in sql?

937

What are different types of triggers?

1110

What is subquery in sql?

1067

How to get the number of rows selected or affected by a sql statement?

917

What is the maximum rows in sql server table?

910

What is dba in sound level?

582

how to rename an existing column in a table? : Sql dba

1018

Define database lock?

912

WHAT IS CARDINALITIES OF JOIN?

2363

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1015

How to disconnect from a sql server using mssql_close()?

1109

What is difference between count (*) and count 1?

926

What does rdbms stand for?

1069

What is read committed?

1084

What do you understand by proactive, retroactive and simultaneous update?

1166

For More Un-Answered { Databases } Questions Click Here