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 5069

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

3112

how we connect the data base in any programme

2 4538

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 9765

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

CarrizalSoft Technologies,

1 7106

How cand Optimize SQL Server Stored Procedures

1 5263

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

2 7900

What is Online Index Rebuild Operation?

1 3844

What are the limitation of the Online Index Rebuild Operation?

1 3772

What Are Three Rules to Use UNION IN SQL SERVER

1 6572

How to create Clustered Primary Key to table?

2 5066

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

2 13007

How to find 6th highest salary from Employee table ?

10 24492

How can I enforce to use particular index?

Symphony,

1 6259

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

1 8088

Un-Answered Questions { Databases }

How is it different from a normal table?

1088

Explain the hardware architecture used in oracle rac?

What does the not null constraint do?

1188

What are the best features of mongodb?

How many types of normalization? What is the use of it?

1196

What are the different types of dbmss?

1062

How can you handle the –secure-file-priv in mysql?

995

What is vacuum in database?

927

Is mysqli faster than mysql?

988

Is it important to partition hard disk?

1078

Whis is not false in primary key?

1531

What is table level trigger?

1060

What is view? Can we update view

1533

What’s the use of custom fields in report?

999

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

1677

For More Un-Answered { Databases } Questions Click Here