Search This Blog

Monday, November 21, 2011

Database Management System Quiz - 1

1. The data in the database cannot be shared
[A]TRUE
[B]FALSE



2. Physical design is tailored to a specific DBMS system
[A]TRUE
[B]FALSE



3. Availability is often thought of as continuity of service, ensuring that database is available 24 hours a day, 7 days a week
[A]TRUE
[B]FALSE



4. The SSL protocol developed by Microsoft Corporation, is an industry accepted standard for network transport layer security
[A]TRUE
[B]FALSE



5. The shadow page table is never changed over the duration of the transaction
[A]TRUE
[B]FALSE



6. The Database administrator cannot grant or revoke privileges to users.
[A]TRUE
[B]FALSE



7. To update city_name to bombay following command is used. UPDATE EMP_TABLE SET CITY='BOMBAY';
[A]TRUE
[B]FALSE



8. A user can grant any object privilege on any object he or she owns to any other user or role
[A]TRUE
[B]FALSE



9. Distinct clause in select command eliminates rows that have exactly same contents in each column.
[A]TRUE
[B]FALSE



10. A relational model relates records by the value that they contain.
[A]TRUE
[B]FALSE



11. SQL is low level language
[A]TRUE
[B]FALSE



12. Centralised Database Management cannot support multiple users.
[A]TRUE
[B]FALSE



13. Unary operator operates only on one operand.
[A]TRUE
[B]FALSE



14. Temporal constraints can be used to limit the value of a particular attribute to be in a range
[A]TRUE
[B]FALSE



15. Codd developed E-R model
[A]TRUE
[B]FALSE



0 comments: