हिंदी
Tamil Nadu Board of Secondary EducationHSC Science Class 12

Samacheer Kalvi solutions for Computer Applications [English] Class 12 TN Board chapter 3 - Introduction to Database Management System [Latest edition]

Advertisements

Chapters

Samacheer Kalvi solutions for Computer Applications [English] Class 12 TN Board chapter 3 - Introduction to Database Management System - Shaalaa.com
Advertisements

Solutions for Chapter 3: Introduction to Database Management System

Below listed, you can find solutions for Chapter 3 of Tamil Nadu Board of Secondary Education Samacheer Kalvi for Computer Applications [English] Class 12 TN Board.


Evaluation - PART – IEvaluation - PART – IIEvaluation - PART – IIIEvaluation - PART – IV
Evaluation - PART – I [Page 82]

Samacheer Kalvi solutions for Computer Applications [English] Class 12 TN Board 3 Introduction to Database Management System Evaluation - PART – I [Page 82]

Choose the correct answer

Evaluation - PART – I | Q 1. | Page 82

Which language is used to request information from a Database?

  • Relational

  • Structural

  • Query

  • Compiler

Evaluation - PART – I | Q 2. | Page 82

The ______ diagram gives a logical structure of the database graphically?

  • Entity-Relationship

  • Entity

  • Architectural Representation

  • Database

Evaluation - PART – I | Q 3. | Page 82

An entity set that does not have enough attributes to form a primary key is known as ______.

  • Strong entity set

  • Weak entity set

  • Identity set

  • Owner set

Evaluation - PART – I | Q 4. | Page 82

______ command is used to delete a database.

  • Delete database database_name

  • Delete database_name

  • drop database database_name

  • drop database_name

Evaluation - PART – I | Q 5. | Page 82

MySQL belongs to which category of DBMS?

  • Object Oriented

  • Hierarchical

  • Relational

  • Network

Evaluation - PART – I | Q 6. | Page 82

MySQL is freely available and is open source.

  • True

  • False

Evaluation - PART – I | Q 7. | Page 82

______ represents a “tuple” in a relational database?

  • Table

  • Row

  • Column

  • Object

Evaluation - PART – I | Q 8. | Page 82

Communication is established with MySQL using ______.

  • SQL

  • Network calls

  • java

  • API’s

Evaluation - PART – I | Q 9. | Page 82

Which is the MySQL instance responsible for data processing?

  • MySQL Client

  • MySQL Server

  • SQL

  • Server Daemon Program

Evaluation - PART – I | Q 10. | Page 82

The structure representing the organizational view of entire database is known as ______ in MySQL database.

  • Schema

  • View

  • Instance

  • Table

Evaluation - PART – II [Page 83]

Samacheer Kalvi solutions for Computer Applications [English] Class 12 TN Board 3 Introduction to Database Management System Evaluation - PART – II [Page 83]

Short Answers

Evaluation - PART – II | Q 1 | Page 83

Define Data Model.

Evaluation - PART – II | Q 1. | Page 83

List the types of data model used.

Evaluation - PART – II | Q 2. | Page 83

List few disadvantages of the file processing system.

Evaluation - PART – II | Q 3. | Page 83

Define Single valued attributes.

Evaluation - PART – II | Q 3. | Page 83

Define multi-valued attributes.

Evaluation - PART – II | Q 4. | Page 83

List any two DDL commands with its Syntax.

Evaluation - PART – II | Q 4. | Page 83

List any two DML commands with its Syntax.

Evaluation - PART – II | Q 5. | Page 83

What are the ACID properties?

Evaluation - PART – II | Q 6. | Page 83

Which command is used to make permanent changes done by a transaction?

Evaluation - PART – II | Q 7. | Page 83

What is view in SQL?

Evaluation - PART – II | Q 8. | Page 83

Write the difference between SQL and MySQL.

Evaluation - PART – II | Q 9. | Page 83

What is a Relationship and List its types?

Evaluation - PART – II | Q 10. | Page 83

State a few advantages of Relational databases.

Evaluation - PART – III [Page 83]

Samacheer Kalvi solutions for Computer Applications [English] Class 12 TN Board 3 Introduction to Database Management System Evaluation - PART – III [Page 83]

Explain in Brief Answer

Evaluation - PART – III | Q 1. | Page 83

Explain on Evolution of DBMS.

Evaluation - PART – III | Q 2. | Page 83

What is a relationship in databases? List its types.

Evaluation - PART – III | Q 3. | Page 83

Discuss on Cardinality in DBMS.

Evaluation - PART – III | Q 4. | Page 83

List any 5 privileges available in MySQL for the User.

Evaluation - PART – III | Q 5. | Page 83

Write few commands used by DBA to control the entire database.

Evaluation - PART – IV [Page 83]

Samacheer Kalvi solutions for Computer Applications [English] Class 12 TN Board 3 Introduction to Database Management System Evaluation - PART – IV [Page 83]

Explain in detail

Evaluation - PART – IV | Q 1. | Page 83

Discuss on various database models available in DBMS.

Evaluation - PART – IV | Q 2. | Page 83

List the basic concepts of ER Model with suitable example.

Evaluation - PART – IV | Q 3. | Page 83

Discuss in detail on various types of attributes in DBMS.

Evaluation - PART – IV | Q 4. | Page 83

Write a note on open source software tools available in MySQL Administration.

Evaluation - PART – IV | Q 5. | Page 83

Explain the DDL command of their functions in SQL.

Solutions for 3: Introduction to Database Management System

Evaluation - PART – IEvaluation - PART – IIEvaluation - PART – IIIEvaluation - PART – IV
Samacheer Kalvi solutions for Computer Applications [English] Class 12 TN Board chapter 3 - Introduction to Database Management System - Shaalaa.com

Samacheer Kalvi solutions for Computer Applications [English] Class 12 TN Board chapter 3 - Introduction to Database Management System

Shaalaa.com has the Tamil Nadu Board of Secondary Education Mathematics Computer Applications [English] Class 12 TN Board Tamil Nadu Board of Secondary Education 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. Samacheer Kalvi solutions for Mathematics Computer Applications [English] Class 12 TN Board Tamil Nadu Board of Secondary Education 3 (Introduction to Database Management System) 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. Samacheer Kalvi textbook solutions can be a core help for self-study and provide excellent self-help guidance for students.

Concepts covered in Computer Applications [English] Class 12 TN Board chapter 3 Introduction to Database Management System are Dbms Database Models, Relational Database Management System, RDBMS Jargons, ER Model, ER-diagram, Introduction to MYSQL, MYSQL - Administration, MYSQL Administration Open Source Software Tools, Designing Databases, Introduction to SQL, Basic SQL Commands, Database Management System Software (DBMS).

Using Samacheer Kalvi Computer Applications [English] Class 12 TN Board solutions Introduction to Database Management System 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 Samacheer Kalvi Solutions are essential questions that can be asked in the final exam. Maximum Tamil Nadu Board of Secondary Education Computer Applications [English] Class 12 TN Board students prefer Samacheer Kalvi Textbook Solutions to score more in exams.

Get the free view of Chapter 3, Introduction to Database Management System Computer Applications [English] Class 12 TN Board additional questions for Mathematics Computer Applications [English] Class 12 TN Board Tamil Nadu Board of Secondary Education, and you can use Shaalaa.com to keep it handy for your exam preparation.

Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×