FPT UNIVERSITY DBI202 EXAM 2024/2025 WITH 100% ACCURATE SOLUTIONS

FPT UNIVERSITY DBI202 EXAM 2024/2025
WITH 100% ACCURATE SOLUTIONS


1. a: QN=1 (6803) A is a logically coherent collection of data with
some inherent meaning, representing some aspect of real world and
being designed, built and populated with data for a specific purpose
a. Database
b.Database Instance
c. Schema
d. Schema Instance
2. b: QN=2 (6801) Choose the most correct statement.
a. Database is created and maintained by a DMBS
b.All of the others
c. Database is a collection of data that is managed by a DBMS
d. Database is a collection of information that exists over a long period o
time
3. b: QN=3 (6802) Which of following is never used as a data model?
a. Hierarchical data model
b.None of the others
c. Graph-based data model
d.Tree-based data model
e. Relational data model
4. a: QN=4 (6817) A is a relation name, together with the
attributes of that relation.
a. schema
b.database
c. database instance
d. schema instance
5. a: QN=5 (6824) A is a notation for describing the structure of the
data in a database, along with the constraints on that data
a. data model
b.database management system
c. data operation
d. data manipulation
6. a: QN=6 (6827) A is a language for defining data structures
a. DDL
b.DML
c. DCL
d. None of the others
7. a: QN=7 (6834) Which statement is used to remove a relation named
R?
a. DROP TABLE R;


, FPT UNIVERSITY DBI202 EXAM 2024/2025
WITH 100% ACCURATE SOLUTIONS

b.REMOVE TABLE R;






, FPT UNIVERSITY DBI202 EXAM 2024/2025
WITH 100% ACCURATE SOLUTIONS


c. DELETE TABLE R;
d.TRUNCATE TABLE R;
8. b: QN=8 (6829) What is another term for a row in a relational table?
a. Attribute
b.Tuple
c. Field
d. Relation
9. d: QN=9 (7961) Given a relation R(A,B,C,D). Which of the followings is
trivial?
a. A->AB
b.A->->AB
c. A->BCD
d. A->->BCD
10.b: QN=10 (7972) Let R(ABCD) be a relation with functional
dependencies
{A ->
B, C -
> B,
B -> D}
What is the key for R (choose one)
a. AB
b.AC
c. AD
d. BD
11.a: QN=11 (7966) Suppose R is a relation with attributes A1,
A2, A3, A4. The only key of R is {A1, A2}. So, how many super-
keys do R have?
a. 4
b.8
c. 12
d. 16
12.a: QN=12 (7990) Consider the following functional
dependencies a,b -> c,d e,g,h -> f,j
a,c -> b,d p,q -> r,s
e,f,g -> h,i s -
> t f,g -> j q -
> u g,h -> i
Which of the following best describes the relation R(e,f,g,h,i,j)?
a. R is in First Normal Form


, FPT UNIVERSITY DBI202 EXAM 2024/2025
WITH 100% ACCURATE SOLUTIONS

b.R is in Second Normal Form
c. R is in Third Normal Form
d. R is in Boyce Codd Normal Form