recategorized by
383 views
1 votes
1 votes

A relational database contains two tables movie, and genre, in which movie table has columns movie_no, movie_name, and genre_id, while genre table has columns genre_id, and genre_name. Following insert statements were executed successfully to populate the empty table.


Insert into genre values $\text{(1, ‘Action’)}$
Insert into genre values $\text{(2, ‘Drama’)}$
Insert into movie values $\text{(1, ‘Chennai Express’, 1)}$
Insert into movie values $\text{(2, ‘K3G’, 2)}$
Insert into movie values $\text{(3, ‘Dhoom’, 1)}$


How many rows and columns will be retrieved by the following SQL statement?

Select * from movie, genre
recategorized by

1 Answer

Related questions

1 votes
1 votes
2 answers
1
admin asked Dec 15, 2022
740 views
What is the minimum number of nodes required in a DAG (Directed Acyclic Graph) for the following block?\[\begin{aligned}U=Z & =V+W \\X=Y & =U+1 \\A & =X+Y\end{aligned}\]
1 votes
1 votes
2 answers
2
admin asked Dec 15, 2022
375 views
What is the size of the physical address space in a paging system, which has a page table containing $64$ entries of $11$ bit each (including valid and invalid bit) and a...