Answers On/OffJS required
Group A
- Q1.Answer the following questions in one sentence:a. What is e-banking?b. What is mobile computing?c. Give any two examples of DBMS.d. Which view of MS-Access helps us to modify table?e. Write down the types of modular programming.f. Write any two names of data types used in C programming language.A.E-banking is the provision of banking services and transactions to customers over electronic channels such as the Internet and mobile networks.Mobile computing is the use of portable computing devices and wireless networks to access information and services anytime and anywhere.Two examples of DBMS are MySQL and MS-Access.Design View in MS-Access helps to modify the structure of a table.Types of modular programming include functional decomposition (functions/procedures) and object-based modularization (modules/classes).Two data types used in C are int and float.
- Q2.Write appropriate technical terms for the following:a. A device that connects two dissimilar networks.b. The technology to encode file or message.A.GatewayEncryption
- Q3.Write the full form of the following:a. ISDNb. STPA.Integrated Services Digital NetworkShielded Twisted Pair
Group B
- Q4.Answer the following questions:a. What is browser? Give any two examples of browser.b. Define digital footprint. How can you manage your digital footprint?c. What is software security? Write any two principles of information security.d. What is E-commerce? Write any two advantages of E-commerce.e. What is contemporary technology? Write any two advantages of cloud computing.f. Differentiate between data and information with example.g. What is RDBMS? Write any two examples of it.h. What is key in DBMS? Write any two names of keys available in DBMS.i. What is query? Write any two ways of creating query.A.A browser is an application software used to access and view web pages on the World Wide Web. Two examples are: Google Chrome and Mozilla Firefox.A digital footprint is the trail of data a person creates while using the internet, including posts, searches, and transactions; you can manage it by reviewing and tightening privacy settings and limiting the amount of personal information you share online.Software security is the practice of designing, implementing, and maintaining software so it resists attacks and protects data; two principles of information security are confidentiality (keeping data private) and integrity (ensuring data is accurate and unaltered).E-commerce is buying and selling of goods and services over electronic networks such as the Internet; two advantages are 24/7 availability and wider market reach.Contemporary technology refers to the modern and current technologies being used today (for example IoT, AI, cloud).Two advantages of cloud computing are:1. Scalable resources on demand.2. Reduced local infrastructure cost.Data are raw facts (for example, numbers 78, 92, 55), while information is processed data that has meaning (for example, “Average score = 75” derived from those numbers).RDBMS (Relational Database Management System) is a DBMS that stores data in tables and supports relationships among tables; examples include Oracle and MS-Access.A key is an attribute or set of attributes used to identify or relate records in a database; two keys are Primary Key and Foreign Key.A query is a request to retrieve or manipulate data in a database; two ways of creating a query are using Design View and using SQL View (writing SQL statements).
- Q5.Write down the output of the given program. Show with dry run in table.DECLARE SUB DTB(N)CLSN = 5126CALL DTB(N)ENDSUB DTB(N)WHILE N <> 0R = N MOD 10S = S + RN = N \ 10WENDPRINT S;END SUBA.Dry run table:
Step N (start) R = N MOD 10 S (cumulative) N after N\10 1 5126 6 0 + 6 = 6 512 2 512 2 6 + 2 = 8 51 3 51 1 8 + 1 = 9 5 4 5 5 9 + 5 = 14 0 Final printed output:14 - Q6.Re-write the given program after correcting the bugs:REM WAP to create file"detail.dat" and insert somerecords.CLSOPEN"detail.dat"FOR APPEND AS #5TOP:INPUT "Enter name, class and address"; nINPUT #5,nINPUT"Do you want to add more.? (Y/N)";C$IF UCASES(C="y" THEN GOTO downCLOSE #5ENDA.REM WAP to create file "detail.dat" and insert some recordsCLSOPEN "detail.dat" FOR APPEND AS #5TOP:INPUT "Enter name, class and address: ", N, A$PRINT #5, N, A$INPUT "Do you want to add more? (Y/N): ", C$IF UCASE) = "Y" THEN GOTO TOPCLOSE #5END
- Q7.Study the following program and answer the given questions:DECLARE FUNCTION count (NS)INPUT "Enter a word": WSC=count (WS)PRINT CENDFUNCTION count (NS)FOR K= 1 to LEN (NS)XS= MIDS (NS. K,1)IF UCASES (XS) ="A" thenX=X+1END IFNEXT Kcount =XEND FUNCTIONa. What are the library functions used in the above program?b. Write the use of variable 'C' in line C = count(WS$).A.LEN, MID$ and UCASE$ are used in the program.C is used to store the value returned by the function count(WS$), which represents the number of occurrences of the letter A (case-insensitive) in the input word.
Practice Without Boundaries.
Premium gives you full access, zero ads, and unlimited custom paper generation. Study your way, every day.
Group C
- Q8.Convert/ calculate as per the instruction:a. (A4D)₁₆ = (?)₂b. (37)₁₀ = (?)₈c. (10101)₂ − (101)₂d. (10101)₂ + (101)₂A.
Hex digit Binary A 1010 4 0100 D 1101 Hence, (A4D)₁₆ = (101001001101)₂Division Quotient Remainder 37 ÷ 8 = 4 4 5 4 ÷ 8 = 0 0 4 Hence, (37)₁₀ = (45)₈Converting to decimal for clarity:10101₂ = 21₁₀; 101₂ = 5₁₀21 − 5 = 16 → binary 10000Hence, (10101)₂ − (101)₂ = (10000)₂Step Number 1 Number 2 Carry Result 1 10101 00101 0 0 2 10101 00101 1 1 3 10101 00101 0 0 4 10101 00101 0 1 5 10101 00101 0 1 Hence, (10101)₂ + (101)₂ = (11010)₂ - Q9.a. Write a program in QBASIC that asks height and radius of cylinder and calculate its volume by user define function and total surface area by sub procedure. [Ve= πr²h, TSA = 2πr(r + h)]A.DECLARE FUNCTION Volume(R, H)DECLARE SUB TotSA(R, H)CLSINPUT "Enter radius: ", RINPUT "Enter height: ", HPRINT "Volume = "; Volume(R, H)CALL TotSA(R, H)ENDFUNCTION Volume(R, H)Volume = 3.1416 * R ^ 2 * HEND FUNCTIONSUB TotSA(R, H)TSA = 2 * 3.1416 * R * (R + H)PRINT "Total Surface Area = "; TSAEND SUB
- Q.b. A sequential data file called "student.txt" has stored data under the field heading Name, Class, Address and Age. Write a program to display all the information of those students whose class is 10 and gender is "male".A.CLSOPEN "student.txt" FOR INPUT AS #1PRINT "Name", "Class", "Address", "Age", "Gender"WHILE NOT EOF(1)INPUT #1, Name, Age, Gender$IF Class = 10 AND LCASE) = "male" THENPRINT Name, Age, Gender$END IFWENDCLOSE #1END
- Q10.Write a program in C language to check the students whether they are pass or fail, when the pass marks is 35.OR,Write a program in C language to display the series with their sum 40,41,42,43......upto 10th terms.A.#include <stdio.h>int main(void) {int marks;printf("Enter marks: ");if (scanf("%d", &marks) != 1) return 1;if (marks >= 35)printf("Pass ");elseprintf("Fail ");return 0;}#include <stdio.h>int main(void) {int i, term = 40, sum = 0;for (i = 1; i <= 10; i++) {printf("%d ", term);sum += term;term++;}printf("\nSum = %d ", sum);return 0;}