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