【计英】Midterm exam整理

阿金的期中考题目（答案不保证全对，仅供参考，如有异议欢迎提出） 更新中...

一、Vocubulary（词汇题）

A.rebrand  给...重塑形象	B.susceptible  易受影响的	C.diretory  目录	D.syntax  句法
E.navigate  浏览，访问	F.interface  接口	G.prepress  印前	H.perfectly  完美地，完全地
L.degrade  降低，削弱（尤指质量）	J.statement  （计算机程序中的）语句	K.legibility  易读性	L.typography  排版，版式
M.successive  连续的，继承的	N.countless  无数的	O.relation  关系，联系	P.takeaway  要点
Q.resolution  分辨率	R.contiguous  连续的，邻近的	S.proprietary  所有（人）的，特有的	T.oversee  监督
U.conjugation  结合，配合；动词的词形变化	V.retrieve  检索，找回，取回	W.intensity  密度	X.pixel per inch  每英寸像素数
Y.thoroughly  仔细地，彻底地	Z.clarity  清晰，清晰度

1、In spreadsheet software, we can______the file we stored in our computer hard disk to open
that file for the modification process at the prepress process.   V

2、Scaling up a raster image,the _____ of that image will be degraded because the image was created by the pixel-besed application software, for instance, the image created by Photoshop,the image created by Paintbrush on Windows.  Z

3、The _______ process refers to the process of creatng a print layout and performing all the steps that lead to tle final print process.   G

4、A 1:1 aspect ratio image or display screen, like the smartwatch display screen or some handheld devices display screen, can be siad to be ________ square.  H

5、It makes sense that Apple would _______OS X to macOS which makes the Mac fit in line with the rest of Apple's software lineup and gives it a more concise and understandable name.  A

6、Most people have heard of a computer virus before. There are ________ kinds of computer viruses, but almost all of them harm your computer or device.  N

7、All vulnerable compuler storage devices such as USB keys and external hand disks are _______ to computer viruses.  B

8、The spatial resolutlon in digital video determines how many pixels are in an individual frame, whereas the temporal resolution determines the fastest change between_________images.  M

9、Most of the SQL database programs also have their _________ extensions and syntaxes in addltion to the SQL standard.  S

10、A telephone__________,commonly called a telephone book or the White and Yellow Pages, is a listing of telephone subscribers in a geographical areas or subscribers to services provided by the organization that publishes the listing of telephone subscribers.  C

11、Each table, sometimes called a/an _________, in a relational database contains one or  more data categories in columns or attributes, Each row, also called a record or tuple, contains aunique instance of data or key for the categories defined by the columns.  O

12、You should always _____ read the instructions on exam papers to get a full 100 score.  Y

13、A desktop publishing document is more than just words on a page with figures added forillustration and interest, The text itself is a form of a graphic, While its shape, size, color, andadditional attributes add to its visuas impact, The study of the letters used to create text is called ________. Understanding how letters are formed is an important desktop publishing skill.  L

14、The arrangement of pixels and lines in a/an ________ (adjacent) region of the memory is called a bitmap. R

15、Typography in multimedia technology is the technique of structuring letters and words in a way that improves the ______ , readability, and even navigation of a website. K

16、In some proprietary SQL-based syntax, an SQL _________ starts with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DRP, CREATE, USE, SHow, and ends with the punctuation semicolon(;). J

17、SQL is followed by a unique set of rules and guidelines called _________. The most important point to be noted here is that SQL is case insensitive, which means SELECT and select have the same meaning in SQL statements. D

18、Pixel pitch is crucial because it determines the level of detail and clarity that can be achieved on nouna display screen, The relationship between pixel pitch and _______ is indirect or in different aspects but related. X

19、 A shell is a/an _______ for access to an operating system's services.It accepts user commands, interprets them, and then communicates with the kernel to execute them. F

20、The Hypertext Markup Language (HTML) is the basic scripting language used by web browsers to render pages on the World Wide Web. The ______s (key points) are that hypertext allows a user to click a link as a crosslink in a nonlinear way to navigate to a new page referenced by the link over text and other elements, markup is the text that appears between two tags (opening tag and closing tag),and content is any multimedia type that web developer designed. P

二、判断题（T/F）

21.Factors affecting the legibility of text are size, background color, and leading of font.  T

22.In the human visual system, the surface of a green apple absorbs all color light rays except the green color that reflects the human eyes. T

23.The temporal resolution determines how many pixels are in an individual frame, whereas the spatial resolution determines the fastest change between successive images.  F

24.Between a handheld device like a smartphone size 4.19"x2.36" with 484 PPl and an HDTV screen size 52"x29" with 36 PPl, we can say that HDTV has a lower resolution.

(4.19*2.36*484 < 52*29*36)  F

25.Resolution is the ratio between the two numbers, width and height, not the numbers themselves, that defines the shape of the image or screen. For example, computer screens featured a 4:3 resolution.  F

三、选择题

26. What is the first database system?  C

A.PostgreSQL

B.MySQL

C.Integrated Data Store (IDS)

D.Oracle

27. What is the digital image file format that the file size is too large and consumes upload-downloading time if it is utilized on a Web page?  B
A.PNG
B.BMP
C.IPG
D.GIF 

 28. What is the digital video file format that offers small file size without sacrificing much in terms of quality and most popular uses on Web pages?  A
A.MP4
B.AVI
C.MOV
D.FLV

29.What is an example of an object-oriented DBS?  C
A. MS SQL Server
B. Oracle
C.PostgreSQL

D.Integrated Data Store (lDS)

30.What is the name of word processing application software that can be said it is a proprietary product of Google?  D
A. Word
B.Sheets
C.Excel
D.Docs

 四、主谓一致

Directions: There are four underlined words or phrases in a sentence or paragraph. The four underlinedparts of the sentence are marked (A), (B), (C), and (D). Identify the one underlined word or phrase thatmust be changed in order for the sentence or paragraph to be correct, Please select only one best answerby choosing only one letter (A or B or C or D) for answering.
active/passive.

31. A terminal is a physical or virtual device that allows(A) users to interact with the shell e.g., macOsTerminal, terminal in a network, It provides a text-based interface through which users are allowed(B) to input commands and view the output, In the context of modern computers, a terminal often refer(C) to a terminal emulator, which is an application software that emulates(D) the behavior ofa physical terminal within a graphical user interface.  C

 (32题没拍到)

33. The memory manager is in charge(A) of the main memory. Every request are(B) scanned to memory space and checks if balances. lt allows the alkocation of the memory space they are(C) not training up already.Memory space may need to be deallocated to free up spaces for other requests(D).  B

34.The Hierrchiaal Model was the first(A) database managemeut system. This concept uses a  hiemnrchical tree structure to organnize the data. The hiererchy begins at(B) the root, which contains root data, and then grows (C) into a tree as child rodes are added to the parent node.This model accurarly depicts diverse real-world relationship(D) such as food recipes, wbsite sitemaps, and so on.  D

 35. Database management softwares are(A) not new concept and as such was first implemented in the 1960s(B). Charles Bachmen's integrated data store is said to be the first DBMS in history, With time, database technologies evolved a lot and never regressed(C) while usage and expected functionalities of database have increased(D) immensely.  A 

五、阅读（此处省略）

六、 问答题

41. What are the differences between kernel and shell in an OS? Please explain.

Kernel is the core component of the operating system, while the shell is an interface for access to an operating system's services.

42. What are the differences between aspect ratio and resolution? Please explain.

Aspect ratio is the ratio of the width to the height of an image or screen, while resolution is the number of pixels contained in our digital image assets.

43. What are the diferences between pixel pitch and pixel per inch(PPI)? Please explain.

Pixel pitch is a method of measuring pixel density, while PPI is the number of pixels contained in one inch of the display.

44. What is the optimal viewing distance to distinguish a P2.5 LED screen? lf the optimal distance can be calculated by pixel pitch (mm)/(0.3-0.8). 

2.5/0.3≈8.33m

2.5/0.8=3.125m