2nd Year Computer MCQs

Full book important Multiple Choice Questions as a form of 2nd Year Computer MCQs written by Honorable Professor Mr. Tayyab Shahzad Suib. These notes are very helpful in the preparation of the 2nd year computer mcqs pdf of Computer Science for the students of the intermediate and these are according to the paper patterns of all Punjab boards.

Summary and Contents:     
Topics which are discussed in the notes are given below:
  • Important 2nd year computer important mcqs for Intermediate Part-II Students. 
  • A database is an organized collection of ......... related data.
  • (a) Logically    (b) Physically (c) Loosely (d) Badly
  • Which of the following database model is also referred an inverted tree?
  • (a) Hierarchal (b) Network   (c) Relational (d) Object
  • Which one refers to the correctness and consistency of data?
  • (a) Data independence (b) Data integration (c) Data integrity (d) Data model
  • Multiple copies of the same data is referred to as:
  • (a) Data integrity (b) Data inconsistency (c) Data redundancy (d) Data isolation
  • SQL stands for:
  • (a) Sort-Query-List (b) Self-Quantifying-Language (c) Structured Query language  (d) Self Quantative language
  • Insert command is used to insert:
  • (a) A new table (b) A new record   (c) A view (d) Dependencies
  • CREATE command is used to create a:
  • (a) Table (b) View (c) View (d) Query
  • SQL is used for:
  • (a) Data definition (b) Data manipulation (c) Data definition and manipulation (d) Searching records
  • Important 2nd year computer solved mcqs pdf for Intermediate Part-II Students. 
  • The foreign key is found in:
  • (a) Parent table (b) Dependent table (c) Pivot table (d) Index table
  • A table must have:
  • (a) Primary key (b) Secondary key (c) Composite key (d) Sort key
  • An entity related to itself in an ERD model refers to:
  • (a) Recursive relationship (b) One-to-many relationship (c) Many-to-many relationship  (d) One-to-one relationship
  • Which of the following keys does not hold uniqueness property?
  • (a) Candidate key (b) Foreign key (c) Primary key (d) Secondary key
  • Important 2nd year computer chapter wise mcqs for Intermediate Part-II Students. 
  • Database development process involve mapping of conceptual data model into:
  • (a) Object oriented data model   (b) Network data model (c) Implementation model  (d) Hierarchical data model
  • In relational database, a table is also called a:
  • (a) Tuple (b) Relation (c) File  (d) Schema
  • A category of data or information that describes an entity is called a(n):
  • (a) Attribute (b) Data item (c) Record (d) Tuple
  • Important mcqs of computer class 12 for Intermediate Part-II Students. 
  • The row of relation can be of ......... order.
  • (a) Any   (b) Same (c) Sorted (d) Constant
  • A relation is analogous to a:
  • (a) Table (b) Field (c) Record (d) Row
  • Which of the following is degree of a table?
  • (a) Total number of rows (b) Total number of columns  (c) Total number of cells (d) Total number of foreign keys
  • Important important mcqs of computer 2nd year for Intermediate Part-II Students. 
  • The row of table is also called:
  • (a) Entity (b) Attributes (c) Cell   (d) Record
  • A relation is also known as:
  • (a) Table (b) Tuple (c) Relationship (d) Attribute
  • The columns of a table correspond to:
  • (a) Table (b) Record (c) Field (d) Cell
  • Which of the following is not included in the definition of entity?
  • (a) Person (b) Object (c) Concept (d) Action
  • Important 2nd year computer mcqs chapter wise for Intermediate Part-II Students. 
  • Which of the following is used to associate entities with one another?
  • (a) Entity (b) Attribute (c) Identifier  (d) Relationship
  • In MS Access, table contains:
  • (a) Fields (b) Record (c) Character (d) File
  • Views are also called:
  • (a) Complex tables (b) Simple tables (c) Virtual tables (d) Actual tables
  • Important mcq of computer class 12 for Intermediate Part-II Students. 
  • 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 * ”
  • A virtual table that is constructed form other tables is called:
  • (a) Tuple (b) Table (c) View (d) Report
  • A key that consists more than one attributes is called:
  • (a) Foreign key (b) Composite key (c) Primary key (d) Control key
  • Important 2nd year computer important mcqs with answers for Intermediate Part-II Students. 
  • The selected candidate key is called:
  • (a) Foreign key (b) Composite key (c) Primary key (d) Sort key
  • ......... key does not hold uniqueness property.
  • (a) Foreign (b) Candidate (c) Primary (d) Secondary
  • A table must have a:
  • (a) Primary key (b) Secondary key (c) Composite key (d) Sort key
  • Important 2nd year computer mcqs test for Intermediate Part-II Students. 
  • Foreign key is found in:
  • (a) Parent table (b) Dependent table (c) Pivot table (d) Index table
  • How many primary keys can a relation have?
  • (a) At least once (b) Only one (c) No limit (d) Three
  • Important 2nd year computer important mcqs 2025 for Intermediate Part-II Students.
  • All the hardware costs are considered during:
  • (a) Project planning (b) Requirements analysis  (c) Feasibility study (d) Data analysis

Loading your document...

Download PDF