ZIUQ

Front

Which feature is absent in file systems but present in DBMS?

Back

Crash recovery

Front

Which of the following is NOT a characteristic of a DBMS? Data redundancy, Data integrity, Data security, Data independence

Back

Data redundancy

Front

The DBMS acts as an interface between: The user and the software

Back

The user and the software

Front

Which SQL command is used to delete a table?

Back

DROP TABLE

Front

What is the primary purpose of normalization in a DBMS?

Back

To reduce data redundancy and improve data integrity

Front

Which of the following is NOT a valid type of SQL join? INNER JOIN, OUTER JOIN, LEFT JOIN

Back

MIDDLE JOIN

Front

What is a foreign key?

Back

A field in one table that uniquely identifies a row in another table.

Front

What does the 'GROUP BY' clause in SQL do?

Back

Groups rows that have the same values into summary rows

Front

What is the purpose of the 'HAVING' clause in SQL?

Back

To filter groups after the GROUP BY clause

Front

Which of the following is NOT a component of the relational model? Tables, Attributes, Objects, Tuples

Back

Objects