MTA: DATABASE FUNDAMENTALS
EXAM (98-364)
What is the UNIQUE constraint? - Correct Answers -Specifically identifies which column
should not contain duplicate values.
What is the CHECK constraint? - Correct Answers -Allows the admin to limit the types
of data a user can insert into that column of the database.
What is a default constraint? - Correct Answers -Used to insert a default value into a
column.
What is the primary key? - Correct Answers -This uniquely identifies a column in the db.
Has to have a unique constraint by default. Cannot be Null and data type must match.
Ensures entity integrity(Uniquely id each row). Not always created as CLUSTERED
indexes if one is already made.
Databases are often put on database servers for what reason - Correct Answers -so
that they can be accessed by multiple users and provide a higher level of performance.
One popular database server is Microsoft SQL Server.
Exact numeric data types - Correct Answers -are the most common SQL Server data
types used to store numeric information.
serveradmin fixed server role - Correct Answers -can Configure server -wide settings
and issue SHUTDOWN command which immediately stops the SQL server.
DROP LOGIN - Correct Answers -Command will remove a windows user or group from
the SQL server. This will not alter Windows its self
WHERE - Correct Answers -is used to obtain only subset of rows that fulfill criterion in
the WHERE clause
What is a foreign key? - Correct Answers -This is a column in one table that points to
the primary key in another table(defines relationship between two tables). Ensures
domain and referential integrity, not entity integrity. There is not a predefined limit for
foreign keys.
Why is it a bad idea to let a foreign key contain a NULL value? - Correct Answers -
Because it may be impossible to verify the constraints if a foreign key consists of two or
more columns if one of them is NULL.
, What is a self-reference? - Correct Answers -When the foreign key refers to columns in
the same table.
What is XQuery? - Correct Answers -A query and functional programming language
designed to query collections of XML data.
What is SQLCMD? - Correct Answers -A command line application that comes with
SQL and exposes the management features of SQL Server. It allows SQL queries to be
written and executed from the command prompt.
What is TRANSACT-SQL - Correct Answers -This is the primary means of programming
and manageing SQL Server. When you use an SSMS to perform an action, it is using T-
SQL commands in the background to do the work.
What are the three types of files in SQL? - Correct Answers -MDF = Primary data files,
NDF = Secondary data files and LDF = Log files
Database objects are divided into two categories: - Correct Answers -Storage and
Programmability
Tables created using the ________ statement are used to store data. - Correct Answers
-CREATE TABLE
Constraints are also referred to as ____ constraints. - Correct Answers -Column;
limitations or rules placed on a field or column to ensure that data that is considered
invalid is not entered.
In order to use views, you must use the ______ T-SQL statement to show data from the
tables. - Correct Answers -SELECT
DDL influences _____, while _______ influences actual data stored in tables. - Correct
Answers -Database objects, DML
The MS database server that hosts relational databases is called _____ - Correct
Answers -MS SQL Server
The code DML statements are (5) - Correct Answers -MIDUS: MERGE, INSERT,
DELETE, UPDATE, SELECT
System views belong to the ______ - Correct Answers -sys schema
What are 6 constraint types? - Correct Answers -Unique, Check(domain Integrity),
Default(domain integrity), Not Null, Primary Key(entity integrity), Foreign Key(referential
integrity)
EXAM (98-364)
What is the UNIQUE constraint? - Correct Answers -Specifically identifies which column
should not contain duplicate values.
What is the CHECK constraint? - Correct Answers -Allows the admin to limit the types
of data a user can insert into that column of the database.
What is a default constraint? - Correct Answers -Used to insert a default value into a
column.
What is the primary key? - Correct Answers -This uniquely identifies a column in the db.
Has to have a unique constraint by default. Cannot be Null and data type must match.
Ensures entity integrity(Uniquely id each row). Not always created as CLUSTERED
indexes if one is already made.
Databases are often put on database servers for what reason - Correct Answers -so
that they can be accessed by multiple users and provide a higher level of performance.
One popular database server is Microsoft SQL Server.
Exact numeric data types - Correct Answers -are the most common SQL Server data
types used to store numeric information.
serveradmin fixed server role - Correct Answers -can Configure server -wide settings
and issue SHUTDOWN command which immediately stops the SQL server.
DROP LOGIN - Correct Answers -Command will remove a windows user or group from
the SQL server. This will not alter Windows its self
WHERE - Correct Answers -is used to obtain only subset of rows that fulfill criterion in
the WHERE clause
What is a foreign key? - Correct Answers -This is a column in one table that points to
the primary key in another table(defines relationship between two tables). Ensures
domain and referential integrity, not entity integrity. There is not a predefined limit for
foreign keys.
Why is it a bad idea to let a foreign key contain a NULL value? - Correct Answers -
Because it may be impossible to verify the constraints if a foreign key consists of two or
more columns if one of them is NULL.
, What is a self-reference? - Correct Answers -When the foreign key refers to columns in
the same table.
What is XQuery? - Correct Answers -A query and functional programming language
designed to query collections of XML data.
What is SQLCMD? - Correct Answers -A command line application that comes with
SQL and exposes the management features of SQL Server. It allows SQL queries to be
written and executed from the command prompt.
What is TRANSACT-SQL - Correct Answers -This is the primary means of programming
and manageing SQL Server. When you use an SSMS to perform an action, it is using T-
SQL commands in the background to do the work.
What are the three types of files in SQL? - Correct Answers -MDF = Primary data files,
NDF = Secondary data files and LDF = Log files
Database objects are divided into two categories: - Correct Answers -Storage and
Programmability
Tables created using the ________ statement are used to store data. - Correct Answers
-CREATE TABLE
Constraints are also referred to as ____ constraints. - Correct Answers -Column;
limitations or rules placed on a field or column to ensure that data that is considered
invalid is not entered.
In order to use views, you must use the ______ T-SQL statement to show data from the
tables. - Correct Answers -SELECT
DDL influences _____, while _______ influences actual data stored in tables. - Correct
Answers -Database objects, DML
The MS database server that hosts relational databases is called _____ - Correct
Answers -MS SQL Server
The code DML statements are (5) - Correct Answers -MIDUS: MERGE, INSERT,
DELETE, UPDATE, SELECT
System views belong to the ______ - Correct Answers -sys schema
What are 6 constraint types? - Correct Answers -Unique, Check(domain Integrity),
Default(domain integrity), Not Null, Primary Key(entity integrity), Foreign Key(referential
integrity)
