Home Library Explore SAT

Home Library Explore SAT

Repetitorium DBS I Flashcards | StudBud

Explore/Repetitorium DBS I

Repetitorium DBS I

10 terms·StudBud Administration·99 plays

Questions based on Helland, P (2016) The Singular Success of SQL, Communications of the ACM 59(8) 38-41.

Flashcards10 cardsFPractice quizPHost liveL

Questions 10

Answers

1
What is CODASYL?
A database architecture
A drug
A database model
A standards committee
2
Which of these belongs to the data definition (DD) aspect of SQL?
CREATE TABLE
Functions (e.g. COUNT)
INSERT INTO
Queries (e.g. SELECT)
3
What's remarkable about SQL?
Its impact on the database industry
Its complexity
Its capability to handle Big Data
Its community support
4
What is the strength of SQL?
Hierarchical server scaling
Transactional Serializability
Dealing with unstructured data
A well defined schema
5
SQL metadata is defined before the query is issued.
True
False
6
Which of these is NOT a basic element of SQL?
Table
Event
Function
Schema
7
What happened to databases in the early 2000s?
The Millennium bug (Y2K)
New data representations (e.g. XML)
Wikipedia (web application)
Google Search (page rank algorithm)
8
What kind of programming language is SQL?
Compiled
Object-oriented
List-based
Declarative
9
Which mathematical theory is the basis of SQL operations?
Linear Algebra
Graph theory
Relational Algebra
Set theory
10
When was Jimmy Carter US president?
Between Bill Clinton and George W Bush
1980-1988
He was not a US president
Before Ronald Reagan