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 7214

How do you add a data file to a tablespace?

1 3808

How do you resize a data file?

2 5315

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

1 3969

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

2225

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 5668

How can you gather statistics on a table?

3 8790

How can you enable a trace for a session?

2 6944

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

1 5357

Name two files used for network connection to a database.

1 3317

What is NOCOPY?

DELL,

6 21897

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 7010

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

4 9946

Un-Answered Questions { Databases }

what types of replication are supported in sql server? : Sql server database administration

1050

Explain what is a replica set?

What is an Oracle Data Segment?

1052

How would you extract DDL of a table without using a GUI tool?

2490

How do I upgrade sql?

1004

How does pgadmin connect to remote database?

985

Explain a segment?

1093

Can we use redis as database?

989

What is rich query?

983

How will you find out if there are expensive SQL statements running or not?

1017

What is primary key secondary key alternate key candidate key?

1037

What is father dbms?

1346

How to delete a user account in oracle?

978

8. Supporting AP, AR and GL?

2311

WHAT IS ecc 6.0

2149

For More Un-Answered { Databases } Questions Click Here