(A) Where
(B) Order by
(C) From
(D) Having
Tag: Database Interview Questions
In SQL, which command is used to delete rows from table?
(A) Delete
(B) Remove
(C) Truncate
(D) Both I and II
In airline reservation system the enteies are date, flight number, place of departure, destination, type of plan and seats available?
(A) flight number
(B) flight number + place of departure
(C) flight number + date
(D) flight number + destination
Which of the following desired features are beyond the capabilty of rational algebra?
(A) Aggregate computation
(B) Multiplication
(C) Finding transtive clousure
(D) All of the above
The data flow model of an application mainly shows?
(A) the underlying data and the relations among them
(B) processing requirments and the floe of data
(C) decesion and control information
(D) communication and network structure
What are the potental problems when a DBMS executes multiple transections concurrently?
(A) The lost update problem
(B) The dirty read problem
(C) The unrepeatable read problem
(D) All the three
The column of a table is reffered to as the?
(A) tuple
(B) attribute
(C) entity
(D) degree
If every non key attrebute is functionaly dependent on the primary key then the relation will be in?
(A) first normal form
(B) second normal form
(C) third normal form
(D) fourth normal form