MTA Exam 98-364, Exam 98-364 Database
Fundamentals Questions With Correct
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
Fundamentals Questions With Correct
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
