PAST QUESTIONS ON OBJECTIVE
See 2023 Essay and Objectives answers
The database tool that allows the user to select and filter data from multiple tables is referred to as
- A. Form
- B. Table
- C. Query
- D. Report
Correct Answer: Option C
Explanation
A query in a database is a request for information from a database management system (DBMS), which is the software program that maintains data. Users can make a query to retrieve data or change information in a database, such as adding or removing data.
2 . The following statements are steps used in creating a new workbook in a Microsoft Excel application.
I. Click on New
II. Click on the Microsoft Office button
III. Choose blank document Which of the following arrangements shows the correct order of operation from the steps above?
- A. I, II and III
- B. II, I and III
- C. II, III and I
- D. III, II and I
Correct Answer: Option B
Explanation
The steps used in creating a new workbook in a Microsoft Excel application
– Click on the Microsoft Office button
– Click on New
– Choose blank document
Shared-memory is an architecture in
- A. Parallel database
- B. Trusted distributed database
- C. Relational database
- D. Distributed database
Correct Answer: Option A
Explanation
Shared-memory is the architectural model adopted by recent servers based on symmetric multiprocessors (SMP). It has been used by several parallel database system prototypes and products as it makes DBMS porting easy, using both inter-query and intra-query parallelism.
One example of web design package is
- A. MS frontpage
- B. MS outlook
- C. SPSS
- D. Peachtree
Correct Answer: Option A
Explanation
Other examples of web design package
– Adobe Dreamweaver.
– Google web designers.
– Microsoft SharePoint designer.
– Net Objects fusion.
Preventive maintenance measures in computer room do not include
- A. The use of tiles
- B. The use of rugs
- C. Good ventilation
- D. Proper illumination
Correct Answer: Option B
Explanation
Use of rugs is not a preventive maintenance measures
Corrective maintenance of software refers to
- A. Enhancement aimed at making the product faster
- B. Deploying the software to a different hardware platform
- C. Modifications initiated due to defects in software
- D. Making the software easier to understand
Correct Answer: Option C
Explanation
Corrective maintenance is concerned with fixing errors that are observed when the software is in use
(1a)
Information Transmission can be referred to as the process of sending out processed data from one person or place to another in a meaningful form through a communication medium.
(1bi)
The Internet is a globally-connected network of computers that enables people to share information and communicate with each other. While an intranet, is a local or restricted network that enables people to store, organize, and share information within an organization.
(1bii)
A LAN, abbreviated from Local Area Network, is a network that covers a small geographical area such as homes, offices, and groups of buildings. While a WAN, abbreviated from Wide Area Network, is a network that covers larger geographical areas that can span the globe.
(1c)
(i) Hub
(ii) Switch
(iii) Router
(iv) Bridge
(2a)
A database refers to a collection of logically related information organized so that it can be easily accessible, managed, and updated.
(2aii)
(PICK ANY THREE)
(i) MySQL
(ii) PostgreSQLO
(iii) Microsoft SQL Server
(iv) Oracle
(2bi)
(i) Painting
(ii) Drawing
(2bii)
(PICK ANY THREE)
(i) MS Paint
(ii) PC Paintbrush
(iii) Adobe Photoshop
(iv) CorelDraw
(3ai)
A presentation package is a software program that contains a text editor and the ability to add charts and graphic images, such as photographs, clip art, or other objects so as to make a slide show for the purpose of communicating visually to an audience.
(3aii)
(PICK ANY TWO)
(i) Microsoft PowerPoint.
(ii) Macromedia flash.
(iii) Windows movie maker
(iv) Open office
(3aiii)
(PICK ANY THREE)
(i) Presentation packages contain slides.
(ii) Presentation packages allow users to insert pictures and objects into their presentation from external sources.
(iii) Presentation packages allow users to insert video and audio into their presentation from external sources.
(iv) Creation of Graphics
(v) Creating organizational and other types of chart
(3b)
– Click the Find & Select button on the Home tab.
– Select Replace. Press Ctrl + H
– Type the text you want to replace in the Find what box.
– Type the replacement text in the Replace with box.
– Click the Find Next button. The first instance is selected.
– Click Close when you’re finished
No 5 (a)
(i) Click the Microsoft office button
(ii) Click on Microsoft Access
(iii) Click new
(iv) Click the new blank database icon
(v) Type in the name “student_ Record”
(vi) Click create
(5b)
(i) Click the table design button from the create tab
(ii) A blank table appears. Enter each Field
(iii) Enter the name for each field eg ID Number, Full name, Data of Birth, Age and Home address
(v) Enter the field properties using the button panel of each field
(vi) Click save
(5c)
ID_Number ==> Number data type
Full Name ==> Short text data type
Date of Birth ==> Data/Time data type
Home Address ==> Long text data type
(5d)
ID_Number Field
(5e)
It serves as a unique identifier for a row of data in a database table.
(6ai)
(i)Open a blank word document
(ii) On the top, click on insert
(iii) Click the table button
(iv) Click on “insert table”
(v) Go to number of columns band enter 4
(vi) Go to number of rows and enter 6
(vii) Click ok
(6aii)
(i) Select the text you want to use as a hyperlink
(ii) Click the insert tab
(iii) Click on hyperlink