Best practices for Database Administrator Interviews

Dear DBA User,

It is very useful to do practices for interview by attending questions and check the score.

We are here put some basic level of interview questions.

You may get your answers from mailing us or comment on this page. We will replying you shortly.


** Questions regarding null values **

1.What is the output of select null/0 (from dual)

2.select ISNULL(null/0,0)

3.select ISNULL('NULL','Bhavesh')

**Basic SQL Server related Questions.

4.How many system Databases?what is the use of it ?name of it.

5.Types of Joins in SQL

6.How to connect SQL Server from Command Prompt ?.

7.What is Normalization ?

8.What is the difference between Truncate and Delete ?.

9.What is Schema ?which one is Database Default Schema.?

10.What are the  Indexes ?What are the usages to use it ?.

11.What is Database User?What is SQL Server Login?What is the difference between DATABASE USERS  and SQL LOGIN ?.

12.What is DMV and DMF ?

13.What is Views ?.

14.What are the triggers ?what is use of it ?

15.What is DML,DDL and DCL ?.

16.What is Stored Procedure and benefits of it ?

17.How to shrink Database ?

18.What is use of Transaction log ?

19.How to take backup of database ?

20. How to recover Database ?


** Some Basic and Complex Queries **

21.Get the Second Highest Salary paid to Employee from EMPLOYEE_SALARY_TAB

22.Get duplicate values from Table

USER_LOGIN_TAB
USERID INT
NAME VARCHAR
PASSWORD VARCHAR
EMAIL VARCHAR
ADDRESS VARCHAR
ISACTIVE bit
ISLOCKED bit



23.Get information of product sell on month of march in current year.

PRODUCT_SELL_INFO
ID INT
PID INT
DATE_OF_SELLDATE
QTYDECIMAL
Status VARCHAR


24.Retrieve Age Group info from Table.

Patients_Info_Tab
PID INT
NAME VARCHAR
AGEINT
ADDRESSVARCHAR(MAX)
GENDER VARCHAR

Age Group Chart

Age Group
AG1 AG2 AG3
5 10 15

**AG1 means age between 10-16
**AG2 means age between 17-30
**AG3 means age between >30

25.Write Query to retrieve next 10 products on click on website.(Paging on shopping Cart).


PRODUCT_MASTER_TAB
PID INT
PRODUCTNAME VARCHAR
SHORT_NAMEVARCHAR
MIN_QTYDECIMAL
MAX_QTY DECIMAL
ISACTIVE BIT

SAMPLE OUTPUT







26.
select *from (select DATEPART(MM,GETDATE()) b) a where          a.b=datepart(mm,getdate()-365)


Comments

Popular posts from this blog

Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c

Oracle 10g/11g Linux:SMS the alert logs ORA- errors generated in timestamp

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server.