Database systems questions with answers
112 multiple-choice questions. Open any question for its answer and explanation.
- Sort/report generators
- The data dictionary tells the DBMS
- In SQL, which command(s) is(are) used to enable/disable a database trigger?
- If the record management system allows you to edit values before they are recorded on disk, you can
- The relational model uses some unfamiliar terminology. A tuple is equivalent to a
- The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
- An-owner-member set in the CODASYL specifications may have
- What is the name given to the database management system which is able to handle full text data, image data, audio and video?
- A top-to-bottom relationship among the items in a database is established by a
- A database management system
- Which of the following hardware components is the most important to the operation of a database management system?
- To have a file hold a list, it is necessary to
- Sophisticated report generators can
- In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
- Which two files are used during operation of the DBMS?
- When using a database management system, the first thing that you must do is to
- A network schema
- Which of the following is not a relational database?
- A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
- A file produced by a spreadsheet
- A form defines
- Which of the following is true of a network structure?
- In SQL, GRANT command is used to
- The highest level in the hierarchy of data organization is called
- The logical data structure with a one-to-many relationship is a