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

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 5087

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

1 3121

how we connect the data base in any programme

2 4556

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 9770

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

CarrizalSoft Technologies,

1 7117

How cand Optimize SQL Server Stored Procedures

1 5272

How many types of system privileges are there, Can we add or delete privileges?

2 7911

What is Online Index Rebuild Operation?

1 3867

What are the limitation of the Online Index Rebuild Operation?

1 3793

What Are Three Rules to Use UNION IN SQL SERVER

1 6587

How to create Clustered Primary Key to table?

2 5079

Write a SQL Query to find first Week Day of month?

2 13022

How to find 6th highest salary from Employee table ?

10 24539

How can I enforce to use particular index?

Symphony,

1 6282

What is sorting and what is the difference between sorting and clustered indexes?

1 8098

Un-Answered Questions { Databases }

how to use regular expression in pattern match conditions? : Sql dba

1102

Is primary key clustered index?

1008

Does group by remove duplicates?

1106

What is subquery? Explain the properties of a subquery?

1052

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

1051

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2207

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

How can we solve concurrency problems?

1116

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2345

What is the difference between upgrade and migration in sql server?

1170

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

2695

What is the difference between case version and decode version?

1097

What are the kinds of subquery?

1093

Can we shrink data file in sql server?

1117

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1121

For More Un-Answered { Databases } Questions Click Here