Database Systems – Section 1

31. Which command is used to remove a table from the database in SQL?

A. DELETE TABLE
B. DROP TABLE
C. ERASE TABLE
D. UNATTACH TABLE
E. None of the above

Correct Answer: B. DROP TABLE
Advertisement

32. A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?

A. Specialized file
B. Log file
C. Master file
D. Update file
E. None of the above

Correct Answer: C. Master file
Advertisement

33. A file produced by a spreadsheet

A. is generally stored on disk in an ASCII text format
B. can be used as it by the DBMS
C. can be used for graphic
D. All of the above
E. None of the above

Correct Answer: A. is generally stored on disk in an ASCII text format
Advertisement

34. A form defines

A. where data is placed on the screen
B. the width of each field
C. both (a) and (b)
D. All of the above
E. None of the above

Correct Answer: C. both (a) and (b)
Advertisement

35. Which of the following is true of a network structure?

A. It is a physical representation of the data
B. It allows a many-to-many relationship
C. It is conceptually simple
D. It will be the dominant database of the future
E. None of the above

Correct Answer: B. It allows a many-to-many relationship
Advertisement

Leave A Comment?