Quiz
Databases Topic 1 Quiz
Erstelle ein kostenloses Konto, um dieses Quiz zu beenden
Speichere deinen Fortschritt und sieh dir dein Endergebnis an.
oder mit deiner E-Mail registrieren
Schon ein Konto? Anmelden
Fragen in diesem 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
Informationen
- Beschreibung
- Introduction to databases and Relational Model
- Autor
- jaydeeees
- Sprache
- English
- Aufrufe
- 387
- Schlagwörter
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz