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

What is the built-in used to get and set lov properties during run-time?

1 5054

What are the various methods of performing a calculation in a report ?

1 3903

Can a field be used in a report wihtout it appearing in any data group?

1 4068

what are different types of canvas views?

3 18049

Explain about stacked canvas views?

2 11456

what are the different objects that you cannot copy or reference in object groups?

1 3995

What are the triggers available in the reports?

3 5537

List some built-in routines used to manipulate images in image_item?

1 4446

What are modalless windows?

1 4304

Which of the two views should objects according to possession?

1 4473

Can a repeating frame be careated without a data group as a base?

2 5019

What is an anchoring object & what is its use?

2 5421

What is the built-in function used for finding the alert?

1 4350

What is the built_in routine used to count the no of rows in a group?

1 5605

How can a text file be attached to a report while creating in the report writer?

1 3722

Un-Answered Questions { Databases }

What is the difference between cross join and natural join?

1068

How to write a query with an inner join in oracle?

1096

What is compound trigger?

1106

What are the different types of database objects?

1121

What are security principals used in sql server 2005?

1038

How do I install microsoft sql?

1116

Which is better Oracle or MS SQL? Why?

5037

How do I make my sql query run faster?

1018

Is it possible to call a stored procedure within a stored procedure?

1026

How to pipe multiline string to isql?

1053

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

1976

List the merits of index covering.

920

What is the simplest way to create a new database in ms sql server?

1052

Explain about thread and memory management process of SQL?

1018

what is the difference between a having clause and a where clause? : Sql dba

1159

For More Un-Answered { Databases } Questions Click Here