DBA Interview Questions

Recently Posted

Category

13

Answers

What is the difference between Delete and Truncate?

Cristopher Coronado
4y Reply
1

Answer

What is the difference between Top 1 and Top 1 1 in SQL Query

Jenith Thakkar
6y Reply
2

Answers

What is Database Cloning?

Gajendra Jangid
7y Reply
4

Answers

What are Cron jobs? How it is done in SQL Managment Studio?

Ahsan Siddique
7y Reply
1

Answer

I have a sql column Employee_Id , I want display all data of this column in two equaly devided column in one table

Prafull Goswami
7y Reply
1

Answer

How to make a column which accepts unique values or multiple null without using a trigger?

Vimal Lohani
8y Reply
10

Answers

What is the difference between where clause and having Clause?

Vishal Dusane
8y Reply
2

Answers

What is the difference between mysql and mysqli?

Bhushan Singh
8y Reply
7

Answers

What is the difference between inner and outer join? Explain with example.

Vishal Prajapati
8y Reply
14

Answers

How to delete duplicate rows in a Table keeping only one using MSSQL Query?

Sabyasachi Mishra
9y Reply
25

Answers

Difference between Table and Views ?

Pavan Ramamurthy
9y Reply
9

Answers

What is ROWNUM, RANK and ROWCOUNT ?

Pavan Ramamurthy
9y Reply
1

Answer

Write a SQL Function to find the MAX and MIN number From String .

Gyan Prakash Verma
10y Reply
1

Answer

snapshot, _________ clause tells oracle how long to wait between refreshes 1) complete 2) force 3) next 4) refreshes

Rupesh Kahane
10y Reply
17

Answers

Database template is 1) matser 2) model 3) Temp DB 4) None of these

Rupesh Kahane
10y Reply

1
2
3
4
5

16 - 30 of 231