NEW
Font size
WorksheetsRDBMS WITH PL/SQL Unit 1 Objective Test
Total questions: 25
Worksheet time: 19mins
What is the primary purpose of a database system?
To ensure data is always encrypted and secure.
To store, manage, and retrieve data efficiently.
To create and design user interfaces.
To analyze and visualize data trends.
Storing the same data in multiple places unnecessarily is known as _____________
Data Isolation
Data Integrity
Data Redundancy
Data Security
What are the main types of database languages?
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
All of them
Define the term 'database design'.
Database design is the process of defining the structure and organization of data in a database.
Database design is the technique of managing server hardware and software configurations.
Database design refers to the process of writing SQL queries for data retrieval.
Database design is the method of creating user interfaces for applications.
The Relational Algebra expression (R - S), where R and S are two relations with the same schema, will produce a relation containing
All tuples (rows) that appear in R or in S
Only the common tuples (rows) that appear in both R and S
All tuples (rows) that appear in S but not in R
All tuples (rows) that appear in R but not in S
The property that ensures a change (like a money transfer) either happens completely or not at all is called ____.
Isolation
Consistency
Durability
Atomicity
Who are the typical users of a database system?
Web designers, content creators, software testers, and IT support staff.
Network engineers, system architects, project managers, and data scientists.
Database administrators, application developers, data analysts, and naive users.
Business analysts, marketing specialists, hardware engineers, and system operators.
What is the relational model in databases?
The relational model stores data in unstructured formats like JSON and XML.
The relational model focuses on hierarchical data organization without tables.
The relational model organizes data into tables (relations) with defined relationships, enabling efficient data management and retrieval.
The relational model uses graphs to represent data connections and relationships.
Which language is used for accessing and updating the data in the database (e.g., inserting, selecting, deleting)?
DDL
DCL
TCL
DML
The overall logical structure or design of the database is called the ____________
Instance
Schema
Model
Relation
What are keys in a database schema?
Keys in a database schema are random values that can be duplicated across records.
Keys in a database schema are optional attributes that enhance data retrieval.
Keys in a database schema are visual representations of data relationships.
Keys in a database schema are attributes that uniquely identify records and establish relationships between tables.
The actual content of the database at a particular moment in time is called the _____
Instance
Schema
model
Definition
The ability to modify the physical storage structure without changing the logical schema is known as _____
Data Isolation
Physical Data Independence
Data Integrity
Atomicity
Which DBMS component is responsible for handling concurrent accesses to ensure data consistency?
Storage Manager
Query Processor
Interpreter
Transaction Manager
What is the difference between a primary key and a foreign key?
A primary key uniquely identifies records; a foreign key links records between tables.
A primary key is used for indexing; a foreign key is used for sorting.
A primary key is a type of foreign key; a foreign key is a unique identifier.
A primary key can be null; a foreign key cannot be null.
A user who interacts with the database using the application program interface, such as a data-entry screen or a mobile application, without needing to know the complexities of the system is classified as a _________
Naive User
System Analyst
Specialized User
Database Administrator
What is a column in a relation (table) formally known as?
Tuple
Attribute
Relation
Instance
Which key is chosen by the database designer to be the main unique identifier for a table?
Foreign Key
Minimal Key
Unique Key
Primary Key
A field in one table that references the primary key of another table is a _______
Foreign Key
Candidate Key
Relational Key
Superkey
How many basic operators constitute the Relational Algebra?
2
4
6
10
What is the purpose of indexing in a database?
Indexing helps in speeding up data retrieval operations by providing quick access to rows in a table.
Indexing is primarily for organizing data into multiple tables.
Indexing is a method for encrypting sensitive data in the database.
Indexing is used to create backups of the database.
What is a stored procedure in database management?
A stored procedure is a method for importing data from external sources.
A stored procedure is a set of SQL statements that can be stored and executed on the database server.
A stored procedure is a type of database backup method.
A stored procedure is a graphical tool for designing database schemas.
The Project operation (Π) in Relational Algebra is used to choose _______
Only certain rows
The entire table
Only certain attributes
Only the attributes that are keys
The Union (U) operation can only be applied to two relations if they have the same ___________
Name
Primary key
Number of rows
Schema (same number and types of attributes)
Which type of DDL command is used to add new attributes (columns) to an existing table?
ALTER
INSERT
UPDATE
SELECT
