RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Building Database
SQL Server
«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
Specifying Length Precision Scale
SQL Allow Null
Specify Default Column Values
Table Identity Columns
Rowguidcol Attribute Flag
Create Transact SQL Datatype
TableColumn Attributes Conclusion
SQL-Server DB Tables
SQL Server Overview - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Before you actually construct a database, what should you do?
Please select the best answer.
A.
Nothing. Begin constructing the database immediately.
B.
Construct a physical model.
C.
Construct a logical model.
D.
Construct your tables.
2.
Which SQL Server tool would you use if you wanted to browse the objects in a Timesheet database?
Please select the best answer.
A.
A browser
B.
The Enterprise Manager
C.
The Query Analyzer
D.
A Web Assistant
3.
Before you can issue a query to SQL Server 2012, which service do you start first?
Please select the best answer.
A.
MSDTC
B.
MSSQLServer
C.
SQLServerAgent
D.
DCOM Distributed Service
4.
Which SQL Server tool would you use if you wanted to issue an ad hoc query against a Timesheet database?
Please select the best answer.
A.
A browser
B.
The Enterprise Manager
C.
The Query Analyzer
D.
A Web Assistant
Correct answers:
Your Score: 0
Submit
Quiz Explanation