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

Can you tell me how to add new column in existing views?how?How is possible?

FIS,

1446

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

IBM, Saama Tech,

1 3084

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from ; except this you can't use another select statement. You can use no of variables as per requirement.

1 2508

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

Infosys,

1349

how to find 6th highest salary

Chetak Logistics,

1528

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

difference of using cursor for loop and open,fetch,close.which one is better

Accenture,

1805

What are local and global Indexes and where they are useful.

1443

how are rank and dense rank being alloted for column with same values over a particular column

1 2399

what are sequences

1746

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

how to hide the stored procedure inside a package

1 2116

Explain few examples of stored procedure over triggers?

ADITI,

1043

What are the different types of backups that exist?

ADITI,

1167

What can be used instead of trigger?

ADITI,

1156

Un-Answered Questions { Databases }

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

985

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4010

Explain what are the advantages of views?

1069

Can we store pdf files in mysql?

987

How do I set ts role in order to run certain dbccs?

789

How do I create a new database in mysql?

905

How to create table with timestamp in postgres?

815

What are the two types of data independence?

1130

What is page in sql server?

947

How to access postgresql database from another machine?

770

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1933

Explain the structure of pl/sql in brief.

1095

How do I open the query tool in pgadmin?

812

What database should I learn first?

959

Explain bcnf (boyce-codd normal form)?

1017

For More Un-Answered { Databases } Questions Click Here