CIT 208 TMA :(1)(2)(3)(4)

1 SQL SELECT DISTINCT Syntax
SELECT DISTINCT column_name(s) FROM table_name SELECT DISTINCT table_name(s) FROM column_name SELECT column_name(s) FROM table_name DISTINCT SELECT DISTINCT column_name(s) FROM table_address

2 For numeric values, the correct statement is
SELECT * FROM Persons WHERE Year='1965” SELECT * FROM Persons WHERE Year=”1965” SELECT * FROM Persons WHERE Year='1965' SELECT * FROM Persons WHERE Year=1965

3 … names can be given to database objects by using synonyms
Same Contrast Alternative Emerging

4 The --- statement is used to delete records and rows in a table
REMOVE DELETE FILTER CLEAN

5 The --- operator displays a record if both the first condition and the second condition is true
OR AND NOR NAND

6 A decomposition of a relation schema R consists of --- the relation schema by two or more relation schema that each contain a subset of the attribute of R and together include all the attributes in R
adding removing replacing depleting

7 The relational algebra is a --- query language
maths procedural non-procedural calculation

8 WSDL is used for ---
depositing the services available describing the services available providing the services available connecting the services available

9 What do we use to tag data?
XML XNL LMN XLN

10 Database constraints are defined ---
over a scheme over a schema over a system over a schematic

11 A null value is ---
a value that is not certain a value that is unrealistic a value that is available a value that is unavailable

12 UDDI is used ---
for listing what systems are available for listing what services are available for describing what services are available for listing what services

13 How is SOAP used?
To describe data To picture data To transfer data To execute data

14 Web service ---
describes a standardized way of integrating Web-based applications using the XML describes a standardized way of integrating Web-based applications using the LMX describes a standardized way of integrating Web-based applications using the XLM describes a standardized way of integrating Web-based applications using the LPM

15 What is Web Service Security?
defines how to use HTTPS Encryption and XML Signature in SOAP to secure message exchanges as an alternative or extension to using HTTPS to secure the channel defines how to use XML Encryption and XML Signature in SOAP to secure message exchanges as an alternative or extension to using HTTPS to secure the channel defines how to use XML Encryption and HTTPS Signature in SOAP to secure message exchanges as an alternative or extension to using HTTPS to secure the channel defines how to use XML Encryption and SOAP Signature in SOAP to secure message exchanges as an alternative or extension to using HTTPS to secure the channel

16 WSA stands for
Web System Architecture Web Services Architecture Web Services Accounting Window Services Architecture

17 WSA provides ---
a web service a conceptual model and a context for understanding Web services and the relationships between the components of this model a conceptual model and a context for understanding Web and the relationships between the components of this model a conceptual model and a context for understanding Web services and the disimiliarity between the components of this model

18 What is database roll forward?
restoring using the sort data and all valid transactions since the save are reapplied restoring using the sort data and all valid transactions restoring using all sort transactions since the save are reapplied using the sort data and all valid transactions since the save are reapplied

19 Database roll back ---
undo changes made by erroneous or partially processed transaction by doing the changer they have made in the database undo changes made by erroneous or partially processed transaction by undoing the changer they have made in the database undo erroneous or partially processed transaction by undoing the changer they have made in the database undo changes made by erroneous or partially processed transaction by undoing the changer they have made in the segment

20 What do you understand by conceptual model?
conceptual model represents 'concepts' (entities) and relationships conceptual model represents 'concepts' (entities) and relationships between them conceptual model represents 'concepts' (entities) and relationships inbetween conceptual model diagrams 'concepts' (entities) and relationships between them