36. In SQL, GRANT command is used to

A. allow user to access databases
B. allow user to create databases
C. grant system privileges, roles, and object privileges to uses and roles
D. choose auditing for specific SQL commands
E. None of the above


Correct Answer: C. grant system privileges, roles, and object privileges to uses and roles

37. The highest level in the hierarchy of data organization is called

A. data bank
B. database
C. data file
D. data record
E. None of the above


Correct Answer: B. database

38. The logical data structure with a one-to-many relationship is a :

A. network
B. tree
C. chain
D. relational
E. None of the above


Correct Answer: B. tree

39. Updating a database means

A. revising the file structure
B. reorganizing the database
C. modifying or adding record occurrences
D. All of the above
E. None of the above


Correct Answer: C. modifying or adding record occurrences

40. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

A. ALTER TRIGGERS
B. ALTER TABLE
C. MODIFY TRIGGERS IN TABLE
D. All of the above
E. None of the above


Correct Answer: B. ALTER TABLE

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    18 − three =