32. RDBMS stands for _______.
a. Relational Database Management System.
b. Relational Data Management System.
c. Relation Data Master System.
d. Relational Database Master System
Answer: a. Relational Database Management System.
33. In the RDBMS data can be integrated using _______.
a. keys
b. fields
c. rows
d. None of these
Answer: a. keys
34. Which of the following is not a keys in RDBMS?
a. Primary Key
b. Secondary Key
c. Composite Primary Key
d. Foreign Key
Answer: b. Secondary Key
35. A ________ is a unique value that identifies a row in a table.
a. Primary Key
b. Secondary Key
c. Composite Primary Key
d. Foreign Key
Answer: a. Primary Key
36. _________ are also indexed in the database, making it faster for the database to search for a record.
a. Primary Key
b. Secondary Key
c. Composite Primary Key
d. Foreign Key
Answer: a. Primary Key
37. When primary key constraint is applied on one or more columns then it is known as ___________ .
a. Primary Key
b. Secondary Key
c. Composite Primary Key
d. Foreign Key
Answer: c. Composite Primary Key
38. The __________ identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table.
a. Primary Key
b. Secondary Key
c. Composite Primary Key
d. Foreign Key
Answer: d. Foreign Key
39. One, Parent ==> ___________; many, child ==> ___________
a. PK, FK
b. FK, PK
c. None of these
Answer: a. PK, FK
On the basis of given figure, answer the following questions (40 to 44)
40. Which of the column is a primary key in the Client Table?
a. ClientId
b. Name
c. Address
d. Phone
Answer: a. ClientId
41. Which of the column is a primary key in the Order Table?
a. ClientId
b. OrderId
c. SaleDate
d. ItemsBought
Answer: b. OrderId
42. Which of the column is a Foreign key in the Order Table?
a. ClientId
b. OrderId
c. SaleDate
d. ItemsBought
Answer: a. ClientId
43. Which table is a parent table?
a. Client Table
b. Sales Table
c. None of these
Answer: a. Client Table
44. Which table is a child table?
a. Client
b. Sales
c. None of these
Answer: b. Sales Table
45. A relational database is a type of _________.
a. database
b. word processor
c. spreadsheet
d. presentation
Answer: a. database
46. _________ uses a structure that allows us to identify and access data in relation to another piece of data in the database.
a. Database
b. RDBMS
c. DBMS
d. Spreadsheet
Answer: b. RDBMS
47. Data in a relational database is organized into _________.
a. row
b. column
c. tables
d. None of these
Answer: c. tables
Class 10 Info Tech – MCQ’s
- Class 10 IT 402 RDBMS – SQL Commands in OpenOffice Base Notes
- Structured Query Language (SQL ) in OpenOffice.org Base
- Class 10 Info Tech 402 Unit 3 RDBMS Database Management System Notes Download PDF
- Class 10 Info Tech Unit 3 RDBMS Session 5 – Create Forms and Reports using Wizard 50+ Question Answer
- Class 10 Info Tech Unit 3 RDBMS Session 4 – Retrieve Data Using Query 50+ Question Answer
- Class 10 Info Tech Unit 3 RDBMS Session 3 – Perform Operations On Tables 50+ Question and Answer
- Class 10 Info Tech Unit 3 RDBMS Session 2 – Create and Edit Tables Using Wizard & SQL Commands 50+ Question Answer
- Class 10 Info Tech Unit 3 RDBMS Session 1 Appreciate Concept of Database Management System 50+ Question Answer
- Class 10 Info Tech Electronic Spreadsheet Advanced Session 4 – Create and Use Macros in Spreadsheets MCQs
- Class 10 Info Tech Electronic Spreadsheet Advanced Session 3 – Share and Review a Spreadsheet MCQ’s
- Class 10 Info Tech RDBMS Session 2 Create and Edit Tables Using Wizard and SQL Commands MCQs
- Class 10 Info Tech Electronic Spreadsheet Advanced Session 2 – Link Data and Spreadsheets MCQ’s
- Class 10 Info Tech Unit 3 RDBMS Session 1 Appreciate the Concept of Database Management System MCQs
- Class 10 Info Tech Unit 1 Digital Documentation Session 5 Implement Mail Merge MCQs
- Class 10 Info Tech Electronic Spreadsheet Advanced Session 1 – Analyse Data Using Scenarios and Goal Seek MCQs
- Class 10 Info Tech Unit 1 Digital Documentation Create and Customize Table of Contents MCQs 50+
- Class 10 Info Tech Digital Documentation Insert and Use Images
- Class 10 Info Tech Unit 1 Digital Documentation Create and Use Templates MCQs
- Class 10 Info Tech Unit 1 Digital Documentation Create and Apply Styles MCQs
- Styles in a Document Digital Documentation Advanced Notes
Class 10 Employability Skills – MCQs
- Class 10 Unit 1 – Communication Skills Important Question Answer
- Class 10 Unit 3 – Information and Communication Technology ICT Skills II 100+ MCQ’s SET-1
- Class 10 Employability Skills Unit 1 Communication Skills 50+ MCQ’s
- Class 10 Employability skills Unit 2 Self Management Skills 100+ MCQ’s
- Class 10 – Unit 3 ICT Skills 100+ MCQ’s Set 2
- Class 10 – Unit 3 ICT Skills 100+ MCQ’s Set 3
- Class 10 – Unit 3 ICT Skills 100+ MCQ’s Set 4
- Class 10 – Unit 3 ICT Skills 100+ MCQ’s Set 5
- Class 10 Unit 3 Information and Communication Technology ICT Skills II 50+ MCQs
- Class 10 Employability Skills Unit 4 Entrepreneurial Skills 100+ MCQ’s
- Class 10 Employability Skills Unit 5 Green Skills 100+ MCQs
- Class 10 Information Technology 402 Employability Skills MCQs Question Answer Notes
- Class 10 Employability Skills Unit 5 Green Skills Question and Answer
- Class 10 Employability Skills Unit 3 ICT Skills Important Question Answers 50+
- Class 10 Employability Skills Unit 4 Entrepreneurial Skills Question and Answer
- Class 10 Employability Skills MCQ Question Answer Question Bank and Notes
- Class 10 Employability Skills Question Answers based on NCERT Book
- Employability Skills Class 10 – Exam Notes based on NCERT Book
- Class 10 CBSE Employability Skills Question Bank based on Previous Year Sample Question Paper and CBSE Question Paper
