D664 OBJECTIVE ASSESSMENT EXAM TEST
PAPER 2026 COMPLETE QUESTIONS AND
SOLUTIONS 100% CORRECT
◉ SMALLINT. Answer: 2 bytes
◉ BIGINT. Answer: 8 bytes
◉ TINYINT. Answer: 1 byte
◉ MEDIUMINT. Answer: 3 bytes
◉ % (Modulo). Answer: Divides one numeric value by another and
returns the integer remainder
◉ ^. Answer: Raises one numeric value to the power of another.
◉ =. Answer: Compares two values for equality.
◉ !=. Answer: Compares two values for inequality.
,◉ NULL. Answer: A special value that represents either unknown or
inapplicable data.
◉ INSERT Statement (Clauses). Answer: INTO clause names the
table and columns where data is to be added. The keyword INTO is
optional.
VALUES clause specifies the column values to be added.
◉ INSERT Statement (Syntax). Answer: INSERT [INTO] TableName
(Column1, Column2, ...)VALUES (Value1, Value2, ...);
◉ UPDATE Statement (Clauses). Answer: Uses the SET clause to
specify the new column values.
An optional WHERE clause specifies which rows are updated.
Omitting the WHERE clause results in all rows being updated.
◉ DELETE Statement (Keywords/Clauses). Answer: The FROM
keyword is followed by the table name whose rows are to be deleted.
An optional WHERE clause specifies which rows should be deleted.
Omitting the WHERE clause results in all rows in the table being
deleted.
◉ TRUNCATE Statement. Answer: Deletes all rows from a table.
, ◉ Primary Key. Answer: A _______ ___ is a constraint on a column, or
group of columns, used to identify a row. The ________ ____ is usually
the table's first column and appears on the left of table diagrams, but
the position is not significant to the database. A solid circle (●)
notates these in table diagrams.
MUST BE "Unique" and "Not NULL"
◉ Simple Primary Key. Answer: A key that consists of a SINGLE
column.
◉ Composite Key. Answer: A key that consists of multiple columns
and is denoted with parenthesis.
MUST BE Minimal, meaning only NECESSARY primary keys may be
involved. In it's minimal stage, if one of these keys is removed it then
becomes no longer unique.
◉ Auto-Increment. Answer: Database users occasionally make the
following errors when inserting primary keys:
Inserting values for auto-increment primary keys.
Omitting values for primary keys that are not auto-increment
columns.
PAPER 2026 COMPLETE QUESTIONS AND
SOLUTIONS 100% CORRECT
◉ SMALLINT. Answer: 2 bytes
◉ BIGINT. Answer: 8 bytes
◉ TINYINT. Answer: 1 byte
◉ MEDIUMINT. Answer: 3 bytes
◉ % (Modulo). Answer: Divides one numeric value by another and
returns the integer remainder
◉ ^. Answer: Raises one numeric value to the power of another.
◉ =. Answer: Compares two values for equality.
◉ !=. Answer: Compares two values for inequality.
,◉ NULL. Answer: A special value that represents either unknown or
inapplicable data.
◉ INSERT Statement (Clauses). Answer: INTO clause names the
table and columns where data is to be added. The keyword INTO is
optional.
VALUES clause specifies the column values to be added.
◉ INSERT Statement (Syntax). Answer: INSERT [INTO] TableName
(Column1, Column2, ...)VALUES (Value1, Value2, ...);
◉ UPDATE Statement (Clauses). Answer: Uses the SET clause to
specify the new column values.
An optional WHERE clause specifies which rows are updated.
Omitting the WHERE clause results in all rows being updated.
◉ DELETE Statement (Keywords/Clauses). Answer: The FROM
keyword is followed by the table name whose rows are to be deleted.
An optional WHERE clause specifies which rows should be deleted.
Omitting the WHERE clause results in all rows in the table being
deleted.
◉ TRUNCATE Statement. Answer: Deletes all rows from a table.
, ◉ Primary Key. Answer: A _______ ___ is a constraint on a column, or
group of columns, used to identify a row. The ________ ____ is usually
the table's first column and appears on the left of table diagrams, but
the position is not significant to the database. A solid circle (●)
notates these in table diagrams.
MUST BE "Unique" and "Not NULL"
◉ Simple Primary Key. Answer: A key that consists of a SINGLE
column.
◉ Composite Key. Answer: A key that consists of multiple columns
and is denoted with parenthesis.
MUST BE Minimal, meaning only NECESSARY primary keys may be
involved. In it's minimal stage, if one of these keys is removed it then
becomes no longer unique.
◉ Auto-Increment. Answer: Database users occasionally make the
following errors when inserting primary keys:
Inserting values for auto-increment primary keys.
Omitting values for primary keys that are not auto-increment
columns.
