Duplication of data or the storing of the same data in more than one place Integ
ID: 3707622 • Letter: D
Question
Duplication of data or the storing of the same data in more than one place
Integrity B. Security C. Redundancy D. Attribute
Ans c
Structure that can store information about different categories of information and relationships between those categories of information
Non-Database B. Database C. Database Design D. Entity/Table
Ans b
Person, place, object, event or idea for which you want to store and process data.
Entity B. Database C. Spreadsheet D. Attribute
Ans a
Characteristic or property of an entity, may also be called a field or column
Integrity B. Security C. Attribute D. Entity
Ans c
File used to store data, Computer counterpart to ordinary paper file
Table B. Form C. Data File D. Report
Ans c
Visual way to represent a database
Data independence B. Forms C. Entity-relationship (E-R) diagram D. Reports
Ans c
Program, or collection of programs, through which users interact with a database
DBMS B. Data File C. Spread Sheet D. Forms
Ans A
Column or collection of columns of a table (relation) that uniquely identifies a given row in that table
Foreign Key B. Column Name C. Primary Key D. Record
Ans c
Question represented in a way the DBMS can recognize and process
Form B. Report C. Relationship D. Query
Ans D
Each individual criterion must be true in order for the compound criterion to be true
AND B. OR C. Group D. Aggregate
Ans A
Finding the values in a particular field on all the records; each calculation involves groups of records
Crosstab Query B. Text Data C. Aggregate function D. Group calculation
Ans D
A query that prompts for input whenever it is used.
Cross Tab Query B. Parameter Query C. Sub Query D. Function
ANS b
A condition that involves only a single field and a single value
reserved word B. simple condition C. HAVING clause D. compound
ANS B
An instruction by a user that directs a database to perform a certain action
The part of an SQL SELECT command that indicates grouping
GROUP BY clause B. FROM clause C. ORDER BY clause D. HAVING clause
The part of an SQL SELECT command that indicates a sort order
GROUP BY clause B. FROM clause C. ORDER BY clause D. HAVING clause
Two simple criteria in a query that are combines with the AND or OR operators
FROM clause B. Simple condition C. Compound condition D. HAVING clause
The first sort field
Major/Primary Sort key B. QBE (Query-by-Example)
C. Minor/Secondary Sort key D. Design Grid
Similar to the natural join except that it also includes records from each original table that are not common in both tables.
Natural Join B. Outer Join C. Join operation D. Join line
Includes operations that act on existing tables to produce new tables, similar to the way the operations of addition and subtraction act on numbers to produce new numbers in the mathematical algebra with which you are familiar.
SELECT command B. Relational Algebra C. Relational Database
D. Function
Language that is used to manipulate relational databases
SQL B. Programs C. Forms D. Reports
Command to describe table layout to the DBMS, which creates the table
SELECT B. UPDATE C. CREATE D. DELETE
Application program’s or individual user’s picture of the database
Query B. Image C. Report D. View
Record numbers automatically assigned and used by DBMS to increase data retrieval efficiency
Row B. View C. Index D. Field
No field that is part of primary key may accept null values
Entity Integrity B. Referential Integrity C. Primary Key D. Foreign key
Foreign key field(s) whose value is required to match the value of the primary key for a second table
Entity Integrity B. Referential Integrity C. Primary Key D. Foreign key
No record can exist with a value in the field other than one of the legal values
Entity Integrity B. Legal value Integrity C. Primary Key D. Foreign key
A computer that is connect to a network and has access through the server to the database.
Server B. Index C. Client D. Documenter
An index with more than one key field.
Arguments B. Row-and-Column Subset View C. Multiple-field(column) Index D. Documenter
SQL command that changes table’s structure
SELECT B. UPDATE C. CREATE D. ALTER
SQL command for deleting the table.
SELECT B. DROP C. DELETE D. ALTER
Contains information about tables in the database
Systables B. Syscolumns C. System catalog D. Sysindexes
Special file used to store a query that is run often and is placed on the server
Systables B. stored procedure C. System catalog D. Sysindexes
A column in a table that determines at least one other column
Alternate Key B. Interrelation Constraint C. Nonkey Column
D. Determinant
A dependency of a column on only a portion of the primary key
Partial Dependency B. Dependency Diagram C. Nonkey Attribute
D. Functional Dependence
In a table with columns A, B, and C, B is multi-dependent on A if each value for A is associated with a specific collection of values for B and, further, this collection is independent of any values for C
Multidetermine B. Multidependent C. Multivalued Dependence
D. Candidate key
A candidate key that was not chosen to be the primary key
Nonkey Column B. Nonkey Attribute C. Candidate Key D. Alternate Key
More than one entry at a single location in a table
Repeating Group B. Dependency Diagram C. Alternate Key
D. Candidate Key
The process of removing repeating groups to produce a first normal form table. Sometimes refers to the process of creating a third normal form table
Normalization Process B. Functional Dependence C. Primary Key
D. Dependency Diagram
The combination of two or more rows in an operation, such as join, or the combination of two or more columns for a primary key field to uniquely identify a given row in the table
Multidetermine B. Normalization C. Concatenation D. Candidate key
A relation (table) that contains a repeating group (or multiple entries for a single record)
1NF B. 2NF C. 3NF D. Unnormalized relation
In MS Access, Text Data type may contain maximum character of
255 Character B. 256 Character C. 1064 Character D. No Limit
Which of the following is not a valid Data Type in MS Access?
Memo B. Picture C. Currency D. Autonumber
In MS Access “Hyperlink” Data Type can store
Web address B. Email address C. Path of a file D. All the above
Which of the following data type is used to store logical value in MS Access?
True/ False B. Yes/No C. On/Off D. All the above
The appropriate Data Type to store Time in MS Access?
Date/Time B. Date C. Time D. Time cannot be stored
In MS Access “Lookup Wizard” is used to
To select from previous values B. To select values from Excel Sheet
C. To select value from another table D. Not a valid Data Type
In MS Access, AutoNumber Data Type can be
Random B. Sequential C. Edited D. Both A and B
Which object is used to create a form?
Tables and queries B. Tables only C. Tables and Reports D. Queries and reports
What is an intersection of a row and a column?
Form B. Cursor C. Cell D. Record
Explanation / Answer
Duplication of data or the storing of the same data in more than one place
C. Redundancy
Structure that can store information about different categories of information and relationships between those categories of information
B. Database
Person, place, object, event or idea for which you want to store and process data.
A.Entity
Characteristic or property of an entity, may also be called a field or column
C. Attribute
File used to store data, Computer counterpart to ordinary paper file
C. Data File
Visual way to represent a database
C. Entity-relationship (E-R) diagram
Program, or collection of programs, through which users interact with a database
A.DBMS
Column or collection of columns of a table (relation) that uniquely identifies a given row in that table
C. Primary Key
Question represented in a way the DBMS can recognize and process
D. Query
Each individual criterion must be true in order for the compound criterion to be true
A. AND
Finding the values in a particular field on all the records; each calculation involves groups of records
D. Group calculation
A query that prompts for input whenever it is used.
B. Parameter Query
A condition that involves only a single field and a single value
B. simple condition
An instruction by a user that directs a database to perform a certain action
Function
The part of an SQL SELECT command that indicates grouping
A. GROUP BY clause
The part of an SQL SELECT command that indicates a sort order
C. ORDER BY clause
Two simple criteria in a query that are combines with the AND or OR operators
C. Compound condition
The first sort field
A. Major/Primary Sort key
Similar to the natural join except that it also includes records from each original table that are not common in both tables.
B. Outer Join
Includes operations that act on existing tables to produce new tables, similar to the way the operations of addition and subtraction act on numbers to produce new numbers in the mathematical algebra with which you are familiar.
B. Relational Algebra
Language that is used to manipulate relational databases
A.SQL
Command to describe table layout to the DBMS, which creates the table
C. CREATE
Application program’s or individual user’s picture of the database
D. View
Record numbers automatically assigned and used by DBMS to increase data retrieval efficiency
C. Index
No field that is part of primary key may accept null values
A.Entity Integrity
Foreign key field(s) whose value is required to match the value of the primary key for a second table
B. Referential Integrity
No record can exist with a value in the field other than one of the legal values
B. Legal value Integrity
A computer that is connect to a network and has access through the server to the database.
C. Client
An index with more than one key field.
C. Multiple-field(column) Index
SQL command that changes table’s structure
D. ALTER
SQL command for deleting the table.
C. DELETE
Contains information about tables in the database
A.Systables
Special file used to store a query that is run often and is placed on the server
B. stored procedure
A column in a table that determines at least one other column
D. Determinant
A dependency of a column on only a portion of the primary key
A.Partial Dependency
In a table with columns A, B, and C, B is multi-dependent on A if each value for A is associated with a specific collection of values for B and, further, this collection is independent of any values for C
C. Multivalued Dependence
A candidate key that was not chosen to be the primary key
C. Candidate Key
More than one entry at a single location in a table
A.Repeating Group
The process of removing repeating groups to produce a first normal form table. Sometimes refers to the process of creating a third normal form table
A.Normalization Process
The combination of two or more rows in an operation, such as join, or the combination of two or more columns for a primary key field to uniquely identify a given row in the table
C. Concatenation
A relation (table) that contains a repeating group (or multiple entries for a single record)
D. Unnormalized relation
In MS Access, Text Data type may contain maximum character of
255 Character
Which of the following is not a valid Data Type in MS Access?
B. Picture
In MS Access “Hyperlink” Data Type can store
A. Web address
Which of the following data type is used to store logical value in MS Access?
B. Yes/No
The appropriate Data Type to store Time in MS Access?
A.Date/Time
In MS Access “Lookup Wizard” is used to
C. To select value from another table
In MS Access, AutoNumber Data Type can be
D. Both A and B
Which object is used to create a form?
A.Tables and queries
What is an intersection of a row and a column?
C. Cell
Do ask if any doubt. Please upvote.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.