MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 99 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
Reasons for consideration of the stored procedure can be? |
| A. | With which tables will you have to work? Does it make sense to create a VIEW first? |
| B. | How often will this procedure actually be used? |
| C. | Do you want to view data in the database (SELECT), insert new records (INSERT INTO), or do I want to change an existing record (UPDATE)? |
| D. | All of the mentioned |
| Answer» E. | |
| 52. |
____________ cursor is sensitive to any changes to the data source. |
| A. | Static Cursors |
| B. | Dynamic Cursors |
| C. | Keyset Driven Cursors |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 53. |
__________ is used to build the code dynamically and execute it. |
| A. | sp_addmessage |
| B. | sp_dropmessage |
| C. | sp_altermessage |
| D. | sp_executesql |
| Answer» E. | |
| 54. |
Which of the stored procedure used for dynamic SQL is prone to attacks? |
| A. | xp_executesql |
| B. | executesql |
| C. | sp_execute |
| D. | sp_executesql |
| Answer» E. | |
| 55. |
AFTER trigger in SQL Server can be applied to _________________ |
| A. | Table |
| B. | Views |
| C. | Table and Views |
| D. | Function |
| Answer» D. Function | |
| 56. |
The basic syntax for using EXECUTE command is ___________ |
| A. | SP_EXECUTE(@SQLStatement) |
| B. | EXEC_SQL(@SQLStatement) |
| C. | EXECUTE(@SQLStatement) |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 57. |
Which of the following benefit does Exception handling with the TRY and CATCH blocks provide? |
| A. | Exceptions provide a mechanism to signal errors directly rather than using some side effects |
| B. | Exceptions can be seen by the programmer and checked during the compilation process |
| C. | Exceptions provide a clean way to check for errors without cluttering code |
| D. | All of the mentioned |
| Answer» E. | |
| 58. |
_____________ procedure cannot be created in Resource database. |
| A. | System |
| B. | User defined |
| C. | Extended |
| D. | All of the mentioned |
| Answer» C. Extended | |
| 59. |
Which of the following is not a typical trigger action? |
| A. | Insert |
| B. | Select |
| C. | Delete |
| D. | All of the mentioned |
| Answer» C. Delete | |
| 60. |
Which of the following is a control flow keyword? |
| A. | IF |
| B. | GO |
| C. | GOTO |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 61. |
__________ takes no parameters and returns all kinds of interesting information. |
| A. | sp_monitor |
| B. | sp_on |
| C. | sp_status |
| D. | none of the mentioned |
| Answer» B. sp_on | |
| 62. |
Which of the following keyword is not associated with initialization of variable? |
| A. | DECLARE |
| B. | SET |
| C. | SELECT |
| D. | All of the mentioned |
| Answer» E. | |
| 63. |
Which of the following is a global variable for error handling? |
| A. | @@ERRORS |
| B. | @@ERROR |
| C. | @@ERR |
| D. | None of the mentioned |
| Answer» C. @@ERR | |
| 64. |
Which of the following global has return type ‘numeric’? |
| A. | @@ERROR |
| B. | @@MAX_CONNECTIONS |
| C. | @@CPU_BUSY |
| D. | @@IDENTITY |
| Answer» E. | |
| 65. |
Various alternatives to cursor in SQL Server are ___________ |
| A. | FOR |
| B. | IF..ELSE |
| C. | WHILE |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 66. |
Nesting level of a stored procedure’s execution is stored in the _________ function. |
| A. | @@NEST |
| B. | @@NESTLEVEL |
| C. | @@LEVEL |
| D. | None of the mentioned |
| Answer» C. @@LEVEL | |
| 67. |
__________create the removable database. |
| A. | sp_certify_removable |
| B. | sp_certify |
| C. | sp_removable |
| D. | all of the mentioned |
| Answer» B. sp_certify | |
| 68. |
How many ways of returning data is present in SQL Server 2000? |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 6 |
| Answer» C. 5 | |
| 69. |
Variables was added newly to SQL Server version _____________ |
| A. | 2005 |
| B. | 2008 |
| C. | 2012 |
| D. | 2014 |
| Answer» C. 2012 | |
| 70. |
Value of the @techonthenet variable can be changed using the SET statement, as follows __________ |
| A. | SET @techonthenet = ‘Example showing how to declare variable’; |
| B. | SELECT @techonthenet = ‘Example showing how to declare variable’; |
| C. | SET @techonthenet == ‘Example showing how to declare variable’; |
| D. | None of the mentioned |
| Answer» B. SELECT @techonthenet = ‘Example showing how to declare variable’; | |
| 71. |
Which of the following blocks are used for error handling in SQL Server? |
| A. | TRY…CATCH |
| B. | TRY…FINAL |
| C. | TRY…END |
| D. | CATCH…TRY |
| Answer» B. TRY…FINAL | |
| 72. |
How many types of DDL Trigger is present in SQL Server? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» C. 3 | |
| 73. |
____________ triggers do not create the special inserted and deleted tables. |
| A. | DML |
| B. | CLR |
| C. | DDL |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 74. |
The following code snippet uses the DELAY keyword to wait for ______ seconds. |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» B. 3 | |
| 75. |
Which of the following scenario makes use of BEGIN..END keyword redundant? |
| A. | when an IF statement controls the execution of multiple Transact-SQL statement |
| B. | when an IF statement controls the execution of only one Transact-SQL statement |
| C. | when an IF statement controls the execution of one or more Transact-SQL statement |
| D. | none of the mentioned |
| Answer» C. when an IF statement controls the execution of one or more Transact-SQL statement | |
| 76. |
Which of the following two Transact-SQL statements are commonly used with WHILE? |
| A. | BREAK and CONTINUE |
| B. | BREAK and IF |
| C. | IF and ELSE |
| D. | All of the mentioned |
| Answer» B. BREAK and IF | |
| 77. |
Which of the following statements can be checked for Errors? |
| A. | CREATE |
| B. | DROP |
| C. | DELETE |
| D. | INSERT |
| Answer» E. | |
| 78. |
Which of the following FORWARD ONLY Cursor is populated at the time of creation? |
| A. | KEYSET |
| B. | FORWARD_ONLY STATIC |
| C. | FAST_FORWARD |
| D. | All of the mentioned |
| Answer» C. FAST_FORWARD | |
| 79. |
Purpose of TRY…CATCH block in SQL Server is ___________ |
| A. | Error handling |
| B. | Stored Procedure handling |
| C. | Message handling |
| D. | None of the mentioned |
| Answer» B. Stored Procedure handling | |
| 80. |
Stored procedure used to remember the exact number of bytes is _____________ |
| A. | sp_datatype |
| B. | sp_datatype_info |
| C. | sp_info |
| D. | none of the mentioned |
| Answer» C. sp_info | |
| 81. |
_____________ sets procedure options in SQL Server. |
| A. | sp_procoption |
| B. | sp_dropmessage |
| C. | sp_altermessage |
| D. | sp_executesql |
| Answer» B. sp_dropmessage | |
| 82. |
Data return using output parameter is ____________ |
| A. | Return codes, which are always an integer value |
| B. | A global cursor that can be referenced outside the stored procedure |
| C. | A single cursor that can be referenced inside the stored procedure |
| D. | None of the mentioned |
| Answer» E. | |
| 83. |
Which of the following is a proprietary extension of SQL for Microsoft SQL Server? |
| A. | PL-SQL |
| B. | T-SQL |
| C. | PG-SQL |
| D. | P-SQL |
| Answer» C. PG-SQL | |
| 84. |
Which of the following is not a SERVICE BROKER statement? |
| A. | BEGIN CONVERSATION TIMER |
| B. | END CONVERSATION |
| C. | CREATE USERS |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 85. |
Applications that can generate Transact-SQL can be ____________ |
| A. | General office productivity applications |
| B. | Applications that use a graphical user interface (GUI) to let users select the tables and columns from which they want to see data |
| C. | Applications that use general language sentences to determine what data a user wants to see |
| D. | All of the mentioned |
| Answer» E. | |
| 86. |
RECEIVE service broker statement applies to which of the versions? |
| A. | 2000 |
| B. | 2005 |
| C. | 2008 |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 87. |
Which of the following Statement ends one side of an existing conversation? |
| A. | BEGIN CONVERSATION TIMER |
| B. | END CONVERSATION TIMER |
| C. | END CONVERSATION |
| D. | GET CONVERSATION GROUP |
| Answer» C. END CONVERSATION | |
| 88. |
Purpose of GET_TRANSMISSION_STATUS is _____________ |
| A. | Returns the status for the first transmission for end side of a conversation |
| B. | Returns the status for the first transmission for one side of a conversation |
| C. | Returns the status for the last transmission for end side of a conversation |
| D. | Returns the status for the last transmission for one side of a conversation |
| Answer» E. | |
| 89. |
Which of the following is- a security statement? |
| A. | ADD SIGNATURE |
| B. | EXECUTE AS |
| C. | SETUSER |
| D. | All of the mentioned |
| Answer» E. | |
| 90. |
Purpose of CLOSE MASTER KEY is _______________ |
| A. | Deletes the master key of the current database |
| B. | Closes the private key of the current database |
| C. | Closes the public key of the current database |
| D. | None of the mentioned |
| Answer» B. Closes the private key of the current database | |
| 91. |
Which of the following statement decrypts a symmetric key? |
| A. | OPEN SYMMETRIC KEY |
| B. | DECRYPT SYMMETRIC KEY |
| C. | CLOSE SYMMETRIC KEY |
| D. | None of the mentioned |
| Answer» B. DECRYPT SYMMETRIC KEY | |
| 92. |
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 |
| Answer» D. None of the mentioned | |
| 93. |
__________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 |
| Answer» C. Access Metadata Expl | |
| 94. |
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 |
| Answer» E. | |
| 95. |
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 |
| Answer» B. Advanced find Select dialog box | |
| 96. |
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 |
| Answer» C. New records are not available | |
| 97. |
__________ 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 |
| Answer» C. SSMS | |
| 98. |
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 |
| Answer» C. import | |
| 99. |
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 |
| Answer» B. Analysis Tool | |