DBMS Software (MS-Access) MCQs > FREE SET - 3

1. In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
A data field
B data record
C data file
D database

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
2. The data-base environment has all of the following components except:
A users
B separate files
C data base
D data-base administrator

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
3. The distinguishable parts of a record are called
A files
B data
C fields
D database

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
4. In SQL, which command is used to select data in rows and column from one or more tables?
A CHOOSE
B SELECT
C LIST
D BROWSE

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
5. A computer file can be best described as
A a single data item
B a general collection of data items
C an orderly collection of data items
D a random collection of data items

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
6. Embedded pointer provide
A a secondary access path
B a physical record key
C an inverted index
D All of the above

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
7. After you ________ a record, many data management the environments require you to issue a command to save the changes you made.
A Delete
B Update
C Sort key
D Index

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
8. 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 SAVE

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
9. In SQL, which command is used to enable/disable a database trigger?
A MODIFY USER
B CHANGE USER
C ALTER TRIGGER
D All of the above

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
10. Updating a database means
A revising the file structure
B reorganizing the database
C modifying or adding record occurrences
D All of the above

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
11. A ________ means that one record in a particular record type may be related to more than one record of another record type.
A One-to-one relationship
B One-to-many relationship
C Many-to-one relationship
D Many-to many relationship

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
12. An audit trail
A is used to make back-up copies
B is the recorded history of operations performed on a file
C can be used to restore lost information
D All of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
13. In the DBM approach, application programs perform the
A storage function
B processing functions
C access control
D All of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
14. Two files may be joined into a third file if
A they have a row in common
B they have a field in common
C they have no records with the same value in the common field
D None of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
15. Large collections of files are called
A fields
B records
C databases
D file system

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
16. 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

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
17. 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

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
18. 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

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
19. A _________ DBMS distributes data processing tasks between the workstation and a network server.
A Network
B Relational
C Client Server
D Hierarchical

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
20. In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
A CREATE PACKAGE
B CREATE SCHEMA
C CREATE CLUSTER
D All of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
21. Data item characteristics that are important in data management include
A punctuation
B language
C spelling
D width

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
22. When using a database management system, the first thing that you must do is to
A create a database file
B activate file editor
C load the software into your computer
D keep a floppy disk in readiness

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
23. When you have finished entering information into a form
A the template is written to the data file
B the contents of the form are written to the data file
C the contents of the form can be printed
D All of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
24. The main idea behind computer files is that it is convenient to
A arrange them
B store information together
C create them
D access them

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
25. In a relational schema, each tuple is divided into fields called
A Relations
B Domains
C Queries
D All of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
26. In SQL, which command is used to create a synonym for a schema object?
A CREATE SCHEMA
B CREATE SYNONYM
C CREATE SAME
D All of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
27. The model for a ________ resembles the hierarchical model in many respects.
A Network database
B Relational database
C Distributed database
D Hierarchical database

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
28. The modify operation is likely to be done after
A Delete
B Look-up
C Insert
D All of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
29. Versatile report generators can provide
A Columnar totals
B Subtotals
C Calculations
D All of the above

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
30. 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

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
31. Information can be transferred between the DBMS and a
A spreadsheet program
B word processor program
C graphics program
D ALL of the above

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
32. Database management systems are intended to:
A eliminate data redundancy
B manage file access
C maintain data integrity
D All of the above

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
33. Periodically adding, changing and deleting file records is called file
A Updating
B upgrading
C restructuring
D None of the above

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
34. The data dictionary tells the DBMS
A what files are in the database
B what attribute are possessed by the data
C what these files contain
D All of the above

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
35. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
A Full media
B Graphics media
C Multimedia
D Hypertext

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
36. A network schema
A restricts the structure to a one-to-many relationship
B permits many-to-many relationships
C stores data in tables
D All of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
37. In SQL, which command is used to add new rows to a table?
A ALTER TABLE
B ADD ROW
C INSERT
D APPEND

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
38. In SQL, which command is used to add a column/integrity constraint to a table
A ADD COLUMN
B INSERT COLUMN
C MODIFY TABLE
D ALTER TABLE

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
39. An indexing operation
A sorts a file using a single key
B sorts file using two keys
C establishes an index for a file
D both (b) and (c)

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
40. A ________ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
A Network
B Hierarchical
C Relational
D Object-Oriented

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
41. A compound key
A is made up a several pieces of information
B uniquely identifies an item in a list
C both (a) and (b)
D is a combination of each unique key

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
42. The index consists of
A a list of keys
B pointers to the master list
C both (a) and (b)
D All of the above

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
43. 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

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
44. Related fields in a data base are grouped to form
A data file
B data record
C menu
D bank

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
45. The database administration function includes
A application programming
B computer operations management
C database access planning
D All of the above

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
46. In SQL the command is used to create an index for a table or cluster
A CREATE INDEX
B MODIFY INDEX
C SET INDEX TO FILE
D All of the above

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
47. Which command is used to remove an index from the database in SQL?
A DELETE INDEX
B DROP INDEX
C REMOVE INDEX
D ROLL BACK INDEX

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
48. A database management system
A allows simultaneous access to multiple files
B can do more than a record management system
C is a collection of programs for managing data in a single file
D both A) and B)

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
49. 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 pin code
B the last name
C a compound key consisting of the first name and the last name
D All of the above

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
50. In SQL, which of the following is not a data Manipulation Language Commands?
A DELETE
B SELECT
C UPDATE
D CREATE

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
at
Labels:

No comments:

Post a Comment

Your Feedback is hearty Requested to make the MCQs Collection better.

Subscribe to: Post Comments (Atom)

Popular Posts