(a) Distinguish between table and view in database management system. (b) What are the purposes of using a foreign key in a database? Give a…
(a) Distinguish between table and view in database management system.
(b) What are the purposes of using a foreign key in a database? Give a suitable example.
(c) In an SQL query, while performing string matching, when do we use the = operator and when do we use the LIKE operator? Give examples.
From the BPSC Assistant Engineer 2021 – Written exam, question 7 of 16.
More from this paper
- Previous: (a) What is the usable number of host IP addresses available on a network that has a /26 mask? Write down the subnet mask of this network…
- Next: (a) While converting an E-R diagram into tables, how is a many-to-many relationship set between entities A and B converted into database…
- All questions in BPSC Assistant Engineer 2021 – Written