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