Pre-Assessment Data Management - |||\\\ |||\\\ |||\\\ |||\\\
Foundations (PBLN) exam with correct |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
answers
Which requirement within large, complex databases ensures users have limited access to the
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
database?
Recovery
Performance
Authorization
Confidentiality - correct answer✔✔Authorization |||\\\ |||\\\ |||\\\ |||\\\
Which design type specifies database requirements without regard to a specific database
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
system?
Physical design |||\\\
Conceptual design |||\\\
Logical design |||\\\
Abstract design - correct answer✔✔Conceptual design
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
What characterizes the rules of relational databases?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
They are logical constraints that ensure the data is valid.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
They are based on business policy and specific databases.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
They represent data volumes and rapidly changing data structures.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
,They embody the theoretical foundation of the SQL language. - correct answer✔✔They are
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
logical constraints that ensure the data is valid.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Which event will result in an error code and error description when using MySQL Server?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
When the server or updates are incorrectly installed
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
When an SQL statement is entered to locate errors in the database
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
When an SQL statement is syntactically incorrect
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
When a Mac OS shortcut code is used on a Windows OS - correct answer✔✔When an SQL
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
statement is syntactically incorrect |||\\\ |||\\\ |||\\\
Which data type should be used to store whole integer values, such as age?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
NUM
VARCHAR
DATE
INT - correct answer✔✔INT
|||\\\ |||\\\ |||\\\ |||\\\
Which text-based interface is included in the MySQL Server Download?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
MySQL Command-Line Client |||\\\ |||\\\
MySQL Workbench |||\\\
MySQL Enterprise |||\\\
MySQL Community - correct answer✔✔MySQL Command-Line Client
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Which database system includes the World database during its installation?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
, MySQL
MongoDB
Oracle
PostgreSQL - correct answer✔✔MySQL |||\\\ |||\\\ |||\\\ |||\\\
What is the standardized language of relational database systems?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Contextual Query Language |||\\\ |||\\\
Structured Query Language |||\\\ |||\\\
Select Query Language |||\\\ |||\\\
Object Query Language - correct answer✔✔Structured Query Language
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Which SQL sublanguage is used to manage database access?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Data Definition Language (DDL)
|||\\\ |||\\\ |||\\\
Data Query Language (DQL)
|||\\\ |||\\\ |||\\\
Data Manipulation Language (DML)
|||\\\ |||\\\ |||\\\
Data Control Language (DCL) - correct answer✔✔Data Control Language (DCL)
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Which SQL sublanguage is used to roll back database changes?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Data Transaction Language (DTL)
|||\\\ |||\\\ |||\\\
Data Manipulation Language (DML)
|||\\\ |||\\\ |||\\\
Data Query Language (DQL)
|||\\\ |||\\\ |||\\\
Data Control Language (DCL) - correct answer✔✔Data Transaction Language (DTL)
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Foundations (PBLN) exam with correct |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
answers
Which requirement within large, complex databases ensures users have limited access to the
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
database?
Recovery
Performance
Authorization
Confidentiality - correct answer✔✔Authorization |||\\\ |||\\\ |||\\\ |||\\\
Which design type specifies database requirements without regard to a specific database
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
system?
Physical design |||\\\
Conceptual design |||\\\
Logical design |||\\\
Abstract design - correct answer✔✔Conceptual design
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
What characterizes the rules of relational databases?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
They are logical constraints that ensure the data is valid.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
They are based on business policy and specific databases.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
They represent data volumes and rapidly changing data structures.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
,They embody the theoretical foundation of the SQL language. - correct answer✔✔They are
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
logical constraints that ensure the data is valid.
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Which event will result in an error code and error description when using MySQL Server?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
When the server or updates are incorrectly installed
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
When an SQL statement is entered to locate errors in the database
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
When an SQL statement is syntactically incorrect
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
When a Mac OS shortcut code is used on a Windows OS - correct answer✔✔When an SQL
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
statement is syntactically incorrect |||\\\ |||\\\ |||\\\
Which data type should be used to store whole integer values, such as age?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
NUM
VARCHAR
DATE
INT - correct answer✔✔INT
|||\\\ |||\\\ |||\\\ |||\\\
Which text-based interface is included in the MySQL Server Download?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
MySQL Command-Line Client |||\\\ |||\\\
MySQL Workbench |||\\\
MySQL Enterprise |||\\\
MySQL Community - correct answer✔✔MySQL Command-Line Client
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Which database system includes the World database during its installation?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
, MySQL
MongoDB
Oracle
PostgreSQL - correct answer✔✔MySQL |||\\\ |||\\\ |||\\\ |||\\\
What is the standardized language of relational database systems?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Contextual Query Language |||\\\ |||\\\
Structured Query Language |||\\\ |||\\\
Select Query Language |||\\\ |||\\\
Object Query Language - correct answer✔✔Structured Query Language
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Which SQL sublanguage is used to manage database access?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Data Definition Language (DDL)
|||\\\ |||\\\ |||\\\
Data Query Language (DQL)
|||\\\ |||\\\ |||\\\
Data Manipulation Language (DML)
|||\\\ |||\\\ |||\\\
Data Control Language (DCL) - correct answer✔✔Data Control Language (DCL)
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Which SQL sublanguage is used to roll back database changes?
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
Data Transaction Language (DTL)
|||\\\ |||\\\ |||\\\
Data Manipulation Language (DML)
|||\\\ |||\\\ |||\\\
Data Query Language (DQL)
|||\\\ |||\\\ |||\\\
Data Control Language (DCL) - correct answer✔✔Data Transaction Language (DTL)
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
