SQL1

Question 0

Database Query?

Answer 0

Is an inquiry into the database that returns information back from the database.

Question 1

Database?

Answer 1

Is an organized collection of data, typically stored in electronic format. It allows you to input, organized, and retrieve data quickly.

Question 2

An index?

Answer 2

Is a data structure that improves the speed of data retrieval operation on a database table.
Pro-retrieval speed
Con-created and updated,disk space

Question 3

Three type of SQL files?

Answer 3

Primary-.mdf
Tables,views,system tables
2nd-.ndf
Transaction log-.ldf

Question 4

Database Management System (DBMS)?

Answer 4

A collection of programs that enable you to enter, organize, and select data in a database.

Question 5

Three type of database?

Answer 5

Flat-type database
Hierarchical database
Relational database

Question 6

Flat-type database?

Answer 6

Plain-text formats

Question 7

Hierarchical database?

Answer 7

A tree structure (family tree)
Each child can have ONLY one parent

XML : extensible markup language

Question 8

Relational database?

Answer 8

Data is stored in tables and any new information is automatically added into the table without the need to reorganize the table itself.

Multiple parents

Question 9

Two categories of database objects?

Answer 9

Storage

Programmability

Question 10

Constraints?

Answer 10

Limitations or rules place on a field or column to ensure that data that is considered invalid is not entered.

Question 11

A variety of SQL constrains?

Answer 11

A unique constraint: no duplicate
A check constraint: limit data type
A default constraint: insert default value
A not null constraint: no blank allowed
Primary key constraint: uniquely identifies, cannot contain NULL
A foreign key constraint: point to primary key

Question 12

SQL Server Management Studio (SSMS), the Query Analyzer supports?

Answer 12

XQuery: a query and functional programming language
SQLCMD: a command-line application
Transact-SQL: the primary means of programming and managing SQL Server.

Question 13

Type of SQL commands?

Answer 13

Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language(DCL)
Data Administration Commands
Transactional Control commands

Question 14

Data Definition Language (DDL)?

Answer 14

Use
Create
Alter
Drop
Truncate ( free the space)
Delete

Question 15

Data Manipulation Language (DML)?

Answer 15

Select
Insert
Update
Delete
Merge

Question 16

Data Control Language (DCL)?

Answer 16

Grant
Deny
Revoke

Deny overwrite grant
Revoke overwrite grant and deny

Question 17

Table?

Answer 17

Use to store data,are 2 dimensional objects consisting of rows and columns.
Is to provide a structure for storing data within a relational database.

Question 18

Data administration Commands?

Answer 18

Start audit

Stop audit

Question 19

Function?

Answer 19

Return value, never update data

Question 20

Transactional Control Commands?

Answer 20

Commit
Rollback
Savepoint
set transaction

Question 21

Stored Procedures?

Answer 21

Is a previously written SQL statement that has been “store” or saved into a database.

• “usp” is indicates to SQL that this is a user-created stored procedure.

Syntax:
Exec ups_displayallusers