Smart Learning

Digital Learning

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

What is HTML-5? -CLASS-8-CH-6(2026-27):

CBSE SOLUTIONS-2026-27 ,
What is HTML-5? -CLASS-8-CH-6(2026-27):
CBSE SOLUTIONS-2026-27
CLASS-8
CHAPTER-6 HTML-Creating List and Table

A. Multiple Choice Questions:
1. This one is an empty tag:
(A) <OL> (B) <UL> (C) <LI> (D) <TABLE>
Answer: None of these
2. Unordered list is also known as:
(A) Bulleted list (B) Multilevel list (C) Numbered list (D) None of these
Answer: (A) Bulleted list
3. The default numbering style of an ordered list is:
(A) I (B) A (C) i (D) 1
Answer: (D) 1
4. A description list consists of:
(A) Two parts (B) Three parts (C) Four parts (D) None of these
Answer: (A) Two parts
5. This tag marks the definition terms in a description list:
(A) <DD> (B) <DT> (C) <DL> (D) None of these
Answer: (B) <DT>
6. You can specify the space between the border and content in a table by using:
(A) Padding property (B) Height property (C) Width property (D) Table-layout property
Answer: (A) Padding property

Read more »
By
at No comments:
Tags