SQL: Queries, Constraints and Triggers

The MCQ-format quiz focuses on different sets of SQL basics, set and null value operations, modifications, views and transactions, different types of integrity constraints, joins, nested subqueries and aggregate functions, schemas and data types, triggers, processes and procedures, different queries and aggregation features.

Start Quiz

An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has a “Reed” value. Here, attribute A has __ spaces, and attribute B has __ spaces.

3, 20

20, 4

20, 20

3, 4

The basic data type char(n) is __ length character string and varchar(n) is __ length character.

a Fixed, an Equal

an Equal, a variable

a Fixed, a Variable

a Variable, an Equal

Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?

DML (Data Manipulation Language)

DDL (Data Definition Language)

Query

Relational Schema

Which one of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

DML (Data Manipulation Language)

DDL (Data Definition Language)

Query

Relational Schema

To remove a relation from an SQL database, we use the __ command.

Delete

Purge

Remove

Drop table

Which of the following products was the first to implement true relational algebra in a PC DBMS?

IDMS

Oracle

dBase-II

R:base

An example of __ is an application where only one user accesses the database at a given time.

A single-user database application

A multi-user database application

An e-commerce database application

A data mining database application

The DBMS acts as an interface between which components of an enterprise-class database system?

Database application and the database

Data and the database

The user and the database application

Database application and SQL

One commercial example of a DBMS combining DBMS with an application generator is __.

Microsoft's SQL Server

Microsoft's Access

IBM's DB2

Oracle Corporation's Oracle

Because it contains a description of its structure, a database is considered __.

Described

Metadata-compatible

Self-describing

An application program

A database has both data and relationships. True or false?

True

False

In a database, data is stored in spreadsheets with rows and columns. True or false?

True

False

One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete. True or false?

True

False

The DBMS that is most difficult to use is __.

Microsoft's SQL Server

Microsoft's Access

IBM's DB2

Oracle Corporation's Oracle

A database is called “self-describing” because it contains its description. True or false?

True

False

Quiz/Test Summary
Title: SQL: Queries, Constraints and Triggers
Questions: 15
Contributed by:
Ivan