MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 32 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
With SQL Server optimistic locking, an update lock is placed on the row when the row is read. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 2. |
With SQL Server pessimistic locking, no lock is obtained until the user updates the data. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 3. |
'dbo' stands for database object. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 4. |
SQL Server supports a language called Transact-SQL (also called T-SQL). |
| A. | 1 |
| B. | |
| Answer» B. | |
| 5. |
SERIALIZABLE is the strictest isolation level. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 6. |
SQL Server AFTER Triggers may be assigned views. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 7. |
By default, SQL Server will create one data file and one log file for each newly created database. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 8. |
SQL Server supports three recovery modes: simple, full and Bulk. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 9. |
SQL Server indexes are special data structures used to improve performance. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 10. |
SQL Server supports two kinds of indexes: clustered and nonclustered. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 11. |
A differential backup makes a copy of the entire database. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 12. |
The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 13. |
Which of the three possible types of triggers does SQL Server support? |
| A. | INSTEAD OF only |
| B. | AFTER only |
| C. | BEFORE only |
| D. | INSTEAD OF and AFTER only |
| Answer» E. | |
| 14. |
With SQL Server, parameters and variables in T-SQL start with the "%" sign. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 15. |
In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup? |
| A. | Complete backup |
| B. | Transaction Log |
| C. | Differential backup |
| D. | None of the above is correct. |
| Answer» D. None of the above is correct. | |
| 16. |
An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called: |
| A. | COBOL. |
| B. | VB.NET. |
| C. | TRANSACT SQL. |
| D. | Visual Basic. |
| Answer» D. Visual Basic. | |
| 17. |
Better security occurs if Windows-only authentication is selected. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 18. |
Which of the following is a way to create and modify tables using SQL Server? |
| A. | Write SQL code using either CREATE or ALTER SQL statements only. |
| B. | Use the graphical facilities of SQL Server Enterprise Manager only. |
| C. | Both of the two methods above will work. |
| D. | Neither of the two methods above will work. |
| Answer» D. Neither of the two methods above will work. | |
| 19. |
Nonclustered indexes are faster than clustered indexes for retrieval. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 20. |
READ COMMITTED is the default isolation level. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 21. |
SQL Server automatically creates an index on all primary and foreign keys. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 22. |
SQL Server supports INSTEAD OF, AFTER and BEFORE triggers. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 23. |
SQL Server program code that is executed after an SQL command has been processed is called a(n): |
| A. | INSTEAD OF trigger. |
| B. | BEFORE trigger. |
| C. | AFTER trigger. |
| D. | BEGIN trigger. |
| Answer» D. BEGIN trigger. | |
| 24. |
An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 25. |
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data. |
| A. | READ_ONLY |
| B. | SCROLL_LOCK |
| C. | OPTIMISTIC |
| D. | PESSIMISTIC |
| Answer» D. PESSIMISTIC | |
| 26. |
There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 27. |
The strictest transaction isolation level provided by SQL Server is called: |
| A. | REPEATABLE READ. |
| B. | SERIALIZABLE. |
| C. | READ COMMITTED. |
| D. | READ UNCOMMITTED. |
| Answer» C. READ COMMITTED. | |
| 28. |
Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures? |
| A. | # |
| B. | % |
| C. | & |
| D. | @ |
| Answer» E. | |
| 29. |
SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n): |
| A. | INSTEAD OF trigger. |
| B. | BEFORE trigger. |
| C. | AFTER trigger. |
| D. | BEGIN trigger. |
| Answer» B. BEFORE trigger. | |
| 30. |
With which type of SQL Server recovery model are all database changes logged? |
| A. | Differential recovery |
| B. | Full recovery |
| C. | Simple recovery |
| D. | Bulk-logged recovery |
| Answer» C. Simple recovery | |
| 31. |
What mode of authentication does SQL Server NOT provide? |
| A. | Windows-only security |
| B. | Both SQL Server and Windows-only security |
| C. | Mixed security |
| D. | SQL Server only security |
| Answer» E. | |
| 32. |
With which type of SQL Server recovery model are all database changes logged except those that cause large log entries? |
| A. | Differential recovery |
| B. | Full recovery |
| C. | Simple recovery |
| D. | Bulk-logged recovery |
| Answer» E. | |