Answer the following question: (a) How can you revoke permissions from a database table? Give SQL command for it. (b) What happens when someone…
Answer the following question:
(a) How can you revoke permissions from a database table? Give SQL command for it.
(b) What happens when someone tries to delete an entry of a table that has referential integrity constraint? Explain with example.
(c) Differentiate between "delete from" and "drop table" SQL statement.
From the BPSC Assistant Programmer (CSE) 2019 – Written exam, question 7 of 8.
More from this paper
- Previous: Answer the following question: (a) An I/O system with a simple disk gets an average 50 I/O requests per second and average time for a disk…
- Next: Answer the following question: (a) For two 8-bit binary numbers, what will be the output values in 2's complement format: (i)…
- All questions in BPSC Assistant Programmer (CSE) 2019 – Written