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

