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 7829

Use mysqldump to create a copy of the database?

2 6598

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

TCS,

1 5147

What are some good ideas regarding user security in MySQL?

2 5176

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 9878

What does myisamchk do?

1 4484

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 9127

What is SERIAL data type in MySQL?

Aspire,

3 48161

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

2 12396

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

ABC,

2 6294

Un-Answered Questions { Databases }

Explain oracle data types with examples?

1028

How do I delete a trigger?

965

What is translate in oracle?

1098

What is the use of limit() function in mongodb?

Describe an oracle table?

1049

what is 'mysqlimport'? : Sql dba

1051

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1916

Can we write ddl statements in functions?

1116

What is an index. What are the types?

1091

How do I run a query in pl sql developer?

993

Where does mysql store data?

876

Can we use delete in merge statement?

1039

what is a composite primary key ? : Sql dba

1050

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2066

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

950

For More Un-Answered { Databases } Questions Click Here