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

How do you change a password for an existing user via mysqladmin?

2 7828

Use mysqldump to create a copy of the database?

2 6596

Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

TCS,

1 5146

What are some good ideas regarding user security in MySQL?

2 5176

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9876

What does myisamchk do?

1 4483

Explain advantages of InnoDB over MyISAM?

1 8273

Explain advantages of MyISAM over InnoDB?

1 6530

What are HEAP tables in MySQL?

1 12983

How do you control the max size of a HEAP table?

1 8997

What are CSV tables?

1 6229

Explain federated tables?

Tech Mahindra,

3 9126

What is SERIAL data type in MySQL?

Aspire,

3 48157

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

2 12395

If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

ABC,

2 6290

Un-Answered Questions { Databases }

How do I count rows in sql query?

988

Why rdbms is called relational?

916

How to use in conditions in oracle?

1058

What is the role of where clause in ms access?

831

Which data type columns are the best candidates for full-text indexing?

967

How to use 'mysql' to run sql statements?

1094

What is domain in dbms?

953

How do you create access?

886

Can multiple cursors being opened at the same time?

1060

1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

1783

Are you doing the updates from within a cursor?

1119

How to list all field names in the result set using mssql_field_name()?

914

Mention the command used to rename the database.

1005

who developed informix?

Difference between Logical Page and Physical Page in SSRS.

476

For More Un-Answered { Databases } Questions Click Here