Q.1
What is the purpose of Query?
a.
Input data b. Output data c. Filter & sort d. All
Q.2
What happen when selecting record presses delete key?
a.
Row will be deleted b. Content will be deleted
c.
Row moves one step up d. None of the above
Q.3
Which is the function of relationship?
a.
Relate multiple tables b. Relate multiple form
c.
Relate table and form d. Relate queries and
forms
Q.4
OLE means
a.
Open Linking and Embedding b. Object linking and
embedding
c.
Objective Linking and Embedding d. Open Link and End
Q.5
In which object SQL is used
a.
Query b. Form c. Report d. Macro
Q.6
Which data type doesn't exist in access?
a.
Number b. Picture c.
Memo d. Text
Q.7
What is there in Record?
a.
Collection of fields. b.
Collection of number
c.
Collection of Rows d. All of the above
Q.8
What operation is not permitted by query?
a.
Delete b. Entry c. Modify d. Create table
Q.9
Which is not related with Database?
a.
Table b. Query c. Form d.
Macro
Q.10
Which is not numeric data type?
a.
Byte b. Bit c. Single d. Double
Q.11
Which objects uses table & report?
a.
Switch board b. Query c.
Report d. Form
Q.12
How many relation can be formed with two tables?
a.
One b. Two c. Three d. Four
Q.13
Which one is unique field?
a.
Primary key b. Foreign key c. Index key d. None
Q.14
Which is not Data field Type?
a.
OLE b. Memo c. Lookup Wizard d. E-Mail
Q.15
Which fields appears when report is created with report wizard
a.
All fields b. Selected
fields c. Related fields d. All
Q.16
Full form of E-R diagram
a.
Engineer Relational Diagram b. Entity Relation Diagram
c.
External Relational Diagram d. Internal Relation Diagram
Q.17
In Access which wild card is not mostly used?
a.
! b. # c. ? d.
*
Q.18
Which application program is called database program?
a.
Excel b. Word c. PowerPoint d. Access
Q.19
Which one is not relationship type?
a.
Many to many b.
Many to one c. One to many d. One to one
Q.20
Which one is not database object?
a.
Form b. Table c. Report d. Datasheet
Q.21
Table is
a.
Row & Column b. Field/Column c. Row & Chart d. None
Q.22
Which one is used for database management?
a.
Jet Engine b. Boot &
Logic c. Procedure d. Format
Q.23
Restrict to database file use to another user we protect in
a.
Exclusive mode b. Inclusive mode c. Extended mode d. All
Q.24
In Access to insert picture the data type is used
a.
OLE b. Hyperlink c. Lookup wizard d. Picture
Q.25
In Access table, which components are exist?
a.
Field and Column b. Row and
Record c. Column and Row d. Row and Cell
Q.26
Which is database program?
a.
Oracle b. Word c. Excel d. None
Q.27
To print table structure is called
a.
Documenter b. Generator c. Analyzer d. All
Q.28
Which objects extracts the subset of data?
a.
Form b. Field c. Query d. Report
Q.29
Which is included in table?
a.
Record b. Field c. Index d. All
Q.30
Form and Report is called
a.
Object b. Field c. Record d. Column
Q.31
Which one is unique key?
a.
Index key b. Foreign key c.
Assign a common field d. Primary key
Q.32
To insert a form within form is called
a.
Sub Form b. Query c. Report d. Form
Q.33
Which relationship cannot be set between two tables?
a.
One to one b. One to many c. Many to one d.
Many to many
Q.34
The key used to fast data accessing from database.
a.
Index key b. Primary key c. Foreign key d. All
Q.35
The key used to organized database is sorting manner?
a.
Foreign key b. Index key c. Key field d. None
Q.36
Form can be build from
a.
Table b. Table
& Query c. Sub form d. None
Q.37
Form is used for
a.
To enter data b. To display
message c. To place different controls d. All
Q.38
Relationship established with
a.
Two identical fields b. One numeric and
other text field
c.
Foreign key d. All of the
above
Q.39
Database Management system function
a.
Add b. Delete c. Append d. All
Q.40
Filter
a.
Extract the subset of data b.
Extract the numeric data only
c.
Extract the character data only d.
None of the above
Q.41
Record is called in database terminology
a.
Entity b. Attribute c. Relation d. All of the above
Q.42
Properties of database
a.
Consistency b. Independence c. Security d. All of the above
Q.43
Independence means
a.
Exclusive b. Inclusive c. Sharing d. None of the above
Q.44
To modify the data type by
a.
Table design view b. Datasheet view c. Open mode d. All
Q.45
The extension of index file is
a.
ndx b. idx c. ind d. All of the above
Q.46
Tree structure displays the
a.
File only b. Directory only c. Directory and file name d. None
Q.47
Which one is the currently popular database?
a.
Object oriented b. Flat file
database
c.
Object oriented relational database d.
None of the above
Q.48
Query structure
a.
Field b. Records c. Snapshot d. Dynaset
Q.49
In Ms Access, if you type sort(abs(-81)), then it display
a.
9 b. -9 c. 0 d. Wrong command
Q.50
Complete horizontal row of the data is called
a.
Record b. Fields c. Column d. None of the above
Q.51
Ms Access can import file from
a.
Dbase database file b. Excel
workbook c. Notepad delimited text
file d. All
Q.52
Which is not the database application?
a.
Powerpoint b. Excel c. Ms Access d. All of the above
Q.53
Form can be making from
a.
Table & Queries b. Table only c. Table & Report d. Report & Queries
Q.54
DBMS stands for
a.
Database Managerial System b.
Database Management System
c.
Database Basic managerial System d.
Database Basic Management System
Q.55
OLE stands for
a.
Object link & Engaging b.
Object Linking & Embedding
c.
Object like & energy d.
Online linking & embedding
Q.56
Table can be created by ____ in ms access
a.
2 ways b. 3 ways c. 4 ways d. 5 ways
Q.57
Which field type is not used in database?
a.
Currency b. Text c. Number d. Single
Q.58
Primary key
a.
Must have an unique number b.
Not null
c.
Used to relate with foreign key d.
All of the above
Q.59
File extension of MS Access?
a.
.mdb b. .mda c. .mbd d. .mdp
Q.60
RDBMS uses data source from
a.
Flat file b. Table c. OLAP d. None
Q.61
DDL supports for
a.
Drop b. Insert c. Update d. Delete
Q.62
Which can you import in MS access?
a.
Workbook b. Slide c. Word document d. All of above
Q.63
Which is not database object?
a.
Table b. Form c. Macro d. Datasheet
Q.64
Which cannot create report from?
a.
Table b. Query c. Table & Query d. Filter
Q.65
Which is used for connecting database with front-end object?
a.
ADO b. Record set c. Query d.
All of above
Q.66
Which is not database?
a.
LISP b. FoxPro c. Dbase d. Oracle
Q.67
Which is an odd?
a.
SQL b. QBE c. MS access d. QUEL
Q.68
Which is relationship type?
a.
1:1 b. 1:m c. m:n d. All
Q.69
Foreign key is used to
a.
Establish relationship b. Indexing table c. Unique record d. All
Q.70
New record is added using
a.
append record into from browse menu
b. append record from browse menu
c.
add record from edit menu d. all of the above
Q.71
In MS access _____ is used to build and modify database objects and also to
create new queries.
a.
Layout preview b. Datasheet view c. Design view d. Print preview
Q.72
What are the main building blocks of a database?
a. Tables b. Lists c. Queries d. All of the above
a. Tables b. Lists c. Queries d. All of the above
Q.73
Which of the following is not a relational database?
a.
Reflex b. FoxPro c. Dbase IV d. 4th Dimension
Q.74
A phone number in a database is an example of a
a.
File b. Field c. Record d. Sort
Q.75
A _____ helps you perform routine tasks by automating them.
a.
Report b. Query c. Macro d. Form
Q.76
Which is the smallest piece of database?
a.
Bit b. Byte c. Record d. Table
Q.77
Which is not action query?
a.
Append b. Update c. Make table d. Select
Q.78
The shortcut key for add new record?
a.
Ctrl + + b. Alt + + c. Shift + + d. None
Q.79
Which is the action query?
a.
Append b. Update c. Cross tab d. Parameter
Q.80
The primary key is
a.
Redundant key b. Unique key c. Index key d.
None
Q.81
The auto-report generates the ____ report
a.
Simple b. Formatted c. Summary d.
All
Q.82
Database is
a.
Relation b. Order c. List d. Collection of data
Q.83
Which of the following is the largest unit of data?
a.
Field b. Database c. Records d.
Table
Q.84
To add data from which menu
a.
Append from browse menu b. Append from browser
c.
Append from briefcase d. Append
from edit menu
Q.85
The append is
a.
Adds data mid of record source b.
Adds data top of record source
c.
Adds data at the bottom of record source d.
None
Q.86
Which is not the elements of SQL?
a.
Select b. From c. Where d. Main
Q.87
Row is another name of
a.
Record b. Field c. Table d. Query
Q.88
Framework of for storing records in database is a
a.
Form b. Report c. Query d. Table
Q.89
Append from command is used to
a.
Adds new record form file b. Add
record from a variable
c.
Add records from stock d. All of
the above
Q.90
DBMS is
a.
Collection of data b. Set of programs
to access data
c.
Set of programs to update data d.
All of above
Q.91
In ___ data model are organized into tables
a.
Relational b. Network c. Tree d.
Hierarchical
Q.92
Which term refers to a collection of related information?
a.
Database b. List c. Outline d.
Record
Q.93
Oracle and Ms Access are
a.
Spreadsheet b. RDMS
c.
Operating system d. Utility
Q.94
The main output object of MS Access is
a.
Table b. Macro c. Report d. Module
Q.95
The extension of dBase data file is
a.
.exe b. .mdb c. .dbf d. .ndx
Q.96
The extension of MS access data file is
a.
.mdx b. .mdb c. .dbf d. .ndx
Q.97
Which of the following software is not used for database design?
a.
MS access b. Oracle c. SQL server d. Web Server
Q.98
The arranging data in a logical sequence is called
a.
Classifying b. Sorting c. Summarizing d. Reproducing
Q.99
DBMS is
a.
Application Software b. System
Software
c.
Program Software d. All of
the above
Q.100
What do you mean by Report?
a.
Output b. Modify c. Entry Format d. Enquiry
Q.101
Database has
a.
Design view b. Datasheet view c. Format view d. Both a and b
Q.102
Which command is used to display the record that satisfies the specified
criteria?
a.
FIND QUERY b. SEARCH QUERY c. SELECT QUERY d. LOCATE QUERY
Q.103
Which of the following is not a Access database object?
a.
Datasheet b. Table c. Form d. Query
Q.104
What is the maximum character for text field?
a.
64 character b. 255 character c. 512 character d. None
Q.105
Which key is necessary to define relationship between the tables?
a.
Secondary key b.
Primary key
c.
Miscellaneous key d.
Auxiliary key
Q.106
A tool provided in a database management system that allows users to define the
database is called
a.
Structured query language b.
Data definition language
c.
Data manipulation language d.
None
Q.107
What is the full form of RDBMS?
a.
Relational database management system
b.
Rational database management system
c.
Record database management system
d.
Read database management system
Q.108
Index is used to perform the _______
operation
a.
Searching b. Sorting c. Validating d. None
Q.109
The collection of related information is called
a.
Database b. Table c. Field d. Record
Q.110
In Ms Access, Wizard helps to
a.
Create table b. Create form c. Generate report d. All of the above
Q.111
Filter displays
a.
To suppress data and display list of data to meet the criteria
b.
To display all data c. Sort the data d. All
Q.112
In RDBMS file refers as
a.
Table b. Entities c. Field d. None
Q.113
Which is not a field property?
a.
Format b. Indexed c. Color d.
Field size
Q.114
Which of the following automates the task?
a.
Macro b. Autotext c. Wizard d. Template
Q.115
Each individual data item is called
a.
Field b. Data type c. Comment d.
All of the above
Q.116
Which of the following is related to retrieval of data?
a.
Query b. Field c. Record d. Table
Q.117
What are the data called?
a.
Raw and number b. Image b. Facts and figure d. None
Q.118
Which of the following is the Database Programme?
a.
Ms-Access b. Ms-Word c. Ms-Excel d. Ms-Powerpoint
Q.119
What are the files of DBMS called?
a.
Table b. Attribute c. Filed d.
None
Q.120
__________ is a interface through which the user interacts with the
application.
a.
Form b. Module c. Report d. Query
Q.121
When key is used to find and distinguish records uniquely?
a.
Foreign key b. Candidate key c. Primary key d. All of the above
Q.122
________ helps to create the fields of a table in Ms-Access.
a.
Form view b. Design view c. Table view d. None of the above
Q.123
The technique which define a set of values acceptable for the field is known as
a.
validation b. Verification c. Relation d. Audit
Q.124
Technique to speed up data retrieval in database is
a.
Speeding b. Listing c. Indexing d. Warping
Q.125
The oldest database models are
a.
Object oriented b. Hierarchical
and network model
c.
Relational d. None
Q.126
Consider the following table student (roll. No, name, grad, subject). Which SQL
is correct to retrieve the name of all students having grade "B"
a.
SELECT name FROM STUDENTS
b.
SELECT name FROM students WHERE grade="B"
c.
SELECT name FROM students WHERE grade IN B.
d.
Both b and c
Q.127
Which of the following keywords doesn't belong to DDL?
a.
CREATE b. ALTER c. CONSTRAINT d. SELECT
Q.128
A ______ constraint restricts values you can insert into a column.
a.
CHECK b. VALIDATE c. VERIFY d.
Same
Q.129
Term 'Query' is used generally in
a.
Word processing b. Presentation c. OS d.
Database
Q.130
A _______ key is a column in your table that make each record unique and it
cannot have null value.
a.
Primary b. Foreign c. Edit d.
Update
Q.131
In a relational database, a key that is on the many side of a one to may
relationship is known as
a.
Primary key b. Foreign key c. Secondary key d. None of the above
Q.132
From which tale, Data fetching will be show
a.
Table with less number of columns
b.
Table with less number of fields
c.
Table without index on columns
d.
Table with index on columns
Q.133
Which of the following is not a database application?
a.
dBase b. Edit c. FoxPro d. Access
Q.134
Size of a database are usually measured in terms of
a.
Tera bytes b. Mega bytes c. Data bytes d.
Giga bytes
Q.135
A organized collection of logically related data is known as
a.
Data b. Meta data c. Database d.
Data versus information
Q.136
A field that uniquely identify each record in a table is
a.
Main field b. Primary key c. Key field d.
Index key
Q.137
A DBMS allow you to create and maintain a database, create reports, and develop
application programs, select the best fit answer
a.
Database management approach b. DBMS
uses
c.
Database administrator d.
Query language
Q.138
A large collections of tables are called _____
a.
File system b. Fields c. Records d. Databases
Q.139
Which of the following is a database management system?
a.
Oracle b. Ms. Word c. Lotus 1-2-3 d. None of the above
Q.140
Which of the following is not a data type?
a.
Picture b. Date c. Numeric d. Character
Q.141
_____is a collection of data stored in a standardized format designed to be
shared by multiple users.
a.
Database b. Record c. Database management system d. Relation
Q.142
A field or group of fields that uniquely identifies every row of table is
a.
Primary key b. Foreign key c. Hot key d.
Access key
Q.143
The oldest database model are:
a.
Hierarchical and network b. Relational and object oriented
c.
Object oriented and deductive d. None of the above
Q.144
The relational model defines two root language - relational algebra &
relational calculus for accessing
a.
Text file b. Document file c. Relational database d. Flat-file database
Q.145
Meaning of metadata is
a.
Data definition b. Data of data c. Data for data d. Data dictionary
Q.146
Collection of interrelated data is known as
a.
Data model b. DBMS c. Database d. All of the above
Q.147
Which of the following is not a relational database.
a.
Reflex b. Dbase_IV c. Sybase d.
SQL Server
Q.148
The relational algebra is a ____ language.
a.
Complex language b. Lower level language
c.
Procedural language d.
Non-Procedural language
Q.149
The highest level in the hierarchy of data organization is called
a.
Data record b. Data bank c. Database d.
Data file
Q.150
The basic SQL select statement has three clauses
a.
Select, From, Where b.
Select, For, Next
c.
Select, Next, For d. Select, Until, End
Q.151
Which of the following is not characteristics of relational database model?
a.
Records b. Tables c. Tree like structure d.
Complex logical relationship
Q.152
One of the main objective of a DBMS is used to
a.
Replace file based systems
b.
Create a database for an organization.
c.
Facilitate sharing of a database by current and future application.
d.
Allow sharing application program.
where is anwar
ReplyDeleteAnswer plz, sir?
ReplyDeleteanswer key
ReplyDeleteOk I will provide
DeleteAnswer key sir
DeleteI haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. https://cctvsingapore.shutterfly.com/
ReplyDeletePost the Answer sir
ReplyDeleteOk will upload questions with answer also with pdf file.
DeleteBecause you havent provided answers, i always skip your site from reading. need to update. Either provide answers at last of questions or just highlight in the options.
ReplyDelete