Sql Server Interview Questions and Answers (1758) - Page 77

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

1758 records found.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

What is meant by Loading and Indexing in data warehouse?

It is a process to load the data into the data warehouse and to create the necessary indexes

What is meant by Reconciled data in data warehouse?

Consistency of data represents the quality of data in BI. Data warehouse data should be available for analysis and interpretation. Data reconciliation for DataSources allows you to ensure the consistency of data that has been loaded into BI and is available and used productively there.

Which of the following is called as Data transformation?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following is the two-level data warehouse architecture?

NOTE: This is objective type question, Please click question title for correct answer.

What type of tables available in Snowflake Schema?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following is DATA WAREHOUSE?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following is Operational System?

NOTE: This is objective type question, Please click question title for correct answer.

What is the purpose of Data Mining ?

Data Mining is a process of discovering more reliable data (future market trends, patterns, forecasting) from huge amount of data. It is mainly used for explaining some observed event or condition

Which of the follwoing ACTIVE DATA WAREHOUSE?

NOTE: This is objective type question, Please click question title for correct answer.

What is meant be Data Scrubbing?

Data scrubbing is the process of upgrading the quality of data before it is moved into a data warehouse.
i.e.
Correcting data before moving staging data into data warehouse. To prevent unnecessary data storage in data warehouse and maintain/improve data quality Data Scrubbing will be useful.

What is the output of this SQL ? Select Count(SELECT ID FROM Employee)

NOTE: This is objective type question, Please click question title for correct answer.

Output of SELECT MAX('chandu') ?

NOTE: This is objective type question, Please click question title for correct answer.

Ouptut of SELECT MAX(1,3,4) ?

NOTE: This is objective type question, Please click question title for correct answer.

SELECT MAX(1+2*3) ?

NOTE: This is objective type question, Please click question title for correct answer.

SELECT SUM(1+2*3) ?

NOTE: This is objective type question, Please click question title for correct answer.

What is the output of below SQL ? SELECT 'sampleText' FROM Employee

NOTE: This is objective type question, Please click question title for correct answer.

SELECT COUNT() + COUNT() ?

NOTE: This is objective type question, Please click question title for correct answer.

Output of below SQL ? SELECT * FROM TableA , TableB

NOTE: This is objective type question, Please click question title for correct answer.

Output of this query ? SELECT * FROM 'TableA'

NOTE: This is objective type question, Please click question title for correct answer.

Output of this SQL ? SELECT SELECT 'Chandu'

NOTE: This is objective type question, Please click question title for correct answer.

1
...
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
...
88

More SQL SERVER Exclusive Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites.

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

Interview Questions and Answers Categories

.NET Certifications

ASP.NET Web API

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

Interview Questions

Mobile Development

MSBI (SSIS, SSRS, SSAS)

News and Community

Product Reviews

Project Management

Regular Expressions

Web Services, Remoting