A data dictionary is a special file that contains
A data dictionary is a special file that contains
Which of the following is a type of DBMS software?
Which of the following is a type of DBMS software?
A file that is organized in uniform format is formally referred to as a _____ or a database file.
A file that is organized in uniform format is formally referred to as a _____ or a database file.
A multiple-form file management system
A multiple-form file management system
Embedded pointer provide
Embedded pointer provide
A list in alphabetical order
A list in alphabetical order
The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
A form can be used to
A form can be used to
The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
The _____ command is used to allocates an extent for the table in SQL
The _____ command is used to allocates an extent for the table in SQL
Queries to a database
Queries to a database
In order to use a record management system
In order to use a record management system
A logical schema
A logical schema
One approach to standardizing storing of data
One approach to standardizing storing of data
In SQL, the _____ command is used to recompile a view
In SQL, the _____ command is used to recompile a view
What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
Related fields in a data base are grouped to form
Related fields in a data base are grouped to form
One data dictionary software package is called
One data dictionary software package is called
If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
A _____ Contains fields of data about one entity.
A _____ Contains fields of data about one entity.
A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
The modify operation is likely to be done after
The modify operation is likely to be done after
In SQL, the CREATE TABLE is used
In SQL, the CREATE TABLE is used
The master list of an indexed file
The master list of an indexed file
Batch processing is appropriate if
Batch processing is appropriate if
A computer file can be best described as
A computer file can be best described as
In SQL, which command is used to select only one copy of each set of duplicable rows
In SQL, which command is used to select only one copy of each set of duplicable rows
Which language has recently become the de-facto standard for interfacing application programs with relational database system?
Which language has recently become the de-facto standard for interfacing application programs with relational database system?
In SQL, which command is used to remove a stored function from the database?
In SQL, which command is used to remove a stored function from the database?
Which of the following is not the responsibility of the utilities component of DBMS software?
Which of the following is not the responsibility of the utilities component of DBMS software?
If a piece of data is stored in two places in the database, then
If a piece of data is stored in two places in the database, then
A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
A data dictionary doesn't provide information about:
A data dictionary doesn't provide information about:
In SQL, the CREATE TABLESPACE is used
In SQL, the CREATE TABLESPACE is used
It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
A command that lets you change one or more fields in a record is
A command that lets you change one or more fields in a record is
Versatile report generators can provide
Versatile report generators can provide
Data items grouped together for storage purposes are called a
Data items grouped together for storage purposes are called a
Data encryption techniques are particularly useful for
Data encryption techniques are particularly useful for
A good query system
A good query system
The activity of a file
The activity of a file
Which of the following is not true of the traditional approach to information processing?
Which of the following is not true of the traditional approach to information processing?
The database administration function includes
The database administration function includes
A condition that led to the development of databases was
A condition that led to the development of databases was
Which of the following is not an advantage of the data-base approach?
Which of the following is not an advantage of the data-base approach?
Which command is used to select distinct subject (SUB) from the table (BOOK)?
Which command is used to select distinct subject (SUB) from the table (BOOK)?
