Advertisements
Online Mock Tests
Chapters
▶ 2: Introduction to DBMS
3: Impressive Web Designing
4: Cyber Law
![Balbharati solutions for Information Technology (IT) [English] 11 Standard Maharashtra State Board chapter 2 - Introduction to DBMS - Shaalaa.com](/images/information-technology-it-english-11-standard-maharashtra-state-board_6:1e28f80623384526a892dc654b4130d0.jpg "Balbharati solutions for Information Technology (IT) [English] 11 Standard Maharashtra State Board chapter 2 - Introduction to DBMS")
Advertisements
Solutions for Chapter 2: Introduction to DBMS
Below listed, you can find solutions for Chapter 2 of Maharashtra State Board Balbharati for Information Technology (IT) [English] 11 Standard Maharashtra State Board.
Balbharati solutions for Information Technology (IT) [English] 11 Standard Maharashtra State Board 2 Introduction to DBMS Exercise [Pages 28 - 29]
Tick whichever box is not valid.
Graphic
Date
Number
Text
Student wants to create a field pincode in a table, which data type he will choose?
Tick the appropriate box.
is also called foreign key
Uniquely identifies a record
Tick the appropriate circle.
Only one record
Only single table
One or many tables
None of these
Observe the field names of a database given below in ‘Column A’ related to Bus reservation. Write suitable data types for each field in front of the respective field in ‘Column B’.
| Column A (Field Name) |
Column B (Data Type) |
| Passenger Name | |
| Age | |
| Gender | |
| Mobile Number |
Write the use of the following SQL command.
UPDATE
Write the use of following SQL command
INSERT
Create a table for the information given below by choosing appropriate data types. Specify proper primary key for the table 1) Movie 2) Actor
- Movie (Registeration_no, movie_name, Realease_Date)
- Actor (actor_id, Actor_name, birth_date )
Consider the following table stationary. Write SQL commands for following statement.
| S_ID | S_Name | C_Name | Price | Quantity |
| 001 | Note Book | ABC | 20 | 50 |
| 002 | Pencil Box | XYZ | 10 | 80 |
| 003 | A4 Pages rim | PQR | 600 | 2 |
Write SQL command to create above Table.
Consider the following table Stationary. Write SQL commands for following statement.
| S_ID | S_Name | C_Name | Price | Quantity |
| 001 | Note Book | ABC | 20 | 50 |
| 002 | Pencil Box | XYZ | 10 | 80 |
| 003 | A4 Pages rim | PQR | 600 | 2 |
Write SQL command to insert above mentioned record in table
Consider the following table Stationary. Write SQL commands for following statement.
| S_ID | S_Name | C_Name | Price | Quantity |
| 001 | Note Book | ABC | 20 | 50 |
| 002 | Pencil Box | XYZ | 10 | 80 |
| 003 | A4 Pages rim | PQR | 600 | 2 |
To delete above table.
What is a database?
What are the advantages of a DBMS?
What do you understand by Data Model?
What is a primary key?
What is DDL (Data Definition language)?
In a company the data is stored in a table under the following fields Employee number, Last name, Date of birth, Address. Which data type will you use for the above field.
Complete the following.
To remove access rights or previleges from the database
Complete the following.
Extracts data from a table
Solutions for 2: Introduction to DBMS
Balbharati solutions for Information Technology (IT) [English] 11 Standard Maharashtra State Board chapter 2 - Introduction to DBMS
Shaalaa.com has the Maharashtra State Board Mathematics Information Technology (IT) [English] 11 Standard Maharashtra State Board Maharashtra State Board solutions in a manner that help students grasp basic concepts better and faster. The detailed, step-by-step solutions will help you understand the concepts better and clarify any confusion. Balbharati solutions for Mathematics Information Technology (IT) [English] 11 Standard Maharashtra State Board Maharashtra State Board 2 (Introduction to DBMS) include all questions with answers and detailed explanations. This will clear students' doubts about questions and improve their application skills while preparing for board exams.
Further, we at Shaalaa.com provide such solutions so students can prepare for written exams. Balbharati textbook solutions can be a core help for self-study and provide excellent self-help guidance for students.
Concepts covered in Information Technology (IT) [English] 11 Standard Maharashtra State Board chapter 2 Introduction to DBMS are Applications of DBMS, Advantages of DBMS, Database, Database Management System Software (DBMS), Relational Model of DBMS, Properties of Transactions (ACID), Introduction of RDBMS, Basic Database Concepts, Relationships in a Database, Introduction to SQL, Introduction to Data Model, Categories of SQL Commands, Data Types in the DBMS.
Using Balbharati Information Technology (IT) [English] 11 Standard Maharashtra State Board solutions Introduction to DBMS exercise by students is an easy way to prepare for the exams, as they involve solutions arranged chapter-wise and also page-wise. The questions involved in Balbharati Solutions are essential questions that can be asked in the final exam. Maximum Maharashtra State Board Information Technology (IT) [English] 11 Standard Maharashtra State Board students prefer Balbharati Textbook Solutions to score more in exams.
Get the free view of Chapter 2, Introduction to DBMS Information Technology (IT) [English] 11 Standard Maharashtra State Board additional questions for Mathematics Information Technology (IT) [English] 11 Standard Maharashtra State Board Maharashtra State Board, and you can use Shaalaa.com to keep it handy for your exam preparation.
