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

What is a ‘namespace’?

Are null values allowed?

How does sharding work with replication?

When using replication, can some members use journaling and others not?

If a ‘movechunk’ fails, is it necessary to cleanup the partially moved docs?

What is a master or primary?

When an object attribute is removed, is it deleted from the store?

How do I do transactions/locking?

Should you start out with sharded or with a non-sharded mongodb environment?

What happens when a shard is down or slow when querying?

what is cte? : Mysql dba

948

what is database white box testing? : Mysql dba

1002

what is the default port for mysql server? : Mysql dba

1050

can you tell the order of sql select statement? : Mysql dba

914

what is database black box testing? : Mysql dba

1122

Un-Answered Questions { Databases }

What is difference between mysql and mysql workbench?

963

How to create a view using data from another view?

954

what is denormalization and when would you go for it? : Sql server database administration

1204

What is couchdb?

How do you create an update query?

966

What are the restrictions that views have to follow? : SQL Server Architecture

1007

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1979

Explain different types of collation sensitivity?

987

Explain syntax for disabling triggers?

1046

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

What is a null value?

1150

london school of science and technology has a software development unit,known as lsst solutions,which is responsible for developing and implementing software throughout the collegejames tristan keeps a record of all student details in the college including student id,name,and start date and phone number.There are many courses offered by LSST. For example MBA, MSc, BSc, BABS, DF, English etc. Each course id identified by course id, description, duration. Each course has many semesters. Each semester takes place during a particular term. Semester details and term details are required to be stored in the database. Each course has many subjects and same subject may be offered in many courses. For each subject many details such as Subject code, name, result and attendance are required to be stored. Every subject has mainly two assessments; one assignment and one exam. Assignment is worth of 30% and exam 70% respectively. You have been appointed as a database designer. Your job is to provide ERD with all possible entities and relationships. Note: Feel free to make necessary assumptions 3: Assignment Tasks. 1. Create an ERD for the above problem 2. Translate the ERD to Relational Data model (RDM) 3. Implement the RDM by creating the tables 4. Populate the database with your own data. 5. SQL Queries for the following tasks a. List all student details in each course along with course details b. Count and display number of students in each course. c. List student name, course name, assessment description, marks for all students.

2547

What plvcmt and plvrb does in pl/sql?

1328

How do we display rows from the table without duplicates?

977

How to insert stored procedure result into temporary table?

1020

For More Un-Answered { Databases } Questions Click Here