C170 Data Management Applications
Exam with Questions and Correct
Answers 2025
access ,plan ,- ,CORRECT ,ANSWER-A ,set ,of ,instructions ,generated ,at ,application
,compilation ,time ,that ,is ,created ,and ,managed ,by ,a ,DBMS. ,The ,access ,plan
,predetermines ,how ,an ,application's ,query ,will ,access ,the ,database ,at ,run ,time.
algorithms ,- ,CORRECT ,ANSWER-A ,process ,or ,set ,of ,operations ,in ,a
,calculation.
alias ,- ,CORRECT ,ANSWER-An ,alternative ,name ,for ,a ,column ,or ,table ,in ,a ,SQL
,statement.
ALTER ,TABLE ,- ,CORRECT ,ANSWER-The ,SQL ,command ,used ,to ,make ,changes
,to ,table ,structure. ,When ,the ,command ,is ,followed ,by ,a ,keyword ,(ADD ,or
,MODIFY), ,it ,adds ,a ,column ,or ,changes ,column ,characteristics.
AND ,- ,CORRECT ,ANSWER-The ,SQL ,logical ,operator ,used ,to ,link ,multiple
,conditional ,expressions ,in ,a ,WHERE ,or ,HAVING ,clause. ,It ,requires ,that ,all
,conditional ,expressions ,evaluate ,to ,true.
AREA ,- ,CORRECT ,ANSWER-In ,DB2, ,a ,named ,section ,of ,permanent ,storage
,space ,that ,is ,reserved ,to ,store ,the ,database.
associative ,entity ,- ,CORRECT ,ANSWER-An ,entity ,designed ,to ,transform ,an ,M:N
,relationship ,into ,two ,1:M ,relationships. ,The ,composite ,entity's ,primary ,key
,comprises ,at ,least ,the ,primary ,keys ,of ,the ,entities ,that ,it ,connects. ,Also ,known
,as ,a ,bridge ,entity ,or ,associative ,entity. ,See ,also ,linking ,table.
atomic ,attribute ,- ,CORRECT ,ANSWER-An ,attribute ,that ,cannot ,be ,further
,subdivided ,to ,produce ,meaningful ,components. ,For ,example, ,a ,person's ,last
,name ,attribute ,cannot ,be ,meaningfully ,subdivided.
atomicity ,- ,CORRECT ,ANSWER-The ,transaction ,property ,that ,requires ,all ,parts
,of ,a ,transaction ,to ,be ,treated ,as ,a ,single, ,indivisible, ,logical ,unit ,of ,work. ,All
,parts ,of ,a ,transaction ,must ,be ,completed ,or ,the ,entire ,transaction ,is ,aborted.
, authentication ,- ,CORRECT ,ANSWER-The ,process ,through ,which ,a ,DBMS
,verifies ,that ,only ,registered ,users ,can ,access ,the ,database.
automatic ,query ,optimization ,- ,CORRECT ,ANSWER-A ,method ,by ,which ,a ,DBMS
,finds ,the ,most ,efficient ,access ,path ,for ,the ,execution ,of ,a ,query.
AVG ,- ,CORRECT ,ANSWER-A ,SQL ,aggregate ,function ,that ,outputs ,the ,mean
,average ,for ,a ,specified ,column ,or ,expression.
B-tree ,index ,- ,CORRECT ,ANSWER-An ,ordered ,data ,structure ,organized ,as ,an
,upside-down ,tree.
base ,tables ,- ,CORRECT ,ANSWER-The ,table ,on ,which ,a ,view ,is ,based.
batch ,update ,routine ,- ,CORRECT ,ANSWER-A ,routine ,that ,pools ,transactions
,into ,a ,single ,group ,to ,update ,a ,master ,table ,in ,a ,single ,operation.
BETWEEN ,- ,CORRECT ,ANSWER-In ,SQL, ,a ,special ,comparison ,operator ,used ,to
,check ,whether ,a ,value ,is ,within ,a ,range ,of ,specified ,values.
binary ,relationship ,- ,CORRECT ,ANSWER-An ,ER ,term ,for ,an ,association
,(relationship) ,between ,two ,entities. ,For ,example, ,PROFESSOR ,teaches ,CLASS.
bitmap ,index ,- ,CORRECT ,ANSWER-An ,index ,that ,uses ,a ,bit ,array ,(0s ,and ,1s)
,to ,represent ,the ,existence ,of ,a ,value ,or ,condition.
Boolean ,algebra ,- ,CORRECT ,ANSWER-A ,branch ,of ,mathematics ,that ,uses ,the
,logical ,operators ,OR, ,AND, ,and ,NOT.
Boyce-Codd ,normal ,form ,(BCNF) ,- ,CORRECT ,ANSWER-A ,special ,type ,of ,third
,normal ,form ,(3NF) ,in ,which ,every ,determinant ,is ,a ,candidate ,key. ,A ,table ,in
,BCNF ,must ,be ,in ,3NF. ,See ,also ,determinant.
bridge ,entity ,- ,CORRECT ,ANSWER-An ,entity ,designed ,to ,transform ,an ,M:N
,relationship ,into ,two ,1:M ,relationships. ,The ,composite ,entity's ,primary ,key
,comprises ,at ,least ,the ,primary ,keys ,of ,the ,entities ,that ,it ,connects.
buffer ,cache ,- ,CORRECT ,ANSWER-A ,shared, ,reserved ,memory ,area ,that ,stores
,the ,most ,recently ,accessed ,data ,blocks ,in ,RAM. ,AKA ,data ,cache
candidate ,key ,- ,CORRECT ,ANSWER-A ,minimal ,superkey; ,that ,is, ,a ,key ,that
,does ,not ,contain ,a ,subset ,of ,attributes ,that ,is ,itself ,a ,superkey. ,See ,key.
Exam with Questions and Correct
Answers 2025
access ,plan ,- ,CORRECT ,ANSWER-A ,set ,of ,instructions ,generated ,at ,application
,compilation ,time ,that ,is ,created ,and ,managed ,by ,a ,DBMS. ,The ,access ,plan
,predetermines ,how ,an ,application's ,query ,will ,access ,the ,database ,at ,run ,time.
algorithms ,- ,CORRECT ,ANSWER-A ,process ,or ,set ,of ,operations ,in ,a
,calculation.
alias ,- ,CORRECT ,ANSWER-An ,alternative ,name ,for ,a ,column ,or ,table ,in ,a ,SQL
,statement.
ALTER ,TABLE ,- ,CORRECT ,ANSWER-The ,SQL ,command ,used ,to ,make ,changes
,to ,table ,structure. ,When ,the ,command ,is ,followed ,by ,a ,keyword ,(ADD ,or
,MODIFY), ,it ,adds ,a ,column ,or ,changes ,column ,characteristics.
AND ,- ,CORRECT ,ANSWER-The ,SQL ,logical ,operator ,used ,to ,link ,multiple
,conditional ,expressions ,in ,a ,WHERE ,or ,HAVING ,clause. ,It ,requires ,that ,all
,conditional ,expressions ,evaluate ,to ,true.
AREA ,- ,CORRECT ,ANSWER-In ,DB2, ,a ,named ,section ,of ,permanent ,storage
,space ,that ,is ,reserved ,to ,store ,the ,database.
associative ,entity ,- ,CORRECT ,ANSWER-An ,entity ,designed ,to ,transform ,an ,M:N
,relationship ,into ,two ,1:M ,relationships. ,The ,composite ,entity's ,primary ,key
,comprises ,at ,least ,the ,primary ,keys ,of ,the ,entities ,that ,it ,connects. ,Also ,known
,as ,a ,bridge ,entity ,or ,associative ,entity. ,See ,also ,linking ,table.
atomic ,attribute ,- ,CORRECT ,ANSWER-An ,attribute ,that ,cannot ,be ,further
,subdivided ,to ,produce ,meaningful ,components. ,For ,example, ,a ,person's ,last
,name ,attribute ,cannot ,be ,meaningfully ,subdivided.
atomicity ,- ,CORRECT ,ANSWER-The ,transaction ,property ,that ,requires ,all ,parts
,of ,a ,transaction ,to ,be ,treated ,as ,a ,single, ,indivisible, ,logical ,unit ,of ,work. ,All
,parts ,of ,a ,transaction ,must ,be ,completed ,or ,the ,entire ,transaction ,is ,aborted.
, authentication ,- ,CORRECT ,ANSWER-The ,process ,through ,which ,a ,DBMS
,verifies ,that ,only ,registered ,users ,can ,access ,the ,database.
automatic ,query ,optimization ,- ,CORRECT ,ANSWER-A ,method ,by ,which ,a ,DBMS
,finds ,the ,most ,efficient ,access ,path ,for ,the ,execution ,of ,a ,query.
AVG ,- ,CORRECT ,ANSWER-A ,SQL ,aggregate ,function ,that ,outputs ,the ,mean
,average ,for ,a ,specified ,column ,or ,expression.
B-tree ,index ,- ,CORRECT ,ANSWER-An ,ordered ,data ,structure ,organized ,as ,an
,upside-down ,tree.
base ,tables ,- ,CORRECT ,ANSWER-The ,table ,on ,which ,a ,view ,is ,based.
batch ,update ,routine ,- ,CORRECT ,ANSWER-A ,routine ,that ,pools ,transactions
,into ,a ,single ,group ,to ,update ,a ,master ,table ,in ,a ,single ,operation.
BETWEEN ,- ,CORRECT ,ANSWER-In ,SQL, ,a ,special ,comparison ,operator ,used ,to
,check ,whether ,a ,value ,is ,within ,a ,range ,of ,specified ,values.
binary ,relationship ,- ,CORRECT ,ANSWER-An ,ER ,term ,for ,an ,association
,(relationship) ,between ,two ,entities. ,For ,example, ,PROFESSOR ,teaches ,CLASS.
bitmap ,index ,- ,CORRECT ,ANSWER-An ,index ,that ,uses ,a ,bit ,array ,(0s ,and ,1s)
,to ,represent ,the ,existence ,of ,a ,value ,or ,condition.
Boolean ,algebra ,- ,CORRECT ,ANSWER-A ,branch ,of ,mathematics ,that ,uses ,the
,logical ,operators ,OR, ,AND, ,and ,NOT.
Boyce-Codd ,normal ,form ,(BCNF) ,- ,CORRECT ,ANSWER-A ,special ,type ,of ,third
,normal ,form ,(3NF) ,in ,which ,every ,determinant ,is ,a ,candidate ,key. ,A ,table ,in
,BCNF ,must ,be ,in ,3NF. ,See ,also ,determinant.
bridge ,entity ,- ,CORRECT ,ANSWER-An ,entity ,designed ,to ,transform ,an ,M:N
,relationship ,into ,two ,1:M ,relationships. ,The ,composite ,entity's ,primary ,key
,comprises ,at ,least ,the ,primary ,keys ,of ,the ,entities ,that ,it ,connects.
buffer ,cache ,- ,CORRECT ,ANSWER-A ,shared, ,reserved ,memory ,area ,that ,stores
,the ,most ,recently ,accessed ,data ,blocks ,in ,RAM. ,AKA ,data ,cache
candidate ,key ,- ,CORRECT ,ANSWER-A ,minimal ,superkey; ,that ,is, ,a ,key ,that
,does ,not ,contain ,a ,subset ,of ,attributes ,that ,is ,itself ,a ,superkey. ,See ,key.
