(A) Where
(B) Order by
(C) From
(D) Having
Category: Database Mcqs
Database Mcqs for Screening tests, Interviews, Viva and Other competitive exams. Database Mcqs section will help users to prepare mcqs of Database for various exams. Aspirants of Lecturer Computer Science, SST Computer Science, Subject Specialist Computer Science, Data Entry operator, Computer Programmer, Computer Operator, System administrator, Database Administrator and all other Exams can prepare their Database portion from here.
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