C170 Data Management - Applications Exam with Questions and Correct Answers 2025.

C170: Data Management - Applications
Exam with Questions and Correct
Answers 2025




database ,model ,- ,CORRECT ,ANSWER-A ,database ,model ,is ,a ,conceptual
,framework ,for ,database ,software.


NoSQL ,databases ,- ,CORRECT ,ANSWER-Stands ,for ,Not ,Only ,SQL. ,NoSQL ,is ,a
,non-relational ,database. ,Created ,out ,of ,necessity ,for ,big ,data ,and ,is ,optimized
,for ,big ,data. ,Encompasses ,a ,variety ,of ,database ,models. ,NoSQL ,is ,NOT ,the
,dominant ,model ,for ,databases.


Example ,of ,the ,4 ,Database ,Models ,- ,CORRECT ,ANSWER-Hierarchical ,- ,Speed
,and ,storage ,- ,IMS
Network ,Model ,- ,Speed ,and ,storage ,objective ,- ,IDMS. ,
Relational ,Model ,- ,Productivity ,and ,simplicity, ,transactional ,applications ,-
,MySQL, ,Oracle, ,SQL ,Server, ,DB2. ,
NoSQL ,Models ,- ,Big ,data, ,Analytic ,applications ,- ,MongoDB, ,Redis, ,Cassandra,
,Neo4j


Which ,database ,is ,relational? ,DB2, ,IDMs, ,or ,MongoDB... ,- ,CORRECT ,ANSWER-
DB2 ,- ,DB2 ,is ,one ,of ,the ,first ,relational ,databases, ,released ,by ,IBM ,in ,the ,early
,1980's


The ,relational ,model ,was ,originally ,developed ,for ,which ,types ,of ,applications?
,- ,CORRECT ,ANSWER-Transactional ,applications ,like ,banking ,and ,airline
,reservations.


What ,was ,the ,initial ,impediment ,to ,commercial ,adoption ,of ,relational ,databases
,in ,the ,early ,1980's? ,- ,CORRECT ,ANSWER-Processing ,speed

,Relational ,model ,is ,a ,database ,model ,based ,on ,mathematical ,principles, ,with
,three ,parts: ,- ,CORRECT ,ANSWER-1. ,A ,data ,structure ,that ,prescribes ,how ,data
,is ,organized
2. ,Operations ,that ,manipulate ,data ,structures. ,
3. ,Rules ,that ,govern ,valid ,relational ,data.

Set ,Theory ,- ,What ,is ,a ,set? ,- ,CORRECT ,ANSWER-A ,set ,is ,a ,collection ,of
,values, ,or ,elements, ,with ,no ,inherent ,order. ,


Set's ,are ,denoted ,with ,braces. ,Ex: ,{apple, ,banana, ,lemon} ,is ,a ,set ,of ,3 ,fruit.

Relational ,model ,contains ,relational ,data ,structure ,based ,on ,3 ,mathematical
,concepts: ,What ,are ,the ,3 ,concepts? ,- ,CORRECT ,ANSWER-domain
tuple
relation

Domain ,- ,CORRECT ,ANSWER-named ,set ,of ,possible ,database ,values. ,Integers,
,dictionary ,words, ,logical ,values ,such ,as ,True/False.


tuple ,- ,CORRECT ,ANSWER-finite ,sequence ,of ,values, ,each ,drawn ,from ,a ,fixed
,domain. ,ex. ,(3, ,apple, ,True)


relation ,- ,CORRECT ,ANSWER-a ,named ,set ,of ,tuples, ,all ,drawn ,from ,the ,same
,sequence ,of ,domains. ,ex. ,name ,of ,the ,tuple ,(3, ,apple, ,True) ,is ,Grocery, ,as ,is
,the ,name ,of ,the ,tuple ,(0, ,lemon, ,False).


Each ,tuple ,position ,is ,called ,an ,- ,CORRECT ,ANSWER-attribute

Which ,terms ,are ,commonly ,used ,in ,relational ,database ,processing ,- ,CORRECT
,ANSWER-Row, ,table, ,column. ,Occasionally ,tuple, ,relation, ,attribute ,adn ,record,
,file, ,field ,are ,also ,used.


Are ,these ,relations ,the ,same?
{ ,(8, ,mango, ,FALSE), ,(-11, ,watermelon, ,FALSE) ,}{ ,(-11, ,watermelon, ,FALSE), ,(8,
,mango, ,FALSE) ,} ,- ,CORRECT ,ANSWER-Yes. ,Both ,relations ,contain ,the ,same
,tuples. ,Since ,a ,relation ,is ,a ,set, ,the ,order ,of ,the ,tuples ,does ,not ,matter.


In ,the ,relational ,data ,structure, ,which ,components ,are ,named? ,- ,CORRECT
,ANSWER-Domain, ,relation, ,and ,attribute


Relational ,Algebra ,includes ,the ,following ,7 ,relational ,operations: ,- ,CORRECT
,ANSWER-Select ,
Project
Product
Join
Union

, Intersect
Difference

Select ,- ,CORRECT ,ANSWER-Relational ,operation ,aka ,relational ,algebra ,term.
,Means ,to ,select ,a ,subset ,of ,rows ,of ,a ,table.


Project ,- ,CORRECT ,ANSWER-Relational ,operation ,aka ,relational ,algebra ,term.
,Eliminates ,one ,or ,more ,columns ,of ,a ,table.


Product ,- ,CORRECT ,ANSWER-Relational ,operation ,aka ,relational ,algebra ,term.
Lists ,all ,possible ,combinations ,of ,rows ,of ,two ,tables.

Join ,- ,CORRECT ,ANSWER-Relational ,operation ,aka ,relational ,algebra ,term.
a ,product ,operation ,followed ,by ,a ,select ,operation.

SELECT ,statement ,that ,combines ,data ,from ,two ,tables, ,known ,as ,the ,left ,table
,and ,the ,right ,table, ,into ,a ,single ,result. ,


Example: ,
SELECT ,DepartmentName, ,EmployeeName
FROM ,Department, ,Employee
WHERE ,Manager ,= ,ID;

Union ,- ,CORRECT ,ANSWER-Relational ,operation ,aka ,relational ,algebra ,term.
combines ,two ,tables ,by ,selecting ,all ,rows ,of ,both ,tables.

Intersect ,- ,CORRECT ,ANSWER-Relational ,operation ,aka ,relational ,algebra ,term.
combines ,two ,tables ,by ,selecting ,only ,rows ,common ,to ,both ,tables.

Difference ,- ,CORRECT ,ANSWER-Relational ,operation ,aka ,relational ,algebra
,term.
combines ,two ,tables ,by ,selecting ,rows ,that ,appear ,in ,one ,table ,but ,not ,the
,other.


What ,is ,the ,result ,of ,a ,relational ,operation? ,- ,CORRECT ,ANSWER-table

Relational ,rules ,(integrity ,rules) ,- ,CORRECT ,ANSWER-logical ,constraints ,that
,ensure ,data ,is ,valid ,and ,conforms ,to ,business ,policy


Structural ,Rules ,- ,CORRECT ,ANSWER-relational ,rules ,that ,govern ,data ,in ,every
,relational ,database. ,Ex: ,Unique ,primary ,key, ,Unique ,column ,names, ,no
,duplicate ,rows.


Business ,rules ,- ,CORRECT ,ANSWER-relational ,rules ,specific ,to ,a ,particular
,database ,and ,application. ,Ex: ,unique ,column ,values, ,no ,missing ,values, ,delete
,cascade.