Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 7351

How do you add a data file to a tablespace?

1 3922

How do you resize a data file?

2 5432

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

1 4029

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

2293

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

2388

How can you rebuild an index?

1 5349

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

1 5776

How can you gather statistics on a table?

3 8921

How can you enable a trace for a session?

2 7027

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

1 5439

Name two files used for network connection to a database.

1 3387

What is NOCOPY?

DELL,

6 22092

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 7127

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

4 10065

Un-Answered Questions { Databases }

Does sql full backup truncate logs?

1081

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1897

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

What are the restrictions applicable while creating views?

1000

What are the approximate numeric data types?

988

Differentiate between ‘cluster’ and ‘non-cluster’ index.

1011

Which certification is best for sql?

1044

what is a chunk in informix ?

125

How to pipe multiline string to isql?

1057

What is the difference between sga and pga?

667

What is memory advisor in Oracle?

1136

Can we save image in database?

1032

If you are not sure what command does a particular unix function what is the best way to determine the command?

602

Why foreign key constraint is important?

857

What is the difference between mysql_connect and mysqli_connect?

1025

For More Un-Answered { Databases } Questions Click Here