Question 1

Which of the following is true about the size of data and log files?

Accepted Answer

A) you should not change the default sizes 
B) increasing the size on an existing database will degrade performance 
C) you should not set the size larger than the data requires 
D) best practice is to change the Maxsize setting from its default value 
A) you should not change the default sizes 
B) increasing the size on an existing database will degrade performance 
C) you should not set the size larger than the data requires 
D) best practice is to change the Maxsize setting from its default value

Question 2

Describe how the Initial Size setting is used when defining a database. How can this setting affect database performance?

Accepted Answer

The Initial Size setting defines the ini

Question 3

Which of the following is a required setting that must be supplied when creating a database?

Accepted Answer

A) the SQL Server name 
B) a unique database name 
C) the master database configuration 
D) the user credentials 
A) the SQL Server name 
B) a unique database name 
C) the master database configuration 
D) the user credentials

Question 4

Which of the following is true about naming objects?

Accepted Answer

A) the database management system provides strict rules 
B) Camel case does not use special characters to link words 
C) tables should always be named with a character prefix 
D) A column name of Last Name is preferable to LastName 
A) the database management system provides strict rules 
B) Camel case does not use special characters to link words 
C) tables should always be named with a character prefix 
D) A column name of Last Name is preferable to LastName

Question 5

The NEW table SQL language statement is used to make a new table.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following SQL statements deletes an object?

Accepted Answer

A) ALTER 
B) REMOVE 
C) DROP 
D) DEL 
A) ALTER 
B) REMOVE 
C) DROP 
D) DEL

Question 7

Which of the following is true about filegroups?

Accepted Answer

A) filegroups are only used when there is more than one data file 
B) there can be only one data file per filegroup 
C) each database must have a primary filegroup 
D) multiple data files should be of different sizes for best performance 
A) filegroups are only used when there is more than one data file 
B) there can be only one data file per filegroup 
C) each database must have a primary filegroup 
D) multiple data files should be of different sizes for best performance

Question 8

What should you always do before creating a new database?

Accepted Answer

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 
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

Question 9

The widest reaching type of permission in a SQL Server is database permissions.

Accepted Answer

A) True 
 B)False

Question 10

If you want to set the maximum number of digits a numeric data type can hold, what should you set?

Accepted Answer

A) precision 
B) length 
C) scale 
D) size 
A) precision 
B) length 
C) scale 
D) size

Question 11

If you want to set the number of places after the decimal point in a numeric data type, what should you set?

Accepted Answer

A) precision 
B) length 
C) scale 
D) size 
A) precision 
B) length 
C) scale 
D) size

Question 12

The _____________ size setting defines the size of the database when it is first created.

Accepted Answer

The answer of The _____________ size setting defines the size...

Question 13

The ______________ statement is used to change an existing database object.

Accepted Answer

The answer of The ______________ statement is used to change...

Question 14

How is the model system database used in database creation?

Accepted Answer

The model system database is used as the

Question 15

Match between columns
                        Premises: a database object that groups together permissions on different database objects
a constraint that models the relationship that exists between two tables
a word that belongs to the SQL programming language
the number of places after the decimal point in a numeric data type or the accuracy in the case of a date data type
a group of data files used for storage management
a setting that specifies how much the database will increase the file size once it reaches a limit
a logical container that groups together collections of objects within a database and allows them to be managed as a group
a right to perform an action against a database object
the maximum number of digits that a numeric data type can hold
a term used to describe a situation in which two processes compete for the same resource

Accepted Answer

The Answer of role and Autogrowth and reserved keyword and is...

Question 16

Which of the following is best described as a logical unit of work reading or writing from a database?

Accepted Answer

A) I/O performance 
B) database transaction 
C) log file record 
D) individual filegroup 
A) I/O performance 
B) database transaction 
C) log file record 
D) individual filegroup

Question 17

What should you define if you want to grant several users the same permissions to database objects?

Accepted Answer

A) schema 
B) user 
C) role 
D) access list 
A) schema 
B) user 
C) role 
D) access list

Question 18

Tables and ____________ are the main building blocks of a database.

Accepted Answer

The answer of Tables and ____________ are the main building...

Question 19

The two main physical file types in an SQL Server database are data files and log files.

Accepted Answer

A) True 
 B)False

Question 20

Why should log files be stored on a different physical disk from data files?

Accepted Answer

Data and log files are stored on differe

Which of the following is true about the size of data and log files?

Describe how the Initial Size setting is used when defining a database. How can this setting affect database performance?

Which of the following is a required setting that must be supplied when creating a database?

Which of the following is true about naming objects?

The NEW table SQL language statement is used to make a new table.

Which of the following SQL statements deletes an object?

Which of the following is true about filegroups?

What should you always do before creating a new database?

The widest reaching type of permission in a SQL Server is database permissions.

If you want to set the maximum number of digits a numeric data type can hold, what should you set?

If you want to set the number of places after the decimal point in a numeric data type, what should you set?

The _____________ size setting defines the size of the database when it is first created.

The ______________ statement is used to change an existing database object.

How is the model system database used in database creation?

Which of the following is best described as a logical unit of work reading or writing from a database?

What should you define if you want to grant several users the same permissions to database objects?

Tables and ____________ are the main building blocks of a database.

The two main physical file types in an SQL Server database are data files and log files.

Why should log files be stored on a different physical disk from data files?

Introduction to SQL Server 2012

Deploying SQL Server 2012

Architecture and Configuration

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Monitoring SQL Server 2012

Filters

Exam 4: Creating SQL Server 2012 Databases

Which of the following is true about the size of data and log files?

Describe how the Initial Size setting is used when defining a database. How can this setting affect database performance?

Which of the following is a required setting that must be supplied when creating a database?

Which of the following is true about naming objects?

The NEW table SQL language statement is used to make a new table.

Which of the following SQL statements deletes an object?

Which of the following is true about filegroups?

What should you always do before creating a new database?

The widest reaching type of permission in a SQL Server is database permissions.

If you want to set the maximum number of digits a numeric data type can hold, what should you set?

If you want to set the number of places after the decimal point in a numeric data type, what should you set?

The _____________ size setting defines the size of the database when it is first created.

The ______________ statement is used to change an existing database object.

How is the model system database used in database creation?

Which of the following is best described as a logical unit of work reading or writing from a database?

What should you define if you want to grant several users the same permissions to database objects?

Tables and ____________ are the main building blocks of a database.

The two main physical file types in an SQL Server database are data files and log files.

Why should log files be stored on a different physical disk from data files?

Introduction to SQL Server 2012

Deploying SQL Server 2012

Architecture and Configuration

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Monitoring SQL Server 2012

Filters