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.
| 51. |
Ctrl+K+K shortcut refers to ___________ |
| A. | Refresh IntelliSense |
| B. | Add or remove a bookmark |
| C. | Enable all bookmarks |
| D. | Move to the next bookmark |
| Answer» C. Enable all bookmarks | |
| 52. |
With SQL, how can you return the number of not null records in the “Persons” table? |
| A. | SELECT COUNT() FROM Persons |
| B. | SELECT COLUMNS() FROM Persons |
| C. | SELECT COLUMNS(*) FROM Persons |
| D. | SELECT COUNT(*) FROM Persons |
| Answer» B. SELECT COLUMNS() FROM Persons | |
| 53. |
Which of the following code snippet will return output as false? |
| A. | PS C:\bin> $myData = "01/28/1969" |
| B. | PS C:\bin> $myData = "01/28/1969" |
| C. | PS C:\bin> $myData = "01/28/1969" |
| D. | PS C:\bin> $myData = "01/28/1969" |
| Answer» B. PS C:\bin> $myData = "01/28/1969" | |
| 54. |
Which of the following is a feature of SQL Server 2014? |
| A. | Column oriented database |
| B. | Support for 32-bit and 64-bit processors |
| C. | In memory database |
| D. | All of the mentioned |
| Answer» E. | |
| 55. |
______________ is schematic drawing used for representing relationships in database. |
| A. | Trigger |
| B. | Database Diagrams |
| C. | Table designer |
| D. | Query Editor |
| Answer» C. Table designer | |
| 56. |
If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________ |
| A. | ASC |
| B. | DESC |
| C. | There is no default value |
| D. | None of the mentioned |
| Answer» B. DESC | |
| 57. |
Which menu is used to restore windows to their original locations? |
| A. | Edit |
| B. | File |
| C. | Tools |
| D. | Windows |
| Answer» E. | |
| 58. |
Which components of SQL Server 2014 require 1182 Mb? |
| A. | SSIS |
| B. | SSAS |
| C. | Client components |
| D. | SSRS |
| Answer» D. SSRS | |
| 59. |
Data types in SQL Server are organized into how many categories? |
| A. | 6 |
| B. | 8 |
| C. | 9 |
| D. | 10 |
| Answer» B. 8 | |
| 60. |
Which of the following feature is not provided by SSS 2008? |
| A. | Automatic formatting |
| B. | IntelliSense |
| C. | Code Outlining |
| D. | SQLCMD |
| Answer» B. IntelliSense | |
| 61. |
Which of the following is used to build sql statements without writing code? |
| A. | Registered Servers |
| B. | Query Designer |
| C. | Template Explorer |
| D. | Context Explorer |
| Answer» C. Template Explorer | |
| 62. |
Which command is used to reset default configuration in SSMS? |
| A. | Clear |
| B. | Hide |
| C. | Reset all |
| D. | Reset |
| Answer» E. | |
| 63. |
Which of the following data type is not present in SQL Server? |
| A. | bit |
| B. | boolean |
| C. | hierarchyid |
| D. | geography |
| Answer» C. hierarchyid | |
| 64. |
Which of the following is a feature of SQL Server 2012 R2 Enterprise? |
| A. | In memory database |
| B. | Hot-add RAM |
| C. | Database partitioning |
| D. | All of the mentioned |
| Answer» E. | |
| 65. |
______________ function returns current date and time. |
| A. | SET DATEFIRST |
| B. | SYSDATETIME |
| C. | Cert_ID |
| D. | GETDATE |
| Answer» E. | |
| 66. |
Which of the following shortcut is used to clear all bookmarks? |
| A. | Ctrl+K+L |
| B. | Ctrl+K+O |
| C. | Ctrl+K+B |
| D. | Ctrl+K+P |
| Answer» B. Ctrl+K+O | |
| 67. |
Which of the following is a large object data type? |
| A. | varchar(max) |
| B. | varbinary(max) |
| C. | nvarchar(max) |
| D. | image |
| Answer» E. | |
| 68. |
Which of the data type has a storage size of 8 bytes? |
| A. | timestamp |
| B. | uniqueidentifier |
| C. | real |
| D. | smallmoney |
| Answer» B. uniqueidentifier | |
| 69. |
Code for creating an HTML report that lists the name of each service along with its status is __________ |
| A. | Get-Ser | ConvertTo-HTML -Property Name, Status > C:\services.htm |
| B. | Get-Service | Property Name, Status > C:\services.htm |
| C. | Get-Service | ConvertTo-HTML -Property Name, Status > C:\services.htm |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 70. |
ntext data type falls under which category? |
| A. | Exact numerics |
| B. | Character strings |
| C. | Unicode character strings |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 71. |
______________ is monetary data type in SQL Server. |
| A. | Smallmoney |
| B. | sql_variant |
| C. | Cursor |
| D. | None of the Mentioned |
| Answer» B. sql_variant | |
| 72. |
The supported storage types for data files are ___________ |
| A. | RAM |
| B. | Hard Storage |
| C. | SMB File Share |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 73. |
Point out the wrong statement related to SQL Server 2014. |
| A. | SQL Server 2014 CTP 1 is pre-release software and should be installed only on a clean machine |
| B. | SQL Server 2014 CTP 1 is a non-production release and should be installed and used in production environments |
| C. | SQL Server 2014 CTP 1 is only available in the English language |
| D. | None of the mentioned |
| Answer» C. SQL Server 2014 CTP 1 is only available in the English language | |
| 74. |
Which of the following is not a feature of SQL Server 2008 R2 Enterprise? |
| A. | Hot-add CPU |
| B. | Hot-add RAM |
| C. | Database partitioning |
| D. | In memory database |
| Answer» E. | |
| 75. |
Which of the following is a feature of SQL Server 2008 R2 Datacenter? |
| A. | StreamInsight Premium real-time event processing |
| B. | Support for 32-bit and 64-bit processors |
| C. | Support for up to 256 logical CPUs |
| D. | All of the mentioned |
| Answer» C. Support for up to 256 logical CPUs | |
| 76. |
__________ convert object properties into CSV objects. |
| A. | ConvertFrom-CSV |
| B. | Convert-CSV |
| C. | ConvertFromCSV |
| D. | All of the mentioned |
| Answer» B. Convert-CSV | |
| 77. |
Which of the following pane option is not provided by Query Designer? |
| A. | Diagram pane |
| B. | Grid pane |
| C. | Results pane |
| D. | Query pane |
| Answer» E. | |
| 78. |
Which of the SQL Server RTM included native support for managing XML data?Codename for SQL Server 2012 is __________ |
| A. | 7.0Kilimanjaro |
| B. | 6.5Katmai |
| C. | 8Denali |
| D. | 9Hekaton |
| Answer» D. 9Hekaton | |
| 79. |
SQL Server 2005 has the following features? |
| A. | Dynamic Management Views |
| B. | FILESTREAM |
| C. | Powerpivot |
| D. | In-memory capability |
| Answer» B. FILESTREAM | |
| 80. |
Which was the first version of SQL Server to introduce in-memory capability? |
| A. | SQL Server 2012 |
| B. | SQL Server 2014 |
| C. | SQL Server 2005 |
| D. | SQL Server 2008 |
| Answer» C. SQL Server 2005 | |
| 81. |
When was the first version of Microsoft SQL Server released? |
| A. | 1983 |
| B. | 1988 |
| C. | 1990 |
| D. | 1991 |
| Answer» C. 1990 | |
| 82. |
_________ is free database software running free SQL Server technology. |
| A. | SQL Server Express |
| B. | SQL Server Workgroup |
| C. | SQL Server Enterprise |
| D. | SQL Server Web |
| Answer» B. SQL Server Workgroup | |
| 83. |
LocalDB was introduced in which of the following versions of SQL Server? |
| A. | 2012 |
| B. | 2008 |
| C. | 2014 |
| D. | 2008 R2 |
| Answer» B. 2008 | |