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. …
Complete the SQL statement for creating tables: CREATE TABLE ___________ database_name column_name —>> table_name table_column Virus-free. www.avg.com
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 …
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
SQL SELECT Syntax: SELECT column__name(s) FROM Table _address Table _format —>> table _name table _data
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)
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
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
The most common view of an Information System is: Input-Storage-Output —>> Input-Process-Output Input-Output-Process Input-Process-Storage
In SQL, the SELECT statement can be used to carry out the following operations EXCEPT: Projection Selection Joining —>> Intersecting
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.
BIO102 Tma Solutions 1. Adult amphibians use for breathing Fins Gills —>> Lungs Nostrils 2. The female reproductive structure in pteridophyte is called —>> Archegonium Archeganium Antheridium Female structure 3. One of these is not an epidermal outgrowth —>> Fingers …
