Database Systems - Section 6 Multiple Questions and Answers.




11.A _____ means that one record in a particular record type may be related to more than one record of another record type.
A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. Many-to many relationship

12.Which command(s) is(are) used to redefine a column of the table in SQL ?
A. ALTER TABLE
B. DEFINE TABLE
C. MODIFY TABLE
D. All of the above

13.Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
A. DEFINE TABLE
B. MODIFY TABLE
C. ALTER TABLE
D. All of the above

14.In SQL, the ALTER TABLESPACE command is used
A. to add/rename data files
B. to change storage characteristics
C. to take a tablespace online/offline
D. All of the above

15.The language used in application programs to request data from the DBMS is referred to as the
A. DML
B. DDL
C. query language
D. All of the above

«»



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