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

When creating a user, what permissions must you grant to allow them to connect to the database?

4 7217

How do you add a data file to a tablespace?

1 3812

How do you resize a data file?

2 5318

What view would you use to look at the size of a data file?

1 3970

What view would you use to determine free space in a tablespace?

2226

How would you determine who has added a row to a table?

2318

How can you rebuild an index?

1 5258

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 5670

How can you gather statistics on a table?

3 8792

How can you enable a trace for a session?

2 6949

What is the difference between the SQL*Loader and IMPORT utilities?

1 5362

Name two files used for network connection to a database.

1 3322

What is NOCOPY?

DELL,

6 21900

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 7013

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 9947

Un-Answered Questions { Databases }

Tell me what are cursors and when they are useful?

957

How do I debug a stored procedure?

1119

What are the advantages of microsoft access?

896

What happens if the imported table already exists?

1035

Where is data stored in database?

876

Explain fully functional dependency?

973

Can we call stored procedure in trigger?

952

How to get the current date in mysql?

1062

Difference between pre-select and pre-query

1115

What is sql and how does it work?

1182

what is the syntax for using sql_variant_property? : Transact sql

1049

What language is sql server written in?

1042

what is the difference between an ltm and a repagent in sybase?

915

Does google use postgresql?

907

Which is the most used database?

943

For More Un-Answered { Databases } Questions Click Here