RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Building Database
SQL Server Database Creation
«Prev
Next»
SQL Database Creation
SQL - Server
Relational Database
Client Server Architecture
SQL Server Services
EM Administer SQL-Servers
Database Relational Concepts
SQL Server Tables
Data Integrity Elements
Business Rules
Database Normalization
Data Normalization
Database Denormalization
Primary Keys Unique Constraints
Foreign Keys
Relational Concepts
Column Attributes Table
Table Columns Types
Specify Default Column
Create Transact SQL Datatype
SQL-Server DB Tables
SQL Server Column Attributes - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Victoria is defining a table. Her company has 75,000 employees. What datatype must she use to define the EmployeeID column to use the least amount of disk storage, but allow for the identity to be set for the column?
Please select the best answer.
A.
decimal
B.
text
C.
money
D.
int
2.
Winston notices that an application using the database he designed is truncating some data the data that users type in. The users are entering numeric data. What is the most likely reason for this to happen?
Please select the best answer.
A.
The scale is set too low.
B.
The varchar datatype does not allow for enough characters to be typed.
C.
The datatype is a timestamp column.
D.
The datatype is a Uniqueidentifier.
3.
You wish to create a table containing columns A, B, C, and D. You define columns B and D to allow NULL values. You define columns A and B as being the primary key. What will happen when you issue the Transact-SQL statement to create the table?
Please select the best answer.
A.
The table will be created as directed.
B.
The table will be created as directed, but without the primary key.
C.
The table will not be created and will result in error.
D.
The table will not be created unless all columns make up the primary key.
4.
You have defined a column as a tinyint datatype. You have also set the identity flag on the column with a seed value of 1 and an increment value of 100. How many rows will you be able to insert into the table?
Please select the best answer.
A.
100
B.
1
C.
3
D.
255
5.
What is significant about a GUID?
Please select the best answer.
A.
It takes the same amount of space as a char(5) datatype.
B.
It is guaranteed to be unique across every database and every table in the world.
C.
It is guaranteed to be unique within your database only.
D.
It takes the same amount of space as an int datatype.
6.
Harry notices that his tables are going to contain a lot of phone number data. He does not want to specify the datatypes, flags, and attributes for each of the phone numbers.
What is the best way he can speed the process of defining the phone number columns?
Please select the best answer.
A.
He can create a user-defined datatype, called phonenum.
B.
He can cut and paste these attributes for columns.
C.
There is nothing he can do. He must type in the datatypes, flags, and attributes for each column.
D.
He can use the number datatype.
7.
What SQL Server function would you use to find the next available GUID for a Uniqueidentifier datatype?
Please select the best answer.
A.
NEWGUID
B.
NEWID
C.
NEWIDENT
D.
NEWGLOBAL
Your Score: 0
Submit
Quiz Explanation