Question 1

Which of the following is true about the physical file structure of a SQL Server database?

Accepted Answer

A)  it must have at least one log and one data file
B)  only a data file is required
C)  there are two data files for every log file
D)  log files organize data in tables and indexes A

Question 2

What permission must be granted for a user to run procedures within a database?

Accepted Answer

A)  Execute
B)  Read
C)  List
D)  Server-level A

Question 3

Describe how to create a database using the SQL programming language and explain why it might be the preferred method.

Accepted Answer

User databases can be created by executing the CREATE database syntax and supplying a set of configuration parameters using the SQL programming language. The CREATE statement is a SQL instruction to create an object. This option is sometimes preferred by experienced database administrators because it allows them to create standardized scripts, rather than having to manually change each configuration parameter in a Windows form.

Question 4

What are the two main approaches to creating a new user database?

Accepted Answer

The answer of What are the two main approaches to...

Question 5

___________ performance is a term used to describe the number of read and write operations that can be processed by the physical disk in a given time frame.

Accepted Answer

The answer of ___________ performance is a term used to...

Question 6

What happens if you need to compare two values of different data types?

Accepted Answer

A)  the system is halted
B)  the value with the highest precision is returned
C)  an 'incompatible type' error occurs
D)  a data type conversion is performed

Question 7

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.

Accepted Answer

A) True 
 B)False

Question 8

Describe how filegroups are used in a database.

Accepted Answer

The answer of Describe how filegroups are used in a...

Question 9

Which attribute include binary and numeric as categories?

Accepted Answer

A)  column
B)  data type
C)  row
D)  record labels

Question 10

Which of the following is true about log files?

Accepted Answer

A)  they aid in database roll back
B)  log files are optional for each database
C)  there can be only one log file per database
D)  they should be stored on the same physical disk as data files

Question 11

What are roles and how are they used in database security and permissions? Provide an example of a predefine server role.

Accepted Answer

The answer of What are roles and how are they...

Question 12

Before creating a new database, make a full backup of the _____________ system database.

Accepted Answer

The answer of Before creating a new database, make a...

Question 13

Which of the following is a logical container that groups together collections of objects within a database and allows them to be managed as a group?

Accepted Answer

A)  filegroup
B)  data file
C)  transaction
D)  schema

Question 14

Which of the following is true about the Autogrowth setting?

Accepted Answer

A)  by default, it doubles the size of the log file when it becomes full
B)  the data file is affected by it but log files are not
C)  you should keep this value as small as possible
D)  you should configure it so that file growth occurs infrequently

Question 15

Which of the following is true about the model database template?

Accepted Answer

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

Question 16

Which of the following is true about database permissions?

Accepted Answer

A)  access to databases is controlled by Windows logon authentication
B)  database users are defined for each database
C)  server-level permissions provide the least access to SQL databases
D)  permissions can only be set at the server or database level

Question 17

Many tasks can be performed with SQL Server Management Studio, but to delete a database, you need to use a SQL statement in the SQLCMD command prompt.

Accepted Answer

A) True 
 B)False

Question 18

How are log files used for database reliability?

Accepted Answer

The answer of How are log files used for database...

Question 19

Which of the following is true about database creation and configuration?

Accepted Answer

A)  an overly complex database is more secure
B)  other administrators should be able to understand and manage it
C)  configuration changes should be made frequently
D)  client applications automatically adjust to logical object model changes

Question 20

Describe how SQL Server 2012 supports authentication for connecting to the database server.

Accepted Answer

The answer of Describe how SQL Server 2012 supports authentication...

Exam 4: Creating SQL Server 2012 Databases

Which of the following is true about the physical file structure of a SQL Server database?

What permission must be granted for a user to run procedures within a database?

Describe how to create a database using the SQL programming language and explain why it might be the preferred method.

What are the two main approaches to creating a new user database?

___________ performance is a term used to describe the number of read and write operations that can be processed by the physical disk in a given time frame.

What happens if you need to compare two values of different data types?

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.

Describe how filegroups are used in a database.

Which attribute include binary and numeric as categories?

Which of the following is true about log files?

What are roles and how are they used in database security and permissions? Provide an example of a predefine server role.

Before creating a new database, make a full backup of the _____________ system database.

Which of the following is a logical container that groups together collections of objects within a database and allows them to be managed as a group?

Which of the following is true about the Autogrowth setting?

Which of the following is true about the model database template?

Which of the following is true about database permissions?

Many tasks can be performed with SQL Server Management Studio, but to delete a database, you need to use a SQL statement in the SQLCMD command prompt.

How are log files used for database reliability?

Which of the following is true about database creation and configuration?

Describe how SQL Server 2012 supports authentication for connecting to the database server.