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 4028

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 5348

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 8920

How can you enable a trace for a session?

2 7027

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

1 5438

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 }

Where is microsoft access located?

888

What new data source types were added in ssrs 2014?

169

Do you know spatial data types - geometry and geography in sql server 2008?

1092

which background process invoke at the time of upgradation tell me???

2783

Define a temp table?

1082

What is a dynamic query?

1073

What are the numeric comparison operations?

1170

How can you start sql server in different modes?

1021

How is mapping of name of dll and function done?

How to download microsoft sql server 2005 express edition?

1099

Name the different triggers associated with oracle forms having a master-detail relationship.

1060

How do I do transactions/locking in mongodb?

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2540

I am getting error "no communication channel" after changing the domain name? What is the solution?

648

Do you know what is user defined datatypes and when you should go for them?

1014

For More Un-Answered { Databases } Questions Click Here