Viva Questions XII IP

1. Define RDBMS

RDBMS - Relational Database Management System is a software used to store data in the form of related tables. Data is stored in the form of Rows and Columns. Rows are called tuple.Columns are called attributes. Tables are called relation.

2. Name any 3 RDBMS

   1. Oracle

   2. Microsoft SQL Server

3. Define

   1. Tuple - Tuple is a name given to rows, Rows are the data of the table.

   2. Attribute - Attribute is a name given to columns, columns are properties of the given table.

   3. Degree - Degree is the number of columns in a table

   4. Cardinality - Cardinality is the number of Rows in a given table.

4. Define SQL

SQL (Structured Query Language) is a language use to fetch and manipulate data in a the Database. Like SELECT, CREATE, DROP, INSERT, DELETE, UPDATE.

5. Full Forms

   1. SQL - Sturctured Query Language

   2. DML - Data Manipulation Language

   3. DDL - Data Definition Language

   4. DCL - Data Control Language

   5. DQL - Data Query Language

   6. RDBMS - Relational Database Management System

   7. TCL - Trancation Control Language

6. Give Example of DML, DCL, DDL and SQL

DML - INSERT, DELETE, UPDATE

DCL - GRANT , REVOKE

DDL -  CREATE, ALTER, DROP

7. What is the difference between CHAR and VARCHAR

8. What is the Difference between DDL and DML commands

9. Which command is used to remove the data?

DELETE FROM TABLENAME;

10. Which command is used to modify the data?

UPDATE TABLENAME

SET COLUMNNAME= 'NEW VALUE'

WHERE CONDITION;

11. Which command is used to modify the structure of the table?

ALTER TABLE TABLENAME

ADD COLUMNNAME DATATYPE;

ALTER TABLE TABLENAME

MODIFY COLUMNNAME DATATYPE;

ALTER TABLE TABLENAME

DROP COLUMNNAME;

12. Define PRIMARY KEY.

13. What is Foreign Key?

14. Define Candidate Key.

15. What is NULL?

16. What is Relation?

17. Which command is used to add data in a table?

18. What is Database?

19. Give some advantages of Databases.

20. Count(*) and Count(ColumnName)

21. Having and Where

22. Order By 

23. Group By Having

24. Single Row Functions Vs Multi-Row Functions

25. Functions (instr,mid,substr,substring)

26. current Date and Time (now())

27. Cartesian Product T1 (5 Rows) T2(5 Rows) Total Output (25 Rows)

28. Natural Join or Join 

1. What is NUMPy?

2. What is Pandas?

3. Difference between NumPy and Pandas?

4. What is Data Structure?

5. What is the purpose of PIP Command?

6. Name the Data Structures of Pandas.

7. What is Series?

8. What is DataFrame?

9. What is Panel?

10. What is One-Dimensional Array?

11. What is Two-Dimensional Array?

12. What is index? and Why it is used.

13. Define Positional Index and Labeled Index?

14. Define NaN?

15. What is Dictionary?

16. Explain range() function?

17. Explain arange() function?

18. What is the purpose of import command in python code?

19. Explain different functions

    1. head()

    2. tail()

    3. count()

20. Explain loc and iloc?

21. Explain pop, drop and del keywords?

22. Explain append and extend?

23. Fulform of CSV and purpose of CSV files in python

24. Explain read_csv() and to_csv()

25. What is the difference between Indexing and slicing?

26. Which import statement is used to make pyplot?

27. Different function used to create plots or graphs

    1. plot()

    2. xlabel()

    3. ylabel()

    4. bar()

    5. barh()

    6. title()

    7. legend()

    8. xticks()

    9. yticks()

    10. show()

    11. savefig()