A top-to-bottom relationship among the items in a database is established by a
A top-to-bottom relationship among the items in a database is established by a
When you have finished entering information into a form
When you have finished entering information into a form
Data item characteristics that are important in data management include
Data item characteristics that are important in data management include
A computer file contains several records. What does each record contain?
A computer file contains several records. What does each record contain?
To have a file hold a list, it is necessary to
To have a file hold a list, it is necessary to
When performing a look-up operation using a form
When performing a look-up operation using a form
When using a database management system, the first thing that you must do is to
When using a database management system, the first thing that you must do is to
A _____ means that one record in a particular record type is related to only one record of another record type.
A _____ means that one record in a particular record type is related to only one record of another record type.
In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
A database management system might consist of application programs and a software package called
A database management system might consist of application programs and a software package called
In SQL, which command is used to create a database user?
In SQL, which command is used to create a database user?
Sort/report generators
Sort/report generators
The PROJECT command will create new table that has
The PROJECT command will create new table that has
If the record management system allows you to edit values before they are recorded on disk, you can
If the record management system allows you to edit values before they are recorded on disk, you can
Which of the following is not a relational database?
Which of the following is not a relational database?
In a large DBMS
In a large DBMS
Which of the following is not a logical data-base structure?
Which of the following is not a logical data-base structure?
Internal auditors should review data system design before they are
Internal auditors should review data system design before they are
Which of the following is not characteristic of a relational database model?
Which of the following is not characteristic of a relational database model?
An-owner-member set in the CODASYL specifications may have
An-owner-member set in the CODASYL specifications may have
Data security threats include
Data security threats include
Which of the following is a serious problem of file management systems?
Which of the following is a serious problem of file management systems?
The logical data structure with a one-to-many relationship is a :
The logical data structure with a one-to-many relationship is a :
An operation that will increase the length of a list is
An operation that will increase the length of a list is
A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
Updating a database means
Updating a database means
Which command is used to remove a table from the database in SQL?
Which command is used to remove a table from the database in SQL?
The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
The model for a record management system might be
The model for a record management system might be
A scheme describes
A scheme describes
The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
A compound key
A compound key
The distinguishable parts of a record are called
The distinguishable parts of a record are called
What name is given to the collection of facts, items of information or data which are related in some way?
What name is given to the collection of facts, items of information or data which are related in some way?
Each of data files has a _____ that describe the way the data is stored in the file.
Each of data files has a _____ that describe the way the data is stored in the file.
After you _____ a record, many data management the environments require you to issue a command to save the changes you made.
After you _____ a record, many data management the environments require you to issue a command to save the changes you made.
The index consists of
The index consists of
The way a particular application views the data from the data base that the application uses is a :
The way a particular application views the data from the data base that the application uses is a :
The main idea behind computer files is that it is convenient to
The main idea behind computer files is that it is convenient to
In SQL, which command is used to add a column/integrity constraint to a table
In SQL, which command is used to add a column/integrity constraint to a table
Characteristic(s) of a distributed MIS structure is
Characteristic(s) of a distributed MIS structure is
Primitive operations common to all record management systems include
Primitive operations common to all record management systems include
In SQL, the ALTER TABLESPACE command is used
In SQL, the ALTER TABLESPACE command is used
In SQL, GRANT command is used to
In SQL, GRANT command is used to
Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
A file produced by a spreadsheet
A file produced by a spreadsheet
In the DBM approach, application programs perform the
In the DBM approach, application programs perform the
A network schema
A network schema
What is the name given to the database management system which is able to handle full text data, image data, audio and video?
What is the name given to the database management system which is able to handle full text data, image data, audio and video?
A database management system
A database management system
Long-range planning report produced in an MIS are primarily designed for
Long-range planning report produced in an MIS are primarily designed for
Which command(s) is(are) used to redefine a column of the table in SQL ?
Which command(s) is(are) used to redefine a column of the table in SQL ?
Which of the following hardware components is the most important to the operation of a database management system?
Which of the following hardware components is the most important to the operation of a database management system?
In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
An indexing operation
An indexing operation
If a calculation is embedded in a form
If a calculation is embedded in a form
In SQL, which of the following is not a data Manipulation Language Commands?
In SQL, which of the following is not a data Manipulation Language Commands?
A report generator is used to
A report generator is used to
A _____ means that one record in a particular record type may be related to more than one record of another record type.
A _____ means that one record in a particular record type may be related to more than one record of another record type.
If you want to group the records in the abc database, you could use the Jobcode as the _____.
If you want to group the records in the abc database, you could use the Jobcode as the _____.
In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
The data dictionary tells the DBMS
The data dictionary tells the DBMS
Which two files are used during operation of the DBMS?
Which two files are used during operation of the DBMS?
A set of programs that handle a firm's data base responsibilities is called a
A set of programs that handle a firm's data base responsibilities is called a
With respect to data input, the most accurate description of batch control is
With respect to data input, the most accurate description of batch control is
In SQL, which command(s) is(are) used to enable/disable a database trigger?
In SQL, which command(s) is(are) used to enable/disable a database trigger?
In SQL, which command is used to add new rows to a table?
In SQL, which command is used to add new rows to a table?
Large collections of files are called
Large collections of files are called
Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
A number of related records that are treated as a unit is called
A number of related records that are treated as a unit is called
The model for a _____ resembles the hierarchical model in many respects.
The model for a _____ resembles the hierarchical model in many respects.
In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
In SQL, which command(s) is(are) used to redefine an index's future storage allocation
In SQL, which command(s) is(are) used to redefine an index's future storage allocation
A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
A report form
A report form
Two files may be joined into a third file if
Two files may be joined into a third file if
In SQL, the CREATE VIEW command is used
In SQL, the CREATE VIEW command is used
Which command is used to remove an index from the database in SQL?
Which command is used to remove an index from the database in SQL?
Which of the following is true of a network structure?
Which of the following is true of a network structure?
Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
A race condition occurs when
A race condition occurs when
In SQL, which command(s) is(are) used to enable/disable a database trigger?
In SQL, which command(s) is(are) used to enable/disable a database trigger?
An audit trail
An audit trail
What is the language used by most of the DBMSs for helping their users to access data?
What is the language used by most of the DBMSs for helping their users to access data?
A form defines
A form defines
A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
In SQL, which command is used to changes data in a table?
In SQL, which command is used to changes data in a table?
The designer of a form includes
The designer of a form includes
The Management Information system (MIS) structure with one main computer system is called a
The Management Information system (MIS) structure with one main computer system is called a
In SQL, which command is used to select data in rows and column from one or more tables?
In SQL, which command is used to select data in rows and column from one or more tables?
The language used in application programs to request data from the DBMS is referred to as the
The language used in application programs to request data from the DBMS is referred to as the
If you want your database to include methods, you should use a _____ database.
If you want your database to include methods, you should use a _____ database.
The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
The highest level in the hierarchy of data organization is called
The highest level in the hierarchy of data organization is called
The data-base environment has all of the following components except:
The data-base environment has all of the following components except:
In a relational schema, each tuple is divided into fields called
In a relational schema, each tuple is divided into fields called
In SQL, which command(s) is(are) used to create a synonym for a schema object?
In SQL, which command(s) is(are) used to create a synonym for a schema object?
Which of the following is a database administrator's function?
Which of the following is a database administrator's function?
Periodically adding, changing and deleting file records is called file
Periodically adding, changing and deleting file records is called file
Sophisticated report generators can
Sophisticated report generators can
