Pre Assessment Flashcards
Which requirement within large, complex databases ensures users have limited access to the database?
A. Recovery
B. Performance
C. Authorization
D. Confidentiality
C. 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
B. Conceptual design
What characterizes the rules of relational databases?
A. They are logical constraints that ensure the data is valid.
B. They are based on business policy and specific databases.
C. They represent data volumes and rapidly changing data structures.
D. They embody the theoretical foundation of the SQL language.
A. 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?
A. When the server or updates are incorrectly installed
B. When an SQL statement is entered to locate errors in the database
C. When an SQL statement is syntactically incorrect
D. When a Mac OS shortcut code is used on a Windows OS
C. When an SQL statement is syntactically incorrect
Which data type should be used to store whole integer values, such as age?
A. NUM
B. VARCHAR
C. DATE
D. INT
D. INT
Which text-based interface is included in the MySQL Server Download?
A. MySQL Command-Line Client
B. MySQL Workbench
C. MySQL Enterprise
D. MySQL Community
A. MySQL Command-Line Client
Which database system includes the World database during its installation?
A. MySQL
B. MongoDB
C. Oracle
D. PostgreSQL
A. MySQL
What is the standardized language of relational database systems?
A. Contextual Query Language
B. Structured Query Language
C. Select Query Language
D. Object Query Language
B. Structured Query Language
Which SQL sublanguage is used to manage database access?
A. Data Definition Language (DDL)
B. Data Query Language (DQL)
C. Data Manipulation Language (DML)
D. Data Control Language (DCL)
D. Data Control Language (DCL)
Which SQL sublanguage is used to roll back database changes?
A. Data Transaction Language (DTL)
B. Data Manipulation Language (DML)
C. Data Query Language (DQL)
D. Data Control Language (DCL)
Data Transaction Language (DTL) Data Manipulation Language (DML) Data Query Language (DQL)
Data Control Language (DCL)
Which format is used by the TIME data type in MySQL?
A. YYYY-MM-DD
B. YYYY-MM-DD hh:mm:ss
C. hh:mm:ss
D. hh:mm:ss YYYY-MM-DD
C. hh:mm:ss
Which MySQL operator is the last in the order of operator precedence?
A. -
B. OR
C. NOT
D. =
B. OR
Which operator is used to compare columns from the left and right tables in MySQL?
A. <=
B. +
C. =
D. *
C. =
Which type of join combines two tables without comparing columns?
A. SELF
B. EQUIJOIN
C. OUTER
D. CROSS
D. CROSS
Which type of join compares columns using only the = operator?
A. Equijoin
B. Non-equijoin
C. Outer join
D. Inner join
A. Equijoin
Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.Address FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
A. NON-EQUIJOIN
B. SELF JOIN
C. CROSS JOIN
D. EQUIJOIN
D. EQUIJOIN
What is another name for a subquery?
A. Outer query
B. Nested query
C. Correlated query
D. Search query
B. Nested query
Which operator is used to compare against a list of values when determining a match in a WHERE clause?
A. IN
B. BETWEEN
C. LIKE
D. OR
A. IN
Which wildcard character is used to represent zero or more characters when searching for a specified pattern using a LIKE operator?
A. %
B. _
C. <
D. >
A. %
Which function is considered an aggregating function in SQL?
A. TRIM
B. REPLACE
C. MIN
D. SUBSTRING
C. MIN
Which clause or function is used with aggregate functions to produce summary rows?
A. TRIM
B. REPLACE
C. ORDER BY
D. GROUP BY
D. GROUP BY
Which type of join returns only the matching values when selecting rows from two or more tables?
A. Full Join
B. Outer Join
C. Equijoin
D. Inner Join
D. Inner Join
Which join type selects only matching left and right table rows?
A. Full Join
B. Left Join
C. Right Join
D. Inner Join
D. Inner Join
Which phrase refers to the view in which data is persisted and is automatically changed as the underlying data is changed?
A. Virtual View
B. Snapshot View
C. Denormalized View
D. Materialized View
D. Materialized View
Which SQL command uses the correct syntax to update the salary of an employee in the Employee table?
A. CHANGE Employee Salary = 50000 WHERE ID = 1;
B. UPDATE Employee SET Salary = 50000 WHERE ID = 1;
C. ALTER Employee SET Salary = 50000 WHERE ID = 1;
D. UPDATE Employee (Salary) = (50000) WHERE ID = 1;
B. UPDATE Employee SET Salary = 50000 WHERE ID = 1;
What describes elements such as column name and data type?
A. Alter
B. Table
C. Metadata
D. CRUD
C. Metadata
Which term identifies an ordered collection of elements enclosed in parenthesis in a tablespace?
A. Cell
B. Field
C. Column
D. Tuple
D. Tuple
Which SQL command uses the correct syntax to select the name and salary columns from the Employee table, where the salary is greater than 50000, and sort the results by salary in descending order?
A. SELECT name, salary FROM Employee WHERE salary > 50000 ORDER BY salary DESC;
B. SELECT Employee.name, Employee.salary WHERE Employee.salary > 50000 SORT BY Employee.salary DESC;
C. SELECT name, salary FROM Employee SORT BY salary DESC WHERE salary > 50000;
D. SELECT name, salary FROM Employee WHERE salary > 50000 SORT BY salary ASC;
A. SELECT name, salary FROM Employee WHERE salary > 50000 ORDER BY salary DESC;
Which INSERT statement demonstrates valid syntax in SQL?
A. INSERT INTO table_name (column1, column2) SET value1, value2;
B. INSERT INTO table_name VALUES (value1, value2);
C. INSERT INTO table_name (column1, column2) VALUES (value1, value2);
D. INSERT INTO table_name SET column1 = value1, column2 = value2;
C. INSERT INTO table_name (column1, column2) VALUES (value1, value2);
Which UPDATE statement uses valid syntax in SQL?
A. UPDATE table_name column_name= value1 WHERE condition
B. UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
C. UPDATE SET column1 = value1, column2 = value2 WHERE condition IN table_name;
D. UPDATE table_name SET column_name = value1
B. UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
Which statement used to remove data from temporary tables?
A. DROP
B. DELETE
C. DEFAULT
D. TRUNCATE
D. TRUNCATE
Which keyword is a DDL (data definition language) keyword in SQL?
A. INSERT
B. UPDATE
C. DELETE
D. CREATE
D. CREATE
Which property is enforced by a primary key field?
A. Not Null
B. Null
C. Duplicate
D. Numeric
A. Not Null
Which property or function allows SQL to insert a field value?
A. Composite
B. Simple
C. Auto-increment
D. Numeric
C. Auto-increment
Which property specifies an expression on one or more columns of a table?
A. CHECK
B. RESTRICT
C. CASCADE
D. UNIQUE
A. CHECK
Which type of key is a single column in a table used to identify a row?
A. Super key
B. Simple primary key
C. Foreign key
D. Composite primary key
B. Simple primary key
Which type of key is often represented by parentheses to show multiple columns?
A. Composite
B. Simple
C. Unique
D. Foreign
A. Composite
Which primary key characteristic means it includes information that is easy to type and store?
A. Non-null
B. Meaningless
C. Stable
D. Simple
D. Simple
Which part of a junction table in a relational database establishes a many-to-many relationship between two tables?
A. Primary key
B. Foreign key
C. Composite key
D. Candidate key
B. Foreign key
Which type of relationship is established by a foreign key in a relational database?
A. Aggregation
B. Composition
C. One-to-many
D. Many-to-many
C. One-to-many
Which statements may be rejected when a foreign key constraint is specified?
A. INSERT
B. CHECK
C. SELECT
D. ORDER BY
A. INSERT
Which key describes the unique columns in a table that do not contain a primary key?
A. Foreign key
B. Simple key
C. Candidate key
D. Composite key
C. Candidate key
Which index stores column values and row pointers in a hierarchy?
A. Dense index
B. Sparse index
C. Multi-level index
D. Secondary index
C. Multi-level index
Which type of index refers to entries that are assigned to buckets?
A. Bitmap index
B. Logical index
C. Hash index
D. Secondary index
C. Hash index
Which type of index is a grid of bits where each index row corresponds to a unique row in a table?
A. Multi-level index
B. Logical index
C. Hash index
D. Bitmap index
D. Bitmap index
Which type of development activity is used to convert an entity-relationship model (ERM) into tables, columns, and keys?
A. Execution
B. Physical design
C. Analysis
D. Logical design
D. Logical design
Which term addresses columns of A being a subset of the columns of B, with A always depending on B?
A. Third normal form
B. Candidate key
C. Trivial dependency
D. Non-trivial dependency
C. Trivial dependency
Which term describes the process of denormalization?
A. Merging tables
B. Candidate key
C. Trivial dependency
D. Third normal form
A. Merging tables
A database designer is working with a table that has a primary key and no duplicate rows. What can be concluded about the table?
A. It is a Boyce-Codd table.
B. It contains trivial dependency.
C. The table contains a non-key column.
D. It is a first normal form table.
D. It is a first normal form table.
Which process eliminates redundancy by decomposing a table into two or more tables in a higher normal form?
A. Merging
B. Creation of a candidate key
C. Evaluation of trivial dependency
D. Normalization
D. Normalization
Which term describes the optimal normal form for frequent inserts, updates, and deletes of data?
A. Boyce-Codd normal form
B. Candidate key
C. Trivial dependency
D. Third normal form
A. Boyce-Codd normal form
Which relationship is depicted in the following entity-relationship (ER) diagram?
A. Ternary
B. Many-to-many
C. One-to-one
D. One-to-many
D. One-to-many
Which relationship or association exists between a supertype entity and its subtype entities?
A. IsA relationship
B. Weak entity
C. Associative entity
D. Unary relationship
A. IsA relationship
Which symbol is used in an entity-relationship (ER) diagram for an entity?
A. Diamond
B. Square
C. Circle
D. Line
B. Square
Which symbol is used in an entity-relationship (ER) diagram to indicate an attribute?
A. Diamond
B. Square
C. Circle
D. Line
C. Circle
What must be done before creating supertype and subtype entities?
A. Identify entities.
B. Document entities.
C. Determine attribute maxima.
D. Document cardinality.
A. Identify entities.
Which real-world object can be distinctly identified and grouped, such as all employees in a company?
A. Entity-relationship (ER) diagram
B. Glossary
C. Entity
D. Attribute type
C. Entity
Which item in an entity-relationship (ER) diagram follows the attribute name and is placed outside of parentheses?
A. Weak entity
B. Attribute maximum
C. Attribute minimum
D. Physical design
B. Attribute maximum
Which strategy can be used to identify primary keys when investigating data relationships?
A. Trend analysis
B. Unique identifier analysis
C. Hypothesis testing
D. Visualization
B. Unique identifier analysis
How should an entity relationship phrase be read to correctly understand how one entity relates to another entity in an entity- relationship diagram (ER diagram)?
A. From top to bottom
B. In the direction the entity box is facing
C. In the direction the relationship verb is facing
D. From left to right
C. In the direction the relationship verb is facing
