12th Class Class Computer Mcqs Chapter No 2 | 2nd Year Computer Mcqs Chapter Wise Pdf

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