Get documents about "Mid term Exam Fall 2004 - DOC - DOC
Document Sample
Seat No. ___
FACULTY OF BUSINESS ADMINISTRATION
CBIS 111 Computer Applications
Second Semester 2005/2006
MID-TERM EXAMINATION
EXAM DATE : April 19, 2006 (Wednesday)
DURATION : Two hours (6:00 pm - 8:00pm)
STUDENT ID : _____________________ SECTION NO. : ______________
STUDENT NAME : _____________________ INSTRUCTOR : ______________
INSTRUCTIONS:
1. NO books, notes, calculators, mobile phones, electronic dictionaries or computer
professional dictionaries are allowed in the exam. Only CLEAN general dictionaries are
allowed.
2. The total marks for this exam is 100. There are two sections in this exam paper:
Section A: Multiple choices questions (80 marks)
Section B: True or False questions (20 marks)
3. All the answers should be written on the answer-sheets provided. Nothing will be graded
from this exam/question paper.
4. Answers for Section A should be given on the “Examination Answer Sheet” by shading
the most appropriate box/choice with a dark pencil heavily.
5. Answers for Section B should also be given on the “Examination Answer Sheet” by
shading “Option A” for True statements and “Option B” for False statements, with a dark
pencil heavily.
6. Absolutely NO corrections with Correction Fluid/Pen are allowed on the “Examination
Answer Sheet”.
7. The exam paper consists of 13 pages including this covering page.
SECTION A: Multiple Choice Questions - 1 mark each
1. ________ are two of the more widely accessed Internet services.
a) The World Wide Web and e-mail (ans.)
b) FTP and message boards
c) Mailing lists and chat rooms
d) Instant messaging and newsgroups
2. The intent of Internet2 is NOT to ________.
a) relieve bottlenecks in the current architecture
b) replace the current Internet (ans.)
c) enhance tomorrow‟s Internet with advanced technologies and capabilities
d) all of the above
3. In an IP address, the number in each group is between ________.
a) 0 and 255 (ans.)
b) 250 and 555
c) 550 and 755
d) 750 and 955
4. Widely used Web browsers for personal computers include all of the following EXCEPT
________.
a) Netscape
b) Microsoft Internet Explorer
c) Mozilla
d) Microsoft Office PowerPoint 2003 (ans.)
5. When a user specifies a domain name, a ________ translates the domain name into its
associated IP address so data can route to the correct computer.
a) URL client
b) DNS client
c) URL server
d) DNS server (ans.)
6. ________ is the process of a computer receiving information, such as a Web page, from a
server on the Internet.
a) Streaming
b) Downloading (ans.)
c) Flowing
d) Uploading
7. When viewing a Web page, pointing to, or positioning the pointer on, a link on the screen
typically changes the shape of the pointer to a small ________.
a) right-pointing arrow
b) hand with a pointing index finger (ans.)
c) circle with a diagonal stripe
d) lightning bolt
Page 2 of 13
8. Many portals have a ________, which is a Web site that joins a specific group of people
with similar interests or relationships.
a) Web club
b) Web community (ans.)
c) Web klatch
d) Web company
9. A business/marketing Web site ________.
a) contains content that promotes or sells products or services (ans.)
b) offers exciting, challenging avenues for formal and informal teaching and learning
c) contains content that describes a cause, opinion, or idea
d) is maintained by a private individual or family who normally is NOT associated
with any organization
10. Many Web pages use ________, which is the appearance of motion created by displaying
a series of still images in sequence.
a) graphics
b) audio
c) virtual reality
d) animation (ans.)
11. ________ enables users to listen to music as it downloads to their computers.
a) Streaming audio (ans.)
b) Flowing audio
c) Streaming video
d) Flowing video
12. Most e-commerce actually takes place between businesses, which is called ________.
a) consumer-to-business (C2B) e-commerce
b) business-to-consumer (B2C) e-commerce
c) consumer-to-consumer (C2C) e-commerce
d) business-to-business (B2B) e-commerce (ans.)
13. In an Internet e-mail address, a(n) ________ symbol separates the user name from the
domain name.
a) & (ampersand)
b) @ (at) (ans.)
c) * (asterisk)
d) ~ (tilde)
14. ________ is a communications technology used by some outgoing mail servers.
a) SMTP (simple mail transfer protocol) (ans.)
b) ARPA (advanced rural postal addresses)
c) POP (post office protocol)
d) HTML (hypertext mail link)
15. A computer that stores and distributes newsgroup messages is called a ________.
a) news client
b) newsreader
c) news server (ans.)
d) newsmonger
Page 3 of 13
16. In some newsgroups, a posted article is sent to a ________, who reviews the contents of
the article and then posts it, if appropriate.
a) message board
b) newsreader
c) news server
d) moderator (ans.)
17. For ________ to work, both parties must be online at the same time and the receiver of a
message must be willing to accept messages.
a) e-mail
b) FTP
c) instant messaging (ans.)
d) all of the above
18. ________ is an unsolicited e-mail message or newsgroup posting sent to many recipients
or newsgroups at once.
a) An emoticon
b) Spam (ans.)
c) A flame
d) FAQ
19. Use ________, such as :) or :( , to express emotion in an e-mail message or newsgroup
posting.
a) spam
b) FAQs
c) emoticons (ans.)
d) flames
20. All of the following are rules of netiquette EXCEPT ________.
a) be polite and avoid offensive language
b) keep messages brief and use proper grammar and spelling
c) be careful when using sarcasm and humor
d) use all capital letters (ans.)
21. In sequence, the five major steps to Web publishing are: ________.
a) plan a Web site, analyze and design a Web site, create a Web site, deploy a Web
site, maintain a Web site (ans.)
b) analyze and design a Web site, create a Web site, deploy a Web site, maintain a
Web site, plan a Web site
c) create a Web site, deploy a Web site, maintain a Web site, plan a Web site, analyze
and design a Web site
d) deploy a Web site, maintain a Web site, plan a Web site, analyze and design a Web
site, create a Web site
22. Companies called ________ provide storage for Web pages for a reasonable monthly fee.
a) Web browsers
b) Web hosting services (ans.)
c) Web consortiums
d) Web communities
Page 4 of 13
23. When I am using search engine, I should type ________ in the searching box if I want to
display all the results containing the keywords marketing and exact phrase “consumer
behavior”.
a) marketing “consumer behavior”
b) marketing consumer behavior
c) marketing +“consumer behavior” (ans.)
d) marketing –“consumer behavior”
24. In order to enhance the functions of a web browser, ____________ are needed.
a) plug-ins (ans.)
b) hot spots
c) Web logs
d) chat clients
25. ________ is a computer phrase that means users cannot create correct information from
data that is incorrect.
a) First in, first out (FIFO)
b) Rubbish in, rubbish out (RIRO)
c) Garbage in, garbage out (GIGO) (ans.)
d) What you see is what you get (WYSIWYG)
26. Verifiable information ________.
a) gives more value than it costs to produce
b) is arranged to suit the needs and requirements of a decision maker
c) is accurate
d) can be proven as correct or incorrect (ans.)
27. The _______ control the types of activities a user can perform in the database.
a) Data validation
b) Data integrity
c) GIGO
d) Database access privileges (ans.)
28. A DBMS uses the ________ to perform validation checks.
a) data server
b) data dictionary (ans.)
c) data mart
d) data warehouse
29. Although a query language can be used for other purposes, it is commonly used to
________ data.
a) retrieve (ans.)
b) add
c) change
d) delete
30. In a database log, a DBMS stores ________.
a) a copy of a record prior to a change
b) the actual change to a record
c) a copy of a record after a change
d) all of the above (ans.)
Page 5 of 13
31. Compared with relational databases, object-oriented databases ________.
a) allow programmers to reuse objects
b) can store more types of data
c) access data faster
d) all of the above (ans.)
32. ________ is a process designed to ensure the data within the relations (tables) in a
relational database contains the least amount of duplication.
a) Normalization (ans.)
b) Modeling
c) Standardization
d) Querying
33. When compared with a file processing system, a database offers all of the following
EXCEPT ________.
a) reduced data redundancy
b) easier access and shared data
c) reduced development time
d) less required memory, storage, and processing power (ans.)
34. A ________ is the smallest unit of data a computer can process.
a) bit
b) character (ans.)
c) field
d) record
35. ________ is a common data type that consists of lengthy text entries.
a) Numeric
b) Memo (ans.)
c) Object
d) Date
36. A ________ stores data about engineering, architectural, and scientific designs.
a) multimedia database
b) groupware database
c) computer-aided design (CAD) database (ans.)
d) hypertext database
37. The advantage of a multidimensional database is that ________.
a) there is a common query language that compatible with many other databases
b) the content of all dimensions is the same regardless of the subject
c) it can consolidate data much faster than a relational database (ans.)
d) all of the above
38. In a database, a(n) ________ is a group of related fields:
a) character
b) tuple (ans.)
c) file
d) table
Page 6 of 13
39. Which of the followings causes the DBMS uses the log to reenter changes made to a
database since the last save or backup:
a) Roll back
b) Roll forward (ans.)
c) Restore
d) Undo
40. Which of the followings consists of rules and standards that define how a database
organizes data?
a) Data model (ans.)
b) Data dictionary
c) Database applications
d) Web databases
41. A multidimensional database stores data in multiple dimensions, sometimes known as a(n)
________, that allow users to access and analyze any view of the database data.
a) Hypertext
b) Hyperdata
c) Hyperfile
d) Hypercube (ans.)
42. Data warehouses often use a process called ________ to find patterns and relationships
among data.
a) Data mining (ans.)
b) Database querying
c) Database reporting
d) Data modeling
43. Which of the following data type is best suited for storing „sex‟ value?
a) Yes/no (ans.)
b) Auto number
c) Memo
d) Text
44. In database maintenance, which of the following functions are NOT included?
a) Add records
b) Delete records
c) Changing records
d) Creating data files (ans.)
45. Which of the following data validation is suitable for checking whether last name has been
entered?
a) Alphanumeric check
b) Range check
c) Completeness check (ans.)
d) None of the above
Page 7 of 13
46. Which of the following data validation involves at least two fields?
a) Completeness check
b) Consistency check (ans.)
c) Range check
d) None of the above
47. A number(s)/character(s) appended to or inserted into a primary key value to confirm
accuracy of primary key value is ________.
a) Data validation
b) Data dictionary
c) Check digit (ans.)
d) Key field
48. Which of the following(s) is/are the advantages of using database over the file approach?
a) The application is more efficient
b) Shared data (ans.)
c) If the amount of data is huge, database will become simpler to handle and manage
d) The crashes of the database will involve less applications than the file approach
49. Which of the following HTML tag does NOT exist?
a) <BR>
b) <HR>
c) <OL>
d) <UO> (ans.)
50. Which of the following is NOT a physical style tag?
a) <B> and </B>
b) <U> and </U>
c) <center> and </center>
d) None of the above (ans.)
51. A unified set of design elements and color schemes that you can apply to a page to give it
a consistent and attractive appearance inside MS FrontPage is called:
a) Template
b) Themes (ans.)
c) Style
d) Frame
52. Which of the following view is NOT supported by MS FrontPage?
a) Page
b) Frame (ans.)
c) Reports
d) Tasks
53. Logical style tags include:
a) Center
b) Italic
c) Strong (ans.)
d) None of the above
Page 8 of 13
54. In HTML file, we can include ________ as a hyper link.
a) E-mail address
b) Video Clip
c) Other web sites‟ URL
d) All of the above (ans.)
55. Which of the followings is the attribute used to add color to the background of a Web
page?
a) COLOR
b) BACKGROUND
c) BGCOLOR (ans.)
d) All of the above
56. The view in MS FrontPage that is particularly useful for a group of co-worker on
developing a complex web site is:
a) Hyperlinks
b) Tasks (ans.)
c) Reports
d) Folders
57. A type of software that lets you make a Web page without any knowledge of HTML is call
________.
a) MS FrontPage
b) Netscape Composer
c) Authoring software (ans.)
d) None of the above
58. Template is a set of ________.
a) themes (ans.)
b) web pages
c) web sites
d) none of the above
59. Some HTML commands have ________.
a) signs
b) attributes (ans.)
c) tags
d) functions
60. Which of the following is NOT correct to use Frames in MS FrontPage?
a) Divide the page into section
b) Each section display a different page
c) Each section cannot update individually (ans.)
d) All of the above
61. Which of the following CANNOT pre-set by Theme inside MS FrontPage?
a) background
b) title
c) bullets
d) link button (ans.)
Page 9 of 13
62. The following HTML statement tries to create a clickable image:
<A HREF=“http://www.microsoft.com”><IMG ALT = “image.gif”></A>
The statement is incorrectly phrased. How would you modify it so that it works?
a) The <IMG> requires a closing tag
b) Replace ALT with SRC (ans.)
c) The <IMG> should place before the <H HREF…>
d) Nothing wrong
63. Which of the following is NOT a property of HTML file?
a) it is considered as Hypertext
b) it uses tags to format the appearance of the file
c) it is a programming language similar to C and COBOL (ans.)
d) the file will finally be interpreted by the browser for display
64. In HTML, links are created by using the ________.
a) anchor tag (ans.)
b) attributes
c) frames
d) commands
65. To test the appearance of your HTML file, you need to
a) connect to the Internet
b) upload the HTML file to a web server
c) use a browser (ans.)
d) know how to write an HTML document
66. When you organize a HTML document, you will place the <TITLE> tag within which of
the following tag?
a) <BODY>
b) <H1>
c) <EM>
d) <HEAD> (ans.)
67. HTML consists of a set of _______ that tell the browser to perform specific functions.
a) tags (ans.)
b) functions
c) attributes
d) orders
68. Design view of Query is an example of ________.
a) Structured Query Language (SQL)
b) Query By Example (QBE) (ans.)
c) Visual Basic script
d) All of the above
69. To chain/link up tables inside MS Access, ________ is/are created.
a) queries
b) forms
c) reports
d) relationships (ans.)
Page 10 of 13
70. Which data type should be used to store employee‟s photo?
a) Memo
b) Text
c) Object (ans.)
d) Number
71. Create Query using Design View in MS Access is an example of ________.
a) Structured Query Language (SQL)
b) Query By Example (QBE) (ans.)
c) Object Query Language (OQL)
d) All of the above
72. Primary key field is ________.
a) indexed (Duplicate OK)
b) indexed (No duplicates) (ans.)
c) no indexed
d) None of the above
73. In one-to-many relationship creation process, table contains a foreign key is called
________.
a) main table
b) grandfather table
c) parent table
d) child table (ans.)
74. Which of the following data NOT supported by MS Access?
a) Hyper Link
b) Sound clip
c) Digital photo
d) None of the above (ans.)
75. Which table's view is used to view data stored inside a table?
a) Design view
b) Datasheet view (ans.)
c) SQL view
d) Databse view
76. Items listed below are components of MS Access, EXCEPT ________.
a) Tables
b) Queries
c) Micros (ans.)
d) Macros
77. Which of the following information is NOT necessary for a field?
a) Field name
b) Data type
c) Field Description (ans.)
d) Field size
Page 11 of 13
78. To put data with same characteristic in continuous area while designing the report is called
________.
a) Grouping (ans.)
b) Filtering
c) What-if Analysis
d) All of the above
79. Arranging records to display in a typical order called ________.
a) Filtering
b) Grouping
c) Sorting (ans.)
d) Shifting
80. Which data type is used for primary key by default?
a) Text
b) AutoNumber (ans.)
c) Number
d) Object
Page 12 of 13
SECTION B: True/False Questions (A=True, B=False) - 1 mark each
81. No single person, company, institution, or government agency controls or owns the
Internet. (T)
82. Despite their larger size, national ISPs usually offer fewer services and have a smaller
technical support staff than regional ISPs. (F)
83. Every domain name contains a top-level domain, which identifies the type of organization
associated with the domain. (T)
84. To speed up the display of Web pages, most Web browsers allow users to turn off the text
and display only graphics. (F)
85. A Web server can host more than one Web sites. (T)
86. Each hit in the list returned by a search engine has a link that, when clicked, displays the
associated Web site or Web page. (T)
87. QBEs have a graphical user interface that assists users with retrieving data. (T)
88. A database includes a group of related data files. (T)
89. More often, a record is flagged, or marked rather than deleted, so the program will not
process it again. (T)
90. Consistency check is typically applied in primary key field. (F)
91. Data redundancy can increase the chance of error. (T)
92. A database always is simpler than a file processing system. (F)
93. Web page lists can be ordered or unordered. (T)
94. HTML tags can only be typed as UPPER CASE characters only. (F)
95. HTML tags can be nested with other tags. (T)
96. The first page of a web site is named index.htm. (T)
97. MS Access is an example of Object Relational Database. (F)
98. End user can input SQL statement directly inside MS Access to retrieve data. (T)
99. MS Access support one-to-one, 1-to-many and many-to-many three types of relationships
directly. (F)
100. Reports in MS Access are used to input data. (F)
End of Paper
Page 13 of 13
