Q.1
Long-range planning report produced in an MIS are primarily designed for
Q.2
A compound key
Q.3
In SQL, which command(s) is(are) used to redefine an index's future storage allocation
Q.4
In the DBM approach, application programs perform the
Q.5
The model for a record management system might be
Q.6
The designer of a form includes
Q.7
Which of the following is a serious problem of file management systems?
Q.8
With respect to data input, the most accurate description of batch control is
Q.9
In SQL, which command is used to create a database user?
Q.10
When performing a look-up operation using a form
Q.11
A _____ means that one record in a particular record type is related to only one record of another record type.
Q.12
In SQL, which of the following is not a data Manipulation Language Commands?
Q.13
Which of the following is not characteristic of a relational database model?
Q.14
The database administration function includes
Q.15
Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
Q.16
Which command is used to select distinct subject (SUB) from the table (BOOK)?
Q.17
The master list of an indexed file
Q.18
The model for a _____ resembles the hierarchical model in many respects.
Q.19
A set of programs that handle a firm's data base responsibilities is called a
Q.20
A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
Q.21
A computer file contains several records. What does each record contain?
Q.22
In SQL, the CREATE VIEW command is used
Q.23
A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
Q.24
A command that lets you change one or more fields in a record is
Q.25
Which of the following is not the responsibility of the utilities component of DBMS software?
Q.26
In SQL, the CREATE TABLESPACE is used
Q.27
A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
Q.28
In SQL, which command is used to remove a stored function from the database?
Q.29

In SQL, which command(s) is(are) used to change a table's storage characteristics?

  • ALTER TABLE
  • MODIFY TABLE
  • CHANGE TABLE
  • All of the above
  • None of the above
Q.30

In order to use a DBMS, it is important to understand

  • the physical schema
  • all sub-schemas that the system supports
  • one subschema
  • both (a) and (b)
  • None of the above
0 h : 0 m : 1 s