MTA EXAM 98-364, EXAM 98-364:
DATABASE FUNDAMENTALS
What is the name of the data located at the intersection of a row and column - Correct
Answers –Field
Replicated services - Correct Answers -Re-create a full or incremental reproduction of
the database
Knowledge of which core database will ensure that you are prepared for the Database
Administration certification exam? - Correct Answers -RDBMS, DML, DDL, SQL
Which of the following are NOT methods to manipulate data? - Correct Answers -
Creating primary and foreign keys
What is normalization? - Correct Answers -A technique to minimize the inclusion of
duplicate information.
Field - Correct Answers -Is a location in a record in which a particular type of data is
stored.
Column - Correct Answers -Is an attribute for a row or record
Row - Correct Answers -Is a record within a table
Table - Correct Answers -Is a database object consisting of rows and columns
Record - Correct Answers -Is a data structure that is a collection of fields(elements),
each with its own name and type that appear in a table as group of fields across one
row.
Relational model - Correct Answers -Most modern database management systems
implement a Relational Model in which the data is organized in relations (tables)
One-to-One relationship - Correct Answers -Is an association between 2 tables in which
the primary key value of each record in the primary table corresponds to the value in the
matching field of one, and only one, record in the related table.
,Many-to-Many relationship - Correct Answers -Is a complex association between 2 sets
of parameters in which many parameters of each set can relate to many others in the
second set.
Parent/Child relationship - Correct Answers -Is a relationship between nodes in a tree
data structure in which the parent is one step closer to the root(that is, one level higher)
than the child.
Primary Keys - Correct Answers -Are unique data identifiers
Structured Query Language(SQL) - Correct Answers -Is a relational database language
used in querying, updating, and managing relational databases and is the defector for
database projects
Data Manipulation Language(DML) - Correct Answers -Is used to insert, update, and
delete data and to query a database
Data Definition Language(DDL) - Correct Answers -Is used to create, modify, or drop
relational databases, entities, attributes, and other objects(e.g. views)
In the example in the previous question, what effect does the word NULL have when
adding a new cycle to the table? - Correct Answers -Does not require the user to enter a
file for the photo
What is the main difference between the DML command DELETE and the DDL
command DROP? - Correct Answers -DELETE removes all (or a subset of) records
from the table only; it does not remove the table
Schema - Correct Answers -Is a description of a database to a database management
system(DBMS) in the language provided by the DBMS
Data Definition Language (DDL) - Correct Answers -Defines database objects including
entities, attributes, views and indexes
CREATE - Correct Answers -Adds databases or objects
ALTER - Correct Answers -Changes databases or objects
DROP - Correct Answers -Removes databases or objects
What data type should Yan use to store the duration of the song in total seconds? -
Correct Answers -Integer. The duration can be saved as total seconds and the
application can change it back to minutes and seconds if needed.
, Data Types - Correct Answers -Specify the possible range of values of the set, the
operations that can be performed on the values, and the way in which the values are
stored in memory
Integer - Correct Answers -Data types store whole numbers
Floating-Point - Correct Answers -Data types store any real numbers
Character - Correct Answers -Stores A-Z or 0-9. Any digit or letter that math functions
will not be applied to.
Boolean - Correct Answers -Stores 1 or 0, true or false
Proper ANSI SQL syntax refers to a set of rules that: - Correct Answers -Govern the
structure and content of statements
ANSI SQL Syntax - Correct Answers -Is the grammar and rules governing the structure
and content of statements.
Table - Correct Answers -Is a data structure usually consisting of a list of entries.
Key - Correct Answers -An Identifier for a record in a data file that is unique and found
in only one record is called a KEY.
What is the best application of views and T-SQL for this project? - Correct Answers -
Create separate views with the information for each request
Which of the following is an important benefit of using views? - Correct Answers -Can
be used to represent summation data
View - Correct Answers -Is a stored query that creates a virtual table of the result set of
the query. The fields in a view are fields from one or more real tables in the database
Query - Correct Answers -Is a specific set of instructions for extracting/selecting
particular data
Graphical Designer - Correct Answers -Is an application, such as Microsoft Access, that
is object-oriented and drag-and-drop driven
Transact-SQL(T-SQL) - Correct Answers -Is a sophisticated query language with
additional features beyond what is defined in the ANSI SQL
How is a graphical designer such as JetSQL different from T-SQL? - Correct Answers -
Graphical designers are object-oriented
DATABASE FUNDAMENTALS
What is the name of the data located at the intersection of a row and column - Correct
Answers –Field
Replicated services - Correct Answers -Re-create a full or incremental reproduction of
the database
Knowledge of which core database will ensure that you are prepared for the Database
Administration certification exam? - Correct Answers -RDBMS, DML, DDL, SQL
Which of the following are NOT methods to manipulate data? - Correct Answers -
Creating primary and foreign keys
What is normalization? - Correct Answers -A technique to minimize the inclusion of
duplicate information.
Field - Correct Answers -Is a location in a record in which a particular type of data is
stored.
Column - Correct Answers -Is an attribute for a row or record
Row - Correct Answers -Is a record within a table
Table - Correct Answers -Is a database object consisting of rows and columns
Record - Correct Answers -Is a data structure that is a collection of fields(elements),
each with its own name and type that appear in a table as group of fields across one
row.
Relational model - Correct Answers -Most modern database management systems
implement a Relational Model in which the data is organized in relations (tables)
One-to-One relationship - Correct Answers -Is an association between 2 tables in which
the primary key value of each record in the primary table corresponds to the value in the
matching field of one, and only one, record in the related table.
,Many-to-Many relationship - Correct Answers -Is a complex association between 2 sets
of parameters in which many parameters of each set can relate to many others in the
second set.
Parent/Child relationship - Correct Answers -Is a relationship between nodes in a tree
data structure in which the parent is one step closer to the root(that is, one level higher)
than the child.
Primary Keys - Correct Answers -Are unique data identifiers
Structured Query Language(SQL) - Correct Answers -Is a relational database language
used in querying, updating, and managing relational databases and is the defector for
database projects
Data Manipulation Language(DML) - Correct Answers -Is used to insert, update, and
delete data and to query a database
Data Definition Language(DDL) - Correct Answers -Is used to create, modify, or drop
relational databases, entities, attributes, and other objects(e.g. views)
In the example in the previous question, what effect does the word NULL have when
adding a new cycle to the table? - Correct Answers -Does not require the user to enter a
file for the photo
What is the main difference between the DML command DELETE and the DDL
command DROP? - Correct Answers -DELETE removes all (or a subset of) records
from the table only; it does not remove the table
Schema - Correct Answers -Is a description of a database to a database management
system(DBMS) in the language provided by the DBMS
Data Definition Language (DDL) - Correct Answers -Defines database objects including
entities, attributes, views and indexes
CREATE - Correct Answers -Adds databases or objects
ALTER - Correct Answers -Changes databases or objects
DROP - Correct Answers -Removes databases or objects
What data type should Yan use to store the duration of the song in total seconds? -
Correct Answers -Integer. The duration can be saved as total seconds and the
application can change it back to minutes and seconds if needed.
, Data Types - Correct Answers -Specify the possible range of values of the set, the
operations that can be performed on the values, and the way in which the values are
stored in memory
Integer - Correct Answers -Data types store whole numbers
Floating-Point - Correct Answers -Data types store any real numbers
Character - Correct Answers -Stores A-Z or 0-9. Any digit or letter that math functions
will not be applied to.
Boolean - Correct Answers -Stores 1 or 0, true or false
Proper ANSI SQL syntax refers to a set of rules that: - Correct Answers -Govern the
structure and content of statements
ANSI SQL Syntax - Correct Answers -Is the grammar and rules governing the structure
and content of statements.
Table - Correct Answers -Is a data structure usually consisting of a list of entries.
Key - Correct Answers -An Identifier for a record in a data file that is unique and found
in only one record is called a KEY.
What is the best application of views and T-SQL for this project? - Correct Answers -
Create separate views with the information for each request
Which of the following is an important benefit of using views? - Correct Answers -Can
be used to represent summation data
View - Correct Answers -Is a stored query that creates a virtual table of the result set of
the query. The fields in a view are fields from one or more real tables in the database
Query - Correct Answers -Is a specific set of instructions for extracting/selecting
particular data
Graphical Designer - Correct Answers -Is an application, such as Microsoft Access, that
is object-oriented and drag-and-drop driven
Transact-SQL(T-SQL) - Correct Answers -Is a sophisticated query language with
additional features beyond what is defined in the ANSI SQL
How is a graphical designer such as JetSQL different from T-SQL? - Correct Answers -
Graphical designers are object-oriented
