Podcast
Questions and Answers
Which database model is based on a tabular data structure and was published by E.F. Codd in 1970?
Which database model is based on a tabular data structure and was published by E.F. Codd in 1970?
- Relational model (correct)
- MySQL Server
- MySQL Enterprise
- MySQL Workbench
Which database system instance is a single executing copy of a database system?
Which database system instance is a single executing copy of a database system?
- Database system instance (correct)
- DatabaseName
- MySQL Server
- Database model
Which high-level computer language is used for storing, manipulating, and retrieving data?
Which high-level computer language is used for storing, manipulating, and retrieving data?
- MySQL Enterprise
- MySQL Community
- Relational algebra
- Structured Query Language (correct)
Which SQL command is used to create a new database?
Which SQL command is used to create a new database?
Which of the following statements about data is true?
Which of the following statements about data is true?
What is the role of a database administrator?
What is the role of a database administrator?
What is the purpose of a query language in a database system?
What is the purpose of a query language in a database system?
Which keyword is used to perform case-sensitive pattern matching with the LIKE operator?
Which keyword is used to perform case-sensitive pattern matching with the LIKE operator?
Which aggregate function counts the number of rows in a set?
Which aggregate function counts the number of rows in a set?
Which join clause selects all left table rows, but only matching right table rows?
Which join clause selects all left table rows, but only matching right table rows?
Which keyword is used to create an alias for a column or table?
Which keyword is used to create an alias for a column or table?
Which of the following is true about a materialized view?
Which of the following is true about a materialized view?
What happens when the WITH CHECK OPTION is specified for a view?
What happens when the WITH CHECK OPTION is specified for a view?
What is the purpose of the select operation in relational algebra?
What is the purpose of the select operation in relational algebra?
Which keyword is used to specify the column values to be added in an INSERT statement?
Which keyword is used to specify the column values to be added in an INSERT statement?
What does the PRIMARY KEY constraint ensure in a CREATE TABLE statement?
What does the PRIMARY KEY constraint ensure in a CREATE TABLE statement?
What is a foreign key?
What is a foreign key?
Which clause is used to specify actions to be taken when a primary key is updated or deleted?
Which clause is used to specify actions to be taken when a primary key is updated or deleted?
Which statement is true about the CREATE TABLE statement?
Which statement is true about the CREATE TABLE statement?
Which data type represents numbers with fractional values?
Which data type represents numbers with fractional values?
What is the purpose of the SELECT statement?
What is the purpose of the SELECT statement?
What does the IS NULL operator do?
What does the IS NULL operator do?
Which one of the following is true about a database user?
Which one of the following is true about a database user?
Which one of the following statements about a transaction is true?
Which one of the following statements about a transaction is true?
Which one of the following is true about a relational database?
Which one of the following is true about a relational database?
Which one of the following is true about SQL?
Which one of the following is true about SQL?
Flashcards are hidden until you start studying
