Questão 1
Questão
What do the privileges associated with your role (the STUDENT role) allow you to do?
Responda
-
Create tables
-
Drop tables
-
Create triggers
-
All of the above
Questão 2
Questão
Foreign keys in the relational model make it possible to:
Responda
-
Maintain entity integrity
-
Create unique records
-
Open the back door of the house when we have lost our primary key
-
Create relationships between tables
Questão 3
Questão
A database may contain __________.
Responda
-
tables.
-
metadata.
-
triggers.
-
stored procedures.
-
All of the above.
Questão 4
Questão
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?
Responda
-
NUMBER(5)
-
NUMBER(5,2)
-
FLOAT(3,2)
-
NUMBER(3,2)
Questão 5
Questão
The relational model __________.
Responda
-
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.
Questão 6
Questão
What is the main difference between the Oracle SQL data types VARCHAR2 and CHAR?
Responda
-
CHAR is variable in length
-
CHAR allows for numbers and text
-
VARCHAR2 is variable in length
-
VARCHAR2 has a maximum length of 255 characters
Questão 7
Questão
Which of the following is NOT a property of a valid relation?
Responda
-
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
Questão 8
Questão
A null indicates:
Questão 9
Questão
In the relational database terminology, a table is synonymous with:
Responda
-
A relation
-
A row
-
An attribute
-
A column
Questão 10
Questão
In the relational database terminology, a tuple is synonymous with:
Responda
-
An attribute
-
A column
-
A relation
-
A row
Questão 11
Questão
Data models have the following features:
Responda
-
Structure, operators, constraints
-
Entity integrity, referential integrity, domain integrity
-
Relations, attributes, tuples
-
Relational algebra, relational calculus, SQL
Questão 12
Questão
What SQL command would you execute in Oracle to show the structure of a table called Workshop?
Responda
-
DESCRIBE Workshop;
-
DEMONSTRATE Workshop;
-
SELECT * FROM Workshop;
-
SHOW Workshop;
Questão 13
Questão
An unknown value is indicated by:
Questão 14
Questão
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?
Responda
-
(StudentNumber)
-
(StudentNumber, UnitCode, Grade)
-
(StudentNumber, UnitCode, Year, Semester)
-
(StudentNumber, StudentName, UnitCode, Year, Semester, Grade, Mark)
Questão 15
Questão
In the relational database terminology, an attribute is synonymous with:
Responda
-
A relation
-
A column
-
A table
-
A row
Questão 16
Questão
Which of the following statements does NOT apply to relational databases?
Responda
-
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