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

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

2 4967

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

3052

how we connect the data base in any programme

2 4403

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 9681

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

CarrizalSoft Technologies,

1 7001

How cand Optimize SQL Server Stored Procedures

1 5145

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

2 7759

What is Online Index Rebuild Operation?

1 3736

What are the limitation of the Online Index Rebuild Operation?

1 3670

What Are Three Rules to Use UNION IN SQL SERVER

1 6469

How to create Clustered Primary Key to table?

2 4948

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

2 12865

How to find 6th highest salary from Employee table ?

10 24081

How can I enforce to use particular index?

Symphony,

1 6173

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

1 7993

Un-Answered Questions { Databases }

What is the difference between functions, procedures, and packages in pl/sql?

1049

Which four data types cannot be used as a return type from a user-defined function?

1024

How do I create a small business database in access?

877

What's the difference between 'union' and 'union all' ?

999

What is a package in oracle?

1102

1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

2215

How many types of cursors are available in pl/sql?

1109

What is the port 5432?

821

Tell me what is the order in which the sql query is executed?

952

Can a formula column be obtained through a select statement ?

2324

How to display a past time in days, hours and minutes?

1016

Explain the difference between repeating frame and frame.

List the types of joins used in writing subqueries?

997

How global temporary tables are represented and its scope?

977

What is an access?

811

For More Un-Answered { Databases } Questions Click Here