CIT208 Tma Solutions
1. The most common view of an Information System is:
Input-Storage-Output
—>> Input-Process-Output
Input-Output-Process
Input-Process-Storage
2. In SQL, the SELECT statement can be used to carry out the following operations EXCEPT:
Projection
Selection
Joining
—>> Intersecting
3. 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
4. Which of the following options describes the use of an SQL SELECT statement?
To incorporate data into a database
To extrapolate data
To describe data in a database
—>> To extract data from the database
5. Which option describes the category of SQL statements that sets up, changes and removes data structures from tables?
Data Manipulation Language (DML)
Data Retrieval Language (DRL)
—>> Data Definition Language (DDL)
Data Control Language (DCL)
6. SQL SELECT Syntax: SELECT column__name(s) FROM
Table _address
Table _format
—>> table _name
table _data
7. Which of the following options is used to select unique values from the
SELECT ** FROM Persons
—>> SELECT DISTINCT column_name(s) FROM Persons
SELECT UNIQUE * Persons
SELECT FROM * Persons
8. The following options are examples of valid rules for the construction of SQL statements EXCEPT:
SQL statements can be entered on one or many lines
Keywords cannot be split across lines or abbreviated
Clauses are usually placed on separate lines for readability
—>> Indents cannot be used when writing SQL statements
9. Complete the SQL statement for creating tables: CREATE TABLE ___________
database_name
column_name
—>> table_name
table_column
10. The following options describe typical functions of an Information System Department EXCEPT:
Providing medium for recording information.
—>> Providing computers for sale to staff.
Providing storage solutions for information.
Developing techniques for drawing conclusions from information.
JOIN OUR TELEGRAM ON VIP NOUN UPDATES – FOR FREE CIT208 PAST QUESTIONS AND EXAMS SUMMARIES