ADET Prelim Exam

In an ERD, a rectangle usually represents:

• Attribute

• Relationship

• Entity

• Primary Key

A primary key must be:

• nullable

• repeated

• foreign key

• unique and not null

Which of the following best describes a foreign key?

• A key that identifies a record uniquely within its own table

• A key that refers to a primary key in another table

• A key that has no constraints

• A key that can be duplicated freely

A one-to-many relationship in ERD means:

• One entity is linked to one entity only

• One entity is linked to multiple entities

• Many entities are linked to one entity only

• Many entities are linked to many entities

Which is NOT a component of ERD?

• Entities

• Attributes

• Relationships

• Stored Procedures

A weak entity in ERD is:

• An entity without relationships

• An entity dependent on another entity

• An entity with multiple primary keys

• An entity without attributes

SQL stands for:

• Structured Quick Language

• Server Query Language

• Structured Query Language

• Simple Query Language

Which command is used to display database tables?

• SHOW USERS;

• LIST TABLES;

• SHOW TABLES;

• SELECT TABLES;

Which SQL clause is used to filter results?

• FROM

• ORDER BY

• WHERE

• GROUP BY

Which operator is used to combine conditions in SQL?

• =

• LIKE

• AND | OR

• IN