Multiple Choice
The SQL Server default when creating a new database is to create ________ for each database.
A) one data file and one log file
B) one data file and two log files
C) two data files and one log file
D) two data files and two log files
E) there is no default-the database creator must specify how many data files and log files will be created
Correct Answer:
Verified
Correct Answer:
Verified
Q2: Which of the following is a type
Q3: Which of the following is not a
Q6: The column(s)that is/are the primary key in
Q8: Which of the following is not a
Q10: In SQL Server,the full recovery model creates
Q11: Which type of index in SQL Server
Q29: SQL Server supports three types of indexes:
Q43: Briefly describe how a developer defines the
Q51: When viewing a table in the GUI
Q85: One means of processing an SQL Server