A data dictionary is a repository that manages _____
1.Memory
2.Metadata
3.Spell Checker
4.Data Validator
Posted Date:-2021-12-06 07:38:51
In a database Table, the each category of information Is called __________
1.Tuple
2.Field
3.Record
4.all of these
Posted Date:-2021-12-06 07:29:35
In one-to-many relationship the table in 'one' side is called _______
1.Child
2.Owner
3.Parent
4.Owner
Posted Date:-2021-12-06 07:20:22
It is used to establish an association between related tables.
1.Line
2.Relationship
3.Primary Key
4.Records
Posted Date:-2021-12-06 07:24:23
Which of the following fields has width of 8 bytes?
1.Memo
2.Number
3..Date/time
4.Hyperlink
Posted Date:-2021-12-06 07:30:40
which of the following is not a database object?
1.Tables
2.Queries
3.Relationships
4.Reports
Posted Date:-2021-12-06 07:34:27
Duplication of data is called _________
1.Inconsistency
2.Consistency
3.Redundancy
4.Foreign Key
Posted Date:-2021-12-06 08:12:43
A command that lets you change one or more fields in a record is
1.Insert
2.Modify
3.Look up
4.All the above
Posted Date:-2021-12-05 13:16:09
A database is an organized collection of _______________.
1.data
2.Attributes
3.Record
4.none of the above
Posted Date:-2021-12-06 08:05:12
A field that uniquely identifies a record is called a
1.Main field
2.Header
3.Key field
4.None of the above
Posted Date:-2021-12-05 14:02:46
A subset of characters within a data field is known as
1.Record
2.File
3.Data string
4.Byte
Posted Date:-2021-12-05 13:57:19
Auto Report allows you to
1.View a subset of your data
2.Create a simple report
3.Create a data entry form
4.Enter records
Posted Date:-2021-12-05 14:11:54
DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer
1.Database management approach
2.Database administrator
3.DBBMS uses
4.Query language
Posted Date:-2021-12-05 13:56:04
Examples of centralized multi-user databases are
1.Barclays’ Bank customer accounts
2.Supermarket stock control, organ donor database, client database
3. Airline reservations and other national global booking systems
4.None of the above
Posted Date:-2021-12-05 13:18:43
GUI act as front end and database server act as _____
1.Container
2.Back End
3.End
4.none of the above
Posted Date:-2021-12-06 08:11:42
If you are entering data in a form, a quick way to copy a value from the previous record is to press
1.Ctrl+’
2.F6
3.Ctrl+D
4.None of the above
Posted Date:-2021-12-05 13:11:45
In a large DBMS
1.each user can “see†only a small part of the entire database
2.each user can access every subschema
3.each subschema contains every field in the logical schema
4.none of the above is true
Posted Date:-2021-12-05 13:09:45
In a relational schema, each tuple is divided into fields called
1.Relations
2.Domains
3.Queries
4. All of the above
Posted Date:-2021-12-05 13:59:16
In one-to-many relationship the table on 'many' side is called _______
1.Parent
2.Child
3.Sister
4.Master
Posted Date:-2021-12-06 07:14:49
In which state one gathers and list all the necessary fields for the database design project.
1.Data Definition
2.Data Refinement
3.Establishing Relationship
4.None Of The Above
Posted Date:-2021-12-06 07:15:56
It examines a small portion or sample of your data in a report before printing it.
1.Datasheet view
2.Design view
3.Print preview
4.Layout preview
Posted Date:-2021-12-05 13:20:05
Records are deleted using
1.DELETE command followed by pack
2.DELETE command without pack
3.DELETE command followed by zap
4.DELETE command without zap
Posted Date:-2021-12-05 14:10:58
The arranging of data in a logical sequence is called
1.Sorting
2.summarizing
3.summarizing
4.summarizing
Posted Date:-2021-12-05 14:09:16
The following command is used for inserting records
1.INSERT
2.ADD
3.Both of the above
4.None of the above
Posted Date:-2021-12-05 13:10:33
The overall description of a database is called______.
1.Data integrity
2.Data manipulation
3.Database schema
4.Data definition
Posted Date:-2021-12-06 07:37:49
The purpose of the Add-in Manager is to
1.Create macros and automate data processing
2.Add or remove data in an existing database
3.Add or remove templates, macros, and wizards
4.All the above
Posted Date:-2021-12-05 13:17:41
The third stage of designing a database is when we create___________ between tables
1.Relationship
2.Join
3.Query
4.None of These
Posted Date:-2021-12-06 07:27:05
This key that uniquely identifies each record is called :
1.Primary Key
2.Key Record
3.Unique Key
4.Field Name
Posted Date:-2021-12-06 07:25:18
Two tables can be linked with relationship to _____
1..Ensure data entry
2..Ensure data integrity
3..Create Primary Key
4..Ensure Foreign Key
Posted Date:-2021-12-06 07:28:09
Users who store data about real people for marketing purposes must register the data and its potential use with
1.The computer misuse controller
2.The data protection controller
3.HM customs and excise
4.None of the above
Posted Date:-2021-12-05 13:16:53
What are the columns in a Microsoft Access table called?
1.Rows
2.Fields
3.cells
4.Records
Posted Date:-2021-12-05 13:14:15
What are the different view to present a Table ?
1.Datasheet View
2.Design View
3.Pivote TableView
4.All Of Above
Posted Date:-2021-12-06 07:13:50
What do you mean by one to many relationship between Teacher and Class table?
1.One class may have many teachers
2.One teacher can have many classes
3.Many classes may have many teachers
4.Many teachers may have many classes
Posted Date:-2021-12-06 07:12:39
What is a fast way to adjust the width of a column?
1.Right click the left side of the column heading
2.Double click the left side of the column heading
3.Double click the right side of the column heading
4.Select tools>adjust column width from the menu
Posted Date:-2021-12-05 13:08:34
When you save an Access project, what file format do you use?
1.adp
2.xm
3.mdb
4.All of above
Posted Date:-2021-12-05 13:15:02
Which data type allows alphanumeric characters and special symbols to be entered?
1.Text
2.Memo
3.Auto number
4.Mixed
Posted Date:-2021-12-06 07:23:09
Which database object is ideal to view, change, andanalyze datain different ways ?
1.Table
2.Form
3.Query
4.Report
Posted Date:-2021-12-06 07:18:39
Which field allow to select items from drop down list?
1.An OLE field
2.An OLE field
3.A lookup Field
4.A hyperlink field
Posted Date:-2021-12-05 13:53:54
Which name must be unique within a database ? A.. C..
1.Table
2.Field
3.Record
4.Character
Posted Date:-2021-12-06 07:26:08
Which of the following enables us to view data from a table based on a specific criterion
1.Form
2.Query
3.Macro
4.Report
Posted Date:-2021-12-06 07:17:07
Which of the following field of table “Book†can act as primary key?
1.Book_number
2.Subject
3.price
4.Author_name
Posted Date:-2021-12-06 08:16:32
Which of the following is not a database model
1.Network Database Model
2.Relational Database Model
3.Object Oriented Database Model
4.None
Posted Date:-2021-12-06 07:36:37
Which of the following is not a database programs?
1.MySQL
2.Oracle
3.Writer
4.OObase
Posted Date:-2021-12-06 08:06:55
Which of the following is NOT a type of Microsoft Access database object?
1.Queries
2.Workbooks
3.Forms
4.Tables
Posted Date:-2021-12-05 13:13:08
Which of the following is not the advantage of database?
1. Sharing of Data
2. Reduce Data Redundancy
3.. Increase Data Inconsistency
4.Data Security
Posted Date:-2021-12-06 08:13:28
Which of the following software is appropriate to store data about school students?
1.MS-Access
2.Writer
3.Calc
4.Impress
Posted Date:-2021-12-06 08:06:06
Which of the following will help to maintain unique record in the table?
1.Foreign Key
2.Primary Key
3.Composite Key
4.Alternate Key
Posted Date:-2021-12-06 08:15:34
Which one is the guideline of Referential integrity in a relationship ?
1.Do not enter a value in the primary key field of chield table if that value does not exist inthe primary key of the parent table
2.Do not enter a value in the foreign key field of a parent table if that value doesnot exist in the primary key of the child table
3.Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
4.Do not enter a value in the foreign key field of child table if that value does not exist inthe foreign key of the parent table
Posted Date:-2021-12-06 07:35:35
________ are dedicated computers that hold the actual databases and run only DBMS and related Software.
1.Main Server
2.Web Server
3.Database Server
4.Non Database Server
Posted Date:-2021-12-06 08:10:36
________ store data in Single table.
1.Flat File
2.Relational
3.Single File
4.One File
Posted Date:-2021-12-06 08:07:56