By QB365 on 31 Dec, 2022
QB365 provides a detailed and simple solution for every Possible Questions in Class 12 Computer Application Subject - Important 3 Mark English Medium. It will help Students to get more practice questions, Students can Practice these question papers in addition to score best marks.
12th Standard
Computer Applications
Answer All Questions
Briefly explain about Multimedia Components.
What is PageMaker? Explain its uses.
Differentiate Server side and Client Side Scripting language.
Differentiate user defined and system defined Functions.
Differentiate Switch and if else statement.
Differentiate For each and While loop.
Write the purpose Get method and Post method.
Write is the purpose of MySQLi function available.
How computer networks are money saving?
Write the disadvantages of Internet.
Write short notes on HTTP, HTTPS, FTP.
Differentiate Domain name and URL
What are the differences between serial and parallel ports?
List out the Popular open source software.
Compare and contrast the credit card and debit card.
Differentiate asymmetric and symmetric algorithms.
List the various layers of EDI.
How is Multimedia available in public places?
What are the phases involved for development of complex multimedia projects?
Write the steps to Select Text using the Keyboard.
How can you make characters superscript or subscript?
What are the major the functions performed using SQL?
How does the WebServer work?
What is an array data type in PHP? Give example.
Give the example for parameterized function with two arguments?
What are feature of else ... if ladder statement?
Write a PHP program to display the following
Write about Generic Top-Level Domain names.
Write about roll-over cables briefly.
What is Amphenol connector?
Answers
They are explained below :
i) Text :
1. Text is the basic components of multimedia and most common ways of communicating information to other person.
2. Text component is classified into two such as (a) Static text (b) Hypertext.
ii) Images:
Images in multimedia are generated in two ways.
a) Raster or Bitmap Images
b) Vector Images.
iii) Animation :
Animation is the process of displaying still images with continuous movement.
The two basic types of animations are (1) Path animation (2) Frame animation.
iv) Sound :
Sound is a meaningful speech in any language and providing the pleasure of music, special effects and so on.
v) Video :
1. Video is defined as the display of recorded event, scene, etc.
2. The video can be categorized in two types as (1) Analog video and (2) Digital video.
(i) Adobe PageMaker is a page layout software
(ii) It is used to design and produce documents that can be printed.
(iii) A simple business card to a large book can be created.
(iv) Page layout software includes tools that allows to easily position text and graphics on document pages.
(v) Pictures and text next to each other, on top of each other, or beside each other can be placed.
Basis for comparison | Server-side scripting | Client-side scripting |
---|---|---|
Basic | Works in the back end which could not be visible at the client end. | Works at the front end and script are visible among the users. |
Processing | Requires server interaction | Does not need interaction with the server |
Languages involved | PHP, ASP.net,Ruby on Rails, ColdFusion, Python, etcetera. | HTML, CSS, JavaScript, etc. |
Affect | Could effectively customize the web pages and provide dynamic websites | Can reduce the load to the server. |
Server-side scripting |
Relatively secure. | Insecure |
User defined Functions | System define Functions |
---|---|
(i) Functions are provided by the user. (ie) we can create own functions. | (i) Built-in function are functions that exist in PHP installation package. |
(ii) Example function insertMsg() { echo "Helo world" } insertMsg(); |
(ii) Example rename_function() |
Switch Statement | If else statement |
---|---|
Switch statement uses single expression for multiple choices. | if-else statement uses multiple statement for multiple choices. |
It test only for equality. | It test for equality as well as for logical expression. |
Statement will be executed is decided by user. | Evaluates any type |
If switch statements does not match any cases, the default statements is executed. | If the condition fails, then by default the else statement is executed. |
For each loop | While loop |
(i) It provides an easy way to iterate over arrays. | (i) It is used for simple iteration logics. |
(ii) Loop iteration depends on each KEY value pair in the Array | (ii) It executes block of code while the specified condition is true. |
(iii) Syntax: for each (Sarray as $value) { code to be executed; } |
(iii) Syntax: while (condition is true) { code to be executed; } |
The GET and POST methods are used for sending the data to the server and the main difference between them is that GET methods append the data to the URI defined in form's action attribute POST methods attaches data to the requested body.
In PHP Scripting language many functions are available for MySQL Database connectivity and executing SQL queries. MySQLi is extension in PHP Scripting language which gives access to the MySQL database. MySQLi extension was introduced version 5.0.0.
The MySQLi extension contains the following important functions which are related to MySQL database connectivity and management.
i) Mysqli_connect() Function
ii) Mysqli_close() Function
iii) Mysqli_query() Function
Computer networking is also money saving as it reduces paper work, manpower, resources sharing, software sharing and also time saving.
1. Simply wasting the precious time on Internet by surfing, searching unwanted things.
2. Lot of unnecessary information is also there, why because any one can post anything on their webpage, blogs.
3. Hackers and viruses can easily theft our more valuable information available in the Internet. Lot of security issues are there in E-banking.
(i) HTTP: A protocol used between a web client and a web server protects non-secure data transmissions. The core protocol of the World Wide Web.
(ii) HTTPS: A protocol used between a web client and a web server permits secure data transmissions.
(iii) FTP: Used between computers for sending and receiving data. Enables a client to send and receive complete files from a server.
URL | Domain Name |
---|---|
(i) It is sequence of labels. Sequence of labels are separated by dot(.) | (i) URL is the address of a document on the Internet |
(ii) Domain name is always read from the lower level to higher level (ie) From leaf node to root node. | (ii) URL is made up of four parts - protocols, hostname, folder name and file name. |
(iii) Since the root node always represented NULL string, all the domain name ending with dot. | (iii) Each part has its own specific functions.Depending on the applications, additional information can be added to the URL. |
S.No | Serial Port | Parallel Port |
---|---|---|
1. | It transmit the data one bit at one time. | It transmit the data 8-bit at one time. |
2. | Slower than the parallel port | Fast than a serial port |
3. | RS232 is type of serial cable, also known as Null modem cable. | Used to connect the printer and other disk drives. |
NS2, OPEN NMS, Ubuntu, MySQL, PDF Creator, Open Office, 7zip GNUCASH, GIMP, BLENDER, AUDACITY, VLC, MOZILA FIREFOX, MAGENTO, ANDROID, PHP.
No | Basic | Debit card | Credit card |
1. | Transaction limit | Associated with your account. | Work as a short term borrowing instrument. |
2. | Repayment requirement | No repayment required. | Repayment of used fund with in stipulated period. |
3. | Penalty | No Penalty | Interest after due date and penalty on new payment. |
4. | Credit score | Does not impact credit score. | Over dues, non payment and dues settlement can negatively impact the credit score. |
5. | EMI facility | You can't buy items on EMI. | You can buy items on EMI. |
Symmetric Key Encryption | ASymmetric Key Encryption |
---|---|
Same key is used for both encryption and decryption | Different keys is used for encryption and decryption |
Speed of encryption or decryption is very fast | Speed of encryption or decryption is comparatively slow |
Plain text and cipher text are of same size | The size of cipher text is always greater than plain text. |
Algorithms like DES, AES, RC4 uses symmetric key encryption | Algorithms like RSA, ECC, DSA use asymmetric key encryption |
The number of key used grows exponentially with the numbers of users | The number of key used grows linearly with the numbers of users |
Provides confidentiality. | Provides confidentiality, authenticity and non- repudiation. |
Electronic data interchange architecture specifies four different layers namely
(i) Semantic layer
(ii) Standards translation layer
(iii) Transport layer
(iv) Physical layer
(i) Multimedia is available in many public places like trade shows, libraries, railway stations, museums, malls, airports, banks, hotels and exhibitions in the form of kiosks.
(ii) The information presented in kiosk are enriched with animation, video, still pictures, graphics, diagrams, maps, audio and text. Banks uses kiosks in the form of ATM machines.
Adequate time and efficient planning is required for multimedia production, which assures that the project will be proceed smoothly and certainly ensures that the information reaches the target audience.
Following are the phases for development of complex multimedia projects.
1. Conceptual Analysis and Planning
The process of multimedia making begins with a conceptual ignition point. Conceptual analysis identifies a appropriate theme, budget and content availability on that selected theme. Additional criteria like copyright issues also are considered in this phase.
2. Project design
i. Once the theme is finalized objectives, goals, and activities are drawn for the multimedia project.
ii. General statements are termed as goals.
iii. Specific statements in the project is known as the objectives.
iv. Activities are series of actions performed to implement an objective.
v. These activities contribute to the Project design phase.
3. Pre-production
Based on the planning and design, it is necessary to develop the project.
4. Budgeting
Budgeting for each phases like consultants, hardware, software, travel, communication and publishing is estimated for all the multimedia projects.
5. Multimedia Production Team
i. The production team for a high end multimedia project requires a team efforts.
ii. Team comprises of members playing various roles and responsibilities like Script writer, Production manager, Editor, Graphics Architect, Multimedia Architect and Web Master.
6. Hardware/Software Selection
i. Hardware includes the selection of fastest CPU, RAM and huge monitors, sufficient disc for storing the records.
ii. Software and file formats depends on the funds available for the project being developed.
7. Defining thc Content
Content is the "stuff " provided by content specialist to the multimedia architect with which the application is developed, who prepares the narration, bullets, charts and tables etc.
8. Preparing the structural
Detailed structure defines the activities, responsible person for each activity and the start/ end time for each activity.
9. Production
i. After the pre-production activities, the production phase starts
ii. Activities like background music selection, sound recording and so on
iii. Text is incorporated using OCR software Pictures shot by digital camera, video clips are shot, edited and compressed.
iv. A pilot project is ready by this time
10. Testing
i. Thecomplete testing of the pilot product is done before the mass production to ensure that everything is in place, thereby avoiding the failure after launch
ii. If it's an web based issues, it is tested with different browsers
iii. If it is on a LAN, it must be deployed in the server for testing purpose.
iv. After the testing process are over, the product is incorporated with valid suggested changes.
11. Documentation
i. User documentation is mandaory feature of all multimedia projects till the completion of testing
ii. contact details, e-mail/ID and phone number are provided for technical support and sending suggestions and comments
To select text using a keyboard, follow these steps:
1. Place the Insertion point to the left of the first character you wish to select
2. The Shift key is pressed down and the movement keys are used to highlight the required text.
3. When the Shift key is released, the text is selected
To Select | Press |
---|---|
One character to the left | Shift + ⇠ |
One character to the right | Shift + ⟶ |
One line up | Shift + ↑ |
One line down | Shift + ↓ |
To the end of the current line | Shift + End |
To the beginning of the current line | Shift + Home |
Entire Document | Ctrl + A |
You can change the text in Superscript or Subscript from Control palette.
1. Select the character that you want to change Superscript or Subscript.
2. Click on one of the buttons in the Control palette. Superscript (T2 ) Subscript (T2 )
3. The character you selected changes to the required one.
Few major functions performed using SQL are listed below:
(i) Executes queries against a database.
(ii) Retrieves data from database.
(iii) Inserts and updates records in a database
(iv) Delete records from database
(v) Creates new databases and new tables in a database
WebServer software that runs on server hardware, governs the server side scripting compilation into an intermediate byte-code that is then interpreted by the runtime engine.
Array is a data type which has multiple values in single variable.
< ?php
\(\$\)children = array ("SriAkshaya", "SriRam", "Srisaiprasath", "Srivatsan");
var-dump ($children);
?>
The following example has a function with two arguments (\(\$\)name and \(\$\)Strength):
function School_Name(\(\$\)snare,\(\$\)Strength) {
echo \(\$\)sname."in Tamilnadu and Student Strength is".\(\$\)Strength;
}
School-Name ("Government Higher Secondary School Madurai",200);
School-Name ("Government Higher Secondary School Thichy",300);
School-Name ("Govemment Higher Secondary School Chennai",250);
School-Name ("Government Higher Secondary School Kanchipuram"',100);
School-Name ("Government Higher Secondary School Tirunelveli",200);
?>
(i) Each else is associated with another if statement.
(ii) Evaluation of condition starts from top to down.
(iii) If condition becomes true then the associated block with if statement is executed and rest of conditions are skipped.
(iv) If the condition becomes false then it will check for next condition in a sequential manner.
(v) It repeats until all conditions are checked or a true condition is found.
(vi) If dl condition available in else ... if ladder evaluates to false then default else block will be executed. Uses: Else . .. if ladder provides multi way decision making when anyone alternative is to be select among the available option.
The number is: 1
The number is: 2
The number is: 3
The number is: 4
The number is: 5
Program:
< ?php
$ x = 1;
de {
echo "The number is: $x
";
$x++;
} while ($x < = 5);
? >
Top-level domain is the last part of a domain name. Generic top-level domains are used for general purposes and are maintained by IANA.
Domain Name | Meanings |
com | Commercial organisation |
edu | Educational Institution |
gov | Government (us) |
mil | Military groups |
org | Nonprofit Organization |
net | Networking Organization |
info | Information service providers |
1. It is a type of null-modem cable that is often used to connect a device console port to make programming changes to the device.
2. The roll-over wiring has opposite pin arrangements, all the cables are rolled over to different arrangements. Also known as Yost cable (or) Console cable.
(i) The RJ-21 connector has 50 pins with 25 pins at one end an 25 pins at the other end. It is typically used for data communication.
(ii) It is also called a champ connector (or) Amphenol connector. The Amphenol is a connector manufacturer.