Database Systems MCQS
All Questions for: Database Systems MCQS
Question 101: Versatile report generators can provide
- A Subtotals
- B Columnar totals
- C All of the above
- D Calculations
- E None of the above
Explanation: The correct answer to the question is: All of the above
Question 102: The logical data structure with a one-to-many relationship is a :
- A network
- B None of the above
- C tree
- D relational
- E chain
Explanation: The correct answer to the question is: tree
Question 103: If you want to group the records in the abc database, you could use the Jobcode as the _____.
- A Index
- B Update
- C Delete
- D Sort Key
- E None of the above
Explanation: The correct answer to the question is: Sort Key
Question 104: Which of the following is a database administrator's function?
- A user coordination
- B backing up the database
- C All of the above
- D performance monitoring
- E database design
Explanation: The correct answer to the question is: All of the above
Question 105: Primitive operations common to all record management systems include
- A Sort
- B Look-up
- C All of the above
- D Print
- E None of the above
Explanation: The correct answer to the question is: Look-up
Question 106: A logical schema
- A All of the above
- B is a standard way of organizing information into accessible parts
- C is the entire database
- D describes how data is actually stored on disk
- E None of the above
Explanation: The correct answer to the question is: is a standard way of organizing information into accessible parts
Question 107: Batch processing is appropriate if
- A only a small computer system is available
- B only a few transactions are involved
- C a large computer system is available
- D None of the above
- E All of the above
Explanation: The correct answer to the question is: None of the above
Question 108: It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
- A Table
- B None of the above
- C Flat File
- D Record
- E Database
Explanation: The correct answer to the question is: Database
Question 109: Updating a database means
- A modifying or adding record occurrences
- B All of the above
- C revising the file structure
- D None of the above
- E reorganizing the database
Explanation: The correct answer to the question is: modifying or adding record occurrences
Question 110: Sophisticated report generators can
- A None of the above
- B selectively retrieve and print portions of a list
- C perform arithmetic operations
- D All of the above
- E print row-oriented reports
Explanation: The correct answer to the question is: All of the above
Question 111: A scheme describes
- A record relationships
- B All of the above
- C records and files
- D data elements
- E None of the above
Explanation: The correct answer to the question is: All of the above
Question 112: The data dictionary tells the DBMS
- A what these files contain
- B All of the above
- C what attribute are possessed by the data
- D None of the above
- E what files are in the database
Explanation: The correct answer to the question is: All of the above
Question 113: Embedded pointer provide
- A a physical record key
- B None of the above
- C an inverted index
- D All of the above
- E a secondary access path
Explanation: The correct answer to the question is: a secondary access path
Question 114: In SQL, which command(s) is(are) used to redefine an index's future storage allocation
- A REDEFINE INDEX
- B ALTER INDEX
- C MODIFY INDEX
- D None of the above
- E DO INDEX
Explanation: The correct answer to the question is: ALTER INDEX
Question 115: Related fields in a data base are grouped to form
- A data file
- B None of the above
- C bank
- D data record
- E menu
Explanation: The correct answer to the question is: data record
Question 116: Which of the following is true of a network structure?
- A It allows a many-to-many relationship
- B It is conceptually simple
- C None of the above
- D It will be the dominant data base of the future
- E It is a physical representation of the data
Explanation: The correct answer to the question is: It allows a many-to-many relationship
Question 117: In SQL, which command is used to select data in rows and column from one or more tables?
- A SELECT
- B None of the above
- C BROWSE
- D LIST
- E CHOOSE
Explanation: The correct answer to the question is: SELECT
Question 118: A data dictionary doesn't provide information about:
- A It allows a many-to-many relationship
- B where data is located
- C It is conceptually simple
- D the size of the disk storage device
- E It will be the dominant data base of the future
Explanation: The correct answer to the question is: the size of the disk storage device
Question 119: The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
- A exception report
- B on demand report
- C None of the above
- D forecasting report
- E regularly scheduled report
Explanation: The correct answer to the question is: on demand report
Question 120: A form defines
- A None of the above
- B the width of each field
- C where data is placed on the screen
- D All of the above
- E both (a) and (b)
Explanation: The correct answer to the question is: both (a) and (b)
Question 121: A file produced by a spreadsheet
- A can be used as it by the DBMS
- B All of the above
- C None of the above
- D can be used for graphic
- E is generally stored on disk in an ASCII text format
Explanation: The correct answer to the question is: is generally stored on disk in an ASCII text format
Question 122: The data-base environment has all of the following components except:
- A separate files
- B users
- C data base
- D data-base administrator
- E None of the above
Explanation: The correct answer to the question is: separate files
Question 123: Internal auditors should review data system design before they are
- A implemented
- B modified
- C None of the above
- D All of the above
- E developed
Explanation: The correct answer to the question is: All of the above
Question 124: To have a file hold a list, it is necessary to
- A identify the name, width and type of the fields of each record.
- B decide which fields will be used as sort or index keys
- C identify the records in the list
- D None of the above
- E All of the above
Explanation: The correct answer to the question is: All of the above
Question 125: In SQL, which command is used to remove a stored function from the database?
- A ERASE FUNCTION
- B REMOVE FUNCTION
- C None of the above
- D DROP FUNCTION
- E DELETE FUNCTION
Explanation: The correct answer to the question is: DROP FUNCTION
Question 126: In the DBM approach, application programs perform the
- A access control
- B None of the above
- C processing functions
- D storage function
- E All of the above
Explanation: The correct answer to the question is: processing functions
Question 127: In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
- A ALTER TABLE
- B None of the above
- C ALTER TRIGGERS
- D MODIFY TRIGGERS IN TABLE
- E All of the above
Explanation: The correct answer to the question is: ALTER TABLE
Question 128: Which of the following is a type of DBMS software?
- A All of the above
- B utilities
- C report writer
- D database manipulation language
- E query language
Explanation: The correct answer to the question is: database manipulation language
Question 129: In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
- A ZIP
- B PACK
- C COMMIT
- D None of the above
- E SAVE
Explanation: The correct answer to the question is: COMMIT
Question 130: A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
- A tuple
- B None of the above
- C tables
- D both (a) and (b)
- E relations
Explanation: The correct answer to the question is: both (a) and (b)
Question 131: A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
- A the last name
- B All of the above
- C a compound key consisting of the first name and the last name
- D None of the above
- E the pin code
Explanation: The correct answer to the question is: a compound key consisting of the first name and the last name
Question 132: Periodically adding, changing and deleting file records is called file
- A upgrading
- B Updating
- C restructuring
- D None of the above
- E renewing
Explanation: The correct answer to the question is: Updating
Question 133: A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
- A None of the above
- B File structure
- C Database
- D Fields
- E Records
Explanation: The correct answer to the question is: Fields
Question 134: In SQL, the _____ command is used to recompile a view
- A ALTER VIEW
- B CREATE VIEW
- C None of the above
- D DEFINE VIEW
- E COMPILE VIEW
Explanation: The correct answer to the question is: ALTER VIEW
Question 135: If a piece of data is stored in two places in the database, then
- A changing the data is one spot will cause data inconsistency
- B None of the above
- C both (a) and (b)
- D it can be more easily accessed
- E storage space is wasted
Explanation: The correct answer to the question is: both (a) and (b)
Question 136: What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
- A None of the above
- B DASD
- C DBMS
- D EMMS
- E FMS
Explanation: The correct answer to the question is: DBMS
Question 137: The way a particular application views the data from the data base that the application uses is a :
- A module
- B schema
- C subschema
- D None of the above
- E relational model
Explanation: The correct answer to the question is: subschema