Database Systems 2025/2026 Exam
Questions and Correct Answers | New
Update
For each employee, retrieve the employee's first and last name and the first and last
name of the his or her immediate supervisor. - 🧠 ANSWER ✔✔SELECT e.fname,
f.lname, s.fname, s.lname
FROM employee AS e , employee AS s
WHERE e.super_ssn = s.ssn
CRUD - 🧠 ANSWER ✔✔Create, Retrieve, Update, Delete
Metadata - 🧠 ANSWER ✔✔data that describes other data
data independence - 🧠 ANSWER ✔✔A condition in which data access is
unaffected by changes in the physical data storage characteristics.
,Data Abstraction - 🧠 ANSWER ✔✔The separation of the logical view of data from
its implementation
data model - 🧠 ANSWER ✔✔a diagram that represents entities in the database and
their relationships
multiple views - 🧠 ANSWER ✔✔Apps support multiple views
concurrent users - 🧠 ANSWER ✔✔All users can access the database at the same
time
OLTP (online transaction processing) - 🧠 ANSWER ✔✔Database design used for
browsing and manipulating business transaction activity
database administrator - 🧠 ANSWER ✔✔the person responsible for coordinating,
controlling, and managing the database
Schema - 🧠 ANSWER ✔✔a concept or framework that organizes and interprets
information
show databases; - 🧠 ANSWER ✔✔show all databases
use <database name> - 🧠 ANSWER ✔✔changes the database on which you are
working.
, show tables - 🧠 ANSWER ✔✔The SQL command to list all the tables in the
database
describe <table name> - 🧠 ANSWER ✔✔shows table structure
Select * from <database name> - 🧠 ANSWER ✔✔Shows all rows
CREATE DATABASE <name of database> - 🧠 ANSWER ✔✔The SQL command
to create a database
Create table <table name> - 🧠 ANSWER ✔✔Creates a table
name - data type - null or not null - Primary key - 🧠 ANSWER ✔✔Table format
UNIQUE - 🧠 ANSWER ✔✔(adj.) one of a kind; unequaled; unusual; found only in
a given class, place, or situation
Alter table <database name> add( ) - 🧠 ANSWER ✔✔Alter table
drop <database name> <table name> - 🧠 ANSWER ✔✔delete a table
Select <name> as <other name> from table - 🧠 ANSWER ✔✔Changes name
!= - 🧠 ANSWER ✔✔not equal
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
3
Questions and Correct Answers | New
Update
For each employee, retrieve the employee's first and last name and the first and last
name of the his or her immediate supervisor. - 🧠 ANSWER ✔✔SELECT e.fname,
f.lname, s.fname, s.lname
FROM employee AS e , employee AS s
WHERE e.super_ssn = s.ssn
CRUD - 🧠 ANSWER ✔✔Create, Retrieve, Update, Delete
Metadata - 🧠 ANSWER ✔✔data that describes other data
data independence - 🧠 ANSWER ✔✔A condition in which data access is
unaffected by changes in the physical data storage characteristics.
,Data Abstraction - 🧠 ANSWER ✔✔The separation of the logical view of data from
its implementation
data model - 🧠 ANSWER ✔✔a diagram that represents entities in the database and
their relationships
multiple views - 🧠 ANSWER ✔✔Apps support multiple views
concurrent users - 🧠 ANSWER ✔✔All users can access the database at the same
time
OLTP (online transaction processing) - 🧠 ANSWER ✔✔Database design used for
browsing and manipulating business transaction activity
database administrator - 🧠 ANSWER ✔✔the person responsible for coordinating,
controlling, and managing the database
Schema - 🧠 ANSWER ✔✔a concept or framework that organizes and interprets
information
show databases; - 🧠 ANSWER ✔✔show all databases
use <database name> - 🧠 ANSWER ✔✔changes the database on which you are
working.
, show tables - 🧠 ANSWER ✔✔The SQL command to list all the tables in the
database
describe <table name> - 🧠 ANSWER ✔✔shows table structure
Select * from <database name> - 🧠 ANSWER ✔✔Shows all rows
CREATE DATABASE <name of database> - 🧠 ANSWER ✔✔The SQL command
to create a database
Create table <table name> - 🧠 ANSWER ✔✔Creates a table
name - data type - null or not null - Primary key - 🧠 ANSWER ✔✔Table format
UNIQUE - 🧠 ANSWER ✔✔(adj.) one of a kind; unequaled; unusual; found only in
a given class, place, or situation
Alter table <database name> add( ) - 🧠 ANSWER ✔✔Alter table
drop <database name> <table name> - 🧠 ANSWER ✔✔delete a table
Select <name> as <other name> from table - 🧠 ANSWER ✔✔Changes name
!= - 🧠 ANSWER ✔✔not equal
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
3
