Quiz
Databases Topic 1 Quiz
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (16)
1What do the privileges associated with your role (the STUDENT role) allow you to do?
- ACreate tables
- BDrop tables
- CCreate triggers
- DAll of the above
2Foreign keys in the relational model make it possible to:
- AMaintain entity integrity
- BCreate unique records
- COpen the back door of the house when we have lost our primary key
- DCreate relationships between tables
3A database may contain __________.
- Atables.
- Bmetadata.
- Ctriggers.
- Dstored procedures.
- EAll of the above.
4You 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?
- ANUMBER(5)
- BNUMBER(5,2)
- CFLOAT(3,2)
- DNUMBER(3,2)
5The relational model __________.
- Awas first proposed in the late 1960's/early 1970's
- Bwas developed by E.F Codd
- Cwas developed at IBM
- Dresulted in the DBMS product, DB2
- EAll of the above.
6What is the main difference between the Oracle SQL data types VARCHAR2 and CHAR?
- ACHAR is variable in length
- BCHAR allows for numbers and text
- CVARCHAR2 is variable in length
- DVARCHAR2 has a maximum length of 255 characters
7Which of the following is NOT a property of a valid relation?
- AAll tuples must be unique – i.e., there must be an attribute or set of attributes that uniquely identifies each row
- BEach attribute in a relation has a distinct name
- CAttributes and tuples are not ordered
- DEach relation must contain data
8A null indicates:
- AA numeric value with value 0
- BThe absence of a value
- CA very small value
- DAn erroneous value
9In the relational database terminology, a table is synonymous with:
- AA relation
- BA row
- CAn attribute
- DA column
10In the relational database terminology, a tuple is synonymous with:
- AAn attribute
- BA column
- CA relation
- DA row
11Data models have the following features:
- AStructure, operators, constraints
- BEntity integrity, referential integrity, domain integrity
- CRelations, attributes, tuples
- DRelational algebra, relational calculus, SQL
12What SQL command would you execute in Oracle to show the structure of a table called Workshop?
- ADESCRIBE Workshop;
- BDEMONSTRATE Workshop;
- CSELECT * FROM Workshop;
- DSHOW Workshop;
13An unknown value is indicated by:
- AThe string of characters "null"
- BThe null "value"
- CThe value 0
- DThe string of characters "TBA"
14A 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?- A(StudentNumber)
- B(StudentNumber, UnitCode, Grade)
- C(StudentNumber, UnitCode, Year, Semester)
- D(StudentNumber, StudentName, UnitCode, Year, Semester, Grade, Mark)
15In the relational database terminology, an attribute is synonymous with:
- AA relation
- BA column
- CA table
- DA row
16Which of the following statements does NOT apply to relational databases?
- ARelational databases are simple to understand
- BRelational databases have a strong mathematical foundation
- CRelational databases have a strong procedural orientation
- DTables are one of the basic components of relational databases
Information
- Description
- Introduction to databases and Relational Model
- Author
- jaydeeees
- Language
- English
- Views
- 388
- Tags
- Rating
- No ratings yet Rate this quiz