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

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

IBM, TCS,

3 10322

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 14191

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

4368

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

6 17130

what is the location of oracle inventory?

2073

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,

2240

how fastest access of data can be done from database ?

3 5416

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

IBM,

2066

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

Infozech, Wipro,

3 6131

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

Wipro,

4 6603

What is nvl function?

Cap Gemini,

4 13093

what is 'force view'?

Cap Gemini, SPIC,

3 18404

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

2104

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

3 4404

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,

2165

Un-Answered Questions { Databases }

what is the different between now() and current_date()? : Sql dba

1026

What is the use of sqlerrd 3?

944

What is scalar function in sql?

1044

How do I find the port number for sql server?

972

How can you access different databases temporarily?

What do you understand by user-defined function in the sql server?

956

How and why use sql server?

1014

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1069

Differentiate between translate and replace?

1123

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1838

Explain what are page splits? : SQL Server Architecture

1070

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

What does a pl/sql package consist of?

979

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2568

What is database in php mysql?

1000

For More Un-Answered { Databases } Questions Click Here