Features of XML include which of the following?
Shourya Singh Rawat from India is saying Addresses the structuring and manipulation of the data involved. is correct answer
Muhammad Jamshed Mahmood from Lahore, Pakistan is saying All of the above. is correct answer
Imran Ali from Rawalpindi, Pakistan is saying All of the above. is correct answer
ranaasif from Multan, Pakistan is saying All of the above. is correct answer
MUHAMMAD NADEEM from Lahore, Pakistan is saying All of the above. is correct answer
The DBMS utility, ...................... allows to reconstruct the correct state of database from the backup and history of transactions.
- [A] Bakup
- [B] Recovery
- [C] Monitering
- [D] Data loading
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
- [A] entity integrity rule
- [B] referential integrity constraint
- [C] action assertion
- [D] composite attribute
A .................. normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
- [A] first
- [B] second
- [C] third
- [D] fourth
- [A] Zero
- [B] One
- [C] More than one
- [D] All of the above.
What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
- [A] ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
- [B] ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
- [C] ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
- [D] None of the above is correct.