Database - SQL

16. A data manipulation command the combines the records from one or more tables is called

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


17. _________ is a virtual table that draws its data from the result of an SQL SELECT statement

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


18. _________ data type can store unstructured data

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


19. A relational database contains two tables student and department in which the student table has columns (roll_no, name, and dept_id )and the department table has columns (dept-id and dept-name).
The following insert statements were executed successfully to populate the empty tables:
Insert into department values (1, 'Mathematics');
Insert into department values(1, 'Physics');
Insert into department values(1, 'Navin', 1);
Insert into student values (2, 'Ravi', 2);
Insert into student values (3, `Gitu', 1);
How many rows and columns will be retrieved by the following SQL, statement?
Select * from student, department:

Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *