Worksheetsдатабэйз 51-100
Total questions: 53
Worksheet time: 27mins
Name
Class
Date
1.
If the result is true when one expression evaluates to true and the other expression evaluates to false, what operator is being executed?
a)
Or
b)
Xor
c)
Not
d)
Like
e)
And
2.
If an operator negates the value of an expression, what operator is being executed?
a)
Not
b)
Like
c)
And
d)
Or
e)
Xor
3.
What function does the expression [Last Name] [First Name] perform?
a)
Combines two fields into one field
b)
assigns a number to a field
c)
splits two fields into two fields
d)
removes two fields
e)
Compares the fields [Last Name] and [First Name]
4.
What does the concept of attribute mean?
a)
Name of the table field
b)
Name of the record in the table
c)
A set of values associated with a field
d)
Mapping of field name to value set
e)
Table or database name
5.
What is a tuple?
a)
Table entry
b)
Name of the table field
c)
A set of values associated with a field
d)
Mapping of field name to value set
e)
Table or database name
6.
What do we mean by key:
a)
A field or list of fields used to identify records
b)
List of tuples for selecting the desired records
c)
Domains related to a specific value
d)
Attribute value that adds tables
e)
Sort the table
7.
What is an index?
a)
Efficient implementation and sorting of records
b)
Numbering and searching for entries by number
c)
Naming the fund
d)
Attribute value that adds tables
e)
Normalize the table
8.
The table in the database consists of . . .
a)
From field and writing
b)
From the form and report
c)
From field and column
d)
From table and query
e)
From the path and the writing
9.
What is "Record" used for?
a)
Used to output non-editable text, such as titles, comments, and signatures, to the scre
b)
Elements associated with a table field are automatically updated when a value is entered
c)
Saves the entered value without updating the table fields
d)
Expressions, such as functions and formulas, are built on top of each other and do not update the contents of table fields
e)
Allows you to enable or disable the control creation wizard
10.
What is "field" used for?
a)
Allows you to create an area for entering, displaying, or editing data
b)
Switches and toggles, which are sets of alternative values, allow you to create an area to place a set of flags.
c)
Used to create a flag associated with a logical fieldт 3
d)
Allows you to create a button associated with a logical field
e)
is used to create a button called a radio button
11.
What is the name of the attribute value that uniquely identifies tuples?
a)
Primary key
b)
Key
c)
Possible key
d)
Foreign key
e)
Internal key
12.
Synonym for the term "Record":
a)
Path, procession
b)
Table, column, row
c)
Column, field
d)
Table, relation
e)
Table, file
13.
Synonyms for the term "column":
a)
Attribute, field
b)
Path, procession
c)
Table, line
d)
Table, relation
e)
Table, file
14.
The record elements that make up a table column are called . . .
a)
field
b)
entry
c)
path
d)
column
e)
ring
15.
A key field is:
a)
Fields assigned to link tables
b)
is a field with unique values.
c)
field created for related tables
d)
is a field created to sort data
e)
text type field
16.
The main object of the database is
a)
table
b)
file
c)
field
d)
window
e)
all are correct
17.
In what mode is input recording performed?
a)
In table mode
b)
In designer mode
c)
Using the Table Wizard
d)
Using the wizard constructor
e)
In constructors and tables mode
18.
What types of relationships are there between tables?
a)
One - to one, one - to many, many - to one, many - to many
b)
One - mostly
c)
Many - one
d)
Most - mostly
e)
One - many, many - one, many - many
19.
The following data is prepared in tabular form:
a)
relational database
b)
hierarchical database
c)
site database
d)
disk DB
e)
database
20.
What do we call the field designated to link tables?
a)
key field
b)
unique field
c)
counter field
d)
property setting field
e)
there is no correct answer
21.
Attributes that are copies of keys from other relations are called:
a)
Foreign key.
b)
Key
c)
Primary key
d)
Maybe a key
e)
Table key.
22.
Synonymous with the term "Road".
a)
tuple, record
b)
tuple, relation
c)
domain, field
d)
domain, path
e)
table, domain
23.
Synonym of the term "Writing":
a)
string, tuple
b)
table, column, row
c)
column, field
d)
table, relation
e)
domain,table
24.
Synonym of the term "column":
a)
attribute, field
b)
ine, record
c)
table, column, row
d)
table, file
e)
domain, tuple
25.
What is data filtering used for?
a)
To select records from the database that satisfy some conditions
b)
To delete redundant entries
c)
To sort data in ascending order only
d)
To sort data in descending order only
e)
To add a new entry
26.
What is the purpose of a request in a database?
a)
The request is selected and for use with information in different forms.
b)
Request assigned to report
c)
Automates a specific operation in the MS without programming
d)
Assigned to create a form to fill out the request
e)
To output any data to tape, created accordingly
27.
A concept not used in the database:
a)
format
b)
post-relational model
c)
identifier
d)
field
e)
entry
28.
Macro:
a)
Creates automation of actions performed onobjects
b)
arranges all windows in a stack
c)
actions performed in response to modules, functions
d)
transaction, actions performed in response to instances
e)
actions to be performed in response to a form, table
29.
Serverless database management system
a)
Microsoft access
b)
Sybase
c)
DB2
d)
Oracle
e)
Microsoft SQL Server
30.
The following are not included in the tasks of a database management system:
a)
virus check
b)
allows you to define the structure of the database to be created, name it, and perform the initial data load.
c)
controls users' database usage
d)
organizes the use of a database by several users
e)
provides protection for the physical integrity of data
31.
Keyword-inappropriate comments:
a)
delete tables
b)
counter
c)
key attribute values not duplicated
d)
tuple arrangement
e)
linking tables
32.
Life cycle of an information system
a)
design, implementation, application
b)
repair
c) exploit
d)Create
e) registration
33.
Database management systems
a) SQLlite, SQL Server, MS Access
b) MS PowerPoint, Cache Man
c)MS Excel, Powertweak
d) Mathcad, Corel, Cahe man
e) FineReader, Prompt98, Qtrans, RAR
34.
Properties of a relational table
a) All elements in a table column are identical
b) Each element of the table is multiple data elements
c)Each element of the table is unique.
d) Each element of the table is just a counter
e) in the table column
35.
Hierarchical database model
a) a database in which data relationships are organized in the form of a graph
b) tabular database
c) data sorted from lowest to highest values
d) a database where each "generation" is linked to many "ancestors"
e) A database consisting of a collection of records and a collection of relationships
36.
In the model of the database, the relationship between data is represented in the form of an ordered graph
a) hierarchical model
b) object-oriented model
c) network model
d) each generation may have two or more ancestors
e) post-relational model
37.
Comments not related to the table:
a) topology
b)key
c) write
d) index
e) field
38.
Objects not used in the example:
a) file
b) logical operations symbols
c) arithmetic operation symbols
d) functions
e) combination of identifiers
39.
Disadvantages of the hierarchical model:
a) complexity of logical relationships
b) general storage of information
c) general use of information
d) allows you to build any connections
e) uses memory productively
40.
Type of relationships between tables:
a) many-to-many
b) relationship
c) conversion
d) equality
e) request
41.
Relational relationship design methods:
a) 1CF, 2CF, 3CF
b) client/server technology
c) related tables
d) 2H,GY3,HU6
e) Free graph of people's ancestry
42.
The usual relational operations proposed by Codd are:
a) difference and conflict
b) merge and selection
c) crossbreeding and selection
d) selection and projection
e) multiplication and addition
43.
The values that the logical expression accepts according to the arguments are:
a) True, false
b) only positive numbers
c) -1.1
d) -1,0,1
e) any integer
44.
Advantages of the network model:
a) allows you to build any connections
b) uses the relational database model
c) uses a hierarchical database model
d) security measures are ineffective
e) causes difficulties for the user to understand
45.
Disadvantages of the post-relational model:
a) table stores unrestored data
b) multi-valued fields are used
c) increases the efficiency of information processing
d) allows you to transform multiple linked relational tables into a single table
e) There is no limit to the length and number of fields in table entries.
46.
Comments regarding normal form:
a) removing transitive dependency – yields 3 normal forms
b) lead to full functional dependency – corresponds to 3 normal types
c) lead to full functional dependency – 1 normal type
d) If there is only one value at the intersection of each row and each column, then table 2 is in normal form.
e) removing transitive dependency yields -2 normal forms
47.
MSAccess database objects:
a) request
b) spreadsheet editor
c) text editor
d) buttons
e) files
48.
Keys are used for the following purposes:
a) tuple arrangement
b) domain setup
c) update tuples
d)Duplicate values in key attributes
e) delete tables
49.
Data types that work with dates and times in SQL:
a) datetime
b) money
c) float
d) varchar
e) smalllint
50.
Comments related to the data:
a) file server and client-server
b) cyclic and local consideration
c) file server and file client
d) modular – file and client-server
e) branched and local consideration
51.
Index...
a) Efficient implementation and sorting of records
b) Numbering and searching for entries by number
c) Naming the fund
d) Attribute value that adds tables
e) Normalize the table
52.
DROP TABLE…
a)deletesthe table
b)deletes the database
c)deletes the virtual table
d)deletes the index
e)deletes the trigger
53.
Database is …
a) An organized data collection designed for storing, managing, and searching
b)
information
c) File with text information
d) A program for working with tables
e) Project management system
100 %
