Database Management 2

Which SQL object stores a query that can be reused like a table?

Which of the following is NOT a property of a database transaction (ACID)?

Which type of dependency does Boyce-Codd Normal Form (BCNF) remove?

Which of the following SQL functions returns the total number of rows in a result set?

What is the purpose of the ROLLBACK command?

Which of the following is a frontend tool for designing website UIs?

Which language is commonly used for writing backend web applications?

Which of the following is a NoSQL database?

Which SQL clause is used to filter results?

What is an advantage of using a view in SQL?

Which of the following is NOT a type of database relationship?

Which database user role has full administrative privileges?

Which SQL statement is used to update data in a table?

What is the purpose of an index in a database?

What type of SQL statement is CREATE VIEW

Which normal form eliminates duplicate columns and groups related data?

A table is in 2NF if it is in 1NF and also…

What does Firebase primarily provide for web applications?

Which database design approach minimizes redundancy?

What type of SQL statement is CREATE VIEW

What is the role of GitHub in web development?

What does the JOIN clause do in SQL

Which of the following is NOT a type of SQL constraint?

Which HTTP method is used to update a resource?