Databases CIT

Question 1

Application Server

Answer 1

A server that processes application-specific database operations made from
application client programs. The DBMS is in-process with the application code for
very fast internal access.

Question 2

BLOB

Answer 2

An abbreviation for Binary Large OBject. In SQL, BLOB can be a general term for
any data of type long varchar.

Question 3

RDMS Client/Server

Answer 3

A server is a program that runs on a computer that directly manages the database.
A client is a separate program (or process) that communicates with the database
server through some kind of Remote Procedure Call (RPC) in order to perform
application-specific database operations.

Question 4

Column

Answer 4

A single unit of named data that has a particular data type to a column

Question 5

Commit

Answer 5

The action that causes all of the changes made by a particular transaction to be
reliably written to the database files and made visible to other users.

Question 6

Data Type

Answer 6

The basic kind of data that can be stored in a column. Examples of data types that
are available in RDM SQL are: char, varchar, binary, boolean, tinyint, integer,
double, date.

Question 7

Embedded Database

Answer 7

An embedded database is the combination of a database and the database
software which typically resides within an application.

Question 8

Foreign Key

Answer 8

One or more columns in a table intended to contain only values that match the
related primary/unique key column(s) in the referenced table. Foreign and primary
keys explicitly define the direct relationships between tables.

Question 9

Index

Answer 9

A separate structure that allows fast access to a table’s rows based on the data
values of the columns used in the index

Question 10

JDBC

Answer 10

Java Database Connectivity API. JDBC provides a standard database access and
manipulations API for Java programs.

Question 11

Natural Join

Answer 11

A join formed between two tables where the values of identically named and
defined columns are equal.

Question 12

Outer Join

Answer 12

A join formed between two tables that in addition to including the rows from the
two tables with matching join column values will also include the values from one
table that do not have matching rows in the other.

Question 13

Primary Key

Answer 13

A column or group of columns in a given table that uniquely identifies each row of
the table.

Question 14

Query

Answer 14

A complete SELECT statement that specifies
1. the columns and tables from which data is to be retrieved;
2. optionally, conditions that the data must satisfy;
3. optionally, computations that are to be performed on the retrieved column
values; and
4. optionally, a desired ordering of the result set.

Question 15

Referential Integrity

Answer 15

A condition in which the foreign key column values in all of the rows in one table
have matching rows in the referenced primary key table. Referential integrity is
maintained by SQL during the processing of an INSERT and DELETE statement
and any UPDATE statement that modifies a foreign or primary key value.

Question 16

Relational Model

Answer 16

A database in which inter-table relationships are organized primarily
through common data columns, which define a one-to-many relationship between
a row of the primary key table and one or more rows of the matching foreign key
table.

Question 17

Result Set

Answer 17

The complete set of rows that is returned by a particular SELECT statement.

Question 18

Rollback

Answer 18

An operation, usually performed by the SQL ROLLBACK statement, that discards
all of the changes made by all INSERT, UPDATE and DELETE statements that
have been executed since the most recently started transaction (e.g., START
TRANSACTION statement).

Question 19

SQL

Answer 19

The standardized and commonly accepted language used for defining, querying
and manipulating a relational database.

Question 20

Stored Procedure

Answer 20

A named and optionally parametrised compiled set of SQL database access
statements that can be executed as a unit through a call to the stored procedure.

Question 21

Attribute

Answer 21

A table consists of several record/s(row/s), each record can be broken down into
several smaller parts of data known as Attributes.

Question 22

Tuple

Answer 22

A single entry in a table is called a Tuple or Record or Row. A tuple in a table
represents a set of related data.