- Data is in which form?
(A) Oral
(B) Written
(C) Computerized and non-computerized
(D) All of these
Ans.: All of these - All of the tasks related to database handling are known as ……………
(A) Data model
(B) Database management
(C) Database
(D) Data source
Ans.: Database management - Who makes a database practical and more usable?
(A) Data model
(B) DBMS
(C) Database management model
(D) Database management source
Ans.: DBMS - “Base” is based on which data model?
(A) Network
(B) Relational
(C) Hierarchical
(D) Product base
Ans.: Relational - Which of the following is an example of a database?
(A) Name, address, diary containing phone numbers
(B) Attendance record of every student
(C) Telephone directory
(D) All of these
Ans.: All of these - From the following, which data object is based on Base?
(A) Table
(B) Query
(C) Form and reports
(D) All of these
Ans.: All of these - Which facility is provided by forms?
(A) Entering data in a table
(B) Editing data
(C) Deleting data
(D) All of these
Ans.: All of these
- To enter which type of information is the data type used?
(A) Letter
(B) Number
(C) Special character
(D) All of these
Ans.: All of these - How many numeric data types are available in Base?
(A) 4
(B) 8
(C) 10
(D) 14
Ans.: 10 - …………… consumes the least memory.
(A) Tiny Integer
(B) Small Integer
(C) Yes/No (Boolean)
(D) Decimal
Ans.: Yes/No (Boolean) - Which type of process can you perform in a database?
(A) Inserting and editing data
(B) Deleting unnecessary and wrong data
(C) Arranging data as per requirement
(D) All of these
Ans.: All of these - If the Boolean type field, a square box is not marked with a tick mark, then the value of the field is…
(A) 1
(B) 0
(C) Can’t say
(D) None of these
Ans.: 0 - If we click on a Boolean type field, a square box of which symbol will be shown?
(A) X
(B) R
(C) 4
(D) 3
Ans.: R - Which menu is used to establish relationships among tables in the database?
(A) Insert
(B) Tools
(C) Edit
(D) View
Ans.: Tools - You can click on the ……… button to add tables to the active database.
(A) Insert
(B) New
(C) Add
(D) Put
Ans.: Add - To create a relationship between two tables, text is displayed on the ……… side.
(A) Primary key
(B) Foreign key
(C) Both (A) and (B)
(D) None of these
Ans.: Foreign key
- Which options are shown in the Referential Integrity dialog box based on update options?
(A) No action
(B) Update cascade
(C) Set null, set default
(D) All of these
Ans.: All of these - ………………… can be used to retrieve specific sets of information from a database.
(A) Query
(B) Form
(C) Report
(D) Macro
Ans.: Query - Query basically means ………….
(A) Asking a question
(B) Doing an inquiry
(C) Performing analysis
(D) All of these
Ans.: All of these - What is the first step of the Query Wizard?
(A) Field selection
(B) Search condition
(C) Sorting order
(D) Detail or summary
Ans.: Field selection - The field that you finally select to be part of your query will be listed under ………
(A) Fields in the query
(B) Available fields
(C) Fields in the database
(D) Present fields
Ans.: Fields in the query - …………… step provides the facility for value parameters.
(A) First
(B) Second
(C) Third
(D) Fourth
Ans.: Third - Which view also displays the relationships defined between the tables?
(A) Wizard
(B) Design view
(C) SQL
(D) All of these
Ans.: Design view - How many types of criteria can be added to a query?
(A) 2
(B) 3
(C) 4
(D) 5
Ans.: 2 - Which option is used to display records in alphabetical order?
(A) Ascending, Descending
(B) Ascending, Descending, Not sorted
(C) A to Z, Z to A
(D) None of these
Ans.: Ascending, Descending, Not sorted
Question 26
The underlying structure of a database is known as ……………. .
(A) Data
(B) Datamodel
(C) DBMS
(D) Information
Answer: (B) Datamodel
Question 27
Who is responsible for storing and retrieving data?
(A) Data
(B) Datamodel
(C) DBMS
(D) Information
Answer: (C) DBMS
Question 28
Datamodel describes the way of …………….. .
(A) Storing
(B) Retrieving
(C) Both (A) and (B)
(D) None of these
Answer: (C) Both (A) and (B)
Question 29
Which of the following is a type of datamodel?
(A) Hierarchical
(B) Network
(C) Relational
(D) All of these
Answer: (D) All of these
Question 30
In the DBMS chapter, we are discussing …………….. models.
(A) Network
(B) Relational
(C) Hierarchical
(D) Productive
Answer: (B) Relational
Question 31
To work with a computerized database, one has to first define and create a …………….. .
(A) Data
(B) Information
(C) Database
(D) Datamodel
Answer: (C) Database
Question 32
A ……………. is an organized collection of data.
(A) Table
(B) Database
(C) Field
(D) Record
Answer: (B) Database
Question 33
Which of the following represents a single data item in a table?
(A) Record
(B) Field
(C) Table
(D) Database
Answer: (B) Field
Question 34
A ……………. is a collection of related data stored in rows and columns.
(A) Field
(B) Record
(C) Table
(D) Form
Answer: (C) Table
Question 35
In a relational database, a row is also referred to as a …………….. .
(A) Attribute
(B) Record
(C) Field
(D) Column
Answer: (B) Record
Question 36
In a relational database, a column is also referred to as a …………….. .
(A) Field
(B) Record
(C) Table
(D) Database
Answer: (A) Field
Question 37
The ……………. key uniquely identifies each record in a table.
(A) Foreign
(B) Primary
(C) Composite
(D) Candidate
Answer: (B) Primary
Question 38
The relationship between two tables is established using …………….. .
(A) Primary key
(B) Foreign key
(C) Composite key
(D) Alternate key
Answer: (B) Foreign key
Question 39
Which of the following is not a DBMS?
(A) MySQL
(B) Microsoft Access
(C) Oracle
(D) Excel
Answer: (D) Excel
Question 40
SQL stands for …………….. .
(A) Simple Query Language
(B) Structured Query Language
(C) System Query Language
(D) Sequential Query Language
Answer: (B) Structured Query Language