Computer Science - Database Systems MCQs Part 3
1. In SQL, which command is used to select data in rows and column from one or more tables?
A.
CHOOSE
CHOOSE
B.
SELECT
SELECT
C.
LIST
LIST
D.
BROWSE
BROWSE
E.
None of the above
None of the above
Answer Option B
2. A scheme describes
A.
data elements
data elements
B.
records and files
records and files
C.
record relationships
record relationships
D.
All of the above
All of the above
E.
None of the above
None of the above
Answer Option D
3. A report form
A.
appears on the computer monitor during data entry
appears on the computer monitor during data entry
B.
is used during report generation to format data
is used during report generation to format data
C.
both (a) and (b)
both (a) and (b)
D.
All of the above
All of the above
E.
None of the above
None of the above
Answer Option B
4. A computer file can be best described as
A.
a single data item
a single data item
B.
a general collection of data items
a general collection of data items
C.
an orderly collection of data items
an orderly collection of data items
D.
a random collection of data items
a random collection of data items
E.
None of the above
None of the above
Answer Option C
5. A good query system
A.
can accept English language commands
can accept English language commands
B.
allows non-programmers to access information stored in a database
allows non-programmers to access information stored in a database
C.
can be accessed only by data processing professionals
can be accessed only by data processing professionals
D.
both (a) and (b)
both (a) and (b)
E.
None of the above
None of the above
Answer Option B
6. If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
A. Delete
B. Update
C. Sort Key
D. Index
E. None of the above
Answer Option D
7. The modify operation is likely to be done after
A. Delete
B. Look-up
C. Insert
D. All of the above
E. None of the above
Answer Option B
8. One data dictionary software package is called
A. DB/DC dictionary
B. TOTAL
C. ACCESS
D. any of the above
E. None of the above
Answer Option A
9. One approach to standardizing storing of data
A. MIS
B. structured programming
C. CODASYL specifications
D. All of the above
E. None of the above
Answer Option C
10. What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
A. Special purpose packages
B. Custom made programs
C. Single function application packages
D. Data management packages
E. None of the above
Answer Option D
11. A multiple-form file management system
A. lets you define different forms for different operations
B. lets you create a look-up form with an associated read-only password to prevent access by unauthorized users
C. both (a) and (b)
D. allow you to entry data in all the forms
E. None of the above
Answer Option C
12. The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
A. Database
B. Table
C. Flat file
D. Data structure
E. None of the above
Answer Option C
13. A _____ Contains fields of data about one entity.
A. Record
B. File
C. Fields
D. Document
E. None of the above
Answer Option A
14. A condition that led to the development of databases was
A. a demand for more data to support information needs
B. an increase in the amount of data handled by organizations
C. the proliferation of data files
D. All of the above
E. None of the above.
Answer Option D
15. The _____ command is used to allocates an extent for the table in SQL
A. MODIFY ALLOCATES
B. MODIFY TABLE
C. ALTER TABLE
D. REDEFINE TABLE
E. None of the above
Answer Option A
16. Embedded pointer provide
A. a secondary access path
B. a physical record key
C. an inverted index
D. All of the above
E. None of the above
Answer Option A
17. Which of the following is a type of DBMS software?
A. database manipulation language
B. query language
C. utilities
D. report writer
E. All of the above
Answer Option A
18. Data items grouped together for storage purposes are called a
A. record
B. title
C. list
D. string
E. None of the above
Answer Option A
19. The activity of a file
A. is a low percentages of number of records added or deleted from a file
B. if high, reduces processing efficiency for sequential and nonsequential files
C. is a measure of the percentage of existing records updated during a run
D. refers to how closely the files fits into the allocated
E. None of the above.
Answer Option A
20. Versatile report generators can provide
A. Columnar totals
B. Subtotals
C. Calculations
D. All of the above
E. None of the above
Answer Option D
21. Related fields in a data base are grouped to form
A. data file
B. data record
C. menu
D. bank
E. None of the above
Answer Option B
22. A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. Many-to-many relationship
E. None of the above
Answer Option D
23. In SQL, the _____ command is used to recompile a view
A. COMPILE VIEW
B. DEFINE VIEW
C. CREATE VIEW
D. ALTER VIEW
E. None of the above
Answer Option D
24. A list in alphabetical order
A. is in descending order
B. is in ascending order
C. is the result of a sort operation
D. both (b) and (c)
E. None of the above
Answer Option D
25. If a piece of data is stored in two places in the database, then
A. storage space is wasted
B. changing the data is one spot will cause data inconsistency
C. it can be more easily accessed
D. both (a) and (b)
E. None of the above
Answer Option D
26. A data dictionary is a special file that contains
A. the names of all fields in all files
B. the data types of all fields in all files
C. the widths of all fields in all files
D. All of the above
E. None of the above
Answer Option D
27. A file that is organized in uniform format is formally referred to as a _____ or a database file.
A. Document
B. Database
C. Record
D. Structured data file
E. None of the above
Answer Option D
28. A form can be used to
A. modify records
B. delete records
C. format printed output
D. All of the above
E. None of the above
Answer Option D
29. Which language has recently become the de-facto standard for interfacing application programs with relational database system?
A. Oracle
B. SQL
C. dBASE
D. 4GL
E. None of the above
Answer Option B
30. In SQL, the CREATE TABLE is used
A. to create a table, defining its columns, integrity constrains, and storage allocation
B. to add a column/integrity constraint to a table
C. to redefine a column
D. to change a table's storage characteristics
E. All of the above
Answer Option A
31. Which of the following is not true of the traditional approach to information processing?
A. There is common sharing of data among the various applications
B. It is file-oriented
C. Programs are dependent on the files
D. It is inflexible
E. All of the above are true
Answer Option A
32. Batch processing is appropriate if
A. a large computer system is available
B. only a small computer system is available
C. only a few transactions are involved
D. All of the above
E. None of the above
Answer Option E
33. What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
A. DASD
B. FMS
C. EMMS
D. DBMS
E. None of the above
Answer Option D
34. Which of the following is not an advantage of the data-base approach?
A. elimination of the data redundancy
B. ability to associate related data
C. increased security
D. program/data independence
E. All of the above are advantages
Answer Option E
35. A data dictionary doesn't provide information about:
A. where data is located
B. the size of the disk storage device
C. It allows a many-to-many relationship
D. It is conceptually simple
E. It will be the dominant data base of the future
Answer Option B
36. Data encryption techniques are particularly useful for
A. reducing storage space requirements
B. improving data integrity
C. protecting data in data communication systems
D. All of the above
E. None of the above
Answer Option C
37. It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
A. Database
B. Table
C. Record
D. Flat File
E. None of the above
Answer Option A
38. A logical schema
A. is the entire database
B. is a standard way of organizing information into accessible parts
C. describes how data is actually stored on disk
D. All of the above
E. None of the above
Answer Option B
39. Queries to a database
A. are written in English
B. can use aggregate functions like SUM and COUNT
C. both (a) and (b)
D. All of the above
E. None of the above
Answer Option B
40. In order to use a record management system
A. You need to understand the low-level details of how information in stored
B. You need to understand the model the record management system uses.
C. Both (a) and (b)
D. All of the above
E. None of the above
Answer Option B
41. In SQL, which command is used to select only one copy of each set of duplicable rows
A. SELECT DISTINCT
B. SELECT UNIQUE
C. SELECT DIFFERENT
D. All of the above
E. None of the above
Answer Option A
42. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
A. a tree file
B. an indexed file
C. a hashed file
D. a sequential file
E. None of the above
Answer Option C
43. Which command is used to select distinct subject (SUB) from the table (BOOK)?
A. SELECT ALL FROM BOOK
B. SELECT DISTINCT SUB FROM BOOK
C. SELECT SUB FROM BOOK
D. All of the above
E. None of the above
Answer Option B
44. The master list of an indexed file
A. is sorted in ascending order
B. contains only a list of keys and record numbers
C. has a number assigned to each record
D. both (b) and (c)
E. None of the above
Answer Option C
45. Which of the following is not the responsibility of the utilities component of DBMS software?
A. creating the physical and logical designs
B. removing flagged records for deletion
C. creating and maintaining the data dictionary
D. monitoring performance
E. None of the above
Answer Option A
46. In SQL, the CREATE TABLESPACE is used
A. to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
B. to create a database trigger
C. to add/rename data files, to change storage
D. All of the above
E. None of the above
Answer Option A
47. In SQL, which command is used to remove a stored function from the database?
A. REMOVE FUNCTION
B. DELETE FUNCTION
C. DROP FUNCTION
D. ERASE FUNCTION
E. None of the above
Answer Option C
48. The database administration function includes
A. application programming
B. computer operations management
C. database access planning
D. All of the above
E. None of the above
Answer Option C
49. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
A. tables
B. relations
C. tuple
D. both (a) and (b)
E. None of the above
Answer Option D
50. A command that lets you change one or more fields in a record is
A. Insert
B. Modify
C. Look-up
D. All of the above
E. None of the above
Answer Option B
Comments
Post a Comment