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