C192 Pre-Assessment WGU quizzes
with fully solved correct answers
100%accurate
Which factor must be considered during physical database design?
A.) Determination of the specific DBMS vendor product to use
B.) Specification of table definitions
C.) Specification of entities and relationships between entities
D.) Determination of the type of DBMS to be used - answer ✔✔-A.) Determination of the
specific DBMS vendor product to use
Which technique is used to test the correctness of a logical database design model?
A.) Prototyping
B.) Normalization
C.) Logical Grouping
D.) Extensibility - answer ✔✔-B.) Normalization
Which database design phase uses normalization techniques to eliminate anomalies in the data
model?
,A.) XML Database Design
B.) Physical Database Design
C.) Logical Database Design
D.) Conceptual Database Design - answer ✔✔-C.) Logical Database Design
Which step would be seen in the conceptual phase of data model design?
A.) Specification of entities and relationships
B.) Specification of trigger definitions
C.) Specification of storage size
D.) Specification of programming language to use - answer ✔✔-A.) Specification of entities and
relationships
What describes a specialized grouping of entity type occurrences that must be represented in a
data model?
A.) Superclass
B.) Baseclass
C.) Relationship
D.) Subclass - answer ✔✔-D.) Subclass
Which concept does the SQL statement "SELECT * FROM Contacts, Employer" demonstrate?
A.) Difference
B.) Cartesian product
C.) Selection
D.) Intersection - answer ✔✔-B.) Cartesian Product
, What is the difference between a conceptual model and a logical model?
A.) A conceptual model is refined based on the network data model, whereas the logical model
is based on a multidimensional model.
B.) A conceptual model assumes details of the underlying DBMS, whereas the logical model
assumes details based on an abstraction.
C.) A conceptual model is independent of all implementation details, whereas the logical model
is based on a specific database model.
D.) A conceptual model is dependent upon the programming language used to manage the
data, whereas the logical model is dependent on implementation details. - answer ✔✔-C.) A
conceptual model is independent of all implementation details, whereas the logical model is
based on a specific database model.
Which data type is considered a non-interpreted byte stream for a database management
system (DBMS)?
A.) Float
B.) Character
C.) Bit
D.) BLOB
E.) XML - answer ✔✔-D.) BLOB
Which database management systems (DBMS) architecture emerged in the third generation of
DBMSs?
with fully solved correct answers
100%accurate
Which factor must be considered during physical database design?
A.) Determination of the specific DBMS vendor product to use
B.) Specification of table definitions
C.) Specification of entities and relationships between entities
D.) Determination of the type of DBMS to be used - answer ✔✔-A.) Determination of the
specific DBMS vendor product to use
Which technique is used to test the correctness of a logical database design model?
A.) Prototyping
B.) Normalization
C.) Logical Grouping
D.) Extensibility - answer ✔✔-B.) Normalization
Which database design phase uses normalization techniques to eliminate anomalies in the data
model?
,A.) XML Database Design
B.) Physical Database Design
C.) Logical Database Design
D.) Conceptual Database Design - answer ✔✔-C.) Logical Database Design
Which step would be seen in the conceptual phase of data model design?
A.) Specification of entities and relationships
B.) Specification of trigger definitions
C.) Specification of storage size
D.) Specification of programming language to use - answer ✔✔-A.) Specification of entities and
relationships
What describes a specialized grouping of entity type occurrences that must be represented in a
data model?
A.) Superclass
B.) Baseclass
C.) Relationship
D.) Subclass - answer ✔✔-D.) Subclass
Which concept does the SQL statement "SELECT * FROM Contacts, Employer" demonstrate?
A.) Difference
B.) Cartesian product
C.) Selection
D.) Intersection - answer ✔✔-B.) Cartesian Product
, What is the difference between a conceptual model and a logical model?
A.) A conceptual model is refined based on the network data model, whereas the logical model
is based on a multidimensional model.
B.) A conceptual model assumes details of the underlying DBMS, whereas the logical model
assumes details based on an abstraction.
C.) A conceptual model is independent of all implementation details, whereas the logical model
is based on a specific database model.
D.) A conceptual model is dependent upon the programming language used to manage the
data, whereas the logical model is dependent on implementation details. - answer ✔✔-C.) A
conceptual model is independent of all implementation details, whereas the logical model is
based on a specific database model.
Which data type is considered a non-interpreted byte stream for a database management
system (DBMS)?
A.) Float
B.) Character
C.) Bit
D.) BLOB
E.) XML - answer ✔✔-D.) BLOB
Which database management systems (DBMS) architecture emerged in the third generation of
DBMSs?
