NOUN eExams Past Questions: CIT208 - Information Systems

Use Past Questions to see how examiner asked questions in the past
Jed
Posts: 1654
Joined: Tue Oct 10, 2017 6:37 pm
Contact:

NOUN eExams Past Questions: CIT208 - Information Systems

Postby Jed » Mon Aug 02, 2021 3:54 am

NOUN eExams Past Questions: CIT208 - Information Systems


FBQ1: _______________________ system is theoretically capable of making decisions for a user based on input supplied.
Answer: Expert

FBQ2: _________________ system typically helps managers to keep track of daily transactions as well as make decision on when to place orders, make shipments and so on.
Answer: Transaction Processing System

FBQ3: ________________ provides mechanisms for storing, organising, retrieving and modifying data for many users.
Answer: Database management system (DBMS)

FBQ4: SQL is an acronym for _____________
Answer: Structured Query Language

FBQ5: _______________ control manages the changes by a logical group of SQL statements.
Answer: Transaction

FBQ6: ___________ clause of the SQL statement is used to view the structure of any database table
Answer: Describe

FBQ7: You have been employed as a Database Administrator in Godiya International Company and are tasked with extracting data from the company’s database. The most appropriate SQL statement to use is the _____________ statement.
Answer: SELECT

FBQ8: When considering RDBMS, a __________ is a collection of related data entries consisting of columns and rows.
Answer: Table

FBQ9: ____________ part of SQL permits database tables to be created or deleted. It also defines indexes (keys), specify links between tables, and impose constraints between tables.
Answer: DDL

FBQ10: In a table containing duplicate values, the __________ keyword is use to select only unique values with the SQL SELECT statement
Answer: DISTINCT

FBQ11: ___________ clause is used to filter records retrieved from a database with SQL
Answer: Where

FBQ12: To filter records based on more than one condition you use the __________operator
Answer: AND

FBQ13: You have been asked to retrieve records from a database sorted is a particular manner. The ________________ keyword is used to sort the result-set by a specified column.
Answer: ORDER BY

FBQ14: In SQL, the _______________ statement is used to insert new records or a new row in a table of a database.
Answer: INSERT INTO

FBQ15: In SQL, the _______________ statement is used to modify existing records in a table of a database.
Answer: UPDATE

FBQ16: In SQL, the ___________ statement is used to remove records and rows in a table of a database.
Answer: DELETE

FBQ17: In SQL, the ______________ statement can be used to extract data from two different tables to form a new table.
Answer: SELECT

FBQ18: In a table, if a row lacks the data value for a particular column, that value is said to be, or to contain a ___________ value
Answer: Null

FBQ19: A __________________ is an organized body of related information that is organized so that it can be easily accessed, managed and updated.
Answer: database

FBQ20: ________________ enforce rules at the table level whenever a row is inserted, updated, or deleted from that table.
Answer: Constraints

FBQ21: _____________ specifies that a column or combination of columns whose values must be distinct and not duplicated for all rows in the table
Answer: UNIQUE

FBQ22: ________________ specifies a condition that must be true
Answer: CHECK

FBQ23: _________________ is an API for the Java programming language that defines how a client may access a database.
Answer:  

FBQ24: You have been asked to access a database using JDBC, the first step you would take is to load the _____________
Answer: Driver

FBQ25: In accessing a database using JDBC, to get an instance of Connection, the ______________ method of the DriverManager class has to be called
Answer: getConnection()

FBQ26: The rows retrieved by the execution of a SQL query are given back by JDBC in the form of a ________ object
Answer: ResultSet

FBQ27: A ___________ model represents entities and relationships between the entities. 
Answer: Conceptual

FBQ28: _________________ can be represented by combining representations of associated entities and properties of their association.
Answer: Relationship

FBQ29: A ___________________ dependency is a constraint between two sets of attributes in a relation from a database
Answer: Functional

FBQ30: The _____________ of a set of dependencies is the set of all possible dependencies that can be derived from it.
Answer: closure

FBQ31: First norm form (INF), Second norm form (2NF) and#####Third norm form (3NF) are all techniques for ________________
Answer:  

FBQ32: When tagging XML documents, we use ___________________ to give meaning to the different elements
Answer: Namespaces

FBQ33: XML documents are made up of storage units called __________________, which contain either parsed or unparsed data.
Answer: entities

FBQ34: _________________ operator is used before a character if it is an operator and it does not consider it as a character and if we put it before a letter it is a constant.
Answer: Backslash \

FBQ35: Which operator (or character) is used to signify the start of a line in a regular expression
Answer: $

MCQ1: Acme Inc. is a global company specialising in the sales of wallets. Which type of information systems is most appropriate for recording and storing the number of goods sold and their inventory?
Answer: Transaction processing system

MCQ2: Which type of information systems is used to make difficult decisions when not every relevant parameter is known beforehand?
Answer: Decision support systems

MCQ3: Which type of information system is built by modelling the thought processes and decision-making heuristics of recognised professional in a particular field?
Answer: Expert systems

MCQ4: The following options describe typical functions of an Information System Department EXCEPT _________________
Answer: Providing computers for sale to staff.

MCQ5: The following options are examples of various types of Decision Support Systems EXCEPT ________________
Answer: Manager information system

MCQ6: The following options describe the various categories into which SQL statement can be divided into EXCEPT
Answer: Data Retrieval Language (DRL)

MCQ7: Which option describes the category of SQL statements that retrieves data from the database, enters new rows, changes existing rows, and removes unwanted rows from tables in the database?
Answer: Data Manipulation Language (DML)

MCQ8: Which option describes the category of SQL statements that sets up, changes and removes data structures from tables?
Answer: Data Definition Language (DDL)

MCQ9: Which option describes the category of SQL statements that gives or removes access rights to both a database and the structures within it?
Answer: Data Control Language (DCL)

MCQ10: The following options are examples of valid rules for the construction of SQL statements EXCEPT
Answer: Indents cannot be used when writing SQL statements

MCQ11: The following options are all summaries of the functions of SQL EXCEPT ____________.
Answer: SQL can create reports from a database

MCQ12: To build a website that utilises data from a database, you will need all of the following EXCEPT
Answer: XML

MCQ13: Which option is the SQL statement used to add new tables to a database?
Answer: CREATE TABLE

MCQ14: When filtering records from database using SQL, which of the following options is NOT a valid operator?
Answer: Approximate

MCQ15: The following options describe the classification of database according to their organisational approach EXCEPT?
Answer: Demand driven database

MCQ16: Which of the following options is NOT a database object?
Answer: Record

MCQ17: Which of the following options is NOT an implementation or driver supported by JDBC?
Answer: Internet Protocol Driver

MCQ18: Which of the following options is NOT a typical step used to access a database with JDBC?
Answer: Loading the database object

MCQ19: Which of the following options is NOT a type of statement provided by JDBC based on the type of query to be executed?
Answer: ProcedureStatement

MCQ20: Which of the following options is NOT a step that a query passes through when sent to the database server?
Answer: Processing the query

MCQ21: All the following options are techniques for data modelling EXCEPT ____________.
Answer: Abstract Modelling

MCQ22: You have been asked to prepare a schema design for a new database, which of the following options would NOT be taken into consideration in the initial design?
Answer: When do the users want to pay for the database design?

MCQ23: The following options are classifications of functional dependency EXCEPT __________.
Answer: Associative functional dependency

MCQ24: There are basically five kinds of keys which are sets of attributes of a relation functionally depending on one or more attributes of the relation, which of the following options is NOT one of them?
Answer: Singular key

MCQ25: The stepwise formal process that allows the decomposition of database tables in such a way that both data redundancy and update anomalies are minimized is known as ________________.
Answer: Database normalization

MCQ26: When writing regular expressions, which of the following options would select only one sequence of alphabetical characters?
Answer: [a-zA-Z]

MCQ27: When writing regular expressions, which operator is NOT used for class repetition?
Answer: /

MCQ28: Which of the following options is NOT the character or string equivalent of this regular expression [a-zA-z0-9_\.]+@[a-zA-Z0-9-]+\.[a-zA-Z]{0,4}?
Answer: Computer_Science@noun.school

MCQ29: The following options are all examples of aggregate functions in Relational Algebra EXCEPT ________________.
Answer: MODE

MCQ30: The Web Service Architecture (WSA) is intended to provide a common definition of a Web service, and define its place within a larger Web services framework to guide the community. The following options are all examples of the characteristics of WSA EXCEPT __________________.
Answer: Repeater

MCQ31: The following options are all common terms used to describe parts of an XML document EXCEPT _____________.
Answer: Node

MCQ32: Which of the following options is NOT an advantage of using XML documents on the web?
Answer: Produces smaller documents

MCQ33: The following options are all characteristics of a well formed XML document EXCEPT ____________.
Answer: Elements are not case sensitive

MCQ34: Which of the following option is NOT an advantage of XML schema over DTD?
Answer: Are faster to parse

MCQ35: To allow for recovery in the event of a database failure, the database recovery logs store information on all of the following EXCEPT ________________.
Answer: Creation of new views



Who is online

Users browsing this forum: No registered users and 1 guest