Database Basics Workshop Overview
Uploaded by
ScribdTranslationsDatabase Basics Workshop Overview
Uploaded by
ScribdTranslationsWORKSHOP No.
1
Chapter 1: Basic Concepts of Databases
The database can be considered as a unification of several
independent data files, whose basic purpose is to avoid the
duplication of data (Unless it is strictly necessary).
This database property is called:
Shared
Redundancy
Secure
Integrated
E) "Distributed"
2. One of the advantages that the database offers us is the possibility of
show different views depending on the operations that are going to
create different users, allowing them to use the same information
without presenting any problem.
This is known as:
Integrated database
Shared database
Distributed database
Associated database
E) 'database management system (DBMS)'
3. Most companies manage an information system for each
department of the same, That is to say that a system is not managed
centralized information (database), having multiple systems
that sometimes present the same information create a problem
which can be partially avoided with a database that is known
like:
Security
B) Data distribution
C) Redundancy and Inconsistency
D) Consistency
E) Integrity
4. A database file can be organized or stored in
different forms whether by indexes, sequential, embedded pointers,
they can be stored in blocks, etc. But no matter how it is the
1
physical organization of the files that are part of the database,
these should not affect the applications that make use of it. This
database attribute allows the information to be.
A) The independence of information regardless of how the
user accesses it.
B) The most convenient distribution within the hardware that
arrange for the database
C) The more organized management of information within the company
D) Allow control over how the user uses the database
E) Make the development of applications dependent on the structure like
the database is managed
5. Within the database, each person who interacts with it has
his own language in which he can help to distinguish knowledge that
one has the internal structure of the database or the management of the
same. An example of these languages is the query language or
specific purpose <<made to the needs of those who it is for
uses >>. This language refers to or is designed for.
A) Programmer
B) Database Administrator (DBA)
C) Database management system
D) End user
E) All those who are involved in the management of the database
6. The evolution that can be presented in the database that has a
system, it can be a very difficult problem for the administrator of the
database if sufficient information about it is not available, such as
the flows of information between users, the utility of each field
stored, database operations, etc. This makes it necessary that the
database administrator has enough information of the
base to modify or update this information is known
how.
A) Data sublanguage (DSL)
B) Technical data
C) Data Manipulation Language (DML)
D) Metadata
E) cobol
2
7. Databases represent a great advance in management and
storage of information, but even if they are very noticeable the
advantages that can be obtained by managing a database some
Companies are still undecided about implementing this type of systems.
which has led to a great theoretical advancement but little practical
this is largely due to the databases.
A) The limited knowledge of entrepreneurs in new technologies
B) The insecurity of some companies about changing their old
storage systems
C) The inability of some companies to cope with costs that
incurs in changing from the old system to a database and its subsequent
maintenance
D) That the databases are completely new and unreliable
E) The little personnel that exists for the management of a database
8. Being the database the absolute responsible for all the information
what concerns the company, it must manage a level of security that
prevent different users from accessing information that they should not
the compete or may cause damage to the database, also the
management of space in storage units, having points
for restoration for any inconvenience, etc. That is why it is necessary
that the system handles a level of security and that possible issues are fixed
failures within it. this function is directly the responsibility of.
A) User
B) Database Management System (DBMS)
C) Application developers
D) Database designer
E) Database Administrator (DBA)
9. Some of the databases cannot be due to their great length.
to store on a single disk, this instead of becoming a disadvantage
for the database has become a great advantage, since thanks to
the different levels of communication that can be had with the
Computers can easily access the information they have.
more flow this advantage is due to the fact that the bases can be.
Integrated databases
Distributed databases
Random databases
D) Database Management System (DBMS)
E) At the level of security that the databases handle
3
10. As indicated, the database management system (DBMS)
It's nothing more than a program. The Operating System is the program.
the main one responsible for ensuring that the computer works well,
among other things allowing access to input devices and
output devices, such as the keyboard, mouse, monitor, and the devices of
the hard drive, the floppy disks, the CD-ROM, the tapes
magnetic, etc. The only one who can touch these devices is the
Operating System (OS). Since the DBMS needs to store data
on the hard drive, for example, it must interact with the OS in order to
access the hard drive and store the desired data there.
You should also contact the SO whenever you want to recover something.
data from these devices. According to the above, the generating system of the
database can be considered as.
A) An interface between low-level data and different applications
that exist to work with the database
B) A useful medium for the user to make inquiries
C) An internal database system for communication
between themselves
A storage medium that contains the entire database
E) A medium responsible for the security of the database
In a food company, the manager uses the data from his
employees to find out how many of them have salaries between 1000000 and
2,000,000 pesos, while the secretary uses that same data.
to inform them which of them will have the right to enjoy
about your vacation in the month of August. This type of data is called:
A) Integrated data
B) Data redundancy
C) Data compartment
D) Data consistency
E) All of the above
12. In the database design process, the following must be taken into account:
A) The constant maintenance that must be kept, so that your
operation is the best.
B) According to the needs of the company.
C) An abstraction of the problem is made trying to obtain a
representation of the real world.
D) That the files can store the information correctly.
E) The database depends on how the data was centralized in the
Chosen database management system.
4
13. He who manages, protects, and supports the user's operations against the
hardware level details in a database is
The Administrator of the company
B) Database Management System
C) The same user
D) The database programmer
E) Software
14. The importance of providing security to the information stored in a
Database is:
A) So that unauthorized people cannot access
information to which it does not correspond.
B) So that the information stored cannot be modified.
Database.
C) To protect the data.
D) To prevent the database administrator from doing
incorrect operations.
E) To prevent important information from being deleted.
[Link] can guarantee that the applicable forms will be fulfilled?
data representation in a database of the Company of
Luna Cosmetics Inc.
A) The End User
B) The manager of the company
C) The Application Programmer
D) The employee of the company
E) The Database Administrator
16. What is not an essential objective of database systems?
A) Independence of data
B) Control data redundancy
C) Create an inconsistent application
D) The security of the information of the DB
E) Preserve integrity
5
17. Data redundancy in a DBMS is a major problem which
makes this application inconsistent, It can be avoided or controlled
this inconvenience.
A) It is not possible to reduce redundancy in a Database.
B) Yes, carrying out a good analysis process that leads to
different methods, such as Generalization. And it also
It can be avoided by creating relationships between the data of an organization.
C) It is not possible since this is an advantage of the DBMS.
D) Yes, by carrying out an adequate normalization process.
E) Yes, increasing the complexity for the functionality of a DBMS.