Classical

Database MCQ - Query languages SQL

16:  

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

A.

SELECT

B.

PROJECT

C.

JOIN

D.

PRODUCT

 
 

Option: C

Explanation :


17:  

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

A.

View

B.

Synonym

C.

Sequence

D.

Transaction

 
 

Option: A

Explanation :


18:  

 _________ data type can store unstructured data

A.

RAW

B.

CHAR

C.

NUMERIC

D.

VARCHAR

 
 

Option: A

Explanation :


19:  

A relational database contains two tables student and department in which student table has columns (roll_no, name and dept_id )and 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 retrived by the following SQL, statement?

Select * from student, department;

A.

0 row and 4 columns

B.

3 rows and 4 columns

C.

3 rows and 5 columns

D.

6 rows and 5 columns

 
 

Option: D

Explanation :




Suggest an improvement