NEW
Font size
WorksheetsAdvanced Database Systems - Prelim Quiz
Total questions: 15
Worksheet time: 4hrs 45mins
An organized collection of structured information, or data, typically stored electronically in a computer system.
Database
DBMS
Database Application
It is a set of one (1) or more computer programs that serves as an intermediary between the user and the DBMS.
Database
Database Management System
Database Application
These are unsophisticated users who interact with the system by using predefined user interfaces, such as web or mobile applications.
Sophisticated users
Application programmers
Naive users
These arecomputer professionals who write application programs.
Naive users
Application programmers
Sophisticated users
Centralized database system supports data located at a single site.
True
False
A collection of multiple interconnected databases, spread physically across various locations.
Centralized database system
Distributed database system
Local Area Netword databases
A database that stores object rather than data as individual relations.
Structured data
Object-Oriented database
NewSQL
It incorporates and builds on the concepts and principles of SQL and NoSQL systems.
NewSQL
Object-Oriented database
XML
A combination of SQL along with the procedural features of programming languages.
T-SQL
XML
PL-SQL
It is an open-source SQL relational database management system that was developed and supported by Oracle.
MySQL
T-SQL
NoSQL
It specifies a temporary named result set.
Common Table Expression
Non-Recursive CTE
Recursive CTE
A type of CTE that doesn't use repeated procedural loops/recursion.
Common Table Expression
Non-Recursive CTE
Recursive CTE
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.
Common Table Expression
Non-Recursive CTE
Recursive CTE
A query (SELECT Statement) inside another query and expressed inside parentheses.
Structured Query Language
Subquerries
Correlated Subquerries
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.
Database
Database Management System
Database Application
