EXAMIANS
SQL Server automatically creates an index on all primary and foreign keys.
YOUR ANSWER : ?
YOUR ANSWER : ?
A differential backup makes a copy of the entire database.
YOUR ANSWER : ?
By default, SQL Server will create one data file and one log file for each newly created database.
YOUR ANSWER : ?
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.
YOUR ANSWER : ?
SQL Server indexes are special data structures used to improve performance.
YOUR ANSWER : ?
SQL Server supports two kinds of indexes: clustered and nonclustered.
YOUR ANSWER : ?
SERIALIZABLE is the strictest isolation level.
YOUR ANSWER : ?
Better security occurs if Windows-only authentication is selected.
YOUR ANSWER : ?
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
YOUR ANSWER : ?
SQL Server supports a language called Transact-SQL (also called T-SQL).
YOUR ANSWER : ?