FOUNDATIONS (PRE-ASSESSMENT)
(2026/2027) UPDATE|EXAM
QUESTIONS WITH MULTIPLE
CHOICES |VERIFIED & REVISED
ANSWERS (NEW)!!!
1. Whichmrequirementmwithinmlarge,mcomplexmdatabasesmensuresmusersmhavemlimitedmaccess
mtomthemdatabase?
A) Recovery
B) Performance
C) Authorization
D) Confidentialitym-mCORRECTmANSWERmC)mAuthorization
2. Whichmdesignmtypemspecifiesmdatabasemrequirementsmwithoutmregardmtomamspecificmdatab
asemsystem?
A) Physicalmdesign
B) Conceptualmdesign
C) Logicalmdesign
D) Abstractmdesignm-mCORRECTmANSWERmB)mConceptualmDesign
3. Whatmcharacterizesmthemrulesmofmrelationalmdatabases?m-
mCORRECTmANSWERmTheymaremlogicalmconstraintsmthatmensuremthemdatamismvalid.
4. WhichmeventmwillmresultminmanmerrormcodemandmerrormdescriptionmwhenmusingmMySQLmSer
ver?m-mCORRECTmANSWERmWhenmanmSQLmstatementmismsyntacticallymincorrect
, 5. Whichmdatamtypemshouldmbemusedmtomstoremwholemintegermvalues,msuchmasmage?m-
mCORRECTmANSWERmINT
6. Whichmtext-basedminterfacemismincludedminmthemMySQLmServermDownload?m-
mCORRECTmANSWERmMySQLmCommand-LinemClient
7. TruemormFalse:mMySQLmincludesmthemWorldmdatabasemduringmitsminstallation.m-
mCORRECTmANSWERmTrue
8. Whatmismthemstandardizedmlanguagemofmrelationalmdatabasemsystems?m-
mCORRECTmANSWERmStructuredmQuerymLanguagem(SQL)
9. WhichmSQLmsublanguagemismusedmtommanagemdatabasemaccess?m-
mCORRECTmANSWERmDatamControlmLanguagem(DCL)
10. WhichmSQLmsublanguagemismusedmtomrollmbackmdatabasemchanges?m-
mCORRECTmANSWERmDatamTransactionmLanguagem(DTL)
11. WhichmformatmismusedmbymthemTIMEmdatamtypeminmMySQL?m-
mCORRECTmANSWERmhh:mm:ss
12. WhichmMySQLmoperatormismthemlastminmthemordermofmoperatormprecedence?
A) -
B) OR
C) NOT
D) =m-mCORRECTmANSWERmOR