Database :: All Aptitude Test ::

1.To change the value of a customer’s discount from 3 to 5, what command do we need to use:
A. INSERT
B. SELECT
C. DELETE
D. INSERT

2.The WHERE keyword comes before the condition in a normal Select query. When using the command GROUP BY in the Select query, what keyword is used to start the condition section ?
A. Having
B. Find
C. Order
D. Having

3.Higher normal forms are better than lower normal forms because higher normal forms yield fewer _____________ _______________ in the database.
A. update, delete
B. data storage
C. data redundancies
D. update, delete

4.The 2NF describes the tabular format in which:
A. there are no repeating groups in the table
B. all attributes are dependent on the primary key
C. A & B with no partial dependency
D. there are no repeating groups in the table


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