Lesson 11A – Database Management Systems – Multiple Choice Questions(MCQ) IT Theory is part of SAS PC3 Syllabus.In this post, we have provided all important MCQs that are likely to come in the upcoming SAS exam. All the Best !!!
- A ————— is an example of a database.
a. Telephone book
b. Form
C. Field
d. Report - A ——– is a complete collection of records.
a. Table
b. Field
C. DBMS
d. Row - A ———– databases is made up of a set of tables where a common field in any two tables create a
relation between the tables
a. Flat-file
b. Large
c. Relational
d. DBMS - A ———– can store an object, such as a picture, rather than text or numeric data,
a. Counter field
b. Binary field
C. Logical field
d. Numeric field - A —– – tells the DBMS to display records that satisfy a condition while hiding those that do not.
a. Form
b. Column
c. Filter
d. Report - Clerks or other data entry personnel fill in a —–
a. Filter
b. Report
C. SQL
d. Form - You use a[n) ————-sort order to arrange records alphabetically, from A to Z
a. Rising
b. Falling
C. Ascending
d. Descending - A unique numeric value that the DBMS assigns to each record is called a ——–
a. Counter field
b. Query
c. Binary field
d. Time field - A —- field can hold only one of two values, such as Yes or NO.
a. Two-way
b. Binary
c. Logical
d. Counter - Characters that are not used in calculations are usually stored in a ——-
a. Database
b. Text field
C. Date field
d. Binary field - The fields which typically include automatic error checking features are ——
a. Date and time
b. Binary
C. Numeric
d. Text - A ………. is a software tool that enables users to add, view and work with the data in a database.
a. Spreadsheet
b. Word processor
C. DBMS
d. Presentation - The user-generated sets of data usually printed as a document are called —-,
a. Forms
b. Queries
C. wizards
d. reports - ——— databases are two-dimensional tables of fields and records that do not for relationships with
other tables.
a. Relational
b. Hierarchical
C. Flat-file
d. Structured file - SQL stands for Structured —— Language
a. Question
b. Query
C. Quotient
d. Quiet