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 19645

Do view contain data?

Ramco,

6 11537

select 1,col1,col2 from table1. output?

Ramco,

5 10494

What is integrity constraints?

Ramco, Satyam,

5 20974

use of IN/ANY/ALL

Ramco,

5 11207

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

2 7440

Can anyone give me information about oracle certification

1 4610

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

Wipro,

5 10990

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

6 21630

where the connection string store in the database

HCL, Wipro,

2084

what do u mean by canvases and alerts?

2022

how to give input dynamically to a insert statement in sqlserver

HCL,

3 8517

what is dba_segment

4 10163

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

jusco,

2533

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 18629

Un-Answered Questions { Databases }

What is a trigger word?

1037

How is foreign key commands related to primary key?

836

Why should I use oracle database?

1006

How do I open microsoft access on my computer?

866

Explain temporal data types in oracle

1106

What are the different tables present in MySQL?

1124

Do you know how to send email from database?

1019

How to create a postgresql database?

929

What is the sql case statement used for? Explain with an example?

1013

What are a scheduled jobs?

972

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1047

What is the difference between database and server?

1041

What is the advantage of sql server?

1054

Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?

867

What is ora-1555 snapshot too old error? Explain in detail?

698

For More Un-Answered { Databases } Questions Click Here