12th Class Computer Science Chapter 02 MCQs with Answers

Welcome to the 12th Class Computer Science Chapter 02 MCQs Online Test. We are presenting you with top MCQ questions from the 12th Class Computer Science Chapter Basic Concepts And Terminology.

We want to tell you that you can find all the 12th Class Computer Science Chapter 02 MCQs online tests on our website. These online tests are great for learning and as well as for scoring maximum marks in your Intermediate Exams. We are making these Class 12 Computer Science MCQs online tests for those who want full marks in their exams. Attempt all these Grade 12 Computer Science Online Multiple Choice Questions MCQs before going for the exam and it will be beneficial for you! These online tests contain all the important multiple choice questions in the important topics of the FSC Part-II  Computer Science Chapter 02 Basic Concepts And Terminology. 

12th Class Computer Science Chapter 02 MCQs with Answers

Youth For Pakistan has provided an excellent opportunity for the students of the 12th class to prepare their Computer Science Chapter 02 Basic Concepts And Terminology online with MCQs test.

This is a free platform for students to prepare for Computer Science Exams for Class 12 to get the best accomplishments in annual exams. 12th class Students can analyze themself by attempting this online test system as many times as they want until they find themself fully prepared.

MCQs Class 12 Computer Science with Answers

The purpose of these online MCQs tests is to help you evaluate your 12th Class Computer Science Chapter 02 MCQs. These Multiple Choice Questions (MCQs) will prepare you for your academic success in the 12th Class Exams. 12th Class Computer Science Chapters include Chapter No 1 Data basics, Chapter No 2 Basic Concepts And Terminology, Chapter No 3 Database Design Process, Chapter No 4 Data Integrity & Normalization, Chapter No 5 Introduction of Microsoft Access, Chapter No 6 Table and Query, Chapter No 7 Microsoft Access forms & Reports, Chapter No 8 Getting Started with C, Chapter No 9 Element Of C, Chapter No 10 Input/Output, Chapter No 11 Decision Constructors, Chapter No 12 Loop Constructors, Chapter No 13 Functions and Chapter No 14 File Handling in C

What are Basic Concepts And Terminology?

Database – a collection of information related to a particular topic or purpose. There are two types of databases: Non-relational and relational. Database management system – a program such as Access, that stores, retrieves, arranges and formats information contained in a database.

Chapter No 2 Basic Concepts And Terminology

1. Insert command is used to insert.

  1. a new table
  2. a new record
  3. a view
  4. dependencies

2. The foreign key is found in

  1. parent table
  2. dependant table
  3. pivot table
  4. index table

3. Anything in the real world that has a set of different attributes or properties is called choose which one is correct:

  1. Database
  2. Data set
  3. Entity
  4. Data

4. ⎯⎯⎯⎯ represents an entity choose which one is correct:

  1. Car
  2. Student
  3. House
  4. All of these

5. A table is also known as choose which one is correct:

  1. Two-dimensional array
  2. Relation
  3. Both (a) and (b)
  4. None

6. A table is also known as

  1. Multiple arrays
  2. Relation
  3. A file
  4. None of these

7. A tuple in a table is also known as

  1. Occurrence
  2. Attribute
  3. Relation
  4. Record

8. The columns of a relation correspond to choose which one is correct:

  1. Table
  2. Cell
  3. Fields
  4. Records

9. The rows of a table or relation are known as choose which one is correct:

  1. Tuples
  2. Occurrences
  3. Both (a) and (b)
  4. None

10. The column of a relation is known as

  1. Attribute
  2. Tuple
  3. Relation
  4. Record

11. ⎯⎯⎯⎯ is used to create data view choose which one is correct:

  1. Database Manager
  2. SQL
  3. Report Generator
  4. Utilities

12. ⎯⎯⎯⎯ is used to uniquely identify records of a relation choose which one is correct:

  1. Secondary key
  2. Foreign key
  3. Sort key
  4. Primary key

13. A table must have choose which one is correct:

  1. Primary key
  2. Secondary key
  3. Composite key
  4. Sort key

14. A key that consists of two or more than two attributes of a table is called

  1. Composite Key
  2. Foreign Key
  3. Primary Key
  4. Sort Key

15. An attribute is also known as choose which one is correct:

  1. Relation
  2. Row
  3. Field
  4. Tuple

16. ⎯⎯⎯⎯ is known as control key choose which one is correct:

  1. Sort key
  2. Primary key
  3. Candidate key
  4. Composite key

17. SQL is used for

  1. Data manipulation
  2. Data definition
  3. Data Deletion
  4. All of the above

18. Which of the following is responsible for designing the database system.

  1. Data Administrator
  2. End User
  3. Database Administrator
  4. Database Manager

19. ⎯⎯⎯⎯ serves as a bridge between end users and database administrator choose which one is correct:

  1. Data Administrator
  2. System Analyst
  3. Application Programmer
  4. None

20. ⎯⎯⎯⎯ is responsible for designing, coordinating and monitoring the database system choose which one is correct:

  1. Data Administrator
  2. End-user
  3. Database Administrator
  4. Database manager

21. The concept of database evolved from old

  1. Computers
  2. Software
  3. Traditional File Management system
  4. Systems

22. CREATE TABLE command is used to create a choose which one is correct:

  1. Table
  2. View
  3. Report
  4. Query

23. All the data stored on the hard disk as a combination of

  1. Records
  2. Fields
  3. Words
  4. 0’s and 1’s

24. Field is another name of

  1. Records
  2. Data
  3. Column
  4. Table

25. A person, place, event or anything about which data is collected and stored in a database is called choose which one is correct:

  • Relation
  • Entity
  • Attribute
  • Record

26. How many primary keys can a relation have choose which one is correct?

  1. At least two
  2. Only one
  3. No limit
  4. None

27. Another name for file is

  1. Collection of Records
  2. Instance
  3. Dataset
  4. Tuple

28. An attribute of a relation of a database that serves as a primary key of another relation in the same database is called choose which one is correct:

  1. Foreign key
  2. Candidate key
  3. Control key
  4. Alternate key

29. In the Relation ___________ is insignificant

  1. Name of Relation
  2. Order of Rows
  3. No of Records
  4. Size of Relation

30. Atomicity refers to the

  1. Individual Value in a Cell
  2. Individual Value in a Row
  3. Individual Value in a Table
  4. Individual Value in a Tuple

31. ______ are created to keep the data safe and secure from un authorized and illegal users

  1. Security
  2. Tables
  3. Locks
  4. Views

32. To create view ________ statement is also used

  1. Select
  2. Form
  3. Enable
  4. Visualize

33. The attribute or a combination of attributes used to uniquely identify a row in a table.

  1. Foreign Key
  2. Sort Key
  3. Primary Key
  4. Data Key

34. A non unique field is called

  1. Primary key
  2. Candidate Key
  3. Alternate Key
  4. Secondary Key

35. In the presence of more than one unique fields, one is primary and other one is called

  1. Candidate Key
  2. Primary Key
  3. Enable
  4. Secondary Key

36. Another name for composite key is

  1. Primary Key
  2. Control Key
  3. Concatenate Key
  4. Sort Key

37. To physically sequence the stored data __________ key is used

  1. Primary Key
  2. Control Key
  3. Candidate Key
  4. Composite Key

38. A person who is responsible for the organization of entire data of an organization

  1. DBA
  2. DA
  3. Administrator
  4. System Administrator

39. A person who is responsible for the security and maintenance of database

  1. System Administrator
  2. DBA
  3. DA
  4. Administrator

40. View is stored in the

  1. Table
  2. Row
  3. Database
  4. None of Above

Leave a Comment