MTA Exam 98-364, Exam 98-364 |! |! |! |! |!
Database Fundamentals questions |! |! |!
with answers |!
What is the name of the data located at the intersection of a row and column
|! |! |! |! |! |! |! |! |! |! |! |! |! |! |! |!
- Correct answer ✔Field
|! |! |!
Field - Correct answer ✔Is a location in a record in which a particular type of
|! |! |! |! |! |! |! |! |! |! |! |! |! |! |!
data is stored.
|! |! |!
Column - Correct answer ✔Is an attribute for a row or record
|! |! |! |! |! |! |! |! |! |! |!
Row - Correct answer ✔Is a record within a table
|! |! |! |! |! |! |! |! |!
Table - Correct answer ✔Is a database object consisting of rows and columns
|! |! |! |! |! |! |! |! |! |! |! |!
Record - Correct answer ✔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 answer ✔Most modern database management
|! |! |! |! |! |! |! |! |!
systems implement a Relational Model in which the data is organized in
|! |! |! |! |! |! |! |! |! |! |! |!
relations (tables) |!
,One-to-One relationship - Correct answer ✔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 answer ✔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 answer ✔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 answer ✔Are unique data identifiers
|! |! |! |! |! |! |! |!
Structured Query Language(SQL) - Correct answer ✔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 answer ✔Is used to insert,
|! |! |! |! |! |! |! |! |! |!
update, and delete data and to query a database
|! |! |! |! |! |! |! |!
Data Definition Language(DDL) - Correct answer ✔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 answer ✔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 answer ✔DELETE removes all (or a subset
|! |! |! |! |! |! |! |! |! |! |! |!
of) records from the table only; it does not remove the table
|! |! |! |! |! |! |! |! |! |! |!
Schema - Correct answer ✔Is a description of a database to a database
|! |! |! |! |! |! |! |! |! |! |! |! |!
management system(DBMS) in the language provided by the DBMS |! |! |! |! |! |! |! |!
Data Definition Language (DDL) - Correct answer ✔Defines database objects
|! |! |! |! |! |! |! |! |! |!
including entities, attributes, views and indexes
|! |! |! |! |!
CREATE - Correct answer ✔Adds databases or objects
|! |! |! |! |! |! |!
ALTER - Correct answer ✔Changes databases or objects
|! |! |! |! |! |! |!
DROP - Correct answer ✔Removes databases or objects
|! |! |! |! |! |! |!
What data type should Yan use to store the duration of the song in total
|! |! |! |! |! |! |! |! |! |! |! |! |! |! |!
seconds? - Correct answer ✔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 answer ✔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 answer ✔Data types store whole numbers
|! |! |! |! |! |! |! |!
Floating-Point - Correct answer ✔Data types store any real numbers |! |! |! |! |! |! |! |! |!
Character - Correct answer ✔Stores A-Z or 0-9. Any digit or letter that math
|! |! |! |! |! |! |! |! |! |! |! |! |! |!
functions will not be applied to. |! |! |! |! |!
Boolean - Correct answer ✔Stores 1 or 0, true or false
|! |! |! |! |! |! |! |! |! |!
Proper ANSI SQL syntax refers to a set of rules that: - Correct answer
|! |! |! |! |! |! |! |! |! |! |! |! |! |!
✔Govern the structure and content of statements|! |! |! |! |! |!
ANSI SQL Syntax - Correct answer ✔Is the grammar and rules governing the
|! |! |! |! |! |! |! |! |! |! |! |! |!
structure and content of statements. |! |! |! |!
Table - Correct answer ✔Is a data structure usually consisting of a list of
|! |! |! |! |! |! |! |! |! |! |! |! |! |!
entries.
Key - Correct answer ✔An Identifier for a record in a data file that is unique
|! |! |! |! |! |! |! |! |! |! |! |! |! |! |! |!
and found in only one record is called a KEY.
|! |! |! |! |! |! |! |! |!
Database Fundamentals questions |! |! |!
with answers |!
What is the name of the data located at the intersection of a row and column
|! |! |! |! |! |! |! |! |! |! |! |! |! |! |! |!
- Correct answer ✔Field
|! |! |!
Field - Correct answer ✔Is a location in a record in which a particular type of
|! |! |! |! |! |! |! |! |! |! |! |! |! |! |!
data is stored.
|! |! |!
Column - Correct answer ✔Is an attribute for a row or record
|! |! |! |! |! |! |! |! |! |! |!
Row - Correct answer ✔Is a record within a table
|! |! |! |! |! |! |! |! |!
Table - Correct answer ✔Is a database object consisting of rows and columns
|! |! |! |! |! |! |! |! |! |! |! |!
Record - Correct answer ✔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 answer ✔Most modern database management
|! |! |! |! |! |! |! |! |!
systems implement a Relational Model in which the data is organized in
|! |! |! |! |! |! |! |! |! |! |! |!
relations (tables) |!
,One-to-One relationship - Correct answer ✔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 answer ✔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 answer ✔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 answer ✔Are unique data identifiers
|! |! |! |! |! |! |! |!
Structured Query Language(SQL) - Correct answer ✔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 answer ✔Is used to insert,
|! |! |! |! |! |! |! |! |! |!
update, and delete data and to query a database
|! |! |! |! |! |! |! |!
Data Definition Language(DDL) - Correct answer ✔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 answer ✔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 answer ✔DELETE removes all (or a subset
|! |! |! |! |! |! |! |! |! |! |! |!
of) records from the table only; it does not remove the table
|! |! |! |! |! |! |! |! |! |! |!
Schema - Correct answer ✔Is a description of a database to a database
|! |! |! |! |! |! |! |! |! |! |! |! |!
management system(DBMS) in the language provided by the DBMS |! |! |! |! |! |! |! |!
Data Definition Language (DDL) - Correct answer ✔Defines database objects
|! |! |! |! |! |! |! |! |! |!
including entities, attributes, views and indexes
|! |! |! |! |!
CREATE - Correct answer ✔Adds databases or objects
|! |! |! |! |! |! |!
ALTER - Correct answer ✔Changes databases or objects
|! |! |! |! |! |! |!
DROP - Correct answer ✔Removes databases or objects
|! |! |! |! |! |! |!
What data type should Yan use to store the duration of the song in total
|! |! |! |! |! |! |! |! |! |! |! |! |! |! |!
seconds? - Correct answer ✔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 answer ✔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 answer ✔Data types store whole numbers
|! |! |! |! |! |! |! |!
Floating-Point - Correct answer ✔Data types store any real numbers |! |! |! |! |! |! |! |! |!
Character - Correct answer ✔Stores A-Z or 0-9. Any digit or letter that math
|! |! |! |! |! |! |! |! |! |! |! |! |! |!
functions will not be applied to. |! |! |! |! |!
Boolean - Correct answer ✔Stores 1 or 0, true or false
|! |! |! |! |! |! |! |! |! |!
Proper ANSI SQL syntax refers to a set of rules that: - Correct answer
|! |! |! |! |! |! |! |! |! |! |! |! |! |!
✔Govern the structure and content of statements|! |! |! |! |! |!
ANSI SQL Syntax - Correct answer ✔Is the grammar and rules governing the
|! |! |! |! |! |! |! |! |! |! |! |! |!
structure and content of statements. |! |! |! |!
Table - Correct answer ✔Is a data structure usually consisting of a list of
|! |! |! |! |! |! |! |! |! |! |! |! |! |!
entries.
Key - Correct answer ✔An Identifier for a record in a data file that is unique
|! |! |! |! |! |! |! |! |! |! |! |! |! |! |! |!
and found in only one record is called a KEY.
|! |! |! |! |! |! |! |! |!
