Database Management Systems are featured with:
A. The facility to easy editing, spelling check, auto pagination, lay out and printing reports
B. The ability to store large amount of data to facilitate easy update, sort and retrieval
C. The ability to calculate efficiently with the help of built-in functions and analyze
D. All of above
Select an option to see the answer and solution.
In access press to Move to the next page of the wizard
A. TAB
B. ALT+N
C. ALT+B
D. ALT+F
Select an option to see the answer and solution.
Which tool do you use to create a query object?
A. Database wizard
B. Simple filter wizard
C. Simple query wizard
D. Table query wizard
Select an option to see the answer and solution.
What method can you use to add a new table to your database?
A. Use Design View to create a table
B. Enter data directly by using a datasheet
C. Both of above
D. All of the above
Select an option to see the answer and solution.
The complete information about an entity in a database is called
A. Data
B. Information
C. Field
D. Record
Select an option to see the answer and solution.
In order to use dbms, it is important to understand
A. The physical schema
B. All sub schemas that the sytem supports
C. One sub schema
D. Both a and b
Select an option to see the answer and solution.
A ________ is a unit of information in a ________
A. record, field
B. field, record
C. data source, field
D. record, data source
Select an option to see the answer and solution.
Which of the following query type is best suitable to analyze data?
A. Cross tab queries
B. Parameter queries
C. Action queries
D. None of above
Select an option to see the answer and solution.
Which tool is used to generate printout of a table's structure?
A. Analyzer
B. Designer
C. Documenter
D. Generator
Select an option to see the answer and solution.
Search engines use a(n) __________ to automatically index sites.
A. crawler
B. query
C. enterprise
D. sitebuilder
Select an option to see the answer and solution.
Which of the following views displays the field name, description, and properties of a table?
A. Datasheet View
B. Design View
C. Layout View
D. Table View
Select an option to see the answer and solution.
A database can be best described as
A. Organized collection of data
B. Useful presentation of data
C. Graphical representation of data
D. All of above
Select an option to see the answer and solution.
Relationship can be establish between two tables by
A. Drag Primary key of a table into Foreign key of another table
B. Drag Foreign key of a table into Primary key of another table
C. Drag any key of a table into any key of another table
D. All of the above
Select an option to see the answer and solution.
This is not one of the sections of the form design window
A. Form footer
B. Form content
C. Form header
D. Form detail
Select an option to see the answer and solution.
In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box
A. F4 or ALT+DOWN ARROW
B. DOWN ARROW
C. PAGE DOWN
D. F9
Select an option to see the answer and solution.
After creating the table which of the following is correct?
A. Fields cannot be added
B. Fields cannot be deleted
C. Fields can added but only once
D. Fields can added and deleted as needed
Select an option to see the answer and solution.
What is the use of Cascade Delete Option in MS Access?
A. It makes sure that all the records from the parent table and child table is deleted from selected database
B. It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted
C. It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted
D. None of above
Select an option to see the answer and solution.
In Access to switch between Edit mode (with insertion point displaye(D)
Select an option to see the answer and solution.
Which of the following statements does NOT hold true for the Top Values property?
A. The Top Values property displays only the highest values from the query.
B. The Top Values property requires the fields to have a defined sort order.
C. The Top Values property finds a specified number of records.
D. The Top Values property finds a specified percentage of records.
Select an option to see the answer and solution.
A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.
Select an option to see the answer and solution.