DBA Interview Questions

Recently Posted

Category

22

Answers

What is the difference between TRUNCATE and DROP?

Ankur Jain
11y Reply
8

Answers

What function extracts specified characters from a string?

Ankur Jain
11y Reply
6

Answers

What is the difference between a check constraint and a rule?

Ankur Jain
11y Reply
6

Answers

What are different type of Collation Sensitivity?

Ankur Jain
11y Reply
9

Answers

What is the name of the system variable that returns the number of rows affected by a SQL statement?

Ankur Jain
11y Reply
3

Answers

What is the difference between system objects and user objects?

Ankur Jain
11y Reply
3

Answers

What are the properties of Sub–Query?

Ankur Jain
11y Reply
11

Answers

What is the difference between Triggers and Stored Procedure?

Ankur Jain
11y Reply
13

Answers

What are the Difference between Structure and Class??

Abhishek Yadav
11y Reply
4

Answers

What is SGA(System Global Area)?

Sanjay Singh
11y Reply
12

Answers

What is Denormalization?

Praveen Kumar
11y Reply
3

Answers

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

Gaurav Malviya
12y Reply
4

Answers

What are the advantages of VIEW?

Gaurav Malviya
12y Reply
1

Answer

What is CYCLE/NO CYCLE in a Sequence?

Gaurav Malviya
12y 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
12y Reply

1
2
3
4
5

31 - 45 of 231