Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 9499

what operator performs pattern matching?

2 10624

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 6917

Which command displays the SQL command in the SQL buffer, and then executes it?

TCS,

3 17268

Which system tables contain information on privileges granted and privileges obtained

1 6381

Which system table contains information on constraints on all the tables created?

2 6357

what command is used to create a table by copying the structure of another table?

7 12611

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 8645

What is the use of CASCADE CONSTRAINTS?

3 9862

What is the difference between join and union.

3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

27 172816

What is the difference between anonymous block and named blocks?

3 9329

What is user Account in Oracle database ?

2 3626

How will you enforce security using stored procedures ?

2 4929

What are the dictionary tables used to monitor a database spaces ?

2 7437

What are the responsibilities of a Database Administrator ?

3 7039

Un-Answered Questions { Databases }

Why mysql is used with php?

488

What is data file?

606

What is the quickest way to fetch the data from a table?

558

Explain timestamp?

578

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

489

What are the steps to follow when preparing to create a table?

450

How do I import a csv file into postgres?

487

What is the purpose of database?

468

what is Single Byte Overhead...?

2055

hello to all i want code for like this site "Submit Question" page.please give answers thanks.

1377

Explain atomicity?

567

What will you get by the cursor attribute sql%notfound?

582

Is primary key an index?

529

Can python connect to mysql?

475

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

616

For More Un-Answered { Databases } Questions Click Here