Table and Query - MCQs | Online Quiz

Table and Query - MCQs | Online Quiz. Find the most important and more conceptual multiple-choice questions (MCQs) with answers of Computer Chapter No.6: Table and Query, ICS Part 2 | 2nd Year, on the database management system (DBMS) for the interview and final examinations for all boards of Pakistan and entry test for admission in universities.

 

This post contains the multiple-choice questions (MCQs) - online quiz on Table and Query that covers the topics i.e., characteristics of tables, degree of relation, the cardinality of relation, Access IDE, table design view, datasheet view, table creation methods, data type (text, memo, number data/time, currency, auto number, yes/no, OLE object, and hyperlink), relationship and join, sorting and filtering, introduction to queries, types of queries (i.e. select queries, action queries, delete queries, update queries, append queries, crosstab queries, parametric queries), query creation, and performing the calculation in a query.

 

➤ Table and Query - Short Questions
➤ Data Integrity & Normalization
➤ Database Design Process
➤ Basic Concepts & Terminology of Databases
➤ Data Basics
➤ Getting Started with C
➤ Elements of C
➤ Input/Output 
➤ Decision Constructs
➤ Loop Constructs
➤ Functions in C
➤ File Handling

Chapter No.6: 
Table and Query | MCQs - Quiz

1 / 40

1. The collection of related data structured in rows and column refers to?
   1.   Table
   2.   Query
   3.   Form
   4.   Report
2. By specifying criteria, we can?
   1.   Simplify our query
   2.   All of these
   3.   Narrow our query
   4.   Explain our query
3. Which of the following shortcut key is used to enter a new record?
   1.   Ctrl + +
   2.   Ctrl + N
   3.   Ctrl + C
   4.   Ctrl + R
4. To display the related records from other tables in datasheet view we should?
   1.   Click on the “expand” indicator next to the record
   2.   Double click on the record to “expand” it
   3.   All of these
   4.   Apply filter by command to display related records
5. The output of the query is displayed in the form of?
   1.   Query
   2.   Table
   3.   Form
   4.   None of these
6. Which of the following query make changes in specified records of an existing table or creates a new table?
   1.   SQL query
   2.   Crosstab query
   3.   Action query
   4.   Select query
7. In datasheet view, the header of columns represents?
   1.   Records
   2.   Description
   3.   Fields names
   4.   None of these
8. If a relation has 5 rows and 6 columns, its degree will be?
   1.   5
   2.   None of these
   3.   30
   4.   6
9. Which filter method lets you filter the records that match the selected field?
   1.   Filter by form
   2.   Filter by selection
   3.   Auto filter
   4.   All of these
10. In MS Access, the default field size of the text is?
    1.   30 characters
    2.   60 characters
    3.   40 characters
    4.   50 characters
11. The fields in a table have pre-defined?
    1.   Data type
    2.   Data
    3.   None of these
    4.   Record
12. The memory wastage and update problems are generated in?
    1.   Data integrity
    2.   Data redundancy
    3.   Data integration
    4.   Data interdependence
13. The max number of characters in Text data type can be?
    1.   255 characters
    2.   257 characters
    3.   258 characters
    4.   256 characters
14. Which of the following data type is used to store photograph of person in database?
    1.   Text
    2.   Hyperlink
    3.   OLE
    4.   AutoNumber
15. The primary key button is located at?
    1.   Design view window
    2.   Tool bar
    3.   All of these
    4.   Title bar
16. To find all names starting with De, wild card used is?
    1.   De???
    2.   De###
    3.   De*
    4.   De!!!
17. Which of the following view allows us to enter raw data into table?
    1.   Design view
    2.   (Design + datasheet) views
    3.   Table view
    4.   Datasheet view
18. The contents of a filter can be saved as?
    1.   Macro
    2.   Table
    3.   Form
    4.   Query
19. The smallest unit of meaningful data stored in a record refers to?
    1.   Field
    2.   Bit
    3.   Byte
    4.   Record
20. The key which identifies the unique row or a record is called?
    1.   Secondary key
    2.   Foreign key
    3.   Composite key
    4.   Primary key
21. To store and retrieve data, MS-Access consists of various components called?
    1.   Entities
    2.   Properties
    3.   Objects
    4.   Tools
22. The current record in datasheet view is showed by?
    1.   Top arrow head
    2.   Left arrow head
    3.   Right arrow head
    4.   Down arrow head
23. Consider text memo format, < will display “PAKISTAN” into?
    1.   pakistan
    2.   PAKISTAN
    3.   Pakistan
    4.   PAkistan
24. To delete a record __ shortcut key is used?
    1.   Ctrl + -
    2.   Ctrl + D
    3.   None of these
    4.   Ctrl + delete
25. The queries are statements that?
    1.   Delete data
    2.   Extract data
    3.   Update data
    4.   All of these
26. Which of the following object of database will be used to update information of an employee from a table?
    1.   Form + query
    2.   None of these
    3.   Form
    4.   Query
27. In find and replace window, the criteria is entered in ___ text field?
    1.   Find
    2.   Replace
    3.   Replace all
    4.   Find what
28. Which of the following feature automatically corrects common spelling mistakes?
    1.   Auto Spell Correct
    2.   Auto Spell Checker
    3.   AutoCorrect feature
    4.   None of these
29. The output of the query is referred as?
    1.   Dynaset
    2.   Dataset
    3.   None of these
    4.   Query set
30. For Date/Time ___ number of bytes are used?
    1.   24 bytes
    2.   None of these
    3.   16 bytes
    4.   8 bytes
31. In database, the columns of table are also called?
    1.   Cells
    2.   None of these
    3.   Records
    4.   Fields
32. The crosstab queries are used to calculate?
    1.   Average
    2.   Sum
    3.   All of these
    4.   Count
33. The text you typed in description column in table design view is displayed on?
    1.   Title bar of MS Access while entering data
    2.   Description bar in forms
    3.   Report footer when printed
    4.   Status bar while entering data
34. Which of the following enables us to create relationship between different tables?
    1.   Repeating records
    2.   None of these
    3.   Repeating (records+fields)
    4.   Repeating fields
35. Which of the following view is used to design structure of a table in database?
    1.   Datasheet view
    2.   Design view
    3.   None of these
    4.   Table view
36. ___ wildcard is used for single digit?
    1.   !
    2.   ?
    3.   *
    4.   #
37. In database, a table must have?
    1.   Alternate key
    2.   Foreign key
    3.   Secondary key
    4.   Primary key
38. Which of the following data type is used to link database with website or another location of database?
    1.   Hyperlink
    2.   Direct link
    3.   Indirect link
    4.   Relation link
39. The operations like adding or deleting a new record can be performed in?
    1.   Design view
    2.   Table view
    3.   Design + datasheet views
    4.   Datasheet view
40. Which of the following helps in accessing query and sort records faster?
    1.   Index
    2.   Sort key
    3.   View
    4.   Primary key