REVATURE CERTIFICATION EVALUATION
TEST PAPER 2026 QUESTIONS AND
SOLUTIONS GRADED A+
●● relational database.
Answer: type of database; uses a structure that allows us to identify and
access data in relation to another piece of data in the database
●● records.
Answer: rows in the table (database)
●● columns in database table.
Answer: labeled with a descriptive name and have specific data type
●● RDBMX.
Answer: relational database management system; program that allows
you to create, update, and administer a relational database
●● SQL.
Answer: Structured Query Language; programming language used to
communicate with data stored in a RDBMS; syntax = similar to English
,●● WHY DO WE NEED SQL?.
Answer: -Allows users to access data in the RDBMS
-Allows users to describe the data
-Allows users to define the data in a database and manipulate that data
***Allows to embed within other languages using SQL modules,
libraries, and pre-compilers
-Allows users to create and drop databases and tables
-Allows users to create view, stored procedure, functions in a database
-Allows users to set permissions on tables, procedures, and views
●● Primary Key.
Answer: a field that uniquely identifies a record in a table;
-Table can only have 1 primary key-which can consist of single or
multiple fields (multiple fields used as primary key = composite key)
-if a table has a primary key defined on any field(s), then you cannot
have two records having the same value of that field(s)
●● Create Primary Key.
Answer: generally, the primary key is created while creating the
database and the table; can also be created after the creation of the table
,●● Foreign Key.
Answer: A primary key of one table that appears as an attribute in
another table and acts to provide a logical relationship between the two
tables; AKA referencing key
●● SQL Statements.
Answer: -DDL - Data Definition Language - CREATE, ALTER, DROP
-DML - Data Manipulation Language - SELECT, INSERT, UPDATE,
DELETE
-DCL - Data Control Language - GRANT, REVOKE
-TCL - Transaction Control Language - SAVEPOINT, ROLLBACK,
COMMIT
●● SQL SELECT.
Answer: Used to select data from a database and returns the data in the
form of a result table; result table = result-sets
●● SQL WHERE.
Answer: used to filter records and retrieve only the necessary data
, ●● SQL INSERT INTO.
Answer: used to add new rows of data to a table in the database
●● SQL Joins.
Answer: Used to combine rows from two or more tables, based on a
common field between them
●● Different Types of Joins.
Answer: -INNER JOIN
-LEFT JOIN
-RIGHT JOIN
-FULL JOIN
●● Program Structure (C#).
Answer: -Namespace declaration
-A class
-Class methods
-Class attributes
-A Main method
-Statements and Expressions
-Comments
TEST PAPER 2026 QUESTIONS AND
SOLUTIONS GRADED A+
●● relational database.
Answer: type of database; uses a structure that allows us to identify and
access data in relation to another piece of data in the database
●● records.
Answer: rows in the table (database)
●● columns in database table.
Answer: labeled with a descriptive name and have specific data type
●● RDBMX.
Answer: relational database management system; program that allows
you to create, update, and administer a relational database
●● SQL.
Answer: Structured Query Language; programming language used to
communicate with data stored in a RDBMS; syntax = similar to English
,●● WHY DO WE NEED SQL?.
Answer: -Allows users to access data in the RDBMS
-Allows users to describe the data
-Allows users to define the data in a database and manipulate that data
***Allows to embed within other languages using SQL modules,
libraries, and pre-compilers
-Allows users to create and drop databases and tables
-Allows users to create view, stored procedure, functions in a database
-Allows users to set permissions on tables, procedures, and views
●● Primary Key.
Answer: a field that uniquely identifies a record in a table;
-Table can only have 1 primary key-which can consist of single or
multiple fields (multiple fields used as primary key = composite key)
-if a table has a primary key defined on any field(s), then you cannot
have two records having the same value of that field(s)
●● Create Primary Key.
Answer: generally, the primary key is created while creating the
database and the table; can also be created after the creation of the table
,●● Foreign Key.
Answer: A primary key of one table that appears as an attribute in
another table and acts to provide a logical relationship between the two
tables; AKA referencing key
●● SQL Statements.
Answer: -DDL - Data Definition Language - CREATE, ALTER, DROP
-DML - Data Manipulation Language - SELECT, INSERT, UPDATE,
DELETE
-DCL - Data Control Language - GRANT, REVOKE
-TCL - Transaction Control Language - SAVEPOINT, ROLLBACK,
COMMIT
●● SQL SELECT.
Answer: Used to select data from a database and returns the data in the
form of a result table; result table = result-sets
●● SQL WHERE.
Answer: used to filter records and retrieve only the necessary data
, ●● SQL INSERT INTO.
Answer: used to add new rows of data to a table in the database
●● SQL Joins.
Answer: Used to combine rows from two or more tables, based on a
common field between them
●● Different Types of Joins.
Answer: -INNER JOIN
-LEFT JOIN
-RIGHT JOIN
-FULL JOIN
●● Program Structure (C#).
Answer: -Namespace declaration
-A class
-Class methods
-Class attributes
-A Main method
-Statements and Expressions
-Comments
