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

why we go for package? what are the advantages of using instead of seperate procuderes or functions

IBM, TCS,

3 10463

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

Cognizant,

7 14406

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4418

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

6 17396

what is the location of oracle inventory?

2116

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

Satyam,

2278

how fastest access of data can be done from database ?

3 5518

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

IBM,

2129

i had backup last manday.now i need back monday to now ..how do get backup?

Infozech, Wipro,

3 6257

now one user in online.now i want drop him..how do u drop him?

Wipro,

4 6759

What is nvl function?

Cap Gemini,

4 13281

what is 'force view'?

Cap Gemini, SPIC,

3 18531

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2157

5) Which acid property will effect when we use commit in trigger?

3 4545

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

IBM,

2210

Un-Answered Questions { Databases }

How to open and close an explicit cursor in oracle?

1103

How do I edit a procedure in sql server?

1002

What is difference between oracle and mysql?

990

What does REVERT do in SQL Server 2005?

1013

Is mysql from oracle?

1019

Where do you use decode and case statements?

1047

What is 2nf in database?

1083

What are the types of queries in sql?

1136

Which is the most used database?

989

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1152

Why I have to use stored procedures?

1098

What is an etl file?

1015

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

772

What is a user view?

801

What do you mean by SQL injection attack?

1129

For More Un-Answered { Databases } Questions Click Here