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

1. A good query system
A can accept English language commands
B allows non-programmers to access information stored in a database
C can be accessed only by data processing professionals
D None of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
2. 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 change a table's storage characteristics
D All of the above

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
3. In SQL, which command is used to change a table's storage characteristics?
A ALTER TABLE
B MODIFY TABLE
C CHANGE TABLE
D All of the above

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
4. Which of the following hardware components is the most important to the operation of a database management system?
A high-resolution video display
B printer
C high speed, large-capacity disk
D plotter

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
5. In SQL, GRANT command is used to
A allow user to access databases
B allow user to create databases
C grant system privileges, roles, and object privileges to uses and roles
D choose auditing for specific SQL commands

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
6. If you want to group the records in the abc database, you could use the Jobcode as the ________.
A Delete
B Update
C Sort Key
D Index

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
7. The Management Information system (MIS) structure with one main computer system is called a
A hierarchical MIS structure
B distributed MIS structure
C centralized MIS structure
D decentralized MIS structure

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
8. An operation that will increase the length of a list is
A Insert
B Look-up
C Modify
D All of the above

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
9. In SQL, which command is used to create a database user?
A ADD USER TO DATABASE
B MK USER
C CREATE USER
D All of the above

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
10. In SQL, which command is used to redefine an index's future storage allocation
A ALTER INDEX
B REDEFINE INDEX
C MODIFY INDEX
D DO INDEX

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
11. A set of programs that handle a firm's data base responsibilities is called a
A Data Base Management System (DBMS)
B Data Base Processing System (DBPS)
C Data Management System (DMS)
D All of the above

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

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

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
14. 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 All of the above are advantages

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
15. Which of the following is not a relational database?
A dBASE IV
B 4th Dimension
C FoxPro
D Reflex

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
16. Internal auditors should review data system design before they are
A developed
B implemented
C modified
D All of the above

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
17. Which command is used to redefine a column of the table in SQL ?
A ALTER TABLE
B DEFINE TABLE
C MODIFY TABLE
D All of the above

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
18. The language used in application programs to request data from the DBMS is referred to as the
A DML
B DDL
C query language
D All of the above

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
19. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
A report writer
B query language
C data manipulation language
D transaction log

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
20. The way a particular application views the data from the data base that the application uses is a :
A module
B relational model
C schema
D subschema

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
21. A _________ contains fields of data about one entity.
A Record
B File
C Fields
D Document

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

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

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
24. Data integrity control
A has the data dictionary keep the date and time of last access last back-up and most recent modification for all files
B is used to set upper and lower limits on numeric data
C requires the use of passwords to prohibit unauthorized access to the file
D All of the above

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
25. In SQL, which of the following is not a data definition language commands?
A RENAME
B REVOKE
C GRANT
D UPDATE

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

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

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
28. In SQL, the CREATE VIEW command is used
A to recompile view
B to define a view of one or more tables or views
C to recompile a table
D to create a trigger

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
29. In SQL, the ________ command is used to recompile a view
A COMPILE VIEW
B DEFINE VIEW
C CREATE VIEW
D ALTER VIEW

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

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
31. The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
A forecasting report
B exception report
C regularly scheduled report
D on demand report

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

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
33. Which of the following is a type of DBMS software?
A database manipulation language
B query language
C report writer
D All of the above

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

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

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
36. 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 table space
B to create a database trigger
C to add/rename data files to change storage
D All of the above

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

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

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
39. Which of the following button will allow you to add, delete, or change records in your Data Source
A
B
C
D

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
40. What is the disadvantage of a DBMS?
A Data security and integrity
B Complexity
C Data independence
D Crash recovery and concurrent access

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
41. Data models define how the ___________ of a database is modelled.
A Logical Structure
B Object Models
C Physical Structure
D None of the above

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
42. User cannot enter or change the data in ________ Type of field in Database.
A Number
B Characcter
C Auto Number
D Data/Time

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
43. MS Access 2010 creates database in the __________ file format as default.
A .mdb
B .accdb
C . Mbdx
D None of above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
44. A primary key consists of ___________
A Duplicate Values
B Unique Values
C Duplicate and Unique Values
D None of the above

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
45. What are the available database objects in MS Access 2010?
A Macros
B Forms
C Reports
D All of the above

Free MCQs www.sharemcq.com     Answer: Option D
Explanation:
Available Soon.
46. User can create a new table by using
A Design view
B Datasheet view
C Design View and Datasheet View
D None of the above

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
47. __________ is a collection of data that is stored electronically as a series of records in a table.
A Outlook
B Database
C Web page
D Presentation

Free MCQs www.sharemcq.com     Answer: Option B
Explanation:
Available Soon.
48. The __________ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
A Key
B Fields
C Attribute
D Rows

Free MCQs www.sharemcq.com     Answer: Option A
Explanation:
Available Soon.
49. A __________ is an abstract model that describes, how the data are organized and represented.
A Database
B Instances
C Data Model
D Schema

Free MCQs www.sharemcq.com     Answer: Option C
Explanation:
Available Soon.
50. Default and maximum size of text filed in MS Access is ________.
A 50 and 255 characters
B 266 characters and 6400 characters
C 288 characters and 6880 characters
D 299 characters and 6499 characters

Free MCQs www.sharemcq.com     Answer: Option A
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