D426 - DATA MANAGEMENT
FOUNDATIONS (PRE-ASSESSMENT)
QUESTIONS WITH CORRECT
ANSWERS
, Which requirement within large, complex databases ensures users have limited access
to the database?
A) Recovery
B) Performance
C) Authorization
D) Confidentiality - ANSWERC) Authorization
Which design type specifies database requirements without regard to a specific
database system?
A) Physical design
B) Conceptual design
C) Logical design
D) Abstract design - ANSWERB) Conceptual Design
What characterizes the rules of relational databases? - ANSWERThey are logical
constraints that ensure the data is valid.
Which event will result in an error code and error description when using MySQL
Server? - ANSWERWhen an SQL statement is syntactically incorrect
Which data type should be used to store whole integer values, such as age? -
ANSWERINT
Which text-based interface is included in the MySQL Server Download? -
ANSWERMySQL Command-Line Client
True or False: MySQL includes the World database during its installation. -
ANSWERTrue
What is the standardized language of relational database systems? -
ANSWERStructured Query Language (SQL)
Which SQL sublanguage is used to manage database access? - ANSWERData Control
Language (DCL)
Which SQL sublanguage is used to roll back database changes? - ANSWERData
Transaction Language (DTL)
Which format is used by the TIME data type in MySQL? - ANSWERhh:mm:ss
FOUNDATIONS (PRE-ASSESSMENT)
QUESTIONS WITH CORRECT
ANSWERS
, Which requirement within large, complex databases ensures users have limited access
to the database?
A) Recovery
B) Performance
C) Authorization
D) Confidentiality - ANSWERC) Authorization
Which design type specifies database requirements without regard to a specific
database system?
A) Physical design
B) Conceptual design
C) Logical design
D) Abstract design - ANSWERB) Conceptual Design
What characterizes the rules of relational databases? - ANSWERThey are logical
constraints that ensure the data is valid.
Which event will result in an error code and error description when using MySQL
Server? - ANSWERWhen an SQL statement is syntactically incorrect
Which data type should be used to store whole integer values, such as age? -
ANSWERINT
Which text-based interface is included in the MySQL Server Download? -
ANSWERMySQL Command-Line Client
True or False: MySQL includes the World database during its installation. -
ANSWERTrue
What is the standardized language of relational database systems? -
ANSWERStructured Query Language (SQL)
Which SQL sublanguage is used to manage database access? - ANSWERData Control
Language (DCL)
Which SQL sublanguage is used to roll back database changes? - ANSWERData
Transaction Language (DTL)
Which format is used by the TIME data type in MySQL? - ANSWERhh:mm:ss
