jaydeeees
Quiz by , created more than 1 year ago

Introduction to databases and Relational Model

361
0
0
jaydeeees
Created by jaydeeees over 9 years ago
Close

Databases Topic 1 Quiz

Databases Topic 1 Quiz

Question 1 of 16

1

What do the privileges associated with your role (the STUDENT role) allow you to do?

Select one of the following:

  • Create tables

  • Drop tables

  • Create triggers

  • All of the above

Explanation

Question 2 of 16

1

Foreign keys in the relational model make it possible to:

Select one of the following:

  • Maintain entity integrity

  • Create unique records

  • Open the back door of the house when we have lost our primary key

  • Create relationships between tables

Explanation

Question 3 of 16

1

A database may contain __________.

Select one of the following:

  • tables.

  • metadata.

  • triggers.

  • stored procedures.

  • All of the above.

Explanation

Question 4 of 16

1

You need to create a column in a table that will store numbers in the form nnn.xx (e.g., 145.67) What data type is this?

Select one of the following:

  • NUMBER(5)

  • NUMBER(5,2)

  • FLOAT(3,2)

  • NUMBER(3,2)

Explanation

Question 5 of 16

1

The relational model __________.

Select one of the following:

  • was first proposed in the late 1960's/early 1970's

  • was developed by E.F Codd

  • was developed at IBM

  • resulted in the DBMS product, DB2

  • All of the above.

Explanation

Question 6 of 16

1

What is the main difference between the Oracle SQL data types VARCHAR2 and CHAR?

Select one of the following:

  • CHAR is variable in length

  • CHAR allows for numbers and text

  • VARCHAR2 is variable in length

  • VARCHAR2 has a maximum length of 255 characters

Explanation

Question 7 of 16

1

Which of the following is NOT a property of a valid relation?

Select one of the following:

  • All tuples must be unique – i.e., there must be an attribute or set of attributes that uniquely identifies each row

  • Each attribute in a relation has a distinct name

  • Attributes and tuples are not ordered

  • Each relation must contain data

Explanation

Question 8 of 16

1

A null indicates:

Select one of the following:

  • A numeric value with value 0

  • The absence of a value

  • A very small value

  • An erroneous value

Explanation

Question 9 of 16

1

In the relational database terminology, a table is synonymous with:

Select one of the following:

  • A relation

  • A row

  • An attribute

  • A column

Explanation

Question 10 of 16

1

In the relational database terminology, a tuple is synonymous with:

Select one of the following:

  • An attribute

  • A column

  • A relation

  • A row

Explanation

Question 11 of 16

1

Data models have the following features:

Select one of the following:

  • Structure, operators, constraints

  • Entity integrity, referential integrity, domain integrity

  • Relations, attributes, tuples

  • Relational algebra, relational calculus, SQL

Explanation

Question 12 of 16

1

What SQL command would you execute in Oracle to show the structure of a table called Workshop?

Select one of the following:

  • DESCRIBE Workshop;

  • DEMONSTRATE Workshop;

  • SELECT * FROM Workshop;

  • SHOW Workshop;

Explanation

Question 13 of 16

1

An unknown value is indicated by:

Select one of the following:

  • The string of characters "null"

  • The null "value"

  • The value 0

  • The string of characters "TBA"

Explanation

Question 14 of 16

1

A relation that contains data recording Murdoch students' performance in units, has the following attributes:
(StudentNumber, StudentName, UnitCode, Year, Semester, Grade, Mark).

What would be an appropriate primary key for this relation?

Select one of the following:

  • (StudentNumber)

  • (StudentNumber, UnitCode, Grade)

  • (StudentNumber, UnitCode, Year, Semester)

  • (StudentNumber, StudentName, UnitCode, Year, Semester, Grade, Mark)

Explanation

Question 15 of 16

1

In the relational database terminology, an attribute is synonymous with:

Select one of the following:

  • A relation

  • A column

  • A table

  • A row

Explanation

Question 16 of 16

1

Which of the following statements does NOT apply to relational databases?

Select one of the following:

  • Relational databases are simple to understand

  • Relational databases have a strong mathematical foundation

  • Relational databases have a strong procedural orientation

  • Tables are one of the basic components of relational databases

Explanation

Previous
Next