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