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