WGU - C170 - DATA MANAGEMENT
APPLICATIONS
CreateasDatabaseasSyntaxas-asanswers--CREATEasDATABASEasdb_name;
SimpleasSFWasqueryassyntaxas-asanswers--
SELECTas*asFROMasdb_nameasWHEREascolumn_nameasoperatorasvalue;
Cardinality:asInsideasorasoutside?as-asanswers--Outside
Modality:asInsideasorasoutside?as-asanswers--Inside
Whatascommandsasareasusedaswithasdataasdefinition?as-asanswers--
create,asalter,asdrop,astruncate,ascomment,asrename
Whatascommandsasareasusedaswithasdataasmanipulation?as-asanswers--
Select,asInsert,asUpdate,asDelete,asMerge,asCall,asExplainasPlan,asLockasTable
CreateasTableasSyntaxas-asanswers--CREATEasTABLEastable_name
(
ascolumn_name1asdata_type(size),
ascolumn_name2asdata_type(size),
);
APPLICATIONS
CreateasDatabaseasSyntaxas-asanswers--CREATEasDATABASEasdb_name;
SimpleasSFWasqueryassyntaxas-asanswers--
SELECTas*asFROMasdb_nameasWHEREascolumn_nameasoperatorasvalue;
Cardinality:asInsideasorasoutside?as-asanswers--Outside
Modality:asInsideasorasoutside?as-asanswers--Inside
Whatascommandsasareasusedaswithasdataasdefinition?as-asanswers--
create,asalter,asdrop,astruncate,ascomment,asrename
Whatascommandsasareasusedaswithasdataasmanipulation?as-asanswers--
Select,asInsert,asUpdate,asDelete,asMerge,asCall,asExplainasPlan,asLockasTable
CreateasTableasSyntaxas-asanswers--CREATEasTABLEastable_name
(
ascolumn_name1asdata_type(size),
ascolumn_name2asdata_type(size),
);
