Database Management Quiz

Explain in a single sentence why we need to have less number of NULL values in a database?

Apart from identifying every unique row in a database, what other benefit can be achieved from a database where a primary key has been defined? Mention in answer in few words only.

What is BLOB and CLOB in SQL?

Which level of abstraction describes how data is actually stored?

What do you understand by metadata?

Which SQL query mandates need of "AS" in the query?

Which normal form contains information about a single entity?

_____ operation is used to mention list of attributes from a table/relation.

If there are 2 types of tuples, A & B, the ___ operation contains all the tuples that are either in A or B or both in A & B

Which operation eliminates duplicate tuples in relational algebra