wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Advanced Database Systems - Prelim Quiz

Total questions: 15

Worksheet time: 4hrs 45mins

Name
Class
Date
1.

An organized collection of structured information, or data, typically stored electronically in a computer system.

a)

Database

b)

DBMS

c)

Database Application

2.

It is a set of one (1) or more computer programs that serves as an intermediary between the user and the DBMS.

a)

Database

b)

Database Management System

c)

Database Application

3.

These are unsophisticated users who interact with the system by using predefined user interfaces, such as web or mobile applications.

a)

Sophisticated users

b)

Application programmers

c)

Naive users

4.

These arecomputer professionals who write application programs.

a)

Naive users

b)

Application programmers

c)

Sophisticated users

5.

Centralized database system supports data located at a single site.

a)

True

b)

False

6.

A collection of multiple interconnected databases, spread physically across various locations.

a)

Centralized database system

b)

Distributed database system

c)

Local Area Netword databases

7.

A database that stores object rather than data as individual relations.

a)

Structured data

b)

Object-Oriented database

c)

NewSQL

8.

It incorporates and builds on the concepts and principles of SQL and NoSQL systems.

a)

NewSQL

b)

Object-Oriented database

c)

XML

9.

A combination of SQL along with the procedural features of programming languages.

a)

T-SQL

b)

XML

c)

PL-SQL

10.

It is an open-source SQL relational database management system that was developed and supported by Oracle.

a)

MySQL

b)

T-SQL

c)

NoSQL

11.

It specifies a temporary named result set.

a)

Common Table Expression

b)

Non-Recursive CTE

c)

Recursive CTE

12.

A type of CTE that doesn't use repeated procedural loops/recursion.

a)

Common Table Expression

b)

Non-Recursive CTE

c)

Recursive CTE

13.

A type of CTE that uses recursion and useful when working with hierarchical data because the CTE continues to execute until the query returns the entire hierarchy.

a)

Common Table Expression

b)

Non-Recursive CTE

c)

Recursive CTE

14.

A query (SELECT Statement) inside another query and expressed inside parentheses.

a)

Structured Query Language

b)

Subquerries

c)

Correlated Subquerries

15.

This serves as an interface between the database and its end-users or programs, allowing users to retrieve, update, and manage how the information is organized and optimized.

a)

Database

b)

Database Management System

c)

Database Application