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

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

1 1042

Explain for xml explicit mode?

1 1046

How can you check the level of fragmentation on a table?

1 1112

Explain an automatic checkpoint

1 1038

If no size is defined while creating the database, what size will the database have?

1 1061

How you would rewrite the sql query to return the customerid sorted numerically?

1 1070

What you can do to delete a table without the delete trigger firing?

1 1033

What is the difference between insensitive and scroll cursor?

1 1273

Why transaction is important?

1 1049

in the physical file layout, where should the transaction log be stored in relation to the data file?

1 1064

What are the approximate numeric data types?

1 997

What is a partitioned view?

1 1073

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1 1101

What is a derived table?

1 1022

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1 1273

Un-Answered Questions { Databases }

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2088

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

Can delete statement be rollbacked?

1050

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2176

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2701

How to use values from other tables in update statements using oracle?

1149

please send me oracle pl/sql exp resume. and also faqs...

2566

How to write a left outer join with the where clause in oracle?

1149

What is the current version of sql?

1091

How do I remove duplicates in two columns?

1177

what is bcp? When does it used? : Sql dba

1053

what are all the common sql function? : Sql dba

1125

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

Do we need to rebuild index after truncate?

1128

what is the difference between openrowset and openquery?

1186

For More Un-Answered { Databases } Questions Click Here