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