{"id":32918,"date":"2024-12-15T06:32:44","date_gmt":"2024-12-15T01:02:44","guid":{"rendered":"https:\/\/samacheerkalvi.guide\/?p=32918"},"modified":"2024-12-16T11:01:49","modified_gmt":"2024-12-16T05:31:49","slug":"samacheer-kalvi-12th-computer-applications-guide-chapter-3","status":"publish","type":"post","link":"https:\/\/samacheerkalvi.guide\/samacheer-kalvi-12th-computer-applications-guide-chapter-3\/","title":{"rendered":"Samacheer Kalvi 12th Computer Applications Guide Chapter 3 Introduction to Database Management System"},"content":{"rendered":"

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Computer Applications Guide<\/a> Pdf Chapter 3 Introduction to Database Management System Text Book Back Questions and Answers, Notes.<\/p>\n

Tamilnadu Samacheer Kalvi 12th Computer Applications Solutions Chapter 3 Introduction to Database Management System<\/h2>\n

12th Computer Applications Guide Introduction to Database Management System Text Book Questions and Answers<\/h3>\n

Part I<\/span><\/p>\n

Choose The Correct Answers<\/span><\/p>\n

Question 1.
\nWhich language is used to request information from a Database?
\na) Relational
\nb) Structural
\nc) Query
\nd) Compiler
\nAnswer:
\nc) Query<\/p>\n

\"Samacheer<\/p>\n

Question 2.
\nThe …………….. diagram gives a logical structure of the database graphically?
\na) Entity-Relationship
\nb) Entity
\nc) Architectural Representation
\nd) Database
\nAnswer:
\na) Entity-Relationship<\/p>\n

Question 3.
\nAn entity set that does not have enough attributes to form a primary key is known as
\na) Strong entity set
\nb) Weak entity set
\nc) Identity set
\nd) Owner set
\nAnswer:
\nb) Weak entity set<\/p>\n

Question 4.
\n_____ Command is used to delete a database.
\na) Delete database database_name
\nb) Delete database_name
\nc) drop database database_name
\nd) drop database_name
\nAnswer:
\nc) drop database database_name<\/p>\n

Question 5.
\nWhich type of below DBMS is MySQL?
\na) Object-Oriented
\nb) Hierarchical
\nc) Relational
\nd) Network
\nAnswer:
\nc) Relational<\/p>\n

\"Samacheer<\/p>\n

Question 6.
\nMySQL is freely available and is open source.
\na) True
\nb) False
\nAnswer:
\na) True<\/p>\n

Question 7.
\n……………….. represents a “tuple” in a relational database?
\na) Table
\nb) Row
\nc) Column
\nd) Object
\nAnswer:
\nb) Row<\/p>\n

Question 8.
\nCommunication is established with MySQL using
\na) SQL
\nb) Network calls
\nc) java
\nd) API’s
\nAnswer:
\na) SQL<\/p>\n

Question 9.
\nWhich is the MySQL instance responsible for data processing?
\na) MySQL Client
\nb) MySQL Server
\nc) SQL
\nd) Server Daemon Program
\nAnswer:
\nc) SQL<\/p>\n

\"Samacheer<\/p>\n

Question 10.
\nThe structure representing the organizational view of the entire database is known as _____ In MySQL database.
\na) Schema
\nb) View
\nc) Instance
\nd) Table
\nAnswer:
\na) Schema<\/p>\n

Part II<\/span><\/p>\n

Short Answers<\/span><\/p>\n

Question 1.
\nDefine Data Model and list the types of data model used.
\nAnswer:
\nData models define how the logical structure of a database is modeled.
\nData models define how data is connected to each other and how they are processed and stored inside the system. The various data models are;<\/p>\n

    \n
  1. Hierarchical Database Model,<\/li>\n
  2. Network Model,<\/li>\n
  3. Relational Model and<\/li>\n
  4. Object-oriented Database Model.<\/li>\n<\/ol>\n

    Question 2.
    \nList few disadvantages of the file processing system.
    \nAnswer:
    \nData Duplication – Same data is used by multi\u00acple resources for processing, thus created multiple copies of the same data wasting the spaces.<\/p>\n

    High Maintenance – Access control and verify- ing data consistency needs high maintenance cost.
    \nSecurity – Less security provided to the data.<\/p>\n

    Question 3.
    \nDefine Single and multi-valued attributes.
    \nAnswer:
    \nA single-valued attribute contains only one value for the attribute and they don\u2019t have multiple numbers of values. For Example Age.
    \nA multi-valued attribute has more than one value for that particular attribute. For Example Degree.<\/p>\n

    \"Samacheer<\/p>\n

    Question 4.
    \nList any two DDL and DHL commands with its Syntax.
    \nAnswer:
    \nDDL Commands:<\/p>\n\n\n\n\n\n
    Commands<\/td>\nSyntax<\/td>\n<\/tr>\n
    CREATE<\/td>\nCREATE database databasename;<\/td>\n<\/tr>\n
    DROP<\/td>\nDROP database databasename;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    DML Commands:<\/p>\n\n\n\n\n\n
    Commands<\/td>\nSyntax<\/td>\n<\/tr>\n
    INSERT<\/td>\nINSERT INTO table name VALUES (value1, value2, values);<\/td>\n<\/tr>\n
    DELETE<\/td>\nDELETE from table name WHERE columnname=”value”;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Question 5.
    \nWhat are the ACID properties?
    \nAnswer:
    \nACID Properties – The acronym stands for Atomicity, Consistency, Isolation and Durability. Atomicity follows the thumb rule \u201cAll or Nothing\u201d while updating the data in the database for the user performing the update operation. Consistency ensures that the changes in data value to be constant at any given instance. Isolation property is needed during concurrent action. Durability is defined as the system\u2019s ability to recover all committed actions during the failure of storage or the system.<\/p>\n

    \"Samacheer<\/p>\n

    Question 6.
    \nWhich command is used to make permanent changes done by a transaction?
    \nAnswer:<\/p>\n

      \n
    • These SQL commands manage the transactions in SQL databases.<\/li>\n
    • It also helps to save the change into the database permanently.<\/li>\n
    • COMMIT, ROLLBACK, SET TRANSACTION, and SAVEPOINT commands belong to this category.<\/li>\n<\/ul>\n

      Question 7.
      \nWhat is a view in SQL?
      \nAnswer:
      \nViews – A set of stored queries.<\/p>\n

      Question 8.
      \nWrite the difference between SQL and MySQL.
      \nAnswer:<\/p>\n\n\n\n\n\n
      SQL<\/td>\nMySQL<\/td>\n<\/tr>\n
      SQL is a query language.<\/td>\nMySQL is database software.<\/td>\n<\/tr>\n
      To query and operate a database system.<\/td>\nAllows data handling, storing, modifying, deleting in a tabular format.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      Question 9.
      \nWhat is a Relationship and List its types?
      \nAnswer:
      \nOne-to-One relationship
      \nOne-to-Many relationship
      \nMany-to-Many relationship<\/p>\n

      Question 10.
      \nState a few advantages of Relational databases.
      \nAnswer:<\/p>\n

        \n
      1. High Availability<\/li>\n
      2. High Performance<\/li>\n
      3. Robust transfer actions and support<\/li>\n
      4. Ease of management<\/li>\n
      5. Less cost<\/li>\n<\/ol>\n

        \"Samacheer<\/p>\n

        Part III<\/span><\/p>\n

        Explain In Brief Answer<\/span><\/p>\n

        Question 1.
        \nExplain on Evolution of DBMS.
        \nAnswer:<\/p>\n

          \n
        1. The concept of storing the data started 40 years in various formats.<\/li>\n
        2. In earlier days they have used punched card technology to store the data.<\/li>\n
        3. Then files were used. The file systems were known as the predecessor of the database system.<\/li>\n
        4. Various access methods in the file system were indexed, random, and sequential access.<\/li>\n
        5. The file systems have limitations like duplication, less security. To overcome this, DBMS was introduced.<\/li>\n<\/ol>\n

          Question 2.
          \nWhat is a relationship in databases? List its types.
          \nAnswer:
          \nThere exists a relationship between two tables when the foreign key of one table references the primary key of other tables.
          \nThe Entity-Relationship(ER) diagram is based on the three types listed below.<\/p>\n

            \n
          • One-to-One relationship<\/li>\n
          • One-to-Many relationship<\/li>\n
          • Many-to-Many relationship<\/li>\n<\/ul>\n

            \"Samacheer<\/p>\n

            Question 3.
            \nDiscuss on Cardinality in DBMS.
            \nAnswer:<\/p>\n

              \n
            • It is defined as the number of different values in any given table column<\/li>\n
            • It Is defined as the number of items that must be II included in a relationship.ie) number of entities | in one set mapped with the number of entities of I another set via the relationship,<\/li>\n
            • Three classifications in Cardinality are one-to-one, jl one-to-many and Many-to-Many.<\/li>\n<\/ul>\n

              Question 4.
              \nList any 5 privileges available in MySQL for the User.
              \nAnswer:<\/p>\n\n\n\n\n\n\n\n\n
              Privileges<\/td>\n\n

              Action Performed (If Granted)<\/p>\n<\/td>\n<\/tr>\n

              Select_priv<\/td>\nUser can select rows from database tables.<\/td>\n<\/tr>\n
              Insert_priv<\/td>\nUser can insert rows into database tables.<\/td>\n<\/tr>\n
              Update_priv<\/td>\nUser can update rows of database tables.<\/td>\n<\/tr>\n
              Deiete^priv<\/td>\nUser can delete rows of database tables.<\/td>\n<\/tr>\n
              Create_priv<\/td>\nUser can create new tables in database<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

              Question 5.
              \nWrite few commands used by DBA to control the entire database.
              \nAnswer:
              \nUSE Database
              \nThis command is used to select the database in MySQL for working.
              \nSyntax: mysql>use test;<\/p>\n

              SHOW Databases
              \nLists all the databases available in the database server,
              \nSyntax: mysql>show databases;<\/p>\n

              SHOW Tables
              \nLists all the tables available in the current database we are working in.
              \nSyntax: mysql>show tables;<\/p>\n

              \"Samacheer<\/p>\n

              Part IV<\/span><\/p>\n

              Explain In Detail<\/span><\/p>\n

              Question 1.
              \nDiscuss on various database model available in DBMS.
              \nAnswer:
              \nThe major database models are listed below:<\/p>\n

                \n
              • Hierarchical Database Model<\/li>\n
              • Network model<\/li>\n
              • Relational model<\/li>\n
              • Object-oriented database mode!<\/li>\n<\/ul>\n

                Hierarchical Database Model<\/p>\n

                  \n
                • In this model each record has information in par-ent\/child relationship like a tree structure.<\/li>\n
                • The collection of records was called as record types, which are equivalent to tables in relational model.<\/li>\n
                • The individual records are equal to rows.<\/li>\n
                • The famous Hierarchical database model was IMS (Information Management System), IBM’s first DBMS,<\/li>\n<\/ul>\n

                  Advantages:<\/p>\n

                    \n
                  • Less redundant data<\/li>\n
                  • Efficient search<\/li>\n
                  • Data integrity<\/li>\n
                  • Security<\/li>\n<\/ul>\n

                    \"Samacheer<\/p>\n

                    Limitations:<\/p>\n

                      \n
                    • Complex to implement and difficult in handling<\/li>\n
                    • Many to many relationships<\/li>\n<\/ul>\n

                      Network model<\/p>\n

                        \n
                      • The network model is similar to the Hierarchical model except that in this model each member can have
                        \nmore than one owner.<\/li>\n
                      • The many to many relationships are handled in a better way.<\/li>\n
                      • This model identified the three database components<\/li>\n
                      • Network schema – Defines all about the structure of the database<\/li>\n
                      • Sub schema – Controls on views of the database for the user.<\/li>\n
                      • Language for data management – Basic procedural for accessing the database.<\/li>\n<\/ul>\n

                        Relational model:<\/p>\n

                        Oracle and DB2 are few commercial relational models in use.
                        \nThe relational model is defined with two terminologies Instance and Schema.<\/p>\n

                          \n
                        • Instance – A table consisting of rows and columns<\/li>\n
                        • Schema – Specifies the structure including the name and type of each column.<\/li>\n<\/ul>\n

                          A relation (table) consists of unique attributes (columns) and tuples (rows).<\/p>\n

                          Object-oriented database model<\/p>\n

                            \n
                          • This model incorporates the combination of Object-Oriented Programming(OOP’s) concepts and database technologies.<\/li>\n
                          • Practically, this model serves as the base of the Relational model.<\/li>\n
                          • The object-oriented model uses small, reusable software known as Objects.<\/li>\n
                          • These are stored in an object-oriented database.<\/li>\n
                          • This model efficiently manages a large number of different data types.<\/li>\n
                          • Moreover, complex behaviors are handled efficiently using OOP’s concepts.<\/li>\n<\/ul>\n

                            \"Samacheer<\/p>\n

                            Question 2.
                            \nList the basic concepts of ER Model with suitable examples.
                            \nAnswer:
                            \nThe basic concepts of ER model consist of<\/p>\n

                              \n
                            • Entity or Entity type<\/li>\n
                            • Attributes<\/li>\n
                            • Relationship<\/li>\n<\/ul>\n

                              These are the general concepts which help to create an ER diagram and produce an ER model.<\/p>\n

                              Entity or Entity type:<\/p>\n

                                \n
                              • An Entity can be anything a real-world object or animation which is easily identifiable by anyone even by a common man.<\/li>\n
                              • Example: In a company’s database Employees, HR, Manager are considered entities.<\/li>\n
                              • An entity is represented by a rectangular box.<\/li>\n<\/ul>\n

                                Types of Entity:<\/p>\n

                                  \n
                                1. Strong Entity<\/li>\n
                                2. Weak Entity<\/li>\n
                                3. Entity Instance<\/li>\n<\/ol>\n

                                  Strong Entity<\/p>\n

                                    \n
                                  • A Strong entity is the one which doesn’t depend on any other entity on the schema or database<\/li>\n
                                  • A strong entity will have a primary key with it.<\/li>\n
                                  • It is represented by one rectangle<\/li>\n<\/ul>\n

                                    Weak Entity<\/p>\n

                                      \n
                                    • A weak entity is dependent on other entities and it doesn’t have any primary key like the Strong entity.<\/li>\n
                                    • It is represented by a double rectangle.<\/li>\n<\/ul>\n

                                      Entity Instance<\/p>\n

                                        \n
                                      • Instances are the values for the entity if we consider animals as the entity their instances will be dog, cat, cow… Etc.<\/li>\n
                                      • So an Entity Instance denotes the category values for the given entity.<\/li>\n<\/ul>\n

                                        Attributes:<\/p>\n

                                          \n
                                        • An attribute is the information about that entity and it will describe, quantify, classify, and specify an entity.<\/li>\n
                                        • An attribute will always have a single value, that value can be a number or character or string.<\/li>\n<\/ul>\n

                                          Types of attributes:<\/p>\n

                                            \n
                                          1. Key Attribute<\/li>\n
                                          2. Simple Attributes<\/li>\n
                                          3. Composite Attributes<\/li>\n
                                          4. Single Valued Attribute<\/li>\n
                                          5. Multi-Valued Attribute<\/li>\n<\/ol>\n

                                            Relationship:
                                            \nThere exists a relationship between two tables when the foreign key of one table references primary key of other table.
                                            \nThe Entity-Relationship(ER) diagram is based on the three types listed below.<\/p>\n

                                              \n
                                            • One-to-One relationship<\/li>\n
                                            • One-to-Many relationship<\/li>\n
                                            • Many-to-Many relationship<\/li>\n<\/ul>\n

                                              \"Samacheer<\/p>\n

                                              Question 3.
                                              \nDiscuss in detail various types of attributes in DBMS.
                                              \nAnswer:
                                              \nTypes of attributes:
                                              \n1. Key Attribute:
                                              \nGenerally, a key attribute describes a unique characteristic of an entity.<\/p>\n

                                              2. Simple Attribute:<\/p>\n

                                                \n
                                              • The simple attributes cannot be separated it will be having a single value for their entity.<\/li>\n
                                              • For Example: Let us consider the name as the attribute for the entity employee and here the value for that attribute is a single value.<\/li>\n<\/ul>\n

                                                3. Composite Attributes:<\/p>\n

                                                  \n
                                                • The composite attributes can be sub divided into simple attributes without change in the meaning of that attribute.<\/li>\n
                                                • For Example: In the above diagram the employee is the entity with the composite attri\u00acbute Name which are sub-divided into two simple attributes first and last name.<\/li>\n<\/ul>\n

                                                  4. Single Valued Attributes;<\/p>\n

                                                    \n
                                                  • A single valued attribute contains only one value for the attribute and they don’t have multiple numbers of values.<\/li>\n
                                                  • For Example: Age- It is a single value for a person as we cannot give n number of ages for a single person; therefore it is a single valued attribute.<\/li>\n<\/ul>\n

                                                    5. Multi-Valued Attributes:<\/p>\n

                                                      \n
                                                    • A multi valued attribute has more than one value for that particular attribute.<\/li>\n
                                                    • For Example: Degree – A person can hold n number of degrees so it is a multi-valued attribute.<\/li>\n<\/ul>\n

                                                      Question 4.
                                                      \nWrite a note on open-source software tools available in MySQL Administration.
                                                      \nAnswer:<\/p>\n

                                                        \n
                                                      • MySQL is open source software that allows managing relational databases.<\/li>\n
                                                      • It also provides the flexibility of changing the source code as per the needs.<\/li>\n
                                                      • It runs on multiple platforms like Windows, Linux and is scalable, reliable and fast.<\/li>\n<\/ul>\n

                                                        PHPMYADMIN (Web Admin)<\/p>\n

                                                          \n
                                                        • This administrative tool of MySQL is aweb application written in PHP. They are used predominantly in web hosting.<\/li>\n
                                                        • The main feature is providing web interface,- importing data from CSV and exporting data to various formats.<\/li>\n
                                                        • It generates live charts for monitoring MySQL server activities like connections, processes and memory usage. It also helps in making the complex queries easier.<\/li>\n<\/ul>\n

                                                          MySQL Workbench (Desktop Application)<\/p>\n

                                                            \n
                                                          • It is a database tool used by developers and DBA’s mainly for visualization.<\/li>\n
                                                          • This toolhelps in data modeling, development of SQLServer configuration and backup for MySQLin a better way.<\/li>\n
                                                          • Its basic release version is 5.0and is now in 8.0 supporting all Operating Systems.<\/li>\n
                                                          • The SQL editor of this tool is veryflexible and comfortable in dealing multiple results set.<\/li>\n<\/ul>\n

                                                            HeidiSQL (Desktop Application)<\/p>\n

                                                              \n
                                                            • This open source tools helps in the administra-tion of better database systems.<\/li>\n
                                                            • It supports GUI (Graphical User Interface) features for monitoring server host, server connection, Databases, Tables, Views, Triggers and Events.<\/li>\n<\/ul>\n

                                                              \"Samacheer<\/p>\n

                                                              Question 5.
                                                              \nExplain in detail on Sub Queries with suitable examples.
                                                              \nAnswer:<\/p>\n

                                                                \n
                                                              • The SQL query is written within amain Query.<\/li>\n
                                                              • This is called Nested Inner\/SubQuery.<\/li>\n
                                                              • The sub query is executed first and the results of sub query are used as the condition for main query.<\/li>\n<\/ul>\n

                                                                The sub query must follow the below rules:<\/p>\n

                                                                  \n
                                                                • Subqueries are always written within the parentheses.<\/li>\n
                                                                • Always place the Subquery on the right side of the comparison operator.<\/li>\n
                                                                • ORDER BY clause is not used insub query, since Subqueries cannot manipulate the results internally.<\/li>\n<\/ul>\n

                                                                  Example: (Consider the Employee tablewith the fields EmpID, Name, Age andSalary.)
                                                                  \nSELECT * from Employee WHERE EmpID IN (SE-LECT EmpID from Employee WHERE Salary 20000);
                                                                  \nFirst, the inner query is executed. Then outer query will be executed.<\/p>\n

                                                                  12th Computer Applications Guide Introduction to Database Management System Additional Important Questions and Answers<\/h3>\n

                                                                  Part A<\/span><\/p>\n

                                                                  Choose The Correct Answers:<\/span><\/p>\n

                                                                  Question 1.
                                                                  \nExpand DBMS?
                                                                  \n(a) Database Management System
                                                                  \n(b) Data Manipulation Schema
                                                                  \n(c) Data Base Management Schema
                                                                  \n(d) DataBase Manipulation Schema
                                                                  \nAnswer:
                                                                  \n(a) Database Management System<\/p>\n

                                                                  Question 2.
                                                                  \nDBMS provides to ………………… data
                                                                  \na) create
                                                                  \nb) retrieve
                                                                  \nc) update
                                                                  \nd) all of the above
                                                                  \nAnswer:
                                                                  \nd) all of the above<\/p>\n

                                                                  Question 3.
                                                                  \nExpand ODBMS.
                                                                  \n(a) Object DataBase Management System
                                                                  \n(b) Objective Data Base Management System
                                                                  \n(c) Object-Oriented DataBase Management System
                                                                  \n(d) Objective Data Manipulation System
                                                                  \nAnswer:
                                                                  \n(a) Object DataBase Management System<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Question 4.
                                                                  \n……………. is defined as the system’s ability to recover all committed transactions during the failure of storage or the system.
                                                                  \na) Durability
                                                                  \nb) Consistency
                                                                  \nc) Concurrency
                                                                  \nd) All of the above
                                                                  \nAnswer:
                                                                  \na) Durability<\/p>\n

                                                                  Question 5.
                                                                  \nWhich of the following is a commercial relational models in use.
                                                                  \na) Oracle
                                                                  \nb) DB2
                                                                  \nc) PostgreSQL
                                                                  \nd) Both a and b
                                                                  \nAnswer:
                                                                  \nd) Both a and b<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Question 6.
                                                                  \nTo prevent conflict in database updates, the transactions are isolated from other users and serialized. This is called as ……………………….
                                                                  \n(a) Atomicity
                                                                  \n(b) Consistency
                                                                  \n(c) Isolation
                                                                  \n(d) Degree of Consistency
                                                                  \nAnswer:
                                                                  \n(d) Degree of Consistency<\/p>\n

                                                                  Question 7.
                                                                  \nA key with more than one attribute to identify rows uniquely in a table is called…………….
                                                                  \na) Candidate Key
                                                                  \nb) Super Key
                                                                  \nc) Foreign Key
                                                                  \nd) Composite Key
                                                                  \nAnswer:
                                                                  \nd) Composite Key<\/p>\n

                                                                  Question 8.
                                                                  \nAn …………….\u00a0 can be anything a real-world object or animation
                                                                  \na) Data
                                                                  \nb) Entity
                                                                  \nc) Instance
                                                                  \nd) Relationship
                                                                  \nAnswer:
                                                                  \nb) Entity<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Question 9.
                                                                  \nConcurrency control and locking are needed
                                                                  \n(a) Consistency
                                                                  \n(b) data sharing
                                                                  \n(c) data hiding
                                                                  \n(d) TrAnswer:action
                                                                  \nAnswer:
                                                                  \n(b) data sharing<\/p>\n

                                                                  Question 10.
                                                                  \n………… describes a unique characteristic of an entity.
                                                                  \na) Key Attribute
                                                                  \nb) Simple Attributes
                                                                  \nc) Composite Attributes
                                                                  \nd) Single Valued Attribute
                                                                  \nAnswer:
                                                                  \na) Key Attribute<\/p>\n

                                                                  Question 11.
                                                                  \n………… can be subdivided into simple attributes without change in the meaning of that attribute.
                                                                  \na) Key Attribute
                                                                  \nb) Simple Attributes
                                                                  \nc) Composite Attributes
                                                                  \nd) Single Valued Attribute
                                                                  \nAnswer:
                                                                  \nc) Composite Attributes<\/p>\n

                                                                  Question 12.
                                                                  \nA …………. contains only one value for the attribute and they don’t have multiple numbers of values.
                                                                  \na) Key Attribute
                                                                  \nb) Simple Attributes
                                                                  \nc) Composite Attributes
                                                                  \nd) Single Valued Attribute
                                                                  \nAnswer:
                                                                  \nd) Single Valued Attribute<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Question 13.
                                                                  \nIBM\u2019s first DBMS is ……………………..
                                                                  \n(a) IMS
                                                                  \n(b) IVS
                                                                  \n(c) BMS
                                                                  \n(d) VMS
                                                                  \nAnswer:
                                                                  \n(a) IMS<\/p>\n

                                                                  Question 14.
                                                                  \nA ……………. has more than one value for that particular attribute.
                                                                  \na) Multi-valued attribute
                                                                  \nb) Simple Attributes
                                                                  \nc) Composite Attributes
                                                                  \nd) Single Valued Attribute
                                                                  \nAnswer:
                                                                  \na) Multi-valued attribute<\/p>\n

                                                                  Question 15.
                                                                  \nThe parent-child relationship is established in …………………….. database Models.
                                                                  \n(a) Hierarchical
                                                                  \n(b) Network
                                                                  \n(c) Relational
                                                                  \n(d) Object
                                                                  \nAnswer:
                                                                  \n(a) Hierarchical<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Fill in the Blanks:<\/span><\/p>\n

                                                                  1. ………………is known a predecessor of database system
                                                                  \nAnswer:
                                                                  \nFile system<\/p>\n

                                                                  2. MySQL is a database management system founded by…………………
                                                                  \nAnswer:
                                                                  \nMonty Widenius<\/p>\n

                                                                  3. ……………who takes care of configuration, installation, performance, security and data backup.
                                                                  \nAnswer:
                                                                  \nDatabase Administrators<\/p>\n

                                                                  4. …………….. is a web application written in PHP
                                                                  \nAnswer:
                                                                  \nPHPMYADMIN<\/p>\n

                                                                  5. ………………tool of MySQL is a web application written in PHP.
                                                                  \nAnswer:
                                                                  \nPHPMYADMIN<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  6. ………………….. is a database tool used by developers and DBA’s mainly for visualization.
                                                                  \nAnswer:
                                                                  \nMySQL Workbench<\/p>\n

                                                                  Question 7.
                                                                  \nThe ……………….. of this tool is very flexible and comfortable in dealing with multiple results set.
                                                                  \nAnswer:
                                                                  \nSQL editor<\/p>\n

                                                                  Question 8.
                                                                  \n…………………….. is a program or process of copying table contents into a file for future reference
                                                                  \nAnswer:
                                                                  \nBackup<\/p>\n

                                                                  Question 9.
                                                                  \nSQL query is written within a main Query is called as
                                                                  \nAnswer:
                                                                  \nSub Query<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Question 10.
                                                                  \nAn attribute is the information about that …………………
                                                                  \nAnswer:
                                                                  \nEntity<\/p>\n

                                                                  Abbrevation<\/span><\/p>\n

                                                                  1. DBMS – Database Management System.
                                                                  \n2. RDBMS – Relation Database Management System.
                                                                  \n3. OSBMS – Objective Database Management System.
                                                                  \n4. ACID – Automicity, Consistency, Isolation, And Durability.
                                                                  \n5. IMS – Information Management System.
                                                                  \n6. IDS – Integrated Data Store.
                                                                  \n7. OOP’S – Object Oriented Programming.
                                                                  \n8. SQL – Structure Query Language.
                                                                  \n9. ER – Entity Relationship.
                                                                  \n10. DBA – Database Administration.
                                                                  \n11. ANSI – American National Standards Institute.
                                                                  \n12. ISO – International Organization For Standardization.
                                                                  \n13. DDL – Data Definition Language.
                                                                  \n14. DML – Data Manipulation Language.
                                                                  \n15. DQL – Data Query Language.
                                                                  \n16. TCL – Transaction Control Language.
                                                                  \n17. DCL – Data Control Language.<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Assertion And Reason<\/span><\/p>\n

                                                                  Question 1.
                                                                  \nAssertion (A): database management system (DBMS) is system software for creating and managing databases.
                                                                  \nReason (R): The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.\u201d
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
                                                                  \nc) (A) is true and (R) is false
                                                                  \nd) (A) is false and (R) is true
                                                                  \nAnswer:
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)<\/p>\n

                                                                  Question 2.
                                                                  \nAssertion (A) : In a database, we would be grouping only related data together and storing them under one group name called table.
                                                                  \nReason (R): This helps in identifying which data stored where and under what name.
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
                                                                  \nc) (A) is true and (R) is false
                                                                  \nd) (A) is false and (R) \u00a1s true
                                                                  \nAnswer:
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)<\/p>\n

                                                                  Question 3.
                                                                  \nAssertion (A): Oracle and DB2 are few commercial relational models in use.
                                                                  \nReason (R): Relational model is defined with two terminologies Instance and Schema.
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
                                                                  \nc) (A) is true and (R) is false
                                                                  \nd) (A) is false and (R) \u00a1s true
                                                                  \nAnswer:
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Question 4.
                                                                  \nAssertion (A): A single-valued attribute con\u00actains only one value for the attribute and they don’t have multiple numbers of values.
                                                                  \nReason (R): Age – It is a single value for a person as we cannot give n number of ages for a single person, therefore it is a single-valued attribute.
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
                                                                  \nc) (A) is true and (R) Is false
                                                                  \nd) (A) is false and (R) is true
                                                                  \nAnswer:
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)<\/p>\n

                                                                  Question 5.
                                                                  \nAssertion (A): Cardinality is defined as the number of items that must be included in a relationship.ie) number of entities in one set mapped with the number of entities of another set via the relationship.
                                                                  \nReason (R): Three classifications in Cardinality areMany-to-one, one-to-many and Many-to-Many,
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
                                                                  \nc) (A) is true and (R) is false
                                                                  \nd) (A) is false and (R) is true
                                                                  \nAnswer:
                                                                  \nc) (A) is true and (R) is false<\/p>\n

                                                                  Question 6.
                                                                  \nAssertion (A): The Database Administrator (DBA) frequently uses few commands to control the entire database.
                                                                  \nReason (R): These commands are known as SQL Server Commands.
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
                                                                  \nc) (A) is true and (R) is false
                                                                  \nd) (A) is false and (R) is true
                                                                  \nAnswer:
                                                                  \nc) (A) is true and (R) is false<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Question 7.
                                                                  \nAssertion (A); Subqueries are always written within the braces.
                                                                  \nReason (R): ORDER BY clause is not used in sub query, since Subqueries cannot manipulate the results internally.
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
                                                                  \nc) (A) is true and (R) is false
                                                                  \nd) (A) is false and (R) is true
                                                                  \nAnswer:
                                                                  \nd) (A) is false and (R) is true<\/p>\n

                                                                  Question 8.
                                                                  \nAssertion (A); TCL commands manage the transactions in SQL databases. It also helps to save the change into database permanently.
                                                                  \nReason (R) : CREATE, ALTER, DROP, RENAME and TRUNCATE commands belongs to TCL category.
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
                                                                  \nc) (A) is true and (R) is false
                                                                  \nd) (A) is false and (R) is true
                                                                  \nAnswer:
                                                                  \nc) (A) is true and (R) is false<\/p>\n

                                                                  Question 9.
                                                                  \nAssertion (A); A Strong entity is the one which doesn’t depend on any other entity on the schema or database and a strong entity will have a primary key with it
                                                                  \nReason (R): It is represented by one rectangle.
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
                                                                  \nc) (A) is true and (R) is faise
                                                                  \nd) (A) is false and (R) is true
                                                                  \nAnswer:
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Question 10.
                                                                  \nAssertion (A) ; A weak entity is dependent on other entitles and it doesn’t have any primary key like the Strong entity.
                                                                  \nReason (R): It is represented by Diamond,
                                                                  \na) Both (A) and (R) are correct and (R) is the correct explanation of (A)
                                                                  \nb) Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
                                                                  \nc) (A) is true and (R) is false
                                                                  \nd) (A) is false and (R) is true
                                                                  \nAnswer:
                                                                  \nc) (A) is true and (R) is false<\/p>\n

                                                                  Find the odd one on the following:<\/span><\/p>\n

                                                                  1. (a) Sorting
                                                                  \n(b) Retrieving
                                                                  \n(c) Filtering
                                                                  \n(d) Aligning
                                                                  \nAnswer:
                                                                  \n(d) Aligning<\/p>\n

                                                                  2. (a) Creating
                                                                  \n(b) Updating
                                                                  \n(c) Managing
                                                                  \n(d) Converting
                                                                  \nAnswer:
                                                                  \n(d) Converting<\/p>\n

                                                                  3. (a) Data Duplication
                                                                  \n(b) Data Flexibility
                                                                  \n(c) Data Maintenance
                                                                  \n(d) Security
                                                                  \nAnswer:
                                                                  \n(c) Data Maintenance<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  4. (a) Access
                                                                  \n(b) SQL
                                                                  \n(c) Oracle
                                                                  \n(d) Notepad
                                                                  \nAnswer:
                                                                  \n(b) SQL<\/p>\n

                                                                  5. (a) Consistency
                                                                  \n(b) Durability
                                                                  \n(c) Activity
                                                                  \n(d) Isolation
                                                                  \nAnswer:
                                                                  \n(c) Activity<\/p>\n

                                                                  6. (a) DBMS
                                                                  \n(b) Network Schema
                                                                  \n(c) Subschema
                                                                  \n(d) Language
                                                                  \nAnswer:
                                                                  \n(a) DBMS<\/p>\n

                                                                  7. (a) id:int
                                                                  \n(b) name:int
                                                                  \n(c) Nfname:string
                                                                  \n(d) email:string
                                                                  \nAnswer:
                                                                  \n(b) name:int<\/p>\n

                                                                  8. (a) Table
                                                                  \n(b) attribute
                                                                  \n(c) files
                                                                  \n(d) Tuples
                                                                  \nAnswer:
                                                                  \n(c) files<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  9. (a) Class
                                                                  \n(b) Object
                                                                  \n(c) Data
                                                                  \n(d) Abstraction
                                                                  \nAnswer:
                                                                  \n(c) Data<\/p>\n

                                                                  10. (a) Schema
                                                                  \n(b) Key
                                                                  \n(c) Tuple
                                                                  \n(d) Cell
                                                                  \nAnswer:
                                                                  \n(d) Cell<\/p>\n

                                                                  11. (a) Windows
                                                                  \n(b) Linux
                                                                  \n(c) MACOS
                                                                  \n(d) MSSQLServer
                                                                  \nAnswer:
                                                                  \n(d) MSSQLServer<\/p>\n

                                                                  12. (a) Row
                                                                  \n(c) Record
                                                                  \n(b) attribute
                                                                  \n(d) Tuple
                                                                  \nAnswer:
                                                                  \n(b) attribute<\/p>\n

                                                                  13. (a) Vertical Entity
                                                                  \n(b) Attribute
                                                                  \n(c) Tuple
                                                                  \n(d) column
                                                                  \nAnswer:
                                                                  \n(c) Tuple<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  14. (a) primary Key
                                                                  \n(b) Secondary Key
                                                                  \n(c) SuperKey
                                                                  \n(d) Foreign Key
                                                                  \nAnswer:
                                                                  \n(b) Secondary Key<\/p>\n

                                                                  15. (a) Strong Entity
                                                                  \n(c) Super Entity
                                                                  \n(b) Weak Entity
                                                                  \n(d) Entity Instance
                                                                  \nAnswer:
                                                                  \n(c) Super Entity<\/p>\n

                                                                  16. (a) Schema
                                                                  \n(b) Database
                                                                  \n(c) primary Key
                                                                  \n(d) Foreign Key
                                                                  \nAnswer:
                                                                  \n(d) Foreign Key<\/p>\n

                                                                  17. (a) Degree
                                                                  \n(b) Bank Account
                                                                  \n(c) Age
                                                                  \n(d) Subjects
                                                                  \nAnswer:
                                                                  \n(c) Age<\/p>\n

                                                                  18. (a) One:Unary
                                                                  \n(b) Two: Binary
                                                                  \n(c) Three:Ternary
                                                                  \n(d) Four: penta
                                                                  \nAnswer:
                                                                  \n(d) Four: penta<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  19. (a) Rectangle
                                                                  \n(b) Square
                                                                  \n(c) Rhombus
                                                                  \n(d) Ellipse
                                                                  \nAnswer:
                                                                  \n(b) Square<\/p>\n

                                                                  20. (a) DB2
                                                                  \n(b) Netfix
                                                                  \n(c) SQL Lite
                                                                  \n(d) Oracle
                                                                  \nAnswer:
                                                                  \n(b) Netfix<\/p>\n

                                                                  21. (a) Configuration
                                                                  \n(b) Installation
                                                                  \n(c) Performance
                                                                  \n(d) Access
                                                                  \nAnswer:
                                                                  \n(d) Access<\/p>\n

                                                                  22. (a) INSERT
                                                                  \n(b) EDIT
                                                                  \n(c) SELECT
                                                                  \n(d) UPDATE
                                                                  \nAnswer:
                                                                  \n(b) EDIT<\/p>\n

                                                                  23. (a) Select_Priv
                                                                  \n(b) Delete_Priv
                                                                  \n(c) create_Priv
                                                                  \n(d) Edit_Priv
                                                                  \nAnswer:
                                                                  \n(d) Edit_Priv<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  24. (a) MySQL
                                                                  \n(b) Workbench
                                                                  \n(c) PHPMYADMIN
                                                                  \n(d) HeidiSQL
                                                                  \nAnswer:
                                                                  \n(c) PHPMYADMIN<\/p>\n

                                                                  25. (a) ServerHost
                                                                  \n(b) Server Connection
                                                                  \n(c) Events
                                                                  \n(d) processor
                                                                  \nAnswer:
                                                                  \n(d) processor<\/p>\n

                                                                  26. (a) Dashboard
                                                                  \n(b) Reports
                                                                  \n(c) Table
                                                                  \n(d) Statistics
                                                                  \nAnswer:
                                                                  \n(c) Table<\/p>\n

                                                                  27. (a) Table
                                                                  \n(b) Insert
                                                                  \n(c) Queries
                                                                  \n(d) Views
                                                                  \nAnswer:
                                                                  \n(b) Insert<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  28. (a) TRUNCATE
                                                                  \n(b) RENAME
                                                                  \n(c) SELECT
                                                                  \n(d) ALTER
                                                                  \nAnswer:
                                                                  \n(c) SELECT<\/p>\n

                                                                  29. (a) DDL
                                                                  \n(b) DML
                                                                  \n(c) HeidiSQL
                                                                  \n(d) DQL
                                                                  \nAnswer:
                                                                  \n(c) HeidiSQL<\/p>\n

                                                                  30. (a) ANY
                                                                  \n(b) AND
                                                                  \n(c) UNIQUE
                                                                  \n(d) XOR
                                                                  \nAnswer:
                                                                  \n(d) XOR<\/p>\n

                                                                  MAtch the following:<\/span><\/p>\n

                                                                  1. Hierarchical Database – Sybase
                                                                  \n2. Network Database – Rhombus
                                                                  \n3. Relational Database – Multivalued Attribute
                                                                  \n4. Column – Candidate Key
                                                                  \n5. Row – Record
                                                                  \n6. Primary key – Attribute
                                                                  \n7. Super Key – Unique Key Identifier
                                                                  \n8. Double Ellipse – Oracle
                                                                  \n9. Relationships – IMS
                                                                  \n10. Database – IDS
                                                                  \nAnswer:
                                                                  \n1. IMS
                                                                  \n2. IDS
                                                                  \n3. Oracle
                                                                  \n4. Attribute
                                                                  \n5. Record
                                                                  \n6. Unique Key
                                                                  \n7. Candidate Key
                                                                  \n8. Multivalued Attribute
                                                                  \n9. Rhombus
                                                                  \n10. Sybase<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Choose the incorrect statements:<\/span><\/p>\n

                                                                  Question 1.
                                                                  \na) SQL It (Structured query Language) is a programming language designed mainly for . managing data in RDBMS
                                                                  \nb) Schema Retrieves data from two or more tables, by referencing columns in the tables that hold identical values
                                                                  \nc) Query In SQL, all commands are named as query. The query statement is executed against the databases.
                                                                  \nd) Record is referred in a table, which are composed of fields.
                                                                  \nAnswer:
                                                                  \nb) Schema Retrieves data from two or more tables, by referencing columns in the tables that hold identical values<\/p>\n

                                                                  Question 2.
                                                                  \na) A Record is the information about that entity and it will describe, quantify, qualify, classify, and specify an entity.
                                                                  \nb) Cardinality is defined as the number of items that must be included in a relationship
                                                                  \nc) A multi-valued attribute has more than one value for that particular attribute.
                                                                  \nd) A single-valued attribute contains only one value for the attribute and they don’t have multiple numbers of values.
                                                                  \nAnswer:
                                                                  \na) A Record is the information about that entity and it will describe, quantify, qualify, classify, and specify an entity.<\/p>\n

                                                                  Question 3.
                                                                  \na) Network schema defines all about the structure of the database.
                                                                  \nb) Sub schema controls on views of the database for the user
                                                                  \nc) The famous Hierarchical database model was IDS
                                                                  \nd) Language is the basic procedural for accessing the database.
                                                                  \nAnswer:
                                                                  \nc) The famous Hierarchical database model was IDS<\/p>\n

                                                                  \"Samacheer<\/p>\n

                                                                  Question 4.
                                                                  \na) A table consisting of rows and columns
                                                                  \nb) Schema – Specifies the structure including name and type of each column.
                                                                  \nc) A relation consists of unique attributes and tuples.
                                                                  \nd) Query is referred in a table, which are composed of fields.
                                                                  \nAnswer:
                                                                  \nd) Query is referred in a table, which are composed of fields.<\/p>\n

                                                                  Question 5.
                                                                  \na) DCL commands manage the transactions
                                                                  \nb) The DML commands deals with the manipulation of data present in the database
                                                                  \nc) SELECT is the only SQL command used to fetch or retrieve the data from database tables that come under DQL.
                                                                  \nd) The DDL commands are used to define database schema (Structure)
                                                                  \nAnswer:
                                                                  \na) DCL commands manage the transactions<\/p>\n

                                                                  Syntax & Example (Basic Sql Commands)<\/span><\/p>\n

                                                                  1) CREATE DATABASE:
                                                                  \nSyntax: CREATE database databasename;
                                                                  \nExample: mysql> create database studentDB;<\/p>\n

                                                                  2) DROP DATABASE:
                                                                  \nSyntax: DROP database databasename;
                                                                  \nExample: mysql> drop database studentDB;<\/p>\n

                                                                  3) SELECT DATABASE
                                                                  \nSyntax: USE databasename;
                                                                  \nExample: mysqi> USE studentDB;<\/p>\n

                                                                  4) INSERT RECORD
                                                                  \nSyntax 1: INSERT INTO tablename (columnl, column 2, column 3) Values(vaiue 1, value 2, value 3)
                                                                  \nSyntax 2: INSERT INTO tablename
                                                                  \nValues(value 1, va!ue2, value3)<\/p>\n

                                                                  5) DELETING RECORD :
                                                                  \nSyntax 1; DELETE for tablename WHERE Coiumnname =” value ”
                                                                  \nSyntax 2; DELETE for tablename<\/p>\n

                                                                  6) MODIFYING RECORD:
                                                                  \nSyntax : UPDATE tablename SET column 1= “newvalue” where column 2= value2<\/p>\n

                                                                  7) SORTING RECORD:
                                                                  \nSyntax 1 SELECT * FROM TABLENAME ORDER BY COLUMNNAME;
                                                                  \nSyntax 2 select * from tablename ORDER BY columnname DESC;<\/p>\n\n\n\n\n\n\n\n\n\n
                                                                  SQL DDL COMMANDS LIST<\/td>\n<\/tr>\n
                                                                  Commands<\/td>\nDescription<\/td>\n<\/tr>\n
                                                                  CREATE<\/td>\nUsed to create database or tables<\/td>\n<\/tr>\n
                                                                  ALTER<\/td>\nModifies the existing structure of database or table<\/td>\n<\/tr>\n
                                                                  DROP<\/td>\nDeletes a database or table<\/td>\n<\/tr>\n
                                                                  RENAME<\/td>\nUsed to rename an existing object in the database<\/td>\n<\/tr>\n
                                                                  TRUNCATE<\/td>\nUsed to delete all table records<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n
                                                                  SQL TCL COMMANDS LIST<\/td>\n<\/tr>\n
                                                                  Commands<\/td>\nDescription<\/td>\n<\/tr>\n
                                                                  COMMIT<\/td>\nPermanent save into database<\/td>\n<\/tr>\n
                                                                  ROLLBACK<\/td>\nRestore database to orginal form since the last COMMIT<\/td>\n<\/tr>\n
                                                                  SET
                                                                  \nTRANSACTION<\/td>\n                                                                  		SET TRANSACTION command set the transaction properties such as read-write or read-only access<\/td>\n<\/tr>\n
                                                                  SAVE POINT<\/td>\nUse to temporarily save a trans\u00adaction so that we can rollback to that point whenever required<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n
                                                                  SQL DML COMMANDS LIST<\/td>\n<\/tr>\n
                                                                  Commands<\/td>\nDescription<\/td>\n<\/tr>\n
                                                                  INSERT<\/td>\nAdds new rows into database table.<\/td>\n<\/tr>\n
                                                                  UPDATE<\/td>\nmodifies existing data with new data within a table<\/td>\n<\/tr>\n
                                                                  DELETE<\/td>\nDeletes the records from the table<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n
                                                                  SQL DQL COMMANDS LIST<\/td>\n<\/tr>\n
                                                                  Commands<\/td>\nDescription<\/td>\n<\/tr>\n
                                                                  \u00a0SELECT<\/td>\nRetrieve data from the table<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                                                  Part B<\/span><\/p>\n

                                                                  Short Answers<\/span><\/p>\n

                                                                  Question 1.
                                                                  \nDefine database?
                                                                  \nAnswer:
                                                                  \n\u201cA database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data”.<\/p>\n

                                                                  Question 2.
                                                                  \nDefine DBMS
                                                                  \nAnswer:
                                                                  \nDefinition;<\/p>\n

                                                                    \n
                                                                  • A database management system (DBMS), is system software for creating and managing databases.<\/li>\n
                                                                  • The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.<\/li>\n<\/ul>\n

                                                                    Question 3.
                                                                    \nDefine degree of consistency?
                                                                    \nAnswer:
                                                                    \nTo prevent conflict in database updates, the transactions are isolated from other users and serialized. This is also known as the Degree of Consistency.<\/p>\n

                                                                    \"Samacheer<\/p>\n

                                                                    Question 4.
                                                                    \nWhat are the limitations of the database?
                                                                    \nAnswer:<\/p>\n

                                                                      \n
                                                                    • Data Duplication<\/li>\n
                                                                    • High Maintenance<\/li>\n
                                                                    • Security<\/li>\n<\/ul>\n

                                                                      Question 5.
                                                                      \nWrite the various forms of the database.
                                                                      \nAnswer:<\/p>\n

                                                                        \n
                                                                      • Relational Database Management System (RDBMS)<\/li>\n
                                                                      • And Object Database Management System (ODBMS).<\/li>\n<\/ul>\n

                                                                        Question 6.
                                                                        \nDefine relational database?
                                                                        \nAnswer:
                                                                        \nAny database whose logical organization is based on a relational data model is known as Relational Database.<\/p>\n

                                                                        Question 7.
                                                                        \nWhat do you mean by the table in the Relational database model?
                                                                        \nAnswer:
                                                                        \nIn relational database model,<\/p>\n

                                                                          \n
                                                                        • The table is defined as the collection of data organized in terms of rows and columns.<\/li>\n
                                                                        • The table is the simple representation of relations. The true relations cannot have duplicate rows<\/li>\n<\/ul>\n

                                                                          \"Samacheer<\/p>\n

                                                                          Question 8.
                                                                          \nWrite the types of SQL commands.
                                                                          \nAnswer:<\/p>\n

                                                                            \n
                                                                          • Data Definition Language (DDL)<\/li>\n
                                                                          • Data Manipulation Language (DML)<\/li>\n
                                                                          • Data Query Language (DQL)<\/li>\n
                                                                          • Transaction Control Language (TCL)<\/li>\n
                                                                          • Data Control Language (DCL)<\/li>\n<\/ul>\n

                                                                            Question 9.
                                                                            \nDefine Primary key?
                                                                            \nAnswer:<\/p>\n

                                                                              \n
                                                                            1. The candidate key that is chosen to perform the identification task is called the primary key and any others are Alternate keys.<\/li>\n
                                                                            2. Every tuple must-have, a unique value for its primary key.<\/li>\n<\/ol>\n

                                                                              Question 10.
                                                                              \nWhat is XAMPP?
                                                                              \nAnswer:<\/p>\n

                                                                                \n
                                                                              • XAMPP is a free and open-source package.<\/li>\n
                                                                              • It was developed by Apache.<\/li>\n
                                                                              • It is a software platform for MySQL, PHP and Peri programming languages.<\/li>\n<\/ul>\n

                                                                                Question 11.
                                                                                \nDefine Composite key?
                                                                                \nAnswer:
                                                                                \nA key with more than one attribute to identify rows uniquely in a table is called a Composite key. This is also known as Compound Key.<\/p>\n

                                                                                \"Samacheer<\/p>\n

                                                                                Part C<\/span><\/p>\n

                                                                                Explain In Brief Answer.<\/span><\/p>\n

                                                                                Question 1.
                                                                                \nExplain three database components of the network model?
                                                                                \nAnswer:
                                                                                \nThe three database components of Network models are Network schema, Sub schema, and Language.
                                                                                \nNetwork schema – schema defines all about the structure of the database.
                                                                                \nSub schema – controls on views of the database for the user.
                                                                                \nLanguage – basic procedural for accessing the database.<\/p>\n

                                                                                Question 2.
                                                                                \nList few commonly used databases.
                                                                                \nAnswer:<\/p>\n

                                                                                  \n
                                                                                • DB2<\/li>\n
                                                                                • MySQL<\/li>\n
                                                                                • Oracle<\/li>\n
                                                                                • PostgreSQL<\/li>\n
                                                                                • SQLite<\/li>\n
                                                                                • SQL Server<\/li>\n
                                                                                • Sybase<\/li>\n<\/ul>\n

                                                                                  \"Samacheer<\/p>\n

                                                                                  Question 3.
                                                                                  \nWhat are the roles of a Database administrator?
                                                                                  \nAnswer:<\/p>\n

                                                                                    \n
                                                                                  • Database Administrators (DBA’s) who takes care of configuration, installation, performance, security and data backup.<\/li>\n
                                                                                  • DBA’s possess the skills on database design, database queries, RDMS, SQL and networking.<\/li>\n
                                                                                  • The primary task is the creation of new user and providing them with access rights.<\/li>\n<\/ul>\n

                                                                                    Question 4.
                                                                                    \nDefine Super key?
                                                                                    \nAnswer:<\/p>\n

                                                                                      \n
                                                                                    1. An attribute or group of attributes, which is sufficient to distinguish every tuple in the relation from every other one is known as Super Key.<\/li>\n
                                                                                    2. Each super key is called a candidate key.<\/li>\n
                                                                                    3. A candidate key is selected from the set of Super Key.<\/li>\n<\/ol>\n

                                                                                      Question 5.
                                                                                      \nWrite a note on MySQL.
                                                                                      \nAnswer:<\/p>\n

                                                                                        \n
                                                                                      • The candidate key that is chosen to perform<\/li>\n
                                                                                      • MySQL is a database management system founded by Monty Widenius<\/li>\n
                                                                                      • MySQL is open-source software that allows managing relational databases.<\/li>\n
                                                                                      • It also provides the flexibility of changing the source code as per the needs.<\/li>\n
                                                                                      • It runs on multiple platforms like Windows, Linux and is scalable, reliable and fast.<\/li>\n<\/ul>\n

                                                                                        Question 6.
                                                                                        \nWrite a short note on Row (or Record or tuple)
                                                                                        \nAnswer:<\/p>\n

                                                                                          \n
                                                                                        • A single entry in a table is called a Row or Record or Tuple.<\/li>\n
                                                                                        • Set of related data are represented in a row or tuple.<\/li>\n
                                                                                        • The horizontal entity in a table is known as a Record or row.<\/li>\n<\/ul>\n

                                                                                          \"Samacheer<\/p>\n

                                                                                          Question 7.
                                                                                          \nGive the roles and responsibilities of DBA?
                                                                                          \nAnswer:
                                                                                          \nDatabase Administrators (DBA\u2019s) take care of configuration, installation, performance, security, and data backup.
                                                                                          \nDBA\u2019s possess the skills in database design, database queries, RDMS, SQL, and networking.
                                                                                          \nThe primary task is the creation of new users and providing them with access rights.<\/p>\n

                                                                                          Part D<\/span><\/p>\n

                                                                                          Explain in detail.<\/span><\/p>\n

                                                                                          Question 1.
                                                                                          \nExplain the following:<\/p>\n

                                                                                            \n
                                                                                          1. Primary Key<\/li>\n
                                                                                          2. Foreign Key<\/li>\n
                                                                                          3. Candidate Key<\/li>\n
                                                                                          4. Super Key<\/li>\n
                                                                                          5. Composite key<\/li>\n<\/ol>\n

                                                                                            Answer:
                                                                                            \n1. Primary Key:<\/p>\n

                                                                                              \n
                                                                                            • This key of the relational table identifies each record in the table in a unique way.<\/li>\n
                                                                                            • A primary key which is a combination of more than one attribute is called a composite primary key.<\/li>\n
                                                                                            • The candidate key that is chosen to perform the identification task is called the primary key<\/li>\n<\/ul>\n

                                                                                              2. Foreign Key:<\/p>\n

                                                                                                \n
                                                                                              • A foreign key is a “copy” of a primary key that has been exported from one relation into another to represent the existence of a relationship between them.<\/li>\n
                                                                                              • A foreign key is a copy of the whole of its parent primary key i.e if the primary key is composite, then so is the foreign key.<\/li>\n
                                                                                              • Foreign key values do not (usually) have to be unique.<\/li>\n
                                                                                              • Foreign keys can also be null.<\/li>\n
                                                                                              • A composite foreign key cannot have some attribute(s) null and others non-null.<\/li>\n<\/ul>\n

                                                                                                3. Candidate Key:<\/p>\n

                                                                                                  \n
                                                                                                • Each super key is called a candidate key.<\/li>\n
                                                                                                • A candidate key is selected from the set of Super Key.<\/li>\n
                                                                                                • While selecting the candidate key, redundant attributes should not be taken.<\/li>\n
                                                                                                • The candidate key is also known as minimal super keys.<\/li>\n<\/ul>\n

                                                                                                  4. Super Key:
                                                                                                  \nAn attribute or group of attributes, which is sufficient to distinguish every tuple in the relation from every other one is known as Super Key.<\/p>\n

                                                                                                  5. Composite Key (Compound Key): A key with more than one attribute to identify rows uniquely in a table is called a Composite key. This is also known as Compound Key.<\/p>\n

                                                                                                  \"Samacheer<\/p>\n

                                                                                                  Question 2.
                                                                                                  \nTabulate the ER diagram notations
                                                                                                  \nAnswer:
                                                                                                  \n\"Samacheer<\/p>\n

                                                                                                  \"Samacheer<\/p>\n","protected":false},"excerpt":{"rendered":"

                                                                                                  Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Computer Applications Guide Pdf Chapter 3 Introduction to Database Management System Text Book Back Questions and Answers, Notes. Tamilnadu Samacheer Kalvi 12th Computer Applications Solutions Chapter 3 Introduction to Database Management System 12th Computer Applications Guide Introduction to Database Management System Text Book Questions and Answers Part …<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[5],"tags":[],"class_list":["post-32918","post","type-post","status-publish","format-standard","hentry","category-class-12"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/samacheerkalvi.guide\/wp-json\/wp\/v2\/posts\/32918"}],"collection":[{"href":"https:\/\/samacheerkalvi.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/samacheerkalvi.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/samacheerkalvi.guide\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/samacheerkalvi.guide\/wp-json\/wp\/v2\/comments?post=32918"}],"version-history":[{"count":1,"href":"https:\/\/samacheerkalvi.guide\/wp-json\/wp\/v2\/posts\/32918\/revisions"}],"predecessor-version":[{"id":41623,"href":"https:\/\/samacheerkalvi.guide\/wp-json\/wp\/v2\/posts\/32918\/revisions\/41623"}],"wp:attachment":[{"href":"https:\/\/samacheerkalvi.guide\/wp-json\/wp\/v2\/media?parent=32918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/samacheerkalvi.guide\/wp-json\/wp\/v2\/categories?post=32918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/samacheerkalvi.guide\/wp-json\/wp\/v2\/tags?post=32918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}