What should you always do before creating a new database?
A) backup the master system database
B) install a fresh instance of SQL Server 2012
C) delete all existing temporary databases
D) stop and restart the SQL Server service
Answer: A) backup the master database
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 true about the model database template?
- Which of the following is a required setting that must be supplied when creating a 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?