Smart Learning

Digital Learning

Friday, November 13, 2026

Digital Documentation-MS Word-CLASS-9-PART-B-Unit-III-ch-3(2026-27):

                                    


Class-9th

                                                    Part-B                                                   

 UNIT-III Digital Documentation
Chapter 3- MS Word

A. Multiple Choice Questions

1. When MS-Word gets loaded, the opening screen displays a document named: 
(a) DOC1 (b) Document1 (c) Document (d) None of the above
Answer: (b) Document1

2. In portrait-orientation, text is typed or printed: 
(a) length-wise (b) width-wise (c) both (a) and (b) (d) none of these 
Answer: (a) length-wise

3. In which layout does MS-word displays the content of document in such a way that they can be shrunk or expanded? 

(a) Normal view (b) Print layout view (c) Outline view (d) Web layout view 
Answer: (c) Outline view

4. Which of the following features of MS-Word can be used to automatically correct, incorrectly typed words? 

(a) Spell Checker (b) AutoText (c) AutoCorrect (d) All of the above 

Answer: (c) AutoCorrect

5. Which key(s) should be pressed to move to the beginning of the document? 

(a) Home (b) CTRL+Home (c) PgUp (d) SHIFT+Home

Answer: (b) CTRL+Home

6. Paragraph marks indicate: 

(a) beginning of a paragraph (b) end of a paragraph (c) end of sentence (d) current cursor position in a document 

Answer: (b) end of a paragraph

7. Which of the following text effects lowers the selected text below the base line and changes it to smaller font size? 

(a) Superscript (b) Subscript (c) Emboss (d) Small caps

Answer: (b) Subscript

8. A drawing object in MS-Word can be: (a) grouped (b) ungrouped (c) filled with color (d) all of the above 

Answer: (d) all of the above

Tuesday, November 10, 2026

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

Saturday, November 7, 2026

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

Wednesday, November 4, 2026

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;