DBA Interview Questions

Recently Posted

Category

10

Answers

What is Denormalization?

Praveen Moosad
10y Reply
3

Answers

Can a view be updated/inserted/deleted? If Yes – under what conditions?

Gaurav Malviya
10y Reply
4

Answers

What are the advantages of VIEW?

Gaurav Malviya
10y Reply
1

Answer

What is CYCLE/NO CYCLE in a Sequence?

Gaurav Malviya
10y Reply
1

Answer

How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value?

Gaurav Malviya
10y Reply
1

Answer

What is a database link?

Gaurav Malviya
10y Reply
0

Answer

If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

Gaurav Malviya
10y Reply
1

Answer

How will you activate/deactivate integrity constraints?

Gaurav Malviya
10y Reply
1

Answer

Where the integrity constraints are stored in data dictionary?

Gaurav Malviya
10y Reply
0

Answer

What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?

Gaurav Malviya
10y Reply
0

Answer

How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?

Gaurav Malviya
10y Reply
1

Answer

What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type?

Gaurav Malviya
10y Reply
2

Answers

What are the data types allowed in a table?

Gaurav Malviya
10y Reply
0

Answer

What is ON DELETE CASCADE?

Gaurav Malviya
10y Reply
0

Answer

What is the usage of SAVEPOINTS?

Gaurav Malviya
10y Reply

1
2
3
4
5

31 - 45 of 251