MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 4 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 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 | |
| 2. |
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 | |
| 3. |
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 | |
| 4. |
__________ 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 | |