Database Systems - Section 7 Multiple Questions and Answers.




21.Related fields in a data base are grouped to form
A. data file
B. data record
C. menu
D. bank

22.A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. Many-to-many relationship

23.In SQL, the _____ command is used to recompile a view
A. COMPILE VIEW
B. DEFINE VIEW
C. CREATE VIEW
D. ALTER VIEW

24.A list in alphabetical order
A. is in descending order
B. is in ascending order
C. is the result of a sort operation
D. both (b) and (c)

25.If a piece of data is stored in two places in the database, then
A. storage space is wasted
B. changing the data is one spot will cause data inconsistency
C. it can be more easily accessed
D. both (a) and (b)

«»



Date to Date Current Affairs 2022

PakMCQs.net

Quick Links

GAT Subject



   Computer Science    English Mcqs    Agriculture    

Engineering



   Computer Science    Civil Engineering    

Technical



   Networking    Electronics    Database    

Past Papers



   Model Papers    FPSC Papers