Smart Learning

Digital Learning

Tuesday, November 10, 2026

What is Database? Class-10-Unit-3-Ch-2 (PART-B)-2026-27:

CBSE SOLUTIONS-2026-27 ,
What is Database? Class-10-Unit-3-Ch-2 (PART-B)-2026-27:



CBSE-SOLUTIONS
CLASS-10
PART-B
UNIT-III-Chapter-2 Database Management System (Advanced)

A. Multiple Choice Questions

1.What identifies the content of a field? 
(a) Data (b) Field value (c) Field name (d) Table name
Answer: (c) Field name
2. Which of the following is not a field type in MS Access? 
(a) Hyperlink (b) Number (c) Currency (d) True/false
Answer: (d) True/false
3. Field validation is set in fields: 
(a) Input Mask property (b) Validation Rule property (c) Default Value property (d) Validation Act property
Answer: (b) Validation Rule property
4. Which of the following wizard is used to create Lookup fields? 
(a) Table Wizard (b) Form Wizard (c) Field Wizard (d) Lookup Wizard
Answer: (d) Lookup Wizard
5. Text datatype in MS Access stores: 
(a) Upto 64000 characters (b) Upto 255 characters (c) Upto 1024 characters (d) Upto 13064 characters
Answer: (b) Upto 255 characters
6. Which of the following is not a Microsoft Access database object? 
(a) Queries (b) Tables (c) Forms (d) SQL
Answer: (d) SQL
7. What is the full form of SQL? 
(a) Sequence Query Language (b) Structured Query Language (c) Structured Query Layout (d) Sequential Query Language
Answer: (b) Structured Query Language
8. Which of the following is a basic object of a database? 
(a) Form (b) Query (c) Table (d) Report
Answer: (c) Table
9. A form can be prepared for: 
(a) Automating the task (b) Accepting input (c) Printing labels (d) None of these
Answer: (b) Accepting input
10. Which of the following is not an aggregate function in SQL? (a) SUM() (b) MAX() (c) AVG() (d) CONCAT()
Answer: (d) CONCAT()
11. __________ DDL command is used to create a table. 
(a) ALTER (b) CREATE (c) DESIG (d) NEW
Answer: (b) CREATE
12. __________ DDL command is used to change the structure of a database. 
(a) CHANGE (b) TRUNCATE (c) ALTER (d) MODIFY
Answer: (c) ALTER
13. __________ property is used to filter the data either in the ascending or descending order. 
(a) Sort (b) Arrange (c) Query (d) Criteria
Answer: (a) Sort
14. __________ helps us to retrieve the filtered data based upon specified conditions. 
(a) Report (b) Table (c) Query (d) Form
Answer: (c) Query
15. Which of the following is not a logical operator? 
(a) NOT (b) DOT (c) AND (d) OR
Answer: (b) DOT
16. In database, __________ helps us to retrieve the filtered data based upon some conditions. 
(a) Forms (b) Reports (c) Queries (d) Table
Answer: (c) Queries
17. Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task. 
(a) Table (b) Form (c) Relationships (d) Sorting
Answer: (c) Relationships
18. __________ data type takes the values in the form of 0 and 1 in the database. 
(a) Integer (b) Text (c) Boolean (d) Memo
Answer: (c) Boolean

Read more »
By
at No comments:
Tags

Saturday, November 7, 2026

What is Database? Class-10-Unit-3-Ch-1 (PART-B)-2026-27:

CBSE SOLUTIONS-2026-27 ,
What is Database? Class-10-Unit-3-Ch-1 (PART-B)-2026-27:

CBSE-SOLUTIONS
CLASS-10
PART-B
UNIT-III-Chapter-1 Database Management System (Basic)

A. Multiple Choice Questions
1. Full form of RDBMS is:
(a) Relation Disadvantages Based Management System
(b) Relational Database Management System
(c) Random Data By Management System
(d) Relational Data by Managing System
Answer: (b) Relational Database Management System
2. Information is the collection of:
(a) Facts
(b) Records
(c) Tables
(d) Database
Answer: (a) Facts
3. The Database Management System is a:
(a) Collection of Data
(b) Software
(c) Hardware
(d) File
Answer: (b) Software
4. Which of the following term is not related to DBMS?
(a) Table
(b) Record
(c) HTML
(d) Field
Answer: (c) HTML
5. Which of the following is not included in Microsoft Office Suite?
(a) Microsoft Word
(b) Microsoft Access
(c) Microsoft Excel
(d) Dynamics ERP
Answer: (d) Dynamics ERP
6. Duplication of data is called ________.
(a) Consistency
(b) Inconsistency
(c) Redundancy
(d) Foreign Key
Answer: (c) Redundancy
7. Which of the following will help to maintain unique record in the table?
(a) Foreign Key
(b) Primary Key
(c) Composite Key
(d) Null Key
Answer: (b) Primary Key
8. A foreign key is a reference of the ________ key in another table.
(a) Alternate
(b) Primary
(c) Candidate
(d) Composite
Answer: (b) Primary
9. Primary key cannot accept ________ values.
(a) Binary
(b) Duplicate
(c) Text
(d) Numeric
Answer: (b) Duplicate
10. When primary key is made up of two or more columns, then it is called ________ primary key.
(a) Mixed
(b) Foreign
(c) Composite
(d) Combined
Answer: (c) Composite
11. Which of the following is not a good naming field for the table “Student”?
(a) Roll number
(b) Name
(c) Fees
(d) Salary
Answer: (d) Salary
12. A field which is ________ for each and every record is called Primary key.
(a) Common
(b) Same
(c) Unique
(d) Candidate
Answer: (c) Unique
13. Which of the following key defines a relationship between two tables?
(a) Foreign key
(b) Primary key
(c) Composite key
(d) Alternate Key
Answer: (a) Foreign key

Read more »
By
at No comments:
Tags

Wednesday, November 4, 2026

SQL Commands (DDL, DML, DQL, DCL, TCL):

CBSE SOLUTIONS-2026-27 ,
SQL Commands (DDL, DML, DQL, DCL, TCL):

SQL Commands 

SQL Commands – Definition, Syntax and Examples

SQL (Structured Query Language) is a standard programming language used to create, manage, manipulate, and retrieve data from relational databases.

SQL commands are divided into five main categories:

1.      DDL – Data Definition Language

2.      DML – Data Manipulation Language

3.      DQL – Data Query Language

4.      DCL – Data Control Language

5.      TCL – Transaction Control Language

1. DDL – Data Definition Language

DDL commands are used to create, modify, and delete database structures such as tables and databases.

1. CREATE

Definition: CREATE command is used to create a new database or table.

Syntax:

CREATE TABLE table_name (

    column1 datatype,

    column2 datatype

);

Example:

CREATE TABLE Student (

    RollNo INT,

    Name VARCHAR(50),

    Age INT,

    City VARCHAR(30)

);

2. ALTER

Definition: ALTER command is used to modify the structure of an existing table.

Syntax:

ALTER TABLE table_name

ADD column_name datatype;

Example:

ALTER TABLE Student

ADD Marks INT;

3. DROP

Definition: DROP command is used to permanently delete a table or database.

Syntax:

DROP TABLE table_name;

Example:

DROP TABLE Student;

4. TRUNCATE

Definition: TRUNCATE command is used to delete all records from a table without deleting its structure.

Syntax:

TRUNCATE TABLE table_name;

Example:

TRUNCATE TABLE Student;

Read more »
By
at No comments:
Tags

Tuesday, November 3, 2026

Digital Documentation-CLASS-9-PART-B-Unit-III-ch-2(2026-27):

CBSE SOLUTIONS-2026-27 ,
Digital Documentation-CLASS-9-PART-B-Unit-III-ch-2(2026-27):


PART-B
UNIT-III Digital Documentation
Chapter 2- LibreOffice Writer

A. Multiple Choice Questions
1. LibreOffice Writer is
(a) Slideshow maker (b) Spreadsheet (c) Word processor (d) None of these
Answer: (c) Word processor
2. Which of the following is an extension of a Document created in Writer?
(a) .odf (b) .odd (c) .xls (d) .obj
Answer: (a) .odf
3. To change the font in a part of the text within writer you will use:
(a) The edit menu, find and replace command
(b) The menu format command change letter
(c) The format menu, character command
(d) None of these
Answer: (c) The format menu, character command
4. When we insert a table through the insert table option, a table is inserted:
(a) With a column
(b) With 2 rows and two columns
(c) We can select the number of rows and columns
(d) None of these
Answer: (c) We can select the number of rows and columns
5. The bar that appears immediately below the application’s title bar is called:
(a) Command Bar (b) Menu bar (c) Tools menu bar (d) None of these
Answer: (b) Menu bar
6. If after performing an action I want to undo it:
(a) Writer does not reverse the changes
(b) Tools menu, spell check command
(c) Edit undo command menu
(d) None of these
Answer: (c) Edit undo command menu
7. The .DOC extension tells me that the file was created in:
(a) Excel (b) Writer (c) Word (d) None of these
Answer: (c) Word
8. One of the elements that makes up the word processor is:
(a) Cell (b) Ruler (c) Slideshow (d) None of these
Answer: (b) Ruler
9. What combination of keys will you use to paste a previously copied text into Writer?
(a) Ctrl.+ V (b) Ctrl.+ C (c) Ctrl.+ E (d) Ctrl.+ X
Answer: (a) Ctrl.+ V

Read more »
By
at No comments:
Tags