Data Relational Model | 512 plays

1.

Multiple Choice

30 sec

1 pt

In relational data model, the total number of rows can be identified as ______________________ .

Cardinality

Degree

Attribute

Entity

2.

Multiple Choice

30 sec

1 pt

Identify the total number of attributes in a relational data model.

Tuple

Entity

Degree

Cardinality

3.

Multiple Choice

30 sec

1 pt

Identify the candidate key.

W

X

Y

Z

4.

Multiple Choice

30 sec

1 pt

An attribute whose value is calculated (derived) from other attributes. Choose the correct attributes based on the information given.

Registration Number

IC Number

Certificates

Date of Birth

5.

Multiple Choice

30 sec

1 pt

If related data exists in more than one table, they can be joined by using the Primary Key link to the same key in the other table. Identify this key.

Foreign Key

Primary Key

Candidate Key

Composite Key

6.

Multiple Choice

30 sec

1 pt

In relational data model, the total number of attributes can be identified as ______________________ .

Cardinality

Degree

Tuple

Entity

7.

Multiple Choice

30 sec

1 pt

Choose the CORRECT symbol of SELECT in the Relational Algebra

x

$\pi$

$\cap$

$\sigma$

8.

Multiple Choice

30 sec

1 pt

Based on the figure above, identify the number of tuples that will be returned by the following relational algebra query : $\sigma\$ Type = 'Saving' (Account)

2

3

6

0

9.

Multiple Choice

30 sec

1 pt

Base on the table given, identify output that will be produced when, σ _{Salary > 3000 ˅ City = ‘Batu Pahat’} (WORKER).

10.

Multiple Choice

30 sec

1 pt

What is data types?

It specifies what type of data is expected inside of each column in a table (ef. number, date, string)

It specifies how many tables you will create when you convert your Entity Relations Model to a Logical Data Model

It specifies the database-name

It counts how many attributes you have

11.

Multiple Choice

30 sec

1 pt

What does the data-type INT contain

Whole numbers

Decimal numbers

Characters

Date

12.

Multiple Choice

30 sec

1 pt

A row in a database.

Record

Field

Entity

Table

13.

Multiple Choice

30 sec

1 pt

A column in a database.

Field

Record

Entity

Validation

14.

Multiple Choice

30 sec

1 pt

Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...

Data Types

Filters

Sorts

Validations

15.

Multiple Choice

30 sec

1 pt

A unique identifying field.

Primary Key

Integer

Verification

Boolean

16.

Multiple Choice

30 sec

1 pt

What language does the Relational Model use?

Java

Python

SQL

C++

17.

Multiple Choice

30 sec

1 pt

What is SQL?

Structured Query Language

Suitable Query Language

Sustainable Question Language

Suitable Question Language

18.

Multiple Choice

30 sec

1 pt

Example of an SQL Command?

REMOVE

SELECT

BIN

NUMBER

19.

Multiple Choice

30 sec

1 pt

How many records are in this database?

8

5

10

12

20.

Multiple Choice

30 sec

1 pt

What is the primary key in this database?

Emp_Id

Last Name

Gender

Title