Databases Topic 1 Quiz

Beschreibung

Introduction to databases and Relational Model
jaydeeees
Quiz von jaydeeees, aktualisiert more than 1 year ago
jaydeeees
Erstellt von jaydeeees vor fast 10 Jahre
373
0
1 2 3 4 5 (0)

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
A null indicates:
Antworten
  • A numeric value with value 0
  • The absence of a value
  • A very small value
  • An erroneous value

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:
Antworten
  • The string of characters "null"
  • The null "value"
  • The value 0
  • The string of characters "TBA"

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
Zusammenfassung anzeigen Zusammenfassung ausblenden

0 Kommentare

There are no comments, be the first and leave one below:

ähnlicher Inhalt

OCR gcse computer science
Jodie Awthinre
GCSE AQA Computer Science - Definitions
James Jolliffe
Managing Digital Data Review
Shannon Anderson-Rush
Midterm 2 (Chapter 5 - 13)
Yorria Raine
SQL Quiz
Chris Cronin
GCSE AQA Computer Science - Definitions
moffat00
Database Final Exam
dbm
Data, Information and Databases
maryamxjay
AS Levels ICT -Form Controls
lukejones