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: [email protected]
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
