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.
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