کیا آپ آکسفورڈ یونیورسٹی کے انٹری ٹیسٹ کے سوالوں کے جوابات دے سکتے ہیں؟

کیا آپ آکسفورڈ یونیورسٹی کے انٹری ٹیسٹ کے سوالوں کے جوابات دے سکتے ہیں؟

100 important short question computer science part 1

computer short question
1. What is information technology? 2. What is data, information, software, hardware? 3. Difference b/w application and system software and their types? 4. What is input and input device? 5. What is output and output device? 6. What is function key? 7. What is pointing Device name, name any four? 8. What is joy stick? 9. Difference b/w MICR, OCR and OMR? 10. What is Resolution? 11. What is pixel? 12. What are Arrow keys? 13. Difference b/w VGA, XGA, SVGA. 14. What is CRT? 15. Difference b/w LCD and LED. 16. What do you know about page orientation? 17. What is Plotter? 18. Difference b/w flatbed and drum plotter. 19. Difference b/w bit & byte. 20. Conversion of GB, MB, KB, BYTE, BIT? 21. What is Preliminary investigation? 22. What is Feasibility study? 23. What is CBT? 24. What is E-commerce? 25. What is Operating system? 26. What is E-mail? 27. What is OP-code? 28. What is FTP, TCP/IP? 29. Difference b/w Intranet & Extranet. 30. Difference b/w Downloading and Uploading? 31. What is gateway? 32. What is Router? 33. Difference b/w LAN & WAN. 34. Client Server & peer to peer Model. 35. Difference b/w De facto & De jure Standards. 36. Difference b/w Encoder &Decoder. 37. What is data Communication? 38. Define Signals? Difference b/w analog and digital signal. 39. Difference b/w frequency and amplitude. 40. Difference b/w ASCII & Unicode. 41. Difference b/w Simplex, full duplex, half duplex. 42. Difference b/w asynchronous & synchronous transmission. 43. Difference b/w baseband & broadband. 44. What is Fiber optic cable? 45. What is modem? & Difference b/w internal, external, wireless modem 46. Role of computer in Business, Medical. 47. What is robot? 48. How computer use in office automation. 49. Difference b/w CU & ALU. 50. Difference b/w series and parallel transmission. 51. Difference b/w RAM & ROM. 52. What is ATM? 53. What is CAD, CAM? 54. Difference b/w DRAM & SRAM. 55. Define I/O unit. 56. What is cache memory? 57. What is Fetch, Decode, Execute cycle? 58. Difference b/w Compiler and Interpreter. 59. What is Assembler? 60. Define source code & object code. 61. Difference b/w high level language & low level language. 62. Define command line/prompt. 63. Define security. 64. What is virus? How we remove virus. 65. What is antivirus? 66. What is Boot Sector virus & write some causes of virus? 67. What is GUI operating system? 68. What is Plug & Play? 69. Define Disk Management or Disk Management Utility. 70. Define File Management. 71. Define window explorer. 72. What is print queue? 73. What is word processor? 74. Define Header and Footer in MS Word. 75. What is thesaurus? 76. Define Macros. 77. What is Undo & Redo? 78. What is spread Sheet software? 79. Define Formula bar. 80. Difference b/w relative and absolute referencing. 81. Define Function. 82. What is sheet in MS Excel? 83. ARPA Stands for??? 84. What is Internet? 85. What is IP Addressing? 86. Define DNS Addressing. 87. Define web browser? 88. What is WWW (World Wide Web)? 89. What is URL (uniform resource locater)? 90. Define Search Engine. 91. Write part of Email Address. 92. What is HTTP, HTML? 93. Difference b/w Multitasking & Multiprocessing. 94. What is password? 95. Name some famous antivirus and explain briefly. 96. How viruses may damage computer system? 97. Describe Bus and its types. 98. Define the general-purpose registers. 99. Explain the architecture of computer system. 100. Difference b/w Address bus and control bus. 101. Difference b/w serial and parallel ports. 102. Difference b/w linker and loader. 103. What is meant by computer simulation? 104. What is topology? Its types. 105. What is DSL, ISP? 106. Difference b/w guided and unguided media.107.define barcode and barcode reader. 108. Importance of backup. 109. Define DMA. 110. RAM called volatile memory, Justify. 111. Use of clipboard. 112. 4 Different function of MS Excel. 113. Define video conferencing. 114. How we create web pages. 115. Define ARC NET. 116. Define Magnetic strip card. 117. Use of recycle Bin. 118. What is Bus interconnection? 119. Define stack. 120. Write 4 search engine.

Important Long Computer science part 1

computer science
Important Long Question
1. Explain different type of non-impact printer.
2. Discuss different6 type of network models.
3. Explain Fetch-Decode-Execute cycle.
4. How we protect our computer system from virus. Types of virus & Also explain causes of virus
5. What is transmission mode? Explain its types.
6. Discuss different function of operating system.
7. What is data communication? Explain the basic components of communication network.
8. Discuss any three pointing devices.
9. Describe OSI Model? And type of OSI layers.
10. What is topology? Discuss the type of topology.
11. Difference b/w RAM and ROM. Type of RAM & ROM.
12. What is guided media? Briefly describe the guided media.
13. Discuss different security threats to data security. What are the solution of these threats?
14. Define software. Discuss different type of software.
15. Define CPU explain its parts.
16. Explain different type of display screen.
17. What do you understand by “SDLC”? Discuss its steps properly.
18. What do you know about email?

Computer science guess paper 2016

Computer Science Short Questions , Mcqs Notes Chapter 4 to 5

All Banks are providing ______________ service.
Internet
ATM
LAN
Online Education
2
CBT software is used in:
Educatin
Forcecasting
Manufacturing
None
3
Which of the following is not example of e-commerce.
Electronic Banking
Electronic shoping
Online Store
Online Chating
4
Most applications of robotics are in which area?
Cooking
Manufacturing
Teaching
Farming
5
Thr fly-by-wire system is used in:
Medical field
Airline
Education field
None
6
Which of the following is relate to businees?
Marketing
Stock exchange
Banks
All
7
Which of the following is relevant to office automation?
Document management system
Message handling system
Office supports system
All
8
MICR stands for:
Magnetic Card Reader
Magnetic Character Reader
Magnetic Ink Character Reader
None
9
CAT stands for:
Computerize Axial Topography
Computer Axial Topography
Computer aided topography
None
10
Computer based weather forecasting depends on accurate collection of data from:
Television
Weather station
Reader
Antena
11
Modern computer can perfor calculations or proess at:
Per second
Per minute
Nino second
None
12
CAL stands for:
Computer aided learning
Computer assist leaning
Computer added leanrning
None
13
A word processor can be used to:
Write text
Edit text
Print text
All
14
CBT stands for:
Computer based trade
Computer based training
Certificate based training
none
Q-2: Write short answers any TEN, each question carry 2 marks. 2×10=20
i. What is meant by online education.
ii. Write some advantages of video conference.
iii. What is Video Conference?
iv. Define E.Commerce.
v. What is E. Shoping?
vi. How a computer is useful in weather forecasting?
vii. Write use of computer in airline system?
viii. What is meant by computer simulation?
ix. What is meant by computer aided design?
x. Howa robots are use in industries?
xi. What is meant by rprographics?
xii. What is desktop publishing?
xiii. What is the importance of using computer?
xiv. How banks can get benefits from a computer.
Q-3: Write detail answers of the following questions. 2×8=16
1. What is E-Commerce? Discuss its role in our daily life.
2. Discuss the impacts of computer technology on the society.
ALU has _________ units.
2
3
4
5
2
Usually RAM has types:
1
2
3
4
3
CU stand for:
Cache unit
Calculating unit
Calculate unit
Control Unit
4
What is the main purpose of secondary storage device:
Calculating Data
Temporary Storage of Data
Permanent Storage of data
Output of information
5
A program’s syntax errors are detected by:
Compiler
Linker
Loader
Debugger
6
The external devices that are connected to a computer system are known as:
Expansion Cards
Peripherals
Buses
Slots
7
Expansion are inserted into:
Slots
Peripherals devices
CPU
Back of the computer
8
Which is not a kind of register?
Flag
Segment
Accumulator
Math coprocessor
9
The size of accumulator register can be up to:
4 bit
4 KB
4 bytes
4 MB
10
Which one is faster:
RAM
Cache
Register
Hard Disk
11
Memory is made up of:
Set of wires
Set of circuits
BIOS
None
12
A characteristic of ROM if that it is:
Recursive online memory
Rapid online memory
Random only memory
Read only memory
13
Which is the brain of computer:
CPU
RAM
Motherboard
System unit
14
Which is not output device:
Scanner
Speaker
Monitor
Printer
Q-2: Write short answers any TEN, each question carry 2 marks. 2×10=20
i. What is computer architecture?
ii. What is CPU?
iii. What is arithmetic and logic unit (ALU)?
iv. Why is RAM called Random Access Memory?
v. What is funcation of I/O unit?
vi. What is SRAM?
vii. What is EEPROM?
viii. What is Cache memory?
ix. What is motherboard?
x. What is stack ?
xi. What is use of serial port?
xii. What do you known about I/O devices?
xiii. What is compiler?
xiv. What is interpreter?
Q-3: Write any two answer from the following questions. 2×8=16
i. Explain the architecture of computer system. Which type of component are include in computer architecture?
ii. Explain the different types of buses?
iii. What are the CPU register?

Important question for ICS computer science Part 1

What is OSI model? List all the layers of OSI model. Explain any four layers in details. Also draw the diagram of OSI model
What is computer software? Explain its different types in details
What is computer hardware? Explain its different types in details
Define output? What are the different types of output?
What is the purpose of Date Protection Act? Write down the Data Protection Principles
Explain different Data types with the help of examples
Difference between input and output giving three differences
What is difference between LAN and WAN
Write a detailed note on advantages and disadvantages of internet
What is internet? Discuss in detail different services of internet
What is ring topology? Explain its working with diagram. Discuss the advantage and disadvantages
What is topology? Write note on any two of the following:
Star
Ring
Bus
Briefly discus different general purpose of registry
What are the basic elements of data communication system? How is data communicated by using telephone lines? How is analog data converted into digital data?
What is data communication? Explain basic components of data communication and explain different types of data communication modes
What is printer? Describe the different between impact and non-impact printer and also mention their types
Write a note on modem. Describe its feature
Discuss different events of mouse and keywords
What is unguided media? Explain the different unguided media
Explain the architecture of a computer system with the help of diagram. Explain its major components
How media is important in communication? Discuses any three communication media, in term of security, cost, and speed
What are CPU registers? Describe special purpose registry in details
Define CPU and explain its parts
Explain the Fetch-Decode-Execute cycle of CPU
Define display screen. Explain its different types
What is an operation system? Explain different objects of windows operating system
Explain the important features of Window operating system
What is the necessary to protect your computer from virus? Briefly describe five ways to protect your computer from virus. And write a note on any two types of viruses
What is computer virus? List three ways in which viruses can spread. Also mention three precautionary steps you can take to protect your computer from the threat of viruses
Explain different ways of editing text in MS Word
Explain the following with reference to word processing
Word Wrap
Header and Footer
Spell Checking
Write a short not on word processing
Differentiate between header and footer with footnotes and endnotes
Define excel. Explain its importance with the help of its functions
Define PowerPoint. Explain its importance in business
Describe different network connectivity devices used to connect computer network
Explain different network models and their advantages and disadvantages
What is network standard? Discuss different types of network standards
What is the meant by encoding of data? Explain different coding schemes to represent data
What is the meant by data security? Briefly discus different security threats of data security. And what are the solutions to these threats
Describe language processors or translator and their use. Discuss different types of language processors

ICS Notes Computer Science Part 2 Chapter 6 Table and Query Short Questions

ICS Notes Computer Science Part 2 Chapter 6 Table and Query Short Questions

Q 1. What is a table?
Ans. Table is a collection of rows and columns. Each intersection of row and column is called a cell. Cell is the place where data is placed. Table is the fundamental object of relational database. Table is also known as relation. Each row represents a tuple and each column represents an attribute of an entity. Table or relation itself represents an entity.

Q 2. What is meant by degree of relation?
Ans. The number of fields of a relation is called the degree of the relation. A table's degree is specified at the time of creation. But as a rule it can be changed at any time. Change in degree of a table may cause data loss.

Q 3. What is meant by the cardinality of the relation?
Ans. The number of records in a table is called the cardinality of that table. Cardinality of a table changes as new records are added or previous records are deleted. For example a table having 40 rows/records has cardinality 40.

Q 4. What are two two table views available in Microsoft Access?
Ans. Design view and Datasheet view.

Q 5. What is Test data type?
Ans. It is the default data type of a field in MS Access. It can contain text or combination of text and numbers, as well as numbers that don't require calculations, such as  phone numbers. Its size is 255 characters or the length set by the FieldSize property, whichever is less. Microsoft Access does not reserve space for unused portions of a text field.

Q 6. What is Memo data type?
Ans. A text type field that can contain more than 64000 characters. It is used for long description.

Q 7. What is Number data type?
Ans. This field is used to store numeric data for mathematical calculations. Size of this data type can be 1. 2. 4 or 8 bytes (16 bytes if the FieldSize property is set to Replication ID).

Q 8. What is AutoNumber data type?
Ans. A unique sequential (incremented by 1) number or random number assigned by Microsoft Access whenever a new record is added to a table. AutoNumber fields can't be updated. Its size is 4 bytes.

Q 9. What is the use of Default view?
Ans. In some cases, the value of all records in a certain field is same. A default value can be set in this case. The user does not need to type the same value again and again. The property set the default value is used to set default value for a field.

Q 10. What is sorting?
Ans. Arrangement of data in a particular sequence is called sorting. The sequence can be in ascending or descending order.

Q 11. What is referential integrity?
Ans. Referential integrity is a system of rules that ensures that relationship between records in related tables are valid and that you don't accidentally delete or change related data. To enforce referential integrity both tables must have at least one common field, which have same data type and size.

Q 12. What is a query?
Ans. A query is a question that requires some data from the database. A query is created by specifying fields to display their from a table or another query. It can also specify condition for extracting data. Queries select records from one or more tables in a database.

Q 13. What is a join?
Ans. A query that extracts data from multiple tables is called join. It uses the relationship of tables to get data.

Q 14. What are wildcards?
Ans. Wildcards is a special symbol that is used in queries to search data. Some important wildcards are *, ? and #. Wildcards characters are meant to be used with fields that have the Text data type. You can sometimes use them successfully with other data types, such as dates.

Q 15. Define criteria in a query?
Ans. A condition used to limit the number of rows extracted from database is called criteria. For example, instead of viewing all the suppliers that your company uses, you can view just suppliers form China. To do this, you specify criteria that limits the results to records whose Country field is "China".

ICS Notes Computer Science Part 2 Chapter 5 Introduction to Microsoft Access Short Question with answer

Q 1. What is Microsoft Access? Ans. It is one of the most popular and powerful DBMS. It provides the features to the users to create and maintain databases. We can create tables, forms, queries and reports using MS Access.
Q 2. What is wizard? Ans. A wizard is a helper application that makes performing complex tasks easier. A wizard has a simple decision in a window, which has back and next buttons underneath. When you have filled in the required data, you click the next button to go to the next window, or you can click the back button to change your previous decision.
Q 3. What is menu bar? Ans. It is the second bar from top. It consists of many words. Each word on this bar represents a menu. Every word on this bar also has a character underlined. This underlined character represents the short cut key combination for that particular menu.
Q 4. What is database object? Ans. A component of database system is known as database object. These database objects are used to manage data.
Q 5. What is a table? Ans. Table is a collection of rows and columns. All the intersection points of rows and columns are called cells. In these cells data can be stored. Each column of table represents a field. Each field is specified to store a particular type of data. Table can be viewed in different ways but most commonly used are datasheet view and design view.
Q 6. What is a query? Ans. Query is a database object used to get data from the database. In query we can specify a certain criteria to get the required data. The actual objective of data storage is that it can be retrieved when ever required. Using query object data can also be deleted and updated.
Q 7. What is a form? Ans. The window that is used to enter data into the database is called a form. Using form data can be entered, edited and even viewed in Microsoft Access. Data entered in forms directly goes to the tables. Forms are always made after table creation. The fields on forms are linked to the table fields.
Q 8.  What are reports? Ans. Reports are database objects used to represents queried data in a presentable format. Not all but most of the RDBMS provides this facility to its users. Reports can be generated on the basis of tables and queries. We can apply formatting on the reports to make them more presentable and understandable.
Q 9. What is an IDE? Ans. IDE stands for integrated development environment. It is a simple and easy way to do a task. It presents graphical objects like buttons, icons and menus to perform certain operations. Using IDE a new user and programmer can easily do their jobs. MS Access also provides the same facility for its users.

ICS Notes Computer Science Part 2 Chapter 4 Data Integrity and Normalization Short Questions

Q 1. What is meant by entity integrity?
Ans. It is a constraint on entity. Entity integrity is an integrity rule which states that every table must have a primary key and that the column or columns chosen to be the primary key should be unique and not null. A direct consequences of this integrity rule is that duplicate are forbidden in a table. If each value of a primary key must be unique no duplicate rows can logically appear in a table. This NOT NULL characteristic of a primary key ensures that a value can be used to identify all rows in a table.

Q 2. What is referential integrity? 
Ans. It is a constraint on foreign key. If a foreign exists in a relation then either the foreign key value must match the primary key value of some tuple in its parent table or the foreign key value must be completely NULL.

Q 3. What is redundancy?
Ans. Redundancy appears when same data values are stored more than once in a table. It is also called redundancy if the same values are stored in more than one table.

Q 4. What is normalization?
Ans. Normalization is s process of converting complex data structures into simple and stable data structures. It is a technique for reviewing the list of entities and their attributes to ensure that attributes are stored from where they belong. In other words we can say that it is a process of analyzing the dependencies of attributes within entities.

Q 5. What is repeating group?
Ans. Repeating group is a set of one or more data items that may occur a variable number of times in a tuple.

Q 6. What are database anomalies?
Ans. These are certain situations created when one or more records are deleted, modified or inserted in the database and the databases goes into an inconsistent state.

Q 7. What is insertion anomaly?
Ans. Insertion anomaly occurs when a new record is inserted in the relation. In this anomaly user cannot insert a fact about an entity until he has an additional fact about another entity.

Q 8. What is deletion anomaly?
Ans. The deletion anomaly occurs when a record is deleted. In this anomaly the deletion of a record automatically deletes the fact of another entity.

Q 9. What is modification anomaly?
Ans. The modification anomaly occurs when the record is updated in the relation. In this case the modification in the value of specific attribute requires modification in all records in which that value occurs.

Q 10. What is partial dependency?
Ans. A type of dependency in which one or more non-key attributes are functionally dependent on a part of primary key.

Q 11. What is transitive dependency?
Ans. The transitive dependency is a type of functional dependency between two or more non-key attributes. It exists if a non-key attribute depends on any other non-key attribute.

Q 12. What is integrity constraint?
Ans. Integrity means the correctness and consistency of the data. Integrity is usually expressed in terms of certain constraints which are the consistency rules  that the database is not permitted to violate. Integrity is also concerned with the quality of data. Integrity is maintained with the help of integrity constraints. These constraints are the rules that are designed to keep data consistent and correct.

Q 13. What is 1st Normal form?
Ans. A relation is in 1st normal form if and only if all underlying domain contain atomic values only. Each cell should contain only one value and relation does not contain any repeating group.

Q 14. What is 2nd Normal form?
Ans. A relation is in 2nd normal form if it is in 1st normal form and every non-key attribute is fully functionally dependent on the primary key. All on-key attribute must depend on primary key.
Following are a few conditions for 2nd normal form.

• The primary key consist of only one attribute.
• No non-key attributes exist in the relation.
• Every non-key attribute is functionally dependent on the primary key.

Q 15. What is 3rd Normal form?
Ans. A relation is in 3rd normal form if it is in 2nd normal form and no transitive dependencies exist. Transitive dependency is a functional dependency between two or more non-key attributes of a relation.