1|Page
ISDS 7301 (actual 2025/2026) QUESTIONS AND
verified ANSWERS CORRECT
A database system must provide all of the following features except:
A. concurrency control
B. physical data dependence
C. logical data independence
D. database security - (answer)B. physical data dependence
A database schema refers to the organization of data as a blueprint of how the
database is constructed:
True
False - (answer)True
The process of validating user credentials to prevent unauthorized users is called
authorization.
True
False - (answer)False
The process of ensuring each table cell contains a single value is:
A. first normal form
B. second normal form
C. third normal form - (answer)A. first normal form
,2|Page
Normalization is a database design technique which organizes tables in a manner
that reduces redundancy and removes dependency of data.
True
False - (answer)True
All of the following are true about foreign keys except:
A. A foreign key references the primary key of another table.
B. A foreign key ensures rows in one table have corresponding rows in another.
C. A foreign key cannot have a different name from its primary key.
D. A foreign key, unlike primary keys, do not have to be unique. - (answer)C. A
foreign key cannot have a different name from its primary key.
Which statement is used to identify the columns to be returned?
A. Select
B. From
C. Where
D. Group by - (answer)A. Select
The SUM function is which type of function:
A. aggregate
B. system
C. numeric
, 3|Page
D. string - (answer)A. aggregate
The LIKE operator can be used on numeric type values, Where Address Number
Like 21%:
True
False - (answer)False
The default sorting for the Order by clause is:
A. ascending
B. descending - (answer)A. ascending
SQL join(s) is used to combine data from two or more tables. - (answer)True
When using a subquery, the outer query is evaluated before the inner query. -
(answer)False
When possible, it is best to join two tables using the primary key of one table and
the foreign key of the other table. - (answer)True
Which of the following is NOT an explicit join operator?
A. inner
B. right
C. full
ISDS 7301 (actual 2025/2026) QUESTIONS AND
verified ANSWERS CORRECT
A database system must provide all of the following features except:
A. concurrency control
B. physical data dependence
C. logical data independence
D. database security - (answer)B. physical data dependence
A database schema refers to the organization of data as a blueprint of how the
database is constructed:
True
False - (answer)True
The process of validating user credentials to prevent unauthorized users is called
authorization.
True
False - (answer)False
The process of ensuring each table cell contains a single value is:
A. first normal form
B. second normal form
C. third normal form - (answer)A. first normal form
,2|Page
Normalization is a database design technique which organizes tables in a manner
that reduces redundancy and removes dependency of data.
True
False - (answer)True
All of the following are true about foreign keys except:
A. A foreign key references the primary key of another table.
B. A foreign key ensures rows in one table have corresponding rows in another.
C. A foreign key cannot have a different name from its primary key.
D. A foreign key, unlike primary keys, do not have to be unique. - (answer)C. A
foreign key cannot have a different name from its primary key.
Which statement is used to identify the columns to be returned?
A. Select
B. From
C. Where
D. Group by - (answer)A. Select
The SUM function is which type of function:
A. aggregate
B. system
C. numeric
, 3|Page
D. string - (answer)A. aggregate
The LIKE operator can be used on numeric type values, Where Address Number
Like 21%:
True
False - (answer)False
The default sorting for the Order by clause is:
A. ascending
B. descending - (answer)A. ascending
SQL join(s) is used to combine data from two or more tables. - (answer)True
When using a subquery, the outer query is evaluated before the inner query. -
(answer)False
When possible, it is best to join two tables using the primary key of one table and
the foreign key of the other table. - (answer)True
Which of the following is NOT an explicit join operator?
A. inner
B. right
C. full
