Viva Questions XII IP

Define RDBMS

Name any 3 RDBMS

Define

1. Tuple

2. Attribute

3. Degree

4. Cardinality

Define SQL

Full Forms

1. SQL

2. DML

3. DDL

4. DCL

5. DQL

6. RDBMS

7. TCL

Give Example of DML, DCL, DDL and SQL

What is the difference between CHAR and VARCHAR

What is the Difference between DDL and DML commands

Which command is used to remove the data?

Which command is used to modify the data?

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

Define PRIMARY KEY.

What is Foreign Key?

Define Candidate Key.

What is NULL?

What is Relation?

Which command is used to add data in a table?

What is Database?

Give some advantages of Databases.

Count(*) and Count(ColumnName)

Having and Where

Order By 

Group By Having

Single Row Functions Vs Multi-Row Functions

Functions (instr,mid,substr,substring)

current Date and Time (now())

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

Natural Join or Join 

What is NUMPy?

What is Pandas?

Difference between NumPy and Pandas?

What is Data Structure?

What is the purpose of PIP Command?

Name the Data Structures of Pandas.

What is Series?

What is DataFrame?

What is Panel?

What is One-Dimensional Array?

What is Two-Dimensional Array?

What is index? and Why it is used.

Define Positional Index and Labeled Index?

Define NaN?

What is Dictionary?

Explain range() function?

Explain arange() function?

What is the purpose of import command in python code?

Explain different functions

1. head()

2. tail()

3. count()

Explain loc and iloc?

Explain pop, drop and del keywords?

Explain append and extend?

Fulform of CSV and purpose of CSV files in python

Explain read_csv() and to_csv()

What is the difference between Indexing and slicing?

Which import statement is used to make pyplot?

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()