Recovery
Performance
Authorization
Confidentiality<\/a><\/p>\n\n\n\n
Authorization<\/a><\/p>\n\n\n\n Which design type specifies database requirements without regard to a specific database system? Conceptual design<\/a><\/p>\n\n\n\n 3. What characterizes the rules of relational databases? They are logical constraints that ensure the data is valid.<\/a><\/p>\n\n\n\n 4. Which event will result in an error code and error description when using MySQL Server? When an SQL statement is syntactically incorrect<\/a><\/p>\n\n\n\n 5. Which data type should be used to store whole integer values, such as age? INT<\/a><\/p>\n\n\n\n 6. Which text-based interface is included in the MySQL Server Download? MySQL Command-Line Client<\/a><\/p>\n\n\n\n 7. Which database system includes the World database during its installation? MySQL<\/a><\/p>\n\n\n\n 8. What is the standardized language of relational database systems? Structured Query Language<\/a><\/p>\n\n\n\n 9. Which SQL sublanguage is used to manage database access? Data Control Language (DCL)<\/a><\/p>\n\n\n\n 10. Which SQL sublanguage is used to roll back database changes? Data Transaction Language (DTL)<\/a><\/p>\n\n\n\n 11. Which format is used by the TIME data type in MySQL? hh:mm:ss<\/a><\/p>\n\n\n\n 12. Which MySQL operator is the last in the order of operator precedence? OR<\/a><\/p>\n\n\n\n 13. Which operator is used to compare columns from the left and right tables in MySQL? =<\/a><\/p>\n\n\n\n 14. Which type of join combines two tables without comparing columns? CROSS<\/a><\/p>\n\n\n\n 15. Which type of join compares columns using only the = operator? Equijoin<\/a><\/p>\n\n\n\n 16. Which type of join is demonstrated by the following query? EQUIJOIN<\/a><\/p>\n\n\n\n 17. What is another name for a subquery? Nested query<\/a><\/p>\n\n\n\n 18. Which operator is used to compare against a list of values when determining a match in a WHERE clause? IN<\/a><\/p>\n\n\n\n 19. Which wildcard character is used to represent zero or more characters when searching for a specified pattern using a LIKE operator? %<\/a><\/p>\n\n\n\n 20. Which function is considered an aggregating function in SQL? MIN<\/a><\/p>\n\n\n\n 21. Which clause or function is used with aggregate functions to produce summary rows? GROUP BY<\/a><\/p>\n\n\n\n 22. Which type of join returns only the matching values when selecting rows from two or more tables? Inner Join<\/a><\/p>\n\n\n\n 23. Which join type selects only matching left and right table rows? Inner Join<\/a><\/p>\n\n\n\n 24. Which phrase refers to the view in which data is persisted and is automatically changed as the underlying data is changed? Materialized View<\/a><\/p>\n\n\n\n 25. Which SQL command uses the correct syntax to update the salary of an employee in the Employee table? UPDATE Employee SET Salary = 50000 WHERE ID = 1;<\/a><\/p>\n\n\n\n 26. What describes elements such as column name and data type? Metadata<\/a><\/p>\n\n\n\n 27. Which term identifies an ordered collection of elements enclosed in parenthesis in a tablespace? Tuple<\/a><\/p>\n\n\n\n 28. 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? SELECT name, salary FROM Employee WHERE salary > 50000 ORDER + BY salary DESC;<\/a><\/p>\n\n\n\n 29. Which INSERT statement demonstrates valid syntax in SQL? INSERT INTO table_name (column1, column2) VALUES (value1, value2);<\/a><\/p>\n\n\n\n 30. Which UPDATE statement uses valid syntax in SQL? UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;<\/a><\/p>\n\n\n\n 31. Which statement used to remove data from temporary tables? TRUNCATE<\/a><\/p>\n\n\n\n 32. Which keyword is a DDL (data definition language) keyword in SQL? CREATE<\/a><\/p>\n\n\n\n 33. Which property is enforced by a primary key field? Not Null<\/a><\/p>\n\n\n\n 34. Which property or function allows SQL to insert a field value? Auto-increment<\/a><\/p>\n\n\n\n 35. Which property specifies an expression on one or more columns of a table? CHECK<\/a><\/p>\n\n\n\n 36. Which type of key is a single column in a table used to identify a row? Simple primary key<\/a><\/p>\n\n\n\n 37. Which type of key is often represented by parentheses to show multiple columns? Composite<\/a><\/p>\n\n\n\n 38. Which primary key characteristic means it includes information that is easy to type and store? Simple<\/a><\/p>\n\n\n\n 39. Which part of a junction table in a relational database establishes a many-to-many relationship between two tables? Foreign key<\/a><\/p>\n\n\n\n 40. Which type of relationship is established by a foreign key in a relational database? One-to-many<\/a><\/p>\n\n\n\n 41. Which statements may be rejected when a foreign key constraint is specified? INSERT<\/a><\/p>\n\n\n\n 42. Which key describes the unique columns in a table that do not contain a primary key? Candidate key<\/a><\/p>\n\n\n\n 43. Which index stores column values and row pointers in a hierarchy? Multi-level index<\/a><\/p>\n\n\n\n 44. Which type of index refers to entries that are assigned to buckets? Hash index<\/a><\/p>\n\n\n\n 45. Which type of index is a grid of bits where each index row corresponds to a unique row in a table? Bitmap index<\/a><\/p>\n\n\n\n 46. Which type of development activity is used to convert an entity-relationship model (ERM) into tables, columns, and keys? Logical design<\/a><\/p>\n\n\n\n 47. Which term addresses columns of A being a subset of the columns of B, with A always depending on B? Trivial dependency<\/a><\/p>\n\n\n\n 48. Which term describes the process of denormalization? Merging tables<\/a><\/p>\n\n\n\n 49. A database designer is working with a table that has a primary key and no duplicate rows. What can be concluded about the table? It is a first normal form table.<\/a><\/p>\n\n\n\n 50. Which process eliminates redundancy by decomposing a table into two or more tables in a higher normal form? Normalization<\/a><\/p>\n\n\n\n 51. Which term describes the optimal normal form for frequent inserts, updates, and deletes of data? Boyce-Codd normal form<\/a><\/p>\n\n\n\n 52. Which relationship is depicted in the following entity-relationship (ER) diagram? One-to-many<\/a><\/p>\n\n\n\n 53. Which relationship or association exists between a supertype entity and its subtype entities? IsA relationship<\/a><\/p>\n\n\n\n 54. Which symbol is used in an entity-relationship (ER) diagram for an entity? Square<\/a><\/p>\n\n\n\n 55. Which symbol is used in an entity-relationship (ER) diagram to indicate an attribute? Circle<\/a><\/p>\n\n\n\n 56. What must be done before creating supertype and subtype entities? Identify entities.<\/a><\/p>\n\n\n\n 57. Which real-world object can be distinctly identified and grouped, such as all employees in a company? Entity<\/a><\/p>\n\n\n\n Which item in an entity-relationship (ER) diagram follows the attribute name and is placed outside of parentheses? Attribute maximum<\/a><\/p>\n\n\n\n 59. Which strategy can be used to identify primary keys when investigating data relationships? Unique identifier analysis<\/a><\/p>\n\n\n\n
Physical design
Conceptual design
Logical design
Abstract design<\/a><\/p>\n\n\n\n
-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.<\/p>\n\n\n\n
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<\/p>\n\n\n\n
NUM
VARCHAR
DATE
INT<\/a><\/p>\n\n\n\n
MySQL Command-Line Client
MySQL Workbench
MySQL Enterprise
MySQL Community<\/a><\/p>\n\n\n\n
MySQL
MongoDB
Oracle
PostgreSQL<\/a><\/p>\n\n\n\n
Contextual Query Language
Structured Query Language
Select Query Language
Object Query Language<\/a><\/p>\n\n\n\n
Data Definition Language (DDL)
Data Query Language (DQL)
Data Manipulation Language (DML)
Data Control Language (DCL)<\/a><\/p>\n\n\n\n
Data Transaction Language (DTL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL)<\/a><\/p>\n\n\n\n
YYYY-MM-DD
YYYY-MM-DD hh:mm:ss
hh:mm:ss
hh:mm:ss YYYY-MM-DD<\/a><\/p>\n\n\n\n
–
OR
NOT
=<\/a><\/p>\n\n\n\n
<=
+
=
*<\/a><\/p>\n\n\n\n
SELF
EQUIJOIN
OUTER
CROSS<\/a><\/p>\n\n\n\n
Equijoin
Non-equijoin
Outer join
Inner join<\/a><\/p>\n\n\n\n
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
NON-EQUIJOIN
SELF JOIN
CROSS JOIN
EQUIJOIN<\/a><\/p>\n\n\n\n
Outer query
Nested query
Correlated query
Search query<\/a><\/p>\n\n\n\n
IN
BETWEEN
LIKE
OR<\/a><\/p>\n\n\n\n
%
_
<
><\/a><\/p>\n\n\n\n
TRIM
REPLACE
MIN
SUBSTRING<\/a><\/p>\n\n\n\n
TRIM
REPLACE
ORDER BY
GROUP BY<\/a><\/p>\n\n\n\n
Full Join
Outer Join
Equijoin
Inner Join<\/a><\/p>\n\n\n\n
Full Join
Left Join
Right Join
Inner Join<\/a><\/p>\n\n\n\n
Virtual View
Snapshot View
Denormalized View
Materialized View<\/a><\/p>\n\n\n\n
CHANGE Employee Salary = 50000 WHERE ID = 1;
UPDATE Employee SET Salary = 50000 WHERE ID = 1;
ALTER Employee SET Salary = 50000 WHERE ID = 1;
UPDATE Employee (Salary) = (50000) WHERE ID = 1;<\/a><\/p>\n\n\n\n
Alter
Table
Metadata
CRUD<\/a><\/p>\n\n\n\n
Cell
Field
Column
Tuple<\/a><\/p>\n\n\n\n
-SELECT name, salary FROM Employee WHERE salary > 50000 ORDER + BY salary DESC;
-SELECT Employee.name, Employee.salary WHERE Employee.salary > 50000 SORT BY Employee.salary DESC;
-SELECT name, salary FROM Employee SORT BY salary DESC WHERE salary > 50000;
-SELECT name, salary FROM Employee WHERE salary > 50000 SORT BY salary ASC;<\/p>\n\n\n\n
INSERT INTO table_name (column1, column2) SET value1, value2;
INSERT INTO table_name VALUES (value1, value2);
INSERT INTO table_name (column1, column2) VALUES (value1, value2);
INSERT INTO table_name SET column1 = value1, column2 = value2;<\/a><\/p>\n\n\n\n
UPDATE table_name column_name= value1 WHERE condition
UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
UPDATE SET column1 = value1, column2 = value2 WHERE condition IN table_name;
UPDATE table_name SET column_name = value1<\/p>\n\n\n\n
DROP
DELETE
DEFAULT
TRUNCATE<\/a><\/p>\n\n\n\n
INSERT
UPDATE
DELETE
CREATE<\/a><\/p>\n\n\n\n
Not Null
Null
Duplicate
Numeric<\/a><\/p>\n\n\n\n
Composite
Simple
Auto-increment
Numeric<\/a><\/p>\n\n\n\n
CHECK
RESTRICT
CASCADE
UNIQUE<\/a><\/p>\n\n\n\n
Super key
Simple primary key
Foreign key
Composite primary key<\/a><\/p>\n\n\n\n
Composite
Simple
Unique
Foreign<\/a><\/p>\n\n\n\n
Non-null
Meaningless
Stable
Simple<\/a><\/p>\n\n\n\n
Primary key
Foreign key
Composite key
Candidate key<\/a><\/p>\n\n\n\n
Aggregation
Composition
One-to-many
Many-to-many<\/a><\/p>\n\n\n\n
INSERT
CHECK
SELECT
ORDER BY<\/a><\/p>\n\n\n\n
Foreign key
Simple key
Candidate key
Composite key<\/a><\/p>\n\n\n\n
Dense index
Sparse index
Multi-level index
Secondary index<\/a><\/p>\n\n\n\n
Bitmap index
Logical index
Hash index
Secondary index<\/a><\/p>\n\n\n\n
Multi-level index
Logical index
Hash index
Bitmap index<\/a><\/p>\n\n\n\n
Execution
Physical design
Analysis
Logical design<\/a><\/p>\n\n\n\n
Third normal form
Candidate key
Trivial dependency
Non-trivial dependency<\/a><\/p>\n\n\n\n
Merging tables
Candidate key
Trivial dependency
Third normal form<\/a><\/p>\n\n\n\n
It is a Boyce-Codd table.
It contains trivial dependency.
The table contains a non-key column.
It is a first normal form table.<\/a><\/p>\n\n\n\n
Merging
Creation of a candidate key
Evaluation of trivial dependency
Normalization<\/a><\/p>\n\n\n\n
Boyce-Codd normal form
Candidate key
Trivial dependency
Third normal form<\/a><\/p>\n\n\n\n
Ternary
Many-to-many
One-to-one
One-to-many<\/a><\/p>\n\n\n\n![\"Image:](\"https:\/\/quizlet.com\/cdn-cgi\/image\/f=auto,fit=cover,h=200,onerror=redirect,w=240\/https:\/\/o.quizlet.com\/sLuASaj0pc8SlK55vP5t6Q.jpg\")
<\/figure>\n\n\n\n
IsA relationship
Weak entity
Associative entity
Unary relationship<\/a><\/p>\n\n\n\n
Diamond
Square
Circle
Line<\/a><\/p>\n\n\n\n
Diamond
Square
Circle
Line<\/a><\/p>\n\n\n\n
Identify entities.
Document entities.
Determine attribute maxima.
Document cardinality<\/a><\/p>\n\n\n\n
Entity-relationship (ER) diagram
Glossary
Entity
Attribute type<\/a><\/p>\n\n\n\n
Weak entity
Attribute maximum
Attribute minimum
Physical design<\/a><\/p>\n\n\n\n
Trend analysis
Unique identifier analysis
Hypothesis testing
Visualization<\/a><\/p>\n\n\n\n
![\"Image:](\"https:\/\/quizlet.com\/cdn-cgi\/image\/f=auto,fit=cover,h=200,onerror=redirect,w=240\/https:\/\/o.quizlet.com\/KeBSojCEwy9tmXQvdP35eQ.jpg\")
<\/figure>\n\n\n\n