Read the most frequently asked 58 top MSBI multiple choice questions and answers for freshers and experienced job interview questions pdf download free.
1. What is the difference between UNION and UNION ALL?
A. Union selects only unique row (data) from all queries and Union all selects all rows from all queries.
B. Union selects row (data) from all queries and Union all selects all rows from all queries.
C. Union selects only unique row (data) from all queries and Union all selects rows from all queries.
D. Union selects row (data) from all queries and Union all selects rows from all queries.
Ans: a
2. Define Row Number function?
A. To generate sequence number.
B. To generate sequence number based on order by column.
C. To generate number.
D. None.
Ans: b
3. What is Normalization? Types of normalization?
A. Join the tables
B. Move the data into tables.
C. Split the table to reduce duplicates and it has five types.
D. None
Ans: c
4. What are different types of joins?
A. Inner, outer, self join.
B. Equi join and cross join.
C. Right outer join.
D. All above.
Ans: d
5. What are the advantages of using stored procedure?
A. Pre executable program.
B. We can get the data.
C. Security.
D. It is similar to function.
Ans: a
6. What is BCP?
A. Bulk copy program.
B. Business continuity program.
C. A and B.
D. None.
Ans: a
7. Define Index?
A. Predefined pointers to data page.
B. It is primary key.
C. It is foreign key.
D. None.
Ans: a
8. What command do we use to rename db, table, and column?
A. Invoke command
B. Commit
C. Rename
D. None.
Ans: c
9. Define having clause?
A. It is similar to where but must use group by clause.
B. It is equal to where clause.
C. None.
D. It is equal to from clause.
Ans: a
10. What are the basic functions system databases?
A. To create functions.
B. To create stored procedure.
C. To maintain metadata information.
D. None.
Ans: c
Read More Posts =>
Part1 Part2 Part3 Part4 Part5 Part6
1. What is the difference between UNION and UNION ALL?
A. Union selects only unique row (data) from all queries and Union all selects all rows from all queries.
B. Union selects row (data) from all queries and Union all selects all rows from all queries.
C. Union selects only unique row (data) from all queries and Union all selects rows from all queries.
D. Union selects row (data) from all queries and Union all selects rows from all queries.
Ans: a
2. Define Row Number function?
A. To generate sequence number.
B. To generate sequence number based on order by column.
C. To generate number.
D. None.
Ans: b
3. What is Normalization? Types of normalization?
A. Join the tables
B. Move the data into tables.
C. Split the table to reduce duplicates and it has five types.
D. None
Ans: c
4. What are different types of joins?
A. Inner, outer, self join.
B. Equi join and cross join.
C. Right outer join.
D. All above.
Ans: d
5. What are the advantages of using stored procedure?
A. Pre executable program.
B. We can get the data.
C. Security.
D. It is similar to function.
Ans: a
6. What is BCP?
A. Bulk copy program.
B. Business continuity program.
C. A and B.
D. None.
Ans: a
7. Define Index?
A. Predefined pointers to data page.
B. It is primary key.
C. It is foreign key.
D. None.
Ans: a
8. What command do we use to rename db, table, and column?
A. Invoke command
B. Commit
C. Rename
D. None.
Ans: c
9. Define having clause?
A. It is similar to where but must use group by clause.
B. It is equal to where clause.
C. None.
D. It is equal to from clause.
Ans: a
10. What are the basic functions system databases?
A. To create functions.
B. To create stored procedure.
C. To maintain metadata information.
D. None.
Ans: c
Read More Posts =>
Part1 Part2 Part3 Part4 Part5 Part6
No comments:
Post a Comment