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

Explain the ways to controlling cursor behavior?

929

Explain the steps to use transact-sql cursor?

1081

Do you know the cursor types?

1167

What is forward - only cursors / read only cursor?

1101

Do you know the capabilities of cursors?

1159

What is cursor in ms sql server?

1160

What is implicit cursors?

1093

What is explicit cursors?

1087

Explain forward - only cursors?

1088

What is scrollable cursor?

1051

Explain the disadvantages of cursors?

1158

What is key set driven?

971

Explain the cursor lock types?

1068

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

968

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

987

Un-Answered Questions { Databases }

What does mysql flush tables do?

976

What is the difference between BLOB AND TEXT?

1161

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2029

What are the arithmetic operations?

1099

What is a view in sql?

984

Write a query to display even rows in student table using mysql?

905

Can a trigger call a stored procedure?

1084

I am getting error "no communication channel" after changing the domain name? What is the solution?

605

What are truncate options available in sql server? : sql server database administration

1041

Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

1031

Is index automatically created on primary key?

847

What do you understand by a database object?

1083

Explain logical database components? : sql server architect

773

If you have an example table, what is the best way to get sizing data for the production table implementation?

561

What is nvarchar max in sql?

1030

For More Un-Answered { Databases } Questions Click Here