Database Administration Midterm Exam Mock Up Test

This is a mock up test for database administration midterm examination covered lessons from 1 to 5

Data administration

A high-level function that is responsible for the overall management of data resources in a organization, including maintaining corporate-wide definitions and standards

Database administration

A technical function that is responsible for physical database design and for dealing with technical issues such as security enforcement, database performance, and backup and recovery.

Security

The goal of database BLANK is to protect data from accidental or intentional threats to their integrity and access. The database environment has grown more complex, with distributed databases located

Structured Query Language

It is an industry-standard programming language used to insert retrieve, modify, and delete data in a relational database. It also contains statements for defining and administering the objects in a

Relational database

A BLANK is a database divided into logical units called tables, where tables are related to one another within the database. Relational database allows data to be broken down into logical, smaller,

Data definition language

• Commands used to define a database, including those for creating, altering, and dropping tables and establishing constraints.

• Sample of commands are CREATE, ALTER and DROP

Data manipulation language

• Commands are used for updating, inserting, modifying, and querying the data in the database

• Sample of commands are INSERT, UPDATE, DELETE and SELECT

Data control language

Commands help a DBA control the database; they include commands to grant or revoke privileges to access the database or particular objects within the database and to store or remove transactions that would affect the database.

Tables

are database objects that stores data in a collection of rows and columns. Each row represents a unique record, and each column represents a field within the record.

Data type

is an attribute that specifies the type of data that the column can store.

Null

A value that may be assigned to an attribute when no other value applies or when the applicable value is unknown.

Primary Key

is a field or a combination of fields that identify a record uniquely.

Foreign Key

provides a way of enforcing referential integrity within SQL Server. In simple words, BLANK ensures values in one table must be present in another table.

Data integrity

refers to the overall accuracy, consistency, and completeness of data.

Domain integrity

Also known as column integrity, this integrity specifies a set of data values that are valid for a column. This can be defined by the data type, format, data length, nullability, default value and range of allowable values.

Referential Integrity

This is the concept of foreign keys. A state in which all foreign key values in database are valid. For a foreign key to be valid, it must contain either the value NULL, or an existing key value from the PRIMARY KEY value or UNIQUE KEY columns referenced by the foreign key. The referenced row cannot be deleted if a FOREIGN KEY refers to a row, nor can key value can be changed if a FOREIGN KEY refers to it.

Constraints

are business logic that your database server enforces for you. BLANK are used to specify rules for the data in a table. BLANK are used to limit the type of data that can go into a table.

PRIMARY KEY

A BLANK constraint ensures no duplicate values are entered in particular columns and that NULL values are not entered in those columns.

FOREIGN KEY

A BLANK constraints governs the link between the parent or referenced table and the child or referencing table

UNIQUE

A BLANK constraints ensures no duplicate values are entered into specified columns that are not a table's primary key.

DEFAULT

A BLANK constraint enables you to define the value that will be supplied for a column whenever a user fails to enter a value.

CHECK

A BLANK constraint is used to enforce domain integrity by restricting the values allowed in a column to specific values.

Selection

You can use the BLANK capability in SQL to choose the rows in a table that you want returned by a query. You can use various criteria to selectively restrict the rows that you see.

Projection

You can use the BLANK capability in SQL to choose the columns in a table that you want retuned by your query. You can choose as few or as many columns of the table as you require.

Join

You can use the BLANK capability in SQL to bring together data that is stored in different tables by creating a ink through a column that both the tables share.

SELECT

is a list of one or more columns

DISTINCT

suppresses duplicates.

*

selects all columns.

Column

selects the named column.

Alias

gives selected columns different headings.

FROM tablename

specifies the table containing the columns.

WHERE

restricts the query to rows that meet a condition

condition

is composed of column names, expressions, constants, and a comparison operator

AND

Returns TRUE if both component conditions are TRUE

OR

Returns TRUE if either component condition is TRUE

NOT

Returns TRUE if the following condition is FALSE

ORDER BY

clause can be used to sort the rows