1. Which of the following SQL statements deletes all rows in table called 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?
Correct Answer is : SELECT ProductID FROM Products
3. RDBMS stands for
Correct Answer is : Relational Database Management System
4. Which SQL statement is used to extract data from a database?
Correct Answer is : SELECT
5. For which of the following can you fire triggers
Correct Answer is : INSERT, UPDATE and DELETE commands
6. The __________ is an Access add-in program that provides data analysis tools for financial analysis.
Correct Answer is : Analysis ToolPak
7. Point out the correct statement :
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.
Correct Answer is : unlink
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 :
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 ?
Correct Answer is : Slow performance with linked tables
12. Which of the following option is used to find database objects by using filter criteria ?
Correct Answer is : Advanced Object Select dialog box
13. Which of the following change took place in JULY 2014 release of SSMA ?
Correct Answer is : Highlighting of “well known” LOB schemas
14. _________ shows information about Access databases that have been added to the project.
Correct Answer is : Access Metadata Explorer
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.
Correct Answer is : SQL Server 2012 Data Mining Add-ins
17. Point out the correct statement :
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.
Correct Answer is : Table Analysis Tools for Excel
19. ___________ analyzes the patterns in data that have the strongest influence on a certain outcome.
Correct Answer is : Analyze Key Influencers
20. Point out the wrong statement :
Correct Answer is : The Detect categories tool predicts future values based on trends in existing time series data.