Which of the following is true about the model database template?
A) it cannot be customized
B) changes to it will affect existing databases
C) new databases will inherit settings from it
D) modifying model database settings requires different steps than user databases
Answer: C) new databases will inherit settings from it
Structured Query Language
- Which syntax should you use to sort the result set in reverse alphabetic order.
- Which command will result in records that have a Col1 value greater than 100?
- If Col1 contains the string "Hello" and Col2 is Null, what is the result of SELECT Col1 + Col2?
- If you want to remove duplicates from a result set, which command should you use?
- Which command changes the database context?
- Which of the following represents correct syntax for a SELECT statement?
- Which of the following best describes the IntelliSense feature in Query Editor?
- A database operation that can be used to merge and retrieve data stored in more than one table view is called a SELECT.
- Transact-SQL is the variant of SQL developed by Microsoft and Sybase.
- SQL is an imperative programming language.
- What happens if you need to compare two values of different data types?
- What should you define if you want to grant several users the same permissions to database objects?
- Which of the following is true about database permissions?
- Which of the following is true about the Autogrowth setting?
- Which of the following is best described as a logical unit of work reading or writing from a database?
- Which of the following is a required setting that must be supplied when creating a database?
- What should you always do before creating a new database?
- The NEW table SQL language statement is used to make a new table.
- Since it is easy to make configuration changes after a database is created, it's best to get the database created and make changes as necessary afterward.
- What should you do to prevent blockage of the port used to communicate with a SQL Server instance?
- Which of the following may require the database engine to perform a full scan on every record of the database?
- Which of the following is a basic building block of a database that is used to improve the speed and efficiency of data access?
- Which of the following is commonly referred to as a record?
- Which of the following is a file extension used in the physical structure of a SQL database?