SQL Quiz 1

In relational databases, the key which are considered as type of reference attribute is classified as

• foreign keys

• floating keys

• composite keys

• string keys

Considering the relationships, the possible cardinality ratios are

• 1 : N

• 1 : 1

• all presented answers

• M : N

Types of DBMS:

• batch, distributed, multitasking, network

• hierarchical, network, relational, object-oriented

• multipartite, overwrite, direct

• adventure, role-playing, simulation, strategy

• personal, network, local, wireless, metropolitan

The command used in SQL to specify new relation, its initial constraints and attributes is classified as

• CREATE CATALOG

• CREATE SCHEMAS

• CREATE

• CREATE IDENTIFIER

• CREATE TABLE

The graphical representation of database description is called

• structure diagram

• schema diagram

• dynamic schema diagram

• entity path diagram

To add new column to a table, you use…

• create

• alter

• update

• insert

• truncate

Why do we use ER diagrams?

• controls the interaction between people and machines

• helps on the network to share the resources and in communication

• manages the computer's memory and processes

• helps to describe entities, attributes, relationships

• controls a cursor in a GUI

The following action the ON DELETE automatically deletes all the referencing rows in the child table when the referenced rows in the parent table are deleted.

• cascade

• restrict

• set null

• no action

• set default

Advantages of OODB:

• Values are Atomic, Sequence of Rows is Insignificant

• Lack of standards, Organizational Disunity and Rigid structure, Poor flexibility

• High performance, Efficient with 1: N relationships, Increases specialization

• Reusability, Complex data types, Distributed databases

• fast data access, complex queries

Mandatory is denoted with…

• open circle

• perpendicular straight line

• ellipse

• square

• rectangle