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

how to get the rowid/rownumbes of a table in sqlserver

IBM,

7 19598

Do view contain data?

Ramco,

6 11517

select 1,col1,col2 from table1. output?

Ramco,

5 10458

What is integrity constraints?

Ramco, Satyam,

5 20930

use of IN/ANY/ALL

Ramco,

5 11186

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 7421

Can anyone give me information about oracle certification

1 4586

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

Wipro,

5 10962

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 21604

where the connection string store in the database

HCL, Wipro,

2077

what do u mean by canvases and alerts?

2017

how to give input dynamically to a insert statement in sqlserver

HCL,

3 8498

what is dba_segment

4 10141

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

jusco,

2523

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

Perot Systems,

10 18599

Un-Answered Questions { Databases }

How do you create a database?

923

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

939

What is varchar data type in sql?

1088

List out the acid properties and explain?

966

In the oracle version 9.3.0.5.0, what does each number shows?

1306

What is the difference between truncate and delete?

1199

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1007

What is materialized view. What are different methods of refresh?

1394

What are the benefits of oracle rac?

What are local and global variables and their differences?

1096

How many primary keys can be there in a table?

994

What is a hierarchical database?

1020

Explain what are sparse columns?

999

What are different relationships existing in database?

1005

How do I connect to a mysql database?

936

For More Un-Answered { Databases } Questions Click Here