Computer/MS Access MCQ Questions Part 7 Sample Test,Sample questions

Question:
 A __________ enables you to view data from a table based on a specific criterion

1.Form

2.Query

3.Macro

4.Reports


Question:
 Microsoft Access is a

1.Rdbms

2.Oodbms

3.Ordbms

4.Network database model


Question:
 SQL stands for __________.

1.Standard Query Language

2.Structured Query Language

3. Simplified Query Language

4.Static Query Language


Question:
 The ability of a database to grow as the data tracking needs grow is its __________.

1.scalability

2.expandability

3.maintainability

4.platform-independence


Question:
 The database language that allows you to access or maintain data in a database

1.Dcl

2.Dml

3.Ddl

4.None of above


Question:
 The __________ field is used to hold a yes or no answer.

1.object

2.number

3.text

4.logical


Question:
 The __________ is the software tool to store or access data.

1.table

2.DBMS

3.query

4.report


Question:
 The __________ is used to access one record at a time.

1.query

2.filter

3.form

4.report


Question:
 Which of the following database object produces the final result to present?

1.Forms

2.Reports

3.Queries

4.Tables


Question:
 Which of the following methods CANNOT be used to delete records from a table?

1.Selecting records and pressing [Delete]

2.Pressing [Ctrl]+[’]

3.Clicking the Delete Record button

4.From the ribbon selecting Delete Record


Question:
A DBMS that runs on many different operating systems is said to be __________.

1.scalable

2.robust

3.platform independent

4.distributed


Question:
A(n) ____ in the Record Selector indicates a new record.

1.check mark

2.pencil

3.asterisk

4.arrow


Question:
All attachment fields display as a(n) ____ in Datasheet View.

1.icon

2.button

3.thumb tack

4.paperclip


Question:
An application that executes on separate PCs like this is called a(n) __________ application.

1.enterprise

2.distributed

3.tier

4.global


Question:
An enterprise solution with data storage a client interface and a security system is a(n) __________ system.

1.2-tier

2.3-tier

3.4-tier

4.n-tier


Question:
Dcl provides commands to perform actions like

1.Change the structure of tables

2.Insert update or delete records and data values

3.Authorizing access and other control over database

4.None of above


Question:
Following is not a database model

1.Network database model

2.Relational database model

3.Object oriented database model

4.None


Question:
In a database table the category of information is called __________

1.Tuple

2. Field

3.Record

4. All of above


Question:
In table design view which key can be used to switch between the field names and properties panels?

1.F3

2.F4

3.F5

4.F6


Question:
It is an association established between common

1.Line

2.Relationship

3.Primary key

4.Records


Question:
 Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?

1.Press Ctrl+C and Ctrl+V

2.Right-click choose from the shortcut menu Copy and Paste.

3.Press [Ctrl]+[+] and [Ctrl]+[-].

4.From the ribbon select Copy and Paste.


Question:
Search engines use a(n) __________ to automatically index sites.

1.crawler

2.query

3.enterprise

4.sitebuilder


Question:
The command center of access file that appears when you create or open the MS Access database file.

1.Database window

2.Query window

3.Design view window

4. Switchboard


Question:
The default and maximum size of text field in access

1.50 and 255 characters

2.8 and 1 gb

3.266 characters & 64000 characters

4.None of above


Question:
The most open source DBMS.

1.Microsoft SQL Server

2.Microsoft Access

3.MySQL

4.Oracle


Question:
The most popular commercial DBMS.

1.Microsoft SQL Server

2.Microsoft Access

3.MySQL

4.Oracle


Question:
The __________ performs document tracking.

1.distributed application

2.enterprise software

3.Oracle software

4.EDM software


Question:
This database has only one table.

1.relational

2.large

3.flat-file

4.DBMS


Question:
This is the stage in database design where one gathers and list all the necessary fields for the database project.

1.Data definition

2.Data refinement

3.Establishing relationship

4.None of the above


Question:
To delete records or perform calculations on a table the best tool to use is a __________.

1.query

2.filter

3.form

4.report


Question:
To print information from a table the __________ tool is the best choice.

1.form

2.report

3.query

4.macro


Question:
To store your picture in a database requires a(n) __________ field.

1.BLOB

2.text

3.image

4.logical


Question:
What are the columns in a Microsoft Access table called?

1.Rows

2.Records

3.Fields

4.Columns


Question:
What are the different views to display a table

1.Datasheet view

2. Design view

3.Pivote table & pivot chart view

4.All of above


Question:
What is the difference between ‘open’ and ‘open exclusively’

1.Open statement opens access database files and open exclusively opens database files of other program like oracle

2.Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed

3.Both open and open exclusively are same

4. Open exclusive command does not exist in MS Access


Question:
What is the maximum length a text field can be?

1.120

2.255

3.165

4.75


Question:
Where can you find the undo command in Access?

1.Office button

2. Home command tab

3.Status bar

4.Quick Access toolbar


Question:
Which of the field has width 8 bytes?

1.Memo

2.Number

3.Date/time

4.Hyperlink


Question:
Which of the following creates a drop down list of values to choose from?

1.Ole object

2.Hyperlink

3.Memo

4.Lookup wizard


Question:
Which of the following database object hold data?

1.Forms

2.Reports

3.Queries

4.Tables


Question:
Which of the following is a method to create a new table in MS Access?

1.Create table in design view

2. Create table using wizard

3.Create table by entering data

4.All of above


Question:
which of the following is not a database object?

1.Tables

2.Queries

3.Relationships

4.Reports


Question:
Which of the following is not a type of Microsoft Access database object?

1.Table

2.Form

3.Worksheets

4.Modules


Question:
Which of the following statement is true?

1.Foreign key fields don’t allow duplicate values

2. In primary key field you can enter duplicate value

3. In an indexed field you may or may not enter duplicate value depending upon setting

4.All statements are true


Question:
Which of the following store command to retrieve data from database?

1.Forms

2.Reports

3.Queries

4.Tables


Question:
_______ are documents that when filled in create records.

1.Forms

2.Reports

3.Tables

4.Queries


Question:
_______ is the clear leader for personal databases.

1.Microsoft Access

2.Microsoft FoxPro

3.Borland dBase

4.MySQL


Question:
________ is used to build ‘intuitive’ queries

1.SQL

2.Xbase

3.QBE

4.XML


Question:
_________ will answer questions you did not think to ask of your data.

1.data mining

2.data extrapolation

3.knowledge discovery

4.data enlightenment


More MCQS

  1. Computer fundamentals
  2. Computer Basic MCQS
  3. CCC MCQ Sample Paper 1
  4. CCC Exams MCQS Sample Paper Test 2
  5. Computer Basics MCQS Paper 1
  6. Computer Basics MCQS Paper 2
  7. FUNDAMENTALS OF COMPUTERS MCQs PART 2
  8. FUNDAMENTALS OF COMPUTERS MCQs PART 1
  9. FUNDAMENTALS OF COMPUTERS MCQs PART 3
  10. Computer mcqs smaple paper 1
  11. Computer mcqs smaple paper 2
  12. Computer mcqs smaple paper 3
  13. Fundamentals of Computers
  14. Fundamentals of Computers (New) Part 1
  15. Fundamentals of Computers (New) Part 2
  16. Computer Networks MCQ Questions
  17. Computer Networks Transition from IPV4 to IPV6
  18. Computer Fundamentals (New) Part 1
  19. Computer Fundamentals (New) Part 2
  20. Computer Fundamentals (New) Part 3
  21. Computer Fundamentals (New) Part 4
  22. Computer Fundamentals (New) Part 5
  23. Computer Fundamentals (New) Part 6
  24. Computer Fundamentals (New) Part 7
  25. Computer Fundamentals (New) Part 8
  26. Operating Systems MCQs Part 1
  27. Operating Systems MCQs Part 2
  28. OS(Computer Operating Systems) Part 1
  29. OS(Computer Operating Systems) Part 2
  30. OS(Computer Operating Systems) Part 3
  31. OS(Computer Operating Systems) Part 4
  32. OS - Computer Operating Systems Part 5
  33. OS - Computer Operating Systems Part 6
  34. OS - Computer Operating Systems Part 7
  35. MS Word MCQ Questions Part 1
  36. MS Word MCQ Questions Part 2
  37. MS Word MCQ Questions Part 3
  38. MS Word MCQ Questions Part 4
  39. MS Word MCQ Questions Part 5
  40. MS Word MCQ Questions Part 7
  41. MS Word MCQ Questions Part 6
  42. Microsoft Excel MCQ Questions Part 1
  43. Microsoft Excel MCQ Questions Part 2
  44. Microsoft Excel MCQ Questions Part 3
  45. Microsoft Excel MCQ Questions Part 4
  46. Microsoft Excel MCQ Questions Part 5
  47. Microsoft Excel MCQ Questions Part 6
  48. Microsoft Excel MCQ Questions Part 7
  49. MS PowerPoint MCQ Questions PART 1
  50. MS PowerPoint MCQ Questions PART 2
  51. MS PowerPoint MCQ Questions PART 3
  52. MS PowerPoint MCQ Questions PART 4
  53. MS PowerPoint MCQ Questions PART 5
  54. MS PowerPoint MCQ Questions PART 6
  55. MS PowerPoint MCQ Questions PART 7
  56. MS Access MCQ Questions Part 1
  57. MS Access MCQ Questions Part 2
  58. MS Access MCQ Questions Part 3
  59. MS Access MCQ Questions Part 4
  60. MS Access MCQ Questions Part 5
  61. MS Access MCQ Questions Part 6
  62. MS Access MCQ Questions Part 7
  63. MS Access MCQ Questions Part 8
  64. Query of MS Access MCQS Part 1
  65. Query of MS Access MCQS Part 2
  66. Computer Communication and Networking Quiz
  67. Computer Graphics MCQ Quiz Questions and Answers
  68. Computer Basics Quiz Questions
  69. Computer Quiz Questions with Answers
  70. Computer Hardware MCQS Quiz
  71. MCQ Computer Organization & Architecture
  72. MCQ Computer Organisation - Input & output Organisation SET1
  73. MCQ Computer Organisation - Input & output Organisation SET2
  74. MCQ Computer Organisation - Input & output Organisation SET3
  75. MCQS on addressing modes SET 1
  76. MCQS on addressing modes SET 2
  77. Software Engineering MCQs SET 1
  78. Software Engineering MCQs SET 2
  79. Software Engineering MCQs Set 3
  80. Software Engineering MCQs Set 4
  81. Software Engineering MCQs Set 5
  82. Software Engineering MCQs Set 6
  83. Software Engineering MCQs Set 7
  84. mcqs data structures
  85. CCC Exam Sample MCQ Paper
  86. Computer MCQ Questions set-1
  87. Computer MCQ Questions set-2
  88. Computer MCQ Questions set-3
  89. Current affairs mcq Database management
  90. Programming arcitecture
  91. Computer Graphics MCQ Questions part 1
  92. Computer Graphics MCQ Questions part 2
  93. Computer Awareness MCQs and Quiz for Banking, IBPS, RRB, RBI, SBI Exams pART 1
  94. Computer Awareness MCQs and Quiz for Banking, IBPS, RRB, RBI, SBI Exams pART 2
  95. Computer Science MCQs
  96. Computer Mcq Question
  97. MCQs based on Fundamentals of Computer 1 set
  98. Computer Mcq Question set 2
  99. MCQ Encoding Schemes
  100. Data Entry and Keyboarding Skills MCQ
  101. Computer Science Number System
  102. Computer Network MCQ
  103. MCQ Questions on Tally
  104. MCQ Questions on Tally Set 2
  105. MCQ Questions on Tally Set 3
  106. MCQ Questions on Tally Set 4
  107. Internet Technology MCQ Questions for Competitive Exams
  108. Computer Software MCQ GK Questions
  109. Computer Organization and Architecture MCQs
  110. Basic Computer GK Questions
  111. Computer Graphics MCQ Set 1
  112. Operating System MCQ Set 1
  113. Operating System MCQ Set 2
  114. Operating System MCQ Set 3
  115. Operating System MCQ Set 4
  116. Operating System MCQ Set 5
  117. Operating System MCQ Set 6
  118. Operating System MCQ Set 7
  119. Operating System MCQ Set 8
  120. Operating System MCQ Set 9
  121. Operating System MCQ Set 10
  122. Operating System MCQ Set 11
  123. Operating System MCQ Set 12
  124. Operating System MCQ Set 13
  125. Operating System MCQ Set 14
  126. Operating System MCQ Set 15
  127. Operating System MCQ Set 16
  128. Operating System MCQ Set 17
  129. Operating System MCQ Set 18
  130. Operating System MCQ Set 19
  131. Operating System MCQ Set 20
  132. Operating System MCQ Set 21
  133. Computer Graphics MCQ Question Set 1
  134. Computer Networks MCQs
  135. Computer Networks MCQs Set-2
  136. Computer Networks MCQs Set-3
  137. Computer Networks MCQs Set-4
  138. Bachelor of Computer Applications MCQs set-1
  139. Bachelor of Computer Applications MCQs set-2
  140. NET Programming MCQ
  141. Artificial Intelligence and Robotics (AIR) Set 1
  142. Artificial Intelligence and Robotics (AIR) Set 2
  143. Computer Engineering Soft Computing Set 1
  144. Computer Engineering Soft Computing Set 2
  145. COMPUTERS AND IT MCQs QUESTIONS
  146. Ancient Indian History MCQ
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!