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

How do we return a record set from a Stored Procedure in SQl server 2000?

3 6903

What are the magic tables in SQL Server 2000?

Infogain, Merrill Lynch,

7 25868

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 53379

What are the differences between stored procedure and functions in SQL Server 2000?

College School Exams Tests, HCL, Infosys, TCS,

25 114155

What is lexical parameter ?

Zensar,

2 11606

what is a package n what r the packages availbla in report

Convergys,

1 2181

how can u store a picture file in oracle database? explain the path/command?

GE, Satyam,

1 5680

What are all the system Parameters available in ORACLE Reports

GE,

1 19323

What is the sequence the Report triggers will fires while running a report ?

FCS, GE,

1 13856

Where we can use the placeholder columns?

GE,

1 4988

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

GE,

1 2355

How can you create Lexical parameter n Bind parameter in Reports ?

GE, SVSS,

1 6321

What is summary column in Oracle Reports ?

GE,

5 17654

What is the use of Validation triggers in Reports?

GE,

2 12246

What is the use of Printer Definition file (PRT) in Reports ?

Epson, GE,

1 6066

Un-Answered Questions { Databases }

How to Change a users password from unix shell.

1213

What is acid mean in sql server?

1237

How to export data from database and import into another?

993

Does view occupy space?

1005

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1856

How to use values from other tables in update statements using oracle?

1149

what is bcp? When does it used? : Sql dba

1053

Have you written applications to retrieve stored images in a table?

1083

Does group by remove duplicates?

1112

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1190

what are the advantages of sql ? : Sql dba

1138

What is the difference between for xml raw and for xml auto?

1112

What is a view in sql?

1035

What is a concurrency problem in dbms?

1049

Explain system functions or built-in functions? What are different types of system functions?

1060

For More Un-Answered { Databases } Questions Click Here