MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 83 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which are the SQL Server 2008 R2 components require space more than 1.5 Gb? |
| A. | SSIS |
| B. | SSAS |
| C. | Client components |
| D. | SSRS |
| Answer» D. SSRS | |
| 2. |
Which is the minimum processor speed for SQL Server 2012? |
| A. | 1.4 GHz |
| B. | 2.4 GHz |
| C. | 3.4 GHz |
| D. | 4.4 GHz |
| Answer» B. 2.4 GHz | |
| 3. |
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”? |
| A. | SELECT * FROM Persons WHERE FirstName=’a’ |
| B. | SELECT * FROM Persons WHERE FirstName LIKE ‘a%’ |
| C. | SELECT * FROM Persons WHERE FirstName LIKE ‘%a’ |
| D. | SELECT * FROM Persons WHERE FirstName=’%a%’ |
| Answer» D. SELECT * FROM Persons WHERE FirstName=’%a%’ | |
| 4. |
Which SQL function is used to count the number of rows in a SQL query? |
| A. | COUNT() |
| B. | NUMBER() |
| C. | SUM() |
| D. | COUNT(*) |
| Answer» E. | |
| 5. |
The UNION SQL clause can be used with _____________ |
| A. | SELECT clause only |
| B. | DELETE and UPDATE clauses |
| C. | UPDATE clause only |
| D. | All of the mentioned |
| Answer» B. DELETE and UPDATE clauses | |
| 6. |
Syntax for viewing the methods and properties we can pipe our output to Get-Member by ______________ |
| A. | Get-Process |
| B. | Get-Member |
| C. | Get-Process | Get-Member |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 7. |
Find all the tuples having a temperature greater than ‘Paris’. |
| A. | SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’ |
| B. | SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’) |
| C. | SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’) |
| D. | SELECT * FROM weather WHERE temperature > ‘Paris’ temperature |
| Answer» B. SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’) | |
| 8. |
What does the ALTER TABLE clause do? |
| A. | The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints |
| B. | The SQL ALTER TABLE clause is used to insert data into database table |
| C. | THE SQL ALTER TABLE deletes data from database table |
| D. | The SQL ALTER TABLE clause is used to delete a database table |
| Answer» B. The SQL ALTER TABLE clause is used to insert data into database table | |
| 9. |
Which of the following is a database object? |
| A. | Tables |
| B. | Triggers |
| C. | Functions |
| D. | All of the mentioned |
| Answer» E. | |
| 10. |
The main memory requirements for SQL Server 2008 includes ___________ |
| A. | Minimum:512 MB |
| B. | Minimum:1 GB |
| C. | Maximum:252 MB |
| D. | Maximum:512 MB |
| Answer» B. Minimum:1 GB | |
| 11. |
What is the purpose of the SQL AS clause? |
| A. | The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column |
| B. | The AS clause is used with the JOIN clause only |
| C. | The AS clause defines a search condition |
| D. | All of the mentioned |
| Answer» B. The AS clause is used with the JOIN clause only | |
| 12. |
What is the full form of DML in SQL Server Basics? |
| A. | Different Mode Level |
| B. | Data Model Language |
| C. | Data Mode Lane |
| D. | Data Manipulation language |
| Answer» E. | |
| 13. |
DecryptByKeyAutoCert is ________________ type function. |
| A. | Symmetric Encryption and decryption |
| B. | Encryption Hashing |
| C. | Asymmetric Encryption and decryption |
| D. | Symmetric decryption with Automatic key handling |
| Answer» E. | |
| 14. |
With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”? |
| A. | SELECT * FROM Persons SORT BY ‘FirstName’ DESC |
| B. | SELECT * FROM Persons ORDER FirstName DESC |
| C. | SELECT * FROM Persons SORT ‘FirstName’ DESC |
| D. | SELECT * FROM Persons ORDER BY FirstName DESC |
| Answer» E. | |
| 15. |
Which is the minimum processor speed for SQL Server 2008? |
| A. | 1.4 GHz |
| B. | 2.4 GHz |
| C. | 3.4 GHz |
| D. | 4.4 GHz |
| Answer» B. 2.4 GHz | |
| 16. |
What is the meaning of LIKE ‘%0%0%’? |
| A. | Feature begins with two 0’s |
| B. | Feature ends with two 0’s |
| C. | Feature has more than two 0’s |
| D. | Feature has two 0’s in it, at any position |
| Answer» E. | |
| 17. |
What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine? |
| A. | 811 Mb |
| B. | 711 Mb |
| C. | 611 Mb |
| D. | 511 Mb |
| Answer» C. 611 Mb | |
| 18. |
Which of the following are TCL commands? |
| A. | UPDATE and TRUNCATE |
| B. | SELECT and INSERT |
| C. | GRANT and REVOKE |
| D. | ROLLBACK and SAVEPOINT |
| Answer» E. | |
| 19. |
Which of the following function checks whether the expression is a valid date or not? |
| A. | ISDATE |
| B. | ISDAY |
| C. | ISVALID |
| D. | ISYEAR |
| Answer» B. ISDAY | |
| 20. |
Which of the following tool is used for designing schema of the database in SSMS? |
| A. | Query Designer |
| B. | Database Diagrams |
| C. | Table designer |
| D. | Query Editor |
| Answer» D. Query Editor | |
| 21. |
Unrestricted execution policy can be set up in SQL Server can be done using __________ |
| A. | Set-ExecutionPolicy Unrestricted |
| B. | Set-Policy Unrestricted |
| C. | Set-Policy Unrestricted |
| D. | None of the mentioned |
| Answer» B. Set-Policy Unrestricted | |
| 22. |
You want to track date and time of the last write access per row. Select the suitable option among the below. |
| A. | Add TIMESTAMP column to the table |
| B. | Add a DATETIME column to the table and assign getdate() as the default value |
| C. | Add a DATETIME column to the table and write a trigger that sets its value |
| D. | Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions |
| Answer» B. Add a DATETIME column to the table and assign getdate() as the default value | |
| 23. |
________ is a spatial data type. |
| A. | geometry |
| B. | sql_variant |
| C. | cursor |
| D. | all of the mentioned |
| Answer» C. cursor | |
| 24. |
Which of the following is not a mathematical function? |
| A. | ATN2 |
| B. | POWER |
| C. | PI |
| D. | CEIL |
| Answer» E. | |
| 25. |
Which of the following is not a DDL command? |
| A. | UPDATE |
| B. | TRUNCATE |
| C. | ALTER |
| D. | None of the Mentioned |
| Answer» B. TRUNCATE | |
| 26. |
___________ is stored only in the Master database. |
| A. | Database-scoped Dynamic Management View |
| B. | Complex View |
| C. | Catalog View |
| D. | None of the mentioned |
| Answer» E. | |
| 27. |
What is SQL Server 2012 R2 Hard Disk Space Requirement for database engine? |
| A. | 811 Mb |
| B. | 711 Mb |
| C. | 611 Mb |
| D. | 511 Mb |
| Answer» B. 711 Mb | |
| 28. |
SQL query to find all the cities whose humidity is 95. |
| A. | SELECT city WHERE humidity = 95 |
| B. | SELECT city FROM weather WHERE humidity = 95 |
| C. | SELECT humidity = 89 FROM weather |
| D. | SELECT city FROM weather |
| Answer» C. SELECT humidity = 89 FROM weather | |
| 29. |
Which of the following code list all the log files in Window? |
| A. | snippet Clear-Host |
| B. | snippet Clear-Host |
| C. | snippet Clear-Host |
| D. | All of the mentioned |
| Answer» B. snippet Clear-Host | |
| 30. |
The UPDATE SQL clause can _____________ |
| A. | update only one row at a time |
| B. | update more than one row at a time |
| C. | delete more than one row at a time |
| D. | delete only one row at a time |
| Answer» C. delete more than one row at a time | |
| 31. |
Built in Functions in SQL Server is categorized into how many categories? |
| A. | 4 |
| B. | 5 |
| C. | 6 |
| D. | 7 |
| Answer» B. 5 | |
| 32. |
SMO in SQL Server stands for ___________ |
| A. | Server Management Object |
| B. | Service Management Object |
| C. | SQL Management Object |
| D. | SQL Server Management Object |
| Answer» E. | |
| 33. |
What does the SQL Server setup program require? |
| A. | Named Pipes |
| B. | Shared Memory |
| C. | Microsoft Windows Installer 4.5 |
| D. | All of the mentioned |
| Answer» C. Microsoft Windows Installer 4.5 | |
| 34. |
Which of the following operating system is Supported by IA-64 Edition? |
| A. | Windows Server 2003 R2 SP2 64-bit Itanium Datacenter |
| B. | Windows Server 2003 SP2 64-bit x64 Datacenter |
| C. | Windows Server 2003 SP2 64-bit x64 Enterprise |
| D. | Windows Server 2003 SP2 64-bit x64 Standard |
| Answer» B. Windows Server 2003 SP2 64-bit x64 Datacenter | |
| 35. |
Which of the following shortcut is used for displaying error list? |
| A. | Ctrl + / |
| B. | Ctrl + | |
| C. | Ctrl + \ |
| D. | Ctrl + ! |
| Answer» D. Ctrl + ! | |
| 36. |
Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester? |
| A. | SELECT DISTINCT course id |
| B. | SELECT DISTINCT course_id |
| C. | SELECT course id |
| D. | SELECT COUNT (DISTINCT ID) |
| Answer» B. SELECT DISTINCT course_id | |
| 37. |
Which of the following component is not installed by SQL Server setup 2012 required by the product? |
| A. | .NET Framework 3.5 SP11 |
| B. | Named Pipes |
| C. | SQL Server Setup support files |
| D. | All of the mentioned |
| Answer» C. SQL Server Setup support files | |
| 38. |
Syntax for creating views is __________ |
| A. | CREATE VIEW AS SELECT |
| B. | CREATE VIEW AS UPDATE |
| C. | DROP VIEW AS SELECT |
| D. | CREATE VIEW AS UPDATE |
| Answer» B. CREATE VIEW AS UPDATE | |
| 39. |
The phrase “greater than at least one” is represented in SQL by ___________ |
| A. | < all |
| B. | < some |
| C. | > all |
| D. | > some |
| Answer» E. | |
| 40. |
Which SQL statement is used to return only different values? |
| A. | SELECT DIFFERENT |
| B. | SELECT UNIQUE |
| C. | SELECT DISTINCT |
| D. | SELECT ALL |
| Answer» D. SELECT ALL | |
| 41. |
NESTLEVEL function falls under which of the following category? |
| A. | Configuration functions |
| B. | Cursor functions |
| C. | Mathematical functions |
| D. | Date and Time Data Functions |
| Answer» B. Cursor functions | |
| 42. |
Which TCL command undo all the updates performed by the SQL in the transaction? |
| A. | ROLLBACK |
| B. | COMMIT |
| C. | TRUNCATE |
| D. | DELETE |
| Answer» C. TRUNCATE | |
| 43. |
______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking. |
| A. | RANK |
| B. | NTILE |
| C. | DENSE_RANK |
| D. | ROW_NUMBER |
| Answer» D. ROW_NUMBER | |
| 44. |
Which of the following is not a conversion function? |
| A. | CAST and CONVERT |
| B. | PARSE |
| C. | TRY_CAST |
| D. | TRY_CASE |
| Answer» E. | |
| 45. |
Which of the following SQL clauses is used to DELETE tuples from a database table? |
| A. | DELETE |
| B. | REMOVE |
| C. | DROP |
| D. | CLEAR |
| Answer» B. REMOVE | |
| 46. |
The command to remove rows from a table ‘CUSTOMER’ is __________________ |
| A. | DROP FROM CUSTOMER |
| B. | UPDATE FROM CUSTOMER |
| C. | REMOVE FROM CUSTOMER |
| D. | DELETE FROM CUSTOMER WHERE |
| Answer» E. | |
| 47. |
Dynamic Management View is a type of ___________ |
| A. | System Defined Views |
| B. | User Defined View |
| C. | Simple View |
| D. | Complex View |
| Answer» B. User Defined View | |
| 48. |
The following SQL is which type of join: |
| A. | Equi-join |
| B. | Natural join |
| C. | Outer join |
| D. | Cartesian join |
| Answer» E. | |
| 49. |
Which panel presents a list of objects under the selected node? |
| A. | Template Explorer |
| B. | Object Explorer |
| C. | Properties window |
| D. | Query Editor |
| Answer» C. Properties window | |
| 50. |
Which of the following command is used to get child items in powershell? |
| A. | Get-Child |
| B. | Set-Alias |
| C. | Get-Command |
| D. | Get-ChildItem |
| Answer» E. | |