SQL Server Interview Questions - 1

1. Which of the following SQL statements deletes all rows in table called SalesData?

A. DELETE SalesData

B. DELETE * FROM SalesData

C. DELETE ALL SalesData

D. DELETE FROM SalesData

Correct Answer is : DELETE FROM SalesData

2. Which SQL statement selects all rows from a table called Products and sorts the result set by ProductID column?

A. SELECT * FROM Products WHERE ProductID > 200

B. SELECT ProductID FROM Products

C. SELECT * FROM Products ORDERED BY ProductID

D. SELECT * FROM Products ORDER BY ProductID

Correct Answer is : SELECT ProductID FROM Products

3. RDBMS stands for

A. Real Database Management System

B. Read Database Master System

C. Relational Database Management System

D. Remote DataBase Management System

Correct Answer is : Relational Database Management System

4. Which SQL statement is used to extract data from a database?

A. EXTRACT

B. OPEN

C. GET

D. SELECT

Correct Answer is : SELECT

5. For which of the following can you fire triggers

A. INSERT, UPDATE and DELETE commands

B. SEARCH operation

C. Arrange data in sorted ORDER

D. JOIN two tables to retrieve values

Correct Answer is : INSERT, UPDATE and DELETE commands

6. The __________ is an Access add-in program that provides data analysis tools for financial analysis.

A. Analysis ToolPak

B. Analysis Tool

C. Analysis ToolSQL

D. All of the mentioned

Correct Answer is : Analysis ToolPak

7. Point out the correct statement :

A. SSMS for Access converts Access database objects to SQL Server or SQL Azure database object

B. Use the CONVERSION page of the Project Settings dialog box to specify how much data appears on the Data tab

C. SSMA for Access converts Access database objects to SQL Server or SQL Azure database object

D. None of the mentioned

Correct Answer is : SSMA for Access converts Access database objects to SQL Server or SQL Azure database object

8. When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.

A. link

B. unlink

C. import

D. All of the mentioned

Correct Answer is : unlink

9. __________ is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005

A. SSAM

B. SSMA

C. SSMS

D. SSAS

Correct Answer is : SSMA

10. Point out the wrong statement :

A. SQL Server Migration Assistant is a environment that helps you quickly migrate Access databases to SQL Server or SQL Azure

B. By using SSMA, you can review Access and SQL Server or SQL Azure database objects

C. When you link an Access table to a SQL Server,SQL Server database engine stores connection information and table metadata

D. None of the mentioned

Correct Answer is : When you link an Access table to a SQL Server,SQL Server database engine stores connection information and table metadata

11. Which is the most serious issue after migration of access database to SQL Server ?

A. Auto-increment columns are not updated until the record is updated

B. Slow performance with linked tables

C. New records are not available

D. You cannot modify a linked table schema with Access

Correct Answer is : Slow performance with linked tables

12. Which of the following option is used to find database objects by using filter criteria ?

A. Advanced Object Select dialog box

B. Advanced find Select dialog box

C. Advanced filter Select dialog box

D. Advanced Object and filter Select dialog box

Correct Answer is : Advanced Object Select dialog box

13. Which of the following change took place in JULY 2014 release of SSMA ?

A. Added support of MS SQL Server 2014

B. Set cascade actions for circular references to No Action

C. Fixed bugs regarding invisible report pages in IE 10

D. Highlighting of “well known” LOB schemas

Correct Answer is : Highlighting of “well known” LOB schemas

14. _________ shows information about Access databases that have been added to the project.

A. SQL Server Metadata Explorer

B. Access Metadata Explorer

C. Access Metadata Expl

D. None of the mentioned

Correct Answer is : Access Metadata Explorer

15. Which of the following network protocol should be selected to enable IP address ?

A. Udp

B. Named pipes

C. Tcp

D. None of the mentioned

Correct Answer is : Tcp

16. _____________ for Office is a lightweight set of tools for predictive analytics.

A. SQL Server 2008 Data Mining Add-ins

B. SQL Server 2012 Data Mining Add-ins

C. SQL Server 2014 Data Mining Add-ins

D. SQL Server 2012 Data Mining Excel

Correct Answer is : SQL Server 2012 Data Mining Add-ins

17. Point out the correct statement :

A. You cannot create and save connections to re-use data sources, repeat experiments, or re-train models

B. The add-ins are built on the capabilities of the .NET Framework 2.0 and the .NET programmability support provided by Office 2007

C. The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data

D. None of the mentioned

Correct Answer is : The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data

18. _____________ allows you to analyze your spreadsheet data in powerful ways.

A. Data Mining Templates for Visio

B. Table Analysis Tools for Excel

C. Data Mining Client for Excel

D. All of the mentioned

Correct Answer is : Table Analysis Tools for Excel

19. ___________ analyzes the patterns in data that have the strongest influence on a certain outcome.

A. Analyze Key Influencers

B. Detect Categories

C. Fill From Example

D. None of the mentioned

Correct Answer is : Analyze Key Influencers

20. Point out the wrong statement :

A. The Detect Categories tool detects the rows in the data table that contain similar characteristics and groups them into categories

B. The tool employs SQL Server Data Mining to detect patterns in the sample you provide and apply those to the remaining missing values

C. The Detect categories tool predicts future values based on trends in existing time series data.

D. All of the mentioned

Correct Answer is : The Detect categories tool predicts future values based on trends in existing time series data.

SQL Server interview questions part 1

SQL Server interview questions part 1

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

1. Which of the following SQL statements deletes all rows in table called SalesData?

2. Which SQL statement selects all rows from a table called Products and sorts the result set by ProductID column?

3. RDBMS stands for

4. Which SQL statement is used to extract data from a database?

5. For which of the following can you fire triggers

6. The __________ is an Access add-in program that provides data analysis tools for financial analysis.

7. Point out the correct statement :

8. When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.

9. __________ is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005

10. Point out the wrong statement :

11. Which is the most serious issue after migration of access database to SQL Server ?

12. Which of the following option is used to find database objects by using filter criteria ?

13. Which of the following change took place in JULY 2014 release of SSMA ?

14. _________ shows information about Access databases that have been added to the project.

15. Which of the following network protocol should be selected to enable IP address ?

16. _____________ for Office is a lightweight set of tools for predictive analytics.

17. Point out the correct statement :

18. _____________ allows you to analyze your spreadsheet data in powerful ways.

19. ___________ analyzes the patterns in data that have the strongest influence on a certain outcome.

20. Point out the wrong statement :

Similar Interview Questions

Search for latest jobs

For Employers

For Partner

For Jobseekers

Help

Follow Us

snaprecruit

Download mobile appsJust Swipe to apply for jobs. Try it out !