The task of arranging data in order is called
Searching
Sorting
Ordering
Shorting
Correct Answer :
B. Sorting
Related Questions
Which of the following is not a database object in MS Access?
Tables
Query
Report
Relationship
Unlike text data type, this can store up to maximum of 65, 535 characters.
memo
data/time
number
All of above
In a database table, the category of information is called ____________
tuple
field
record
All of above
The database language that allows you to access or maintain data in a database
DCL
DML
DDL
None of above
It is most common type of query. It retrieves records from one or more tables and then displays the
Parameter
Select
crosstab
All of above
The default and maximum size of text field in Access
50 and 255 Characters
8 and 1 GB
266 characters & 64000 characters
None of above
Collection of related records in a database is known as
File
Bench
Table
Relationship
Which of the following may not be a database?
Data presented in table in MS Word document
Data entered in Excel spreadsheet
A presentation created in PowerPoint
A telephone diary
To create primary key for a table when in design view
Type PRIMARY in field type box when creating required field
Mark the Primary check box in field name of required field
Click the Primary Key button in Design ribbon when the cursor is in required field
None of the above
The size of Yes No field is always
1 bit
1 byte
1 character
1 GB
Which of the following creates a drop down list of values to choose from a list?
OLE Object
Hyperlink
Memo
Lookup Wizard
What do you mean by one to many relationship between Student and Class table?
One student can have many classes
One class may have many student
Many classes may have many students
Many students may have many classes
Which of the following is not a type of relationship that can be applied in Access database
One to One
One to Many
Many to Many
All of above can be applied
While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
a doctors sign
thin + sign
outline rectangle
None of above
Database Management Systems are featured with:
The facility to easy editing, spelling check, auto pagination, lay out and printing reports
The ability to store large amount of data to facilitate easy update, sort and retrieval
The ability to calculate efficiently with the help of built-in functions and analyze
All of above
A primary key in any table has the properties
Not Null
No Duplicates
Both of above
None of above
Which of the following is not a database object?
Tables
Queries
Relationships
Reports
Both conditions display on the same row in the design grid when ___operator is in use
OR
IN
AND
LIKE
The two form layout types will display multiple records at one time are tabular and___
columnar
justified
date sheet
pivot table
You can set a controls border type to make the border invisible.
Transparent
Invisible
Do not display
No border
A __________ enables you to view data from a table based on a specific criterion
Form
Query
Macro
Report
To sort records in a table
Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar
Open table, click Sort button on database toolbar, choose field based on which to sort, click OK
Click the field heading to sort it ascending or descending
All of above
To create relationship between two tables
drag the primary key of a table into foreign key of another table
drag the foreign key of a table into the primary key of another table
drag any field from parent table and drop on child table
Any of above can be done to create relationship
Queries in Access can be used as
view, change and analyze data in different ways
a source of records for forms and reports
Only a
Both a and b
The size of a field with Number data type can not be
2
4
8
16
In table design view, which key can be used to switch between the field names and properties panels?
F3
F4
F5
F6
In table design view what are the first column of buttons used for
Indicate Primary Key
Indicate Current Row
Both of above
None of above
When entering field name, how many characters you can type in maximum?
60
64
68
Any number of character
This is the stage in database design where one gathers and lists all the necessary fields for the database project.
data definition
data refinement
establishing relationship
none of the above
Which of the field has width 8 bytes?
Memo
Number
Date/Time
Hyperlink