DBMS Assignment 3

A tuple is an

• A ) Column of a table
• B ) Two dimensional table
• C) Row of table
• D) Key of a table

A(n) ________ organizes data in two-dimensional table

• non-relational DBMS
• mobile DBMS
• relational DBMS
• hierarchical DBMS

SQL stands for ________ .

• A) Structured Query Language
• B) Structured Question Language
• C) Sequential Query Language
• D) Sequential Question Language

Which of the following is a characteristic of a database?

• Data redundancy
• Data inconsistency
• Data sharing
• Data isolation

What is the purpose of the GROUP BY clause in SQL?

• To filter individual rows
• To filter groups of rows
• To group rows
• To sort rows

Logical design of database is called

• all of the options
• database schema
• database instance
• database snapshot

Which of the following is correct regarding Aggregate functions?

• it takes a single value and returns a single value as result
• it takes a list of values and return a single values as result
• it takes a list of values and return a list of values as result
• it takes a single value and returns a list of values as resul

which of the following is not an Aggregate function?

• select
• avg
• min
• max

A relation is considered a

• A) Column
• B ) One-dimensional table
• C ) Two-dimensional table
• D ) Three-dimensional table

Helping people keep track of things is the purpose of a(n) ________ .

• A ) Database
• B ) Table
• C ) Instance
• D ) Relationship