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. Data Structures and algorithms MCQ Questions
  67. Computer Communication and Networking Quiz
  68. Computer Graphics MCQ Quiz Questions and Answers
  69. Computer Basics Quiz Questions
  70. Computer Quiz Questions with Answers
  71. Computer Hardware MCQS Quiz
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!