Computer Science - Database Systems

Exercise :: 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

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

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 data base of the future
E. None of the above

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.