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
Microsoft Access is a
1.Rdbms
2.Oodbms
3.Ordbms
4.Network database model
Posted Date:-2021-02-19 08:23:23
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
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
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
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
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
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
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
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
_______ are documents that when filled in create records.
1.Forms
2.Reports
3.Tables
4.Queries
Posted Date:-2021-02-19 08:23:23
_______ 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
________ is used to build ‘intuitive’ queries
1.SQL
2.Xbase
3.QBE
4.XML
Posted Date:-2021-02-19 08:23:23
_________ 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
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
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
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
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
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
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
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
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
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
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
It is an association established between common
1.Line
2.Relationship
3.Primary key
4.Records
Posted Date:-2021-02-19 08:23:23
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
The __________ performs document tracking.
1.distributed application
2.enterprise software
3.Oracle software
4.EDM software
Posted Date:-2021-02-19 08:23:23
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
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
The most open source DBMS.
1.Microsoft SQL Server
2.Microsoft Access
3.MySQL
4.Oracle
Posted Date:-2021-02-19 08:23:23
The most popular commercial DBMS.
1.Microsoft SQL Server
2.Microsoft Access
3.MySQL
4.Oracle
Posted Date:-2021-02-19 08:23:23
This database has only one table.
1.relational
2.large
3.flat-file
4.DBMS
Posted Date:-2021-02-19 08:23:23
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
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
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
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
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
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
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
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
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
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
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
Which of the following database object hold data?
1.Forms
2.Reports
3.Queries
4.Tables
Posted Date:-2021-02-19 08:23:23
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
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
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
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
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