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
23.Get information of product sell on month of march in current year.
24.Retrieve Age Group info from Table.
Age Group Chart
**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).
SAMPLE OUTPUT
26.
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 |
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_SELL | DATE |
QTY | DECIMAL |
Status | VARCHAR |
24.Retrieve Age Group info from Table.
Patients_Info_Tab | |
PID | INT |
NAME | VARCHAR |
AGE | INT |
ADDRESS | VARCHAR(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_NAME | VARCHAR |
MIN_QTY | DECIMAL |
MAX_QTY | DECIMAL |
ISACTIVE | BIT |
SAMPLE OUTPUT
26.
select *from (select
DATEPART(MM,GETDATE()) b) a where a.b=datepart(mm,getdate()-365)
Comments
Post a Comment
Dear User,
Thank you very much for your kind response