Course Hero Logo

module 2 sd (summative assessment) - Compiled by: EOH...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 4 out of 17 pages.

Compiled by: EOHApproved By: MICTSETAThis document is strictly confidential and may on no account be reproduced,copied or divulged without prior authorisationNC: Information Technology –System Development - 48872NQF Level 5Module 2Summative AssessmentsUnit Standard – 114048 - Unit Standard – 114069Unit Standard – 115367 - Unit Standard – 115373Question 1Revision numberDate revisedPage numberRev 1October 2015Page 1
Compiled by: EOHApproved By: MICTSETAThis document is strictly confidential and may on no account be reproduced,copied or divulged without prior authorisationCreate database access for a computer application using structured querylanguage (114048)TASKQuestionSOAC1.1Define adatabase andDatabase languages (6)11.2Define Data manipulation language (DML) (2)11-41Define adatabase and Database languages
Database languages are special-purpose languages, which do one or more of the following:
2Define Data manipulation language (DML)
TASKQuestionSOAC31What are named row type and User-defined types (8)31-8Revision numberDate revisedPage numberRev 1October 2015Page 2
Compiled by: EOHApproved By: MICTSETAThis document is strictly confidential and may on no account be reproduced,copied or divulged without prior authorisationAnamed rowtypeis a group of fields that are defined under a single name. Afieldrefers to acomponent of a row type and should not be confused with a column, which is associated withtables only. The fields of a named row type are analogous to the fields of a C-languagestructure or members of a class in object-oriented programming. After you create a namedrow type, the name that you assign to the row type represents a unique type within thedatabase. To create a named row type, you specify a name for the row type and the namesand data types of its constituent fields.A user-defined data type(UDT) is a data type that derived from an existing data type. You canuse UDTs to extend the built-in types already available and create your own customized datatypes.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 17 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A
Tags
Data Management, Revision Number, prior authorisation

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture