RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Building Database
Database Tables
«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
Basic SQL-Server Database - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following are overall functions of a database?
Please select all the correct answers.
A.
To act as a collector of other objects
B.
To act as the parent for child objects
C.
to act as a child for a parent object
2.
In addition to a SQL Server 7 wizard, which of the following tools can you use to create, modify, or delete databases?
Please select the best answer.
A.
Query tool
B.
Query Analyzer
C.
Database Analyzer
3.
What is the only permission that you must have to create, delete, and modify tables?
Please select the best answer.
A.
SA
B.
DBO
C.
DBA