State three reasons why it is important to define datatypes of fields in a database correctly.8/1/2021 State three reasons why it is important to define datatypes of fields in a database correctly.
Reasons for defining datatypes in databases
0 Comments
A computer technician found it necessary to disable a firewall when working on a computer system. State two reasons that may have necessitated disabling of the firewall.
When firewall is disabled
Write the acronym MODEM in full.
Explain the purpose of a modem when connecting to the internet.
Figure 1 shows relationships between tables in a database.
Identify two primary and two foreign keys used in the relationship.
Primary keys
The following is an extract from a document created using a wordprocessor.
Identify six formats that have been applied on the extract.
(b) State three tools in a wordprocessor that would help a user to minimize spelling mistakes when creating a document. (c) The following is an extract of a spreadsheet created to manage sales. Use it to answer the questions that follow.
(i)Write a formula that will compute the number of items whose unit price is more than 10,000.
(ii) If the formula = $R2 * C$2 was placed in cell D2, state the output if it was copied to D3. (d) A school administers examinations to all students in sciences, humanities and languages. Use the entities; EXAMINATIONS, STUDENTS, SCIENCES,HUMANITIES and LANGUAGES to illustrate a network database model.
RESPONSES
(a) Formats applied
State two ways in which hardware failure is a threat to data security.
State two items that an electronic mail should have for it to be sent.
Items that an email must have:
A student typed a letter in a wordprocessor and the last line of the letter flowed to the second page. State three ways in which the student could have adjusted the letter to fit on one page without changing the paper size.
Ways of adjusting a document to fit a page
A) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks)
B) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks)
C) Interpret each of the following spreadsheet formula:(i) = countif(D2:D9, “>“&B4) (2 marks) (ii) sumif(B3 :B 11, “4M”, D3 :D11) (2 marks) (i) = Countif (D2 : D9, “>“ & B4)
(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:
II. State three properties to be put in place during table design to ensure integrity of the data entered. (3 marks) I) Product Number — Number/Autonumber/Text
Distinguish between a page break and a column break as used in a word processor. (3 marks)
State the function of each of the following features of an email software:
|
Categories
All
Archives
December 2024
|
Can't find what you are looking for? Don't worry, Use the Search Box Below.
Primary Resources
College Resources
|
Secondary Resources
|
Contact Us
Manyam Franchise
P.O Box 1189 - 40200 Kisii Tel: 0728 450 424 Tel: 0738 619 279 E-mail - sales@manyamfranchise.com |