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

Posted Date:-2021-02-19 08:23:23


Question:
 Microsoft Access is a

1.Rdbms

2.Oodbms

3.Ordbms

4.Network database model

Posted Date:-2021-02-19 08:23:23


Question:
 SQL stands for __________.

1.Standard Query Language

2.Structured Query Language

3. Simplified Query Language

4.Static Query Language

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

1.object

2.number

3.text

4.logical

Posted Date:-2021-02-19 08:23:23


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

1.table

2.DBMS

3.query

4.report

Posted Date:-2021-02-19 08:23:23


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

1.query

2.filter

3.form

4.report

Posted Date:-2021-02-19 08:23:23


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

1.Forms

2.Reports

3.Queries

4.Tables

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

1.scalable

2.robust

3.platform independent

4.distributed

Posted Date:-2021-02-19 08:23:23


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

1.check mark

2.pencil

3.asterisk

4.arrow

Posted Date:-2021-02-19 08:23:23


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

1.icon

2.button

3.thumb tack

4.paperclip

Posted Date:-2021-02-19 08:23:23


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

1.enterprise

2.distributed

3.tier

4.global

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


Question:
Following is not a database model

1.Network database model

2.Relational database model

3.Object oriented database model

4.None

Posted Date:-2021-02-19 08:23:23


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

1.Tuple

2. Field

3.Record

4. All of above

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


Question:
It is an association established between common

1.Line

2.Relationship

3.Primary key

4.Records

Posted Date:-2021-02-19 08:23:23


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.

Posted Date:-2021-02-19 08:23:23


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

1.crawler

2.query

3.enterprise

4.sitebuilder

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


Question:
The most open source DBMS.

1.Microsoft SQL Server

2.Microsoft Access

3.MySQL

4.Oracle

Posted Date:-2021-02-19 08:23:23


Question:
The most popular commercial DBMS.

1.Microsoft SQL Server

2.Microsoft Access

3.MySQL

4.Oracle

Posted Date:-2021-02-19 08:23:23


Question:
The __________ performs document tracking.

1.distributed application

2.enterprise software

3.Oracle software

4.EDM software

Posted Date:-2021-02-19 08:23:23


Question:
This database has only one table.

1.relational

2.large

3.flat-file

4.DBMS

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

1.form

2.report

3.query

4.macro

Posted Date:-2021-02-19 08:23:23


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

1.BLOB

2.text

3.image

4.logical

Posted Date:-2021-02-19 08:23:23


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

1.Rows

2.Records

3.Fields

4.Columns

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

1.120

2.255

3.165

4.75

Posted Date:-2021-02-19 08:23:23


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

1.Office button

2. Home command tab

3.Status bar

4.Quick Access toolbar

Posted Date:-2021-02-19 08:23:23


Question:
Which of the field has width 8 bytes?

1.Memo

2.Number

3.Date/time

4.Hyperlink

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


Question:
Which of the following database object hold data?

1.Forms

2.Reports

3.Queries

4.Tables

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

1.Tables

2.Queries

3.Relationships

4.Reports

Posted Date:-2021-02-19 08:23:23


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

1.Table

2.Form

3.Worksheets

4.Modules

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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

1.Forms

2.Reports

3.Queries

4.Tables

Posted Date:-2021-02-19 08:23:23


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

1.Forms

2.Reports

3.Tables

4.Queries

Posted Date:-2021-02-19 08:23:23


Question:
_______ is the clear leader for personal databases.

1.Microsoft Access

2.Microsoft FoxPro

3.Borland dBase

4.MySQL

Posted Date:-2021-02-19 08:23:23


Question:
________ is used to build ‘intuitive’ queries

1.SQL

2.Xbase

3.QBE

4.XML

Posted Date:-2021-02-19 08:23:23


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

Posted Date:-2021-02-19 08:23:23


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
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!