ISDS 3003 FINAL EXAM QUESTIONS WITH CORRECT ANSWERS LATEST UPDATE 2025/2026
Regarding Big Data, what does the term NoSQL really mean?
A. No SQL used
B. Notational Query Language
C. Non-Blocking Query Language
D. NortonOS Query Language
E. Nonrelational Database - Answers E. Nonrelational Database
What role does the Web browser play in a Web database application?
A. Hardware support
B. Bug-reporting System
C. Web user interface
D. Microchip accelerator
E. Back-end Database Management System - Answers C. Web user interface
A relational database is:
A. a collection of forms and reports that support a given purpose
B. a set of metadata
C. a self-describing collection of related tables
D. a library of queries and data files for querying
E. a set of applications and the data sets for those applications - Answers C. a self-describing
collection of related tables
Which of the following would not be an example of database metadata?
A. Properties of columns
B. Queries against records in the database tables
C. Properties of tables in a database
D. Names of tables in a database
E. Names of columns in a database and their associated tables - Answers B. Queries against
,records in the database tables
The creation of a database and its tables is a function of which component of the database
system?
A. DBMS
B. Users
C. Application
D. Web server
E. Database - Answers A. DBMS
Microsoft SQL server is an example of a:
A. database management system
B. list manager
C. table
D. data manipulation system
E. database - Answers A. database management system
A relational database stores data in the form of:
A. tables
B. lists
C. columns
D. forms
E. spreadsheets - Answers A. tables
SQL stands for:
A. Structured Question Language
B. Standard Question Language
C. Structural Question Language
D. Structured Query Language
E. Standard Query Language - Answers D. Structured Query Language
, The Microsoft Access 2019 data type of AutoNumber is used when there is a specific need for a:
A. primary key
B. secondary key
C. spare key
D. surrogate key
E. foreign key - Answers D. surrogate key
Which of the following problems associated with storing data in a list is avoided by storing data
in a relational database?
A. Duplication of data items
B. Incorrect data typing
C. Lack of necessary bandwidth
D. Running out of memory storage
E. CPU processing inefficiencies - Answers A. Duplication of data items
Which of the following terms is synonymous with "tuple"?
A. Field
B. Relation
C. Row
D. Attribute
E. Table - Answers C. Row
A key that contains more than one attribute is called a:
A. candidate key
B. complex key
C. n-key
D. multi-key
E. composite key - Answers E. composite key
a primary key is a:
Regarding Big Data, what does the term NoSQL really mean?
A. No SQL used
B. Notational Query Language
C. Non-Blocking Query Language
D. NortonOS Query Language
E. Nonrelational Database - Answers E. Nonrelational Database
What role does the Web browser play in a Web database application?
A. Hardware support
B. Bug-reporting System
C. Web user interface
D. Microchip accelerator
E. Back-end Database Management System - Answers C. Web user interface
A relational database is:
A. a collection of forms and reports that support a given purpose
B. a set of metadata
C. a self-describing collection of related tables
D. a library of queries and data files for querying
E. a set of applications and the data sets for those applications - Answers C. a self-describing
collection of related tables
Which of the following would not be an example of database metadata?
A. Properties of columns
B. Queries against records in the database tables
C. Properties of tables in a database
D. Names of tables in a database
E. Names of columns in a database and their associated tables - Answers B. Queries against
,records in the database tables
The creation of a database and its tables is a function of which component of the database
system?
A. DBMS
B. Users
C. Application
D. Web server
E. Database - Answers A. DBMS
Microsoft SQL server is an example of a:
A. database management system
B. list manager
C. table
D. data manipulation system
E. database - Answers A. database management system
A relational database stores data in the form of:
A. tables
B. lists
C. columns
D. forms
E. spreadsheets - Answers A. tables
SQL stands for:
A. Structured Question Language
B. Standard Question Language
C. Structural Question Language
D. Structured Query Language
E. Standard Query Language - Answers D. Structured Query Language
, The Microsoft Access 2019 data type of AutoNumber is used when there is a specific need for a:
A. primary key
B. secondary key
C. spare key
D. surrogate key
E. foreign key - Answers D. surrogate key
Which of the following problems associated with storing data in a list is avoided by storing data
in a relational database?
A. Duplication of data items
B. Incorrect data typing
C. Lack of necessary bandwidth
D. Running out of memory storage
E. CPU processing inefficiencies - Answers A. Duplication of data items
Which of the following terms is synonymous with "tuple"?
A. Field
B. Relation
C. Row
D. Attribute
E. Table - Answers C. Row
A key that contains more than one attribute is called a:
A. candidate key
B. complex key
C. n-key
D. multi-key
E. composite key - Answers E. composite key
a primary key is a:
