/123 0 votes, 0 avg 7 Rawalpindi Board 2nd year Computer Science all past papers MCQS.Rawalpindi Board 2nd year Computer Science all past papers MCQS. 1 / 123 1. Which programming structure executes program statements in order: a) sequence b) decision c) repetition d) relation 2 / 123 2. Global variable are created in: a) ROM b) RAM c) hard disk d) cache 3 / 123 3. The column of a table is know as: a) cell b) record c) field d) table 4 / 123 4. While loop is also called: a) counter loop b) conditional loop c) nested loop d) wend loop 5 / 123 5. A person name ,birthday and social security number are example of: a) attribute b) entities c) relationship d) descriptors 6 / 123 6. Which is a loop stunt: a) if else b) if c) for d) switch 7 / 123 7. A database consist of various components called: a) entities b) tools c) objects d) properties 8 / 123 8. What is the variable that is used by function to receive an argument: a) expression b) constant c) parameter d) funtion 9 / 123 9. In 2nf , which form of dependency is removed: a) non-functional b) associative c) partial d) transitive 10 / 123 10. Variables and constant name cannot contain a(n): a) underscore b) period c) number d) letter 11 / 123 11. Which of the fallowing escape sequence can be used to begin a new line in c? a) \a b) \n c) \b d) \m 12 / 123 12. The fopen() funtion used_________ parameters? a) 2 b) 1 c) 4 d) 5 13 / 123 13. In c,the maximum length of variable name is: a) 55 b) 255 c) 31 d) 25 14 / 123 14. In the statement FILE*FT, the*represents to: a) variable b) parameter c) multiplication d) pointer 15 / 123 15. Which of the following is a one -to-many relations : a) person-date of birth b) field c) mother -daughter d) Country-capital 16 / 123 16. The process of converting source code into object code is know as: a) linking b) saving c) compiling d) executing 17 / 123 17. Merging the relation is also know as: a) view entities b) view relations c) view tables d) view integration 18 / 123 18. The extension of a header file is: a) .h b) .hf c) .txt d) .c 19 / 123 19. The output of compiler is called: a) object code b) library code c) source code d) linked code 20 / 123 20. Which of the following format specifier is used for character data type? a) %s b) %c c) %D d) %e 21 / 123 21. int is a____ in c? a) first word b) keyword c) special word d) cut word 22 / 123 22. In if statement false is represented by: a) 4 b) 2 c) 0 d) 3 23 / 123 23. Microsoft access save the database with the extension: a) .msdb b) .mdb c) .madb d) .mxls 24 / 123 24. Conditional operator is an alternative of: a) do-while b) for c) for-each d) if_else 25 / 123 25. In if statement, true is represented by: a) 3 b) 2 c) 0 d) 1 26 / 123 26. Which form of dependency removed in 2nf? a) associative b) partial c) functional d) transitive 27 / 123 27. Which operation is performed by relational operator: a) division b) subtraction c) addition d) comparison 28 / 123 28. Switch statement is an alternative of: a) nested loop b) while loop c) for loop d) do_while loop 29 / 123 29. which of the follwing is used to associate entities with one another: a) identifier b) relationship c) object d) attribute 30 / 123 30. Which data type is the default data type: a) text b) auto number c) number d) memo 31 / 123 31. The”.exe” file is produced by: a) compiler b) linker c) interpreter d) loader 32 / 123 32. An attribute is also know as: a) relation b) record c) entity d) field 33 / 123 33. The manipulated and processed data is called: a) object b) knowledge c) information d) data 34 / 123 34. The target code produce by the compiler is: a) linked code b) object code c) source code d) library code 35 / 123 35. Another term for conditional operator: a) byte b) binary c) ternary d) iteration 36 / 123 36. Duplicate data in multiple data files is called: a) data integrity b) data redundancy c) program dependency d) data consistency 37 / 123 37. In relational database a table is also called: a) file b) relation c) schema d) tuple 38 / 123 38. Multiples copies of the same data is referred to as: a) data inconsistency b) data integrity c) data isolation d) data redundancy 39 / 123 39. A loop with in a loop is called: a) running loop b) complex loop c) infinite loop d) nested loop 40 / 123 40. In switch statement , the case block ends with: a) end b) abort c) break d) stop 41 / 123 41. Which mode open only an existing file for both reading and writing: a) "w" b) "w+" c) "a" d) "r+" 42 / 123 42. A logical group of character is a: a) table b) file c) record d) field 43 / 123 43. The “exe” file in visual basic is produced by: a) compiler b) interpreter c) loader d) linker 44 / 123 44. A primary key that consists of more than one attribute is called: a) composite key b) global key c) multi valued key d) foreign key 45 / 123 45. In which loop , statement terminators is a part of its syntax: a) for b) while c) for-each d) DO-while 46 / 123 46. The first line of funtion defination is know as: a) return type b) funtion body c) arguments d) funtion header 47 / 123 47. The output of compiler is: a) object code b) library code c) linked code d) source code 48 / 123 48. Which function is used to display output on screen in C-language? a) gets() b) print() c) printf() d) scanf() 49 / 123 49. Which of the fallowing function is used to copy a string to an array of characters: a) strcpy b) strpcy c) sopy d) strcp 50 / 123 50. The data or information that describes an entity is called : a) tuple b) data item c) attribute d) record 51 / 123 51. A form within another form is called: a) query grid b) design form c) design grid d) query form 52 / 123 52. What is the final value of I after executing the code : for(int i=1;i<=5;i+=2) a) 7 b) 6 c) 9 d) 5 53 / 123 53. Each separate piece of information stored in a record is called: a) relation b) table c) form d) field 54 / 123 54. Which statment is used to move the control to the start of loop body: a) continue b) break c) default d) switch 55 / 123 55. Which file is used to store information that remain constant for a long time: a) backup file b) transaction file c) master file d) data file 56 / 123 56. A built-in function: a) exit do b) cannot be redefined c) can be redefined d) end while 57 / 123 57. The foreign key is found in: a) dependent table b) pivot table c) parent table d) index table 58 / 123 58. Which form property will put text into title bar of the form: a) text b) header c) title d) boarder text 59 / 123 59. Which form of dependency is removed in 3NF: a) functional b) associative c) partial d) transitive 60 / 123 60. The loop which never end is called: a) infinite loop b) continuous loop c) running loop d) nested loop 61 / 123 61. In relation database, a single piece if information is called: a) attribute b) records c) table d) entity 62 / 123 62. Which of the fallowing is used associate entities with one another: a) relation b) relationship c) entity d) attribute 63 / 123 63. Different attributes in two different tables having same name are called: a) homonym b) synonym c) mutually exclusives d) acronym 64 / 123 64. A constraint between two attributes is called: a) attribute dependency b) functional dependency c) relation constraint d) functional relation 65 / 123 65. Relational operator allow you to: a) add b) multiply c) divide d) compare 66 / 123 66. In counter loop it is important to declare________ and counter variable : a) specify b) initialize c) identify d) size 67 / 123 67. _______ is not a database object: a) query b) table c) MS word d) report 68 / 123 68. What is the value of ‘X’ after executing the following code? for(x=1;x<=7;x++) a) 7 b) 8 c) 5 d) 4 69 / 123 69. Relational operator allow you to _________ numbers: a) divide b) multiply c) compare 70 / 123 70. Which of the fallowing is valid character constant: a) ‘@’ b) "c" c) = d) a 71 / 123 71. How many types of loop structure are in C -language? a) 4 b) 1 c) 3 d) 2 72 / 123 72. A table is a two dimensional structure that consist of: a) x and y co-ordinate b) interaction of c) rows and column d) matrix element 73 / 123 73. The default size of a text data type field is: a) 20 b) 5 c) 2 d) 50 74 / 123 74. which of the fallowing is used to associate entries with one another: a) attribute b) entity c) relationship d) identifier 75 / 123 75. In MS access ,table contains: a) records b) character c) file d) field 76 / 123 76. The extension of image file is: a) .exl b) .bmp c) .ppt d) .doc 77 / 123 77. Format specifier is started with symbol: a) ? b) & c) * d) % 78 / 123 78. Formal arguments are also called: a) actual arguments b) dummy arguments c) referenced arguments d) original arguments 79 / 123 79. In an E_R diagram , a rectangle represent: a) entity b) none c) relationship d) attribute 80 / 123 80. A virtual table that is constructed from the other table is called: a) table b) report c) view d) tuple 81 / 123 81. In E-R diagram a rectangle represents: a) record b) entity c) attribute d) relationship 82 / 123 82. In 3nf ,a non key attribute must not depend on a: a) Non-key attribute b) composite key c) key attribute d) sort key 83 / 123 83. Which loop structure always executes at least once? a) for b) while wend c) while d) DO-while 84 / 123 84. The lowest level of programming is called: a) java b) assembly language c) Fortran d) pascal 85 / 123 85. Conditional operator takes : a) four operands b) three operands c) two operands d) one operands 86 / 123 86. In which loop condition comes after the body of loop: a) for loop b) while loop c) nested loop d) DO-while loop 87 / 123 87. A set of related files created and managed by a DBMS is called: a) database b) field c) module d) record 88 / 123 88. Which function is used write character to a file: a) fscan() b) fgets() c) fputc() d) frintf() 89 / 123 89. The graphical query tool is know as : a) query grid b) query form c) design grid d) design form 90 / 123 90. A funtion does not return any value has return type a) void b) int c) nothing d) float 91 / 123 91. The smallest meaning full unit of data in a database is called: a) character b) byte c) field d) record 92 / 123 92. A file is stored in : a) ROM b) hard disk c) cache d) RAM 93 / 123 93. The number of bytes used by int data type in c is : a) 5 b) 2 c) 8 d) 3 94 / 123 94. The maximum length of a text type field in MS-excess is: a) 50 b) 250 c) 255 d) 155 95 / 123 95. The data type in C that can handle fractional values is called: a) char b) float c) long d) int 96 / 123 96. Which of the following function is used to write a character to a file: a) getc() b) fgets() c) putc() d) fputs() 97 / 123 97. a+=b is equal to: a) a=a+b b) b+=a c) a=+b d) b=b+a 98 / 123 98. A record may be based on : a) bits b) table c) byte d) field 99 / 123 99. The process of arranging data in a logical sequence is called: a) sorting b) classifyimg c) data capturing d) summarizing 100 / 123 100. The programming structure used for a computer making decision is: a) iteration b) repetition c) selection d) sequential 101 / 123 101. Which keyword is not used in switch statement: a) case b) default c) if d) switch 102 / 123 102. If x=2 and y=3 , what will be the output of the expression :x>y?x+y:x*y; a) 6 b) 9 c) 7 d) 12 103 / 123 103. Which data type is used to define a field that consist of only number to be used in calculations?: a) text b) date\time c) number d) memo 104 / 123 104. ____ is a loop statement: a) for b) if else c) switch d) if 105 / 123 105. The example of popular DBMS is : a) MS-acess b) MS_word c) MS-power point d) MS-execl 106 / 123 106. The format specifier %f is used for: a) float b) double c) int d) long 107 / 123 107. An array script should be: a) an array b) int c) float d) double 108 / 123 108. Which of the fallowing may be temporary file: a) master file b) backup file c) office file d) transaction file 109 / 123 109. The case block ends with: a) end select b) case else c) break d) end case 110 / 123 110. The extension of C source program is: a) .C b) .obj c) .exe d) .h 111 / 123 111. One execution of a loop is know as a(n): a) cycle b) duration c) iteration d) test 112 / 123 112. The output of a query is in the form of a: a) form b) macro c) query d) table 113 / 123 113. _______ form of dependency removed in 3nf: a) functional b) transitive c) partial d) non functional 114 / 123 114. A memory location with some data that can be changed is called: a) named constant b) address c) constant d) variable 115 / 123 115. To find all names start with M from student table ,the criteria is: a) like"M-" b) like"M*" c) like"M?" d) like"M#" 116 / 123 116. Which of follwing is not a loop structure in c: a) while b) condition c) do-while d) for 117 / 123 117. One execution of a loop is know as(n): a) test b) iteration c) cycling d) duration 118 / 123 118. stdio stand for: a) start input output b) standard input output c) string input output d) simple input output 119 / 123 119. A funtion can return ________ value: a) 4 b) 1 c) 2 d) 3 120 / 123 120. Function used for I/O are stored in: a) conio.h b) stdio.h c) math.h d) inout.h 121 / 123 121. Which is numeric data type with decimal point: a) float b) long c) int d) char 122 / 123 122. In visual basic variable cannot contain: a) underscore b) letter c) period d) number 123 / 123 123. Which statement is used for making two decision a) while b) if-else c) nested -if d) if Your score is LinkedIn Facebook Twitter VKontakte 0% Restart quiz Send feedback Rawalpindi Board 2nd year Computer Science Chapter 1/57 0 votes, 0 avg 4 Created on February 18, 2022 By adminRwp_2nd_cs_1Rawalpindi Board 2nd year Computer Science Chapter 1 1 / 57 1. Manipulation of data to achieve the required objectives and result is called a) Data manipulation b) Operation c) Data manipulation and operation d) None 2 / 57 2. A collection of related fields is called: a) File b) Database c) Record d) Character 3 / 57 3. A collection of data that consists of name, address and email of a person is called: a) Character b) Field c) Record d) Byte 4 / 57 4. A record in a database is the information refers to: a) All b) Person c) Event d) Product 5 / 57 5. A logical grouping of character is a a) file b) field c) all d) record 6 / 57 6. A field is to a record as a) data are to file b) attribute are to columns c) A column is to a row d) files are to table 7 / 57 7. a database containing all students in a class would store basic data of students in a) record b) file c) cell d) field 8 / 57 8. A data base containing all students in a class would store the information of individual students in a) cell b) record c) field d) file 9 / 57 9. Which of the following is also known as data set a) module b) field c) record d) file 10 / 57 10. A set of related files created and manage by a (DBMS) is called a) field b) database c) record d) module 11 / 57 11. Which of the following is an example of a database a) library management system b) all c) account & inventory system d) college management system 12 / 57 12. Which of the following used to describe the structure of a database a) data type b) data warehouse c) data model d) data structure 13 / 57 13. Which of the following data model is more flexible a) a and b b) network model c) relational model d) hierarchical model 14 / 57 14. Which of the following type of file require largest processing time a) direct access file b) sequential file c) random file d) indexed sequential file 15 / 57 15. Which of the following may be a temporary file? a) none b) backup file c) transaction file d) master file 16 / 57 16. SQL is a(n) a) object oriented language b) all c) Structured language d) Un structured language 17 / 57 17. SQL stands for a) Sort Query Language b) Seek Query Language c) Self Query Language d) Structured Query Language 18 / 57 18. SQL can be used to a) modify database data only b) query database data only c) create database structures only d) all 19 / 57 19. The type of files from functional point of view include a) none b) data file c) program file d) both a and b 20 / 57 20. Which file is used to store information that remains constant for a long time a) master file b) transaction file c) none d) backup file 21 / 57 21. Which of the following file is used to store additional copy of data a) none b) backup file c) transaction file d) master file 22 / 57 22. Which of the following file consist the software instructions a) program file b) both a and b c) none d) data file 23 / 57 23. The extension of program file is a) .exe b) .com c) none d) .exe and .com both 24 / 57 24. Which of the following is an image file extension a) .tif b) .bmp c) .jpg d) all 25 / 57 25. The extension for a video file is a) .mpg b) .avi and .mpg c) .avi d) .txt 26 / 57 26. The  extension of audio files is a) .mid b) txt c) .wav and .mid d) .doc 27 / 57 27. The file name and the extension are separated by a a) slash b) dot c) colon d) semicolon 28 / 57 28. In “‘program.txt” , ‘txt” is the: a) file location b) extension c) directory d) file name 29 / 57 29. Word processor can save documents using the following extensions EXCEPT a) doc b) txt c) mdb d) rtf 30 / 57 30. The type of files from storage point of view include: a) ALL b) indexed sequential file c) direct or random file d) sequential file 31 / 57 31. The problem synonym occurs in: a) Direct or random files b) Sequential files c) Indexed sequential files d) None 32 / 57 32. The process in which the contents are accessed in a sequence is called: a) Random Access b) Record Access c) Read only Access d) Sequential Access 33 / 57 33. A database is an organized collection of related data a) loosely b) logically c) badly d) physically 34 / 57 34. The objectives of database management systems include: a) All b) Availability c) Database Integrity d) Data Integration 35 / 57 35. The most commonly used database model in current database development is: a) Network b) Hierarchical c) Object-oriented d) Relational 36 / 57 36. Which of the following data model has general shape of an organization chart? a) Object Model b) Network Model c) Hierarchical Model d) Relational Model 37 / 57 37. Which data models creates parent-child relationships B/T data elements and restricts each child? a) Object data model b) Hierarchical data model c) Network data model d) Relational data model 38 / 57 38. Which data models creates parent-child relationships b/t data elements and have more than 2parents a) Hierarchical data model b) Network data model c) Object data model d) Relational data model 39 / 57 39. Information sharing means that: a) Neither a nor b b) The same information can be shared by different applications c) Information can be stored once and retrieved any number of times d) Both a and b 40 / 57 40. A program whose job is to store and retrieve user data in the database is called: a) Database Modeling System b) Data Business Model System c) Data Business Management Service d) Database Management System 41 / 57 41. The database system is composed of four major parts: a) DBMS, Hardware, User, Programmer, Engineer b) Software, You, Me, DBA, Client c) Hardware, Hard drive, Monitor, Data, User d) Hardware, Software, People and Data 42 / 57 42. Data that causes inconsistency lacks: a) Data redundancy b) Good data c) Data integrity d) Data anomaly 43 / 57 43. In a database processing system: a) a and c b) The database application(s) access the database data c) The database application(s) interact with the DBMS d) The DBMS accesses the database data 44 / 57 44. Which one of the following is an advantage of database management approach? a) Increased duplication of data b) Reduced security and the control of data c) Programs are independent of data format d) all 45 / 57 45. DBMS stands for: a) Database Modeling System b) Data Business Model System c) Database Management System d) Data Business Management Service 46 / 57 46. Which of the following is NOT an advantage of database systems? a) Data independence b) Backup /Recovery c) Redundant data d) Better data quality 47 / 57 47. Which of the following enables user to modify data without affecting existing program that use them a) Data dependence b) Data relationships c) Data integration d) Data independence 48 / 57 48. Database application contain procedures for: a) all b) Adding records c) Deleting records d) Processing queries 49 / 57 49. Which of the following is related to a component of database system? a) Application programmer b) All c) End users d) Database administrator 50 / 57 50. Which of the following database models is often referred to as an Inverted Tree? a) Network b) Relational c) Object-oriented d) Hierarchical 51 / 57 51. The major component of DBMS is called a) All b) File Manager c) Database Manager d) Data Manager 52 / 57 52. Duplicate data in multiple data file is: a) Data intergrity b) Data multiplication c) Data redundancy d) None 53 / 57 53. The description of structure and organization of data in a database is contained in: a) data store b) data dictionary c) data mine d) structure query language 54 / 57 54. A request for information from a database in database terminology is called a) Report b) Query c) Letter d) Table 55 / 57 55. A printed or on screen display of data or information in the database is called an: a) Entity b) Screen c) Query d) Report 56 / 57 56. The name for the software to build reports that summarize data from a database is: a) Report Builder b) Report Writer c) Reporter d) Report Generator 57 / 57 57. Which of the following is not a database management system a) Oracle b) excel c) MS Access d) SQL server Your score is LinkedIn Facebook Twitter VKontakte 0% Restart quiz Send feedback Rawalpindi Board 2nd year Computer Science Chapter 2/37 0 votes, 0 avg 2 Rwp_2nd_cs_2Rawalpindi Board 2nd year Computer Science Chapter 2 1 / 37 1. DBA stands for: a) Database authority b) Database Administrator c) Data basic Administration d) Database Application 2 / 37 2. A key strictly used for data retrieval purposes is called: a) Composite key b) Secondary key c) Candidate key d) Primary key 3 / 37 3. Who is responsible to design, implement and maintain a databases? a) Web designer b) Database administrator c) Application programmer d) End user 4 / 37 4. A table in which the foreign key is found is called: a) Parent table b) View c) All d) Dependent table 5 / 37 5. Which of the following is also known as control key? a) Composite key b) Primary key c) Sort key d) Candidate key 6 / 37 6. A primary key that consists of more than one attribute is called a) Multivalued key b) Foreign key c) Composite key d) Global Key 7 / 37 7. An attribute in relation used as the primary key of another relation in the same database is called a) Foreign key b) Global key c) Logic Key d) Link key 8 / 37 8. A candidate key is: a) Primary key b) All c) The primary key selected to be the key of a relation d) An attribute or group of attributes that can be the primary key 9 / 37 9. Which field is the most appropriate primary key? a) NIC Number b) Name c) Address d) Birth Date 10 / 37 10. Which of the following can be a primary key a) Last name b) Customer ID c) Salary d) Region 11 / 37 11. How many primary keys can a table have? a) 1 b) any c) 1 or 2 d) 1 to 5 12 / 37 12. Which of the following is NOT a good primary key? a) Zip code b) Student ID number c) Social security number d) Order number 13 / 37 13. Which of the following describes the primary key? a) It helps in indexing of a large database b) All of the above c) It makes sorting quicker d) It must be unique 14 / 37 14. A key is: a) the last field of a relation b) none of these c) the first field of a relation d) the most important field in a record 15 / 37 15. Which of the following are properties of relations? a) Each attribute has a unique name b) All of the above c) No two rows in a relation are identical d) There are no multivalued attributes in a relation 16 / 37 16. An index can used to: a) Document the structure of the database b) Improve the performance of the database c) Reduce data dependency for application programs d) All 17 / 37 17. Which of the following is NOT a characteristic of relations? a) Each row is unique b) The order of columns is significant c) Columns are all elemental or atomic d) The order of rows is insignificant 18 / 37 18. The data or information that describes an entity is called: a) Tuple b) Attribute c) Data item d) Data item 19 / 37 19. A person, place, thing or event about which data is kept in the database is called a) Record b) Field c) Entity d) Attribute 20 / 37 20. A row of a relation is called: a) a and c b) Attribute c) Tuple d) Tuple 21 / 37 21. A relation is also known as: a) Tuple b) Attribute c) Table d) Relationship 22 / 37 22. An attribute is also known as a: a) Field b) Row c) Table d) Relation 23 / 37 23. A table is a two-dimensional structure that consists of: a) Intersection of data b) Matrix elements c) x and y co-ordinates d) Rows and columns 24 / 37 24. A two-dimensional table of data is called: a) Module b) Set c) Group d) Relation 25 / 37 25. A table should have: a) Primary key b) Sort key c) Secondary key d) Composite key 26 / 37 26. The foreign key is found in: a) Index table b) Dependent table c) Pivot table d) Parent table 27 / 37 27. The Columns of a table correspond to a) Field b) Table c) Cell d) Record 28 / 37 28. SQL is used for: a) Data definition b) Data control c) All d) Data manipulation 29 / 37 29. CREATE command is used to create: a) Query b) Record c) Report d) View 30 / 37 30. A virtual table that is constructed from other tables is called: a) Table b) Tuple c) Relation d) View 31 / 37 31. The number of characters in fixed-length field is a) Variable b) 100 c) Constant d) 10 32 / 37 32. The views are used: a) To hide rows b) To hide complex SQL statements c) All of the above d) To hide columns 33 / 37 33. Views are also called: a) Complex tables b) Simple tables c) Virtual tables d) Actual Tables 34 / 37 34. The SQL statement to create a view is: a) SELECT VIEW b) MAKE VIEWS c) INSERT VIEW d) CREATE VIEW 35 / 37 35. All the intersection of rows and columns must have: a) Single value b) No value c) Multiple values d) Constant value 36 / 37 36. The rows of a relation can be of order. a) Any b) Sorted c) Same d) Sorted 37 / 37 37. Insert command is used to insert: a) View b) New record c) New table d) Dependencies Your score is LinkedIn Facebook Twitter VKontakte 0% Restart quiz Send feedback
