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

Explain the role of indexing in databases?

1 1209

what does the t-sql command ident_incr does? : Transact sql

1 1150

what is the difference between truncate and delete statement? : Transact sql

1 1135

what is “go” in t-sql? : Transact sql

1 1187

what are the join types in tsql? : Transact sql

1 1136

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1 1031

what is uncommittable transactions? : Transact sql

1 1068

what are the t string functions available in tsql? : Transact sql

1 1080

what is the syntax used for partition in tsql? : Transact sql

1 1082

what are rollup and cube in t-sql? : Transact sql

1 1175

what does the t-sql command ident_current does? : Transact sql

1 1065

what are dynamic queries in t-sql? : Transact sql

1 1081

what is top in tsql? : Transact sql

1 1198

what is sub-query? : Transact sql

1 1176

how does a local variable is defined using t-sql? : Transact sql

1 1091

Un-Answered Questions { Databases }

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1897

Is there some bulk load or other way to import a lot of data fast?

931

Can delete statement be rollbacked?

1050

What is your daily office routine?

2340

What is self contained sub query?

1138

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2292

how to start mysql server? : Sql dba

1262

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

Is it possible to have clustered index on separate drive from original table location?

1036

How do I create a trace in sql server?

1113

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

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

1053

Do we need to rebuild index after truncate?

1132

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1844

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

2177

For More Un-Answered { Databases } Questions Click Here