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

What is the maximum size of the page ?

2 7285

Which of the packaged procedure is UNRESTRICTED ?

1 5663

What is SQL FORMS ?

CCIL,

1 4402

Name the two files that are created when you generate a form ?

1 4090

What is a trigger?

3 6277

Explain ERASE packaged procedure ?

1 3641

when All datafiles related to a Tablespace are removed ?

1 1967

How the size of the table space can be increased?

1 5151

when A set of Dictionary tables are created ?

2 14926

What is a DATABLOCK ?

2 4824

Can A column defined as PRIMARY KEY can have NULL values ?

2 5054

where a Database Procedure is stored ?

1 4613

What is Dedicated server configuration ?

2 4520

Which factors does not affect the size of the SGA ?

TCS,

3 10041

What does a COMMIT statement do to a CURSOR?

Microsoft, Oracle,

1 22409

Un-Answered Questions { Databases }

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

List out the different types of locks available in sql server?

1043

How do I start sql server 2017?

1010

If a cursor is open, how can we find in a pl/sql block?

1235

What is a scheduled job or what is a scheduled task?

1031

what is dbms? : Sql dba

1057

what is sql server agent? : Sql dba

1174

Do we need to rebuild index after truncate?

1128

What are the two main functions of queries in databases?

1522

how many tables will create when we create table, what are they? : Sql dba

1139

what are aggregate and scalar functions? : Sql dba

1122

What is the best sql course?

1042

how to escape special characters in sql statements? : Sql dba

1110

How can we solve concurrency problems?

1116

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2346

For More Un-Answered { Databases } Questions Click Here