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 : Click on Discuss to view users comments. |
_________ 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 : Click on Discuss to view users comments. |
_________ data type can store unstructured data
| A. | RAW |
| B. | CHAR |
| C. | NUMERIC |
| D. | VARCHAR |
|
Option: A Explanation : Click on Discuss to view users comments. |
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 : Click on Discuss to view users comments. Hiren MEr said: (6:07pm on Tuesday 6th September 2016)
Insert into department values(1, 'Navin', 1);How this statement can insert the data
|
