Review Final Exam CS 101 Spring 2021 1

Review Final Exam CS 101 Spring 2021

1. The HTML tag <a href= A. B. C. D. creates a table starts a hyperlink must be balanced with a </a> tag all the answers but A.

2. A browser is made to interpret A. Binary codes and show the calculations on the screen B. HTML and show a web page on the screen C. ASCII codes and show the Unicode D. A programming language like Java and show the result

3. Indexing a field in a DBMS A. B. C. D. Makes it able to hold more data Makes searches and sorting a bit faster Makes editing a record faster Erases any inconsistent records

4. An HTML tag <li> is used A. B. C. D. To draw a horizontal line across the screen To start a new list item in a list To start a new row in a table To make a word underlined

5. Concurrent access of database files A. Means users using the same database management system at the same time B. Means two or more users using the same database file across the network C. Can cause errors in the database file if two users are allowed to read at the same time D. Is allowed by MS Access by creating the lock file

6. The HTML tag <title> A. Creates a big banner at the top of the web page B. Puts a message in the title bar of the browser window C. Gives the default value for the bookmark text for that page D. B and C

7. The World Wide Web was created by A. B. C. D. Bill Gates Vint Cerf ICANN Tim Berners-Lee

8. The constraints on a key field are A. The values of the field have to be unique B. The field cannot be empty in any record C. It must be a text field D. A and B

9. A DBMS which is used for very large amounts of data in business is A. my. SQL B. Oracle C. MS Access D. DB 2

10. Referential integrity has to do with A. DBMS enforcing relationships between tables B. A DNS server translating between IP numbers and domain names C. HTML code being interpreted by a browser D. A translator changing high-level code to machine code

11. A is one-to-many with B means A. B. C. D. For one A, there is zero or more B’s For one B, there is one or more A’s B must be a numeric field Both A and B are true

12. Data validation in a DBMS includes A. B. C. D. checking the data types of the values entered checking the data values for accuracy checking the correct fields are indexed all of the answers

13. A CLI is A. An interface where the user must remember the commands and filenames, not friendly B. An interface using a pointing device, icons, drop-down menus, a visual metaphor C. A part of an OS which handles the memory in the computer D. A kind of file format which allows for animation and simple colors

14. An operating system made by Bell Labs, open source, free, stable, is A. Windows B. Unix C. Linux D. i. OS E. Android

15. If the rabbit is facing the door rabbit. move (two meters) else rabbit. turntoface(door) This is an example of which control structure? A. A loop / repetition B. A branch / selection C. A module D. A sequence

16. Multitasking A. Requires more than one CPU B. Can only handle 3 tasks at a time C. Is a simulation (an illusion) if done on one CPU D. Is not available yet, is still under research

17. The front end of a DBMS is A. B. C. D. the ability to sort data in any order the user interface to interact with the data the software that allows backups to be made the price for the first version of the software

18. The “or” operator in a query A. Will always give more results than an “and” operator B. Is expressed by putting different criteria on different lines in the query table C. Will give a hit only if both criteria are satisfied D. None of the answers

19. CPUs understand A. English B. High level languages C. Machine language D. pseudocode

20. A syntax error happens when A. The program tries to divide by zero B. The programmer misspells a keyword in the language C. The programmer multiplied by 10 when they mean to multiply by 100 D. The program tries to open a file that does not exist

21. DRM is A. A programming language B. An old operating system made by IBM C. A sound file format D. Copy protection for songs, movies, books, etc. E. None of the above

22. An algorithm is A. a low-level language translator B. a set of instructions to solve a problem C. a compiler D. something only programmers use

23. In Alice it’s hard to A. Make a syntax error B. Use a loop C. Erase a statement from a program D. Run a program

24. The PNG file format A. B. C. D. Is for sound recordings Is the oldest image format Is a descendant of the GIF format Can do animations