C170 - Data Management Applications
Exam with Questions and Correct
Answers 2025
Relational ,Model ,- ,CORRECT ,ANSWER-database ,model ,based ,on ,mathematical
,principles
3 ,parts ,of ,relational ,model ,- ,CORRECT ,ANSWER-A ,data ,structure ,that
,prescribes ,how ,data ,is ,organized.
Operations ,that ,manipulate ,data ,structures.
Rules ,that ,govern ,valid ,relational ,data.
What ,adds, ,deletes, ,or ,modifies ,columns ,on ,an ,existing ,table ,- ,CORRECT
,ANSWER-ALTER ,TABLE ,statement
ALTER ,TABLE ,Add ,- ,CORRECT ,ANSWER-Adds ,a ,column
Alter ,Table ,Change ,- ,CORRECT ,ANSWER-Modifies ,a ,column
Alter ,Table ,Drop ,- ,CORRECT ,ANSWER-Deletes ,a ,Column
What ,is ,the ,function ,of ,the ,Primary ,Key ,Constraint? ,- ,CORRECT ,ANSWER-
Names ,the ,tables ,column ,that ,uniquely ,identify ,each ,row
PRIMARY ,KEY ,(Column ,Name)
What ,is ,the ,Foreign ,Key ,Syntax? ,- ,CORRECT ,ANSWER-FOREIGN ,KEY ,(Column
,2 ,Name) ,REFERENCES ,(Column ,1 ,Name)
What ,is ,the ,function ,of ,the ,Foreign ,Key ,Constraint? ,- ,CORRECT ,ANSWER-
Refers ,to ,the ,Primary ,Key ,of ,another ,table
What ,does ,Create ,Table ,Statement ,do? ,- ,CORRECT ,ANSWER-Creates ,a ,new
,table ,and ,specifies ,the ,table ,name, ,column ,and ,column ,data ,types
, What ,does ,the ,DROP ,TABLE ,statement ,do? ,- ,CORRECT ,ANSWER-Deletes ,a
,table ,and ,the ,table's ,rows ,from ,a ,database.
What ,does ,the ,ALTER ,TABLE ,statement ,do? ,- ,CORRECT ,ANSWER-Adds,
,deletes ,or ,modifies ,Columns ,on ,an ,existing ,table. ,It ,specifies ,a ,table ,name
,followed ,by ,a ,clause ,that ,indicates ,what ,should ,be ,altered.
What ,are ,the ,3 ,ALTER ,TABLE ,Clauses? ,- ,CORRECT ,ANSWER-Add ,- ,adds ,a
,column
Change ,- ,Modifies ,a ,column
Drop ,- ,Deletes ,a ,column
What ,actions ,are ,specified ,with ,the ,FOREIGN ,KEY ,Constraint? ,- ,CORRECT
,ANSWER-On ,Delete
On ,Update
What ,are ,the ,4 ,Foreign ,Key ,Action ,Responses? ,- ,CORRECT ,ANSWER-Restrict ,-
,Rejects ,an ,insert, ,update ,or ,delete
Set ,Null ,- ,Sets ,an ,invalid ,Foreign ,Key ,Value ,to ,NULL.
Set ,Default ,- ,Sets ,invalid ,Foreign ,Keys ,to ,a ,default ,primary ,key ,value
Cascade ,- ,matching ,Primary ,Key ,Changes ,are ,mirrored ,to ,Foreign ,Keys.
What ,does ,the ,INSERT ,Statement ,do? ,- ,CORRECT ,ANSWER-Adds ,rows ,to ,a
,table ,and ,includes ,the ,INTO ,and ,Values ,Clauses.
What ,do ,the ,INTO ,and ,VALUES ,Clauses ,do ,for ,an ,INSERT ,Statement? ,-
,CORRECT ,ANSWER-INTO ,- ,names ,the ,table ,and ,columns ,where ,data ,is ,to ,be
,added
VALUES ,- ,Specifies ,the ,column ,Values ,to ,be ,added.
What ,does ,the ,UPDATE ,Statement ,do? ,- ,CORRECT ,ANSWER-Modifies ,existing
,ROWS ,in ,a ,table.
Uses ,the ,SET ,Clause ,to ,specify ,the ,new ,column ,Values.
Uses ,the ,Where ,Clause ,to ,determine ,which ,rows ,are ,updates.
What ,does ,the ,DELETE ,FROM ,Statement ,do? ,- ,CORRECT ,ANSWER-Deletes
,existing ,rows ,in ,a ,table.
DELETE ,FROM ,<Table ,Name>
Exam with Questions and Correct
Answers 2025
Relational ,Model ,- ,CORRECT ,ANSWER-database ,model ,based ,on ,mathematical
,principles
3 ,parts ,of ,relational ,model ,- ,CORRECT ,ANSWER-A ,data ,structure ,that
,prescribes ,how ,data ,is ,organized.
Operations ,that ,manipulate ,data ,structures.
Rules ,that ,govern ,valid ,relational ,data.
What ,adds, ,deletes, ,or ,modifies ,columns ,on ,an ,existing ,table ,- ,CORRECT
,ANSWER-ALTER ,TABLE ,statement
ALTER ,TABLE ,Add ,- ,CORRECT ,ANSWER-Adds ,a ,column
Alter ,Table ,Change ,- ,CORRECT ,ANSWER-Modifies ,a ,column
Alter ,Table ,Drop ,- ,CORRECT ,ANSWER-Deletes ,a ,Column
What ,is ,the ,function ,of ,the ,Primary ,Key ,Constraint? ,- ,CORRECT ,ANSWER-
Names ,the ,tables ,column ,that ,uniquely ,identify ,each ,row
PRIMARY ,KEY ,(Column ,Name)
What ,is ,the ,Foreign ,Key ,Syntax? ,- ,CORRECT ,ANSWER-FOREIGN ,KEY ,(Column
,2 ,Name) ,REFERENCES ,(Column ,1 ,Name)
What ,is ,the ,function ,of ,the ,Foreign ,Key ,Constraint? ,- ,CORRECT ,ANSWER-
Refers ,to ,the ,Primary ,Key ,of ,another ,table
What ,does ,Create ,Table ,Statement ,do? ,- ,CORRECT ,ANSWER-Creates ,a ,new
,table ,and ,specifies ,the ,table ,name, ,column ,and ,column ,data ,types
, What ,does ,the ,DROP ,TABLE ,statement ,do? ,- ,CORRECT ,ANSWER-Deletes ,a
,table ,and ,the ,table's ,rows ,from ,a ,database.
What ,does ,the ,ALTER ,TABLE ,statement ,do? ,- ,CORRECT ,ANSWER-Adds,
,deletes ,or ,modifies ,Columns ,on ,an ,existing ,table. ,It ,specifies ,a ,table ,name
,followed ,by ,a ,clause ,that ,indicates ,what ,should ,be ,altered.
What ,are ,the ,3 ,ALTER ,TABLE ,Clauses? ,- ,CORRECT ,ANSWER-Add ,- ,adds ,a
,column
Change ,- ,Modifies ,a ,column
Drop ,- ,Deletes ,a ,column
What ,actions ,are ,specified ,with ,the ,FOREIGN ,KEY ,Constraint? ,- ,CORRECT
,ANSWER-On ,Delete
On ,Update
What ,are ,the ,4 ,Foreign ,Key ,Action ,Responses? ,- ,CORRECT ,ANSWER-Restrict ,-
,Rejects ,an ,insert, ,update ,or ,delete
Set ,Null ,- ,Sets ,an ,invalid ,Foreign ,Key ,Value ,to ,NULL.
Set ,Default ,- ,Sets ,invalid ,Foreign ,Keys ,to ,a ,default ,primary ,key ,value
Cascade ,- ,matching ,Primary ,Key ,Changes ,are ,mirrored ,to ,Foreign ,Keys.
What ,does ,the ,INSERT ,Statement ,do? ,- ,CORRECT ,ANSWER-Adds ,rows ,to ,a
,table ,and ,includes ,the ,INTO ,and ,Values ,Clauses.
What ,do ,the ,INTO ,and ,VALUES ,Clauses ,do ,for ,an ,INSERT ,Statement? ,-
,CORRECT ,ANSWER-INTO ,- ,names ,the ,table ,and ,columns ,where ,data ,is ,to ,be
,added
VALUES ,- ,Specifies ,the ,column ,Values ,to ,be ,added.
What ,does ,the ,UPDATE ,Statement ,do? ,- ,CORRECT ,ANSWER-Modifies ,existing
,ROWS ,in ,a ,table.
Uses ,the ,SET ,Clause ,to ,specify ,the ,new ,column ,Values.
Uses ,the ,Where ,Clause ,to ,determine ,which ,rows ,are ,updates.
What ,does ,the ,DELETE ,FROM ,Statement ,do? ,- ,CORRECT ,ANSWER-Deletes
,existing ,rows ,in ,a ,table.
DELETE ,FROM ,<Table ,Name>
