Page 316 - IT-802_class_12
P. 316

Viva Voce Questions


                                                                                                   Subject Enrichment
                                                                                                    Communication
                                                                                                    Communication


          1.  Name some programming languages supported by MySQL in which applications can be created.
         Ans.  Java, C++, Python,                                                                   Critical thinking
          2.  Is SQL same as MySQL? If not, how is SQL different?
         Ans.  SQL is language to write queries. MySQL, on the other hand, is a RDBMS software to execute SQL queries.
          3.   What is the primary difference between DDL and DML?
         Ans.   DDL is a language used to specify the restrictions and structure of data and DML is used to add, alter, and move
             data from a database.
          4.  What are the different data types which can be used to store string or character data?
         Ans.  CHAR and VARCHAR
          5.   What is the key reason due to which organizations are taking efforts to perform proper storage and manipulation
             of data?
         Ans.   A  ‘Database’  is  a  collection  of  logically  related  data  that  allows  easy  and  efficient  storage,  retrieval  and
             manipulation of data.
          6.  What are the basic types of users with regards to a database?

         Ans.  End Users, Database Administrator (DBA), Database Administrator (DBA) and System Analyst.
          7.  Who is responsible to authorize access and monitoring the usage of a database?
         Ans.  Database Administrator (DBA)
          8.  How can a DBMS enable user friendly environment for data operations?
         Ans.  User Friendly
          9.  What do you mean by Degree of a Relation?
         Ans.  The number of attributes in a relation is called the Degree of a relation.
          10.  Elaborate the Cost limitation for DBMS.
         Ans.   It  is  a  very  time-consuming  process  that  involves  analysing  user  requirements,  designing  the  database
             specifications, writing application programs, and then also providing training.
          11.  What is the difference between a Tuple and Attribute?
         Ans.  The difference between a Tuple and Attribute is:
              Tuple: A row is called a Tuple.
              Attribute: A column is called an Attribute.
          12.  What is the purpose of using JOINS in SQL?
         Ans.  A JOIN clause is used to combine rows from two or more tables, based on a related column between them.

          13.  What do you mean by JVM?
         Ans.  JVM (Java Virtual Machine) is a program to convert the Java program to machine code.
          14.  Why are comments required in a Java Program?
         Ans.   Programmers use comments in their code to document their programs and provide explanatory remarks to
             anyone who view them.


          314   Touchpad Information Technology-XII
   311   312   313   314   315   316   317   318   319   320   321