Database Systems — Part 2 MCQs with Explanations

modifying or adding record occurrences is the correct answer to “Updating a database means”. This question is standard in competitive examination syllabi for Database Systems.

ALTER TABLE is the correct answer to “In SQL, which command(s) is(are) used to enable/disable all triggers on a table”. This question is standard in competitive examination syllabi for Database Systems.

the contents of the form are written to the data file is the correct answer to “When you have finished entering information into a form”. This question is standard in competitive examination syllabi for Database Systems.

store information together is the correct answer to “The main idea behind computer files is that it is convenient to”. This question is standard in competitive examination syllabi for Database Systems.

a compound key consisting of the first name and the last name is the correct answer to “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”. This question is standard in competitive examination syllabi for Database Systems.

INSERT is the correct answer to “In SQL, which command is used to add new rows to a table”. This question is standard in competitive examination syllabi for Database Systems.

file is the correct answer to “A number of related records that are treated as a unit is called”. This question is standard in competitive examination syllabi for Database Systems.

Sort Key is the correct answer to “If you want to group the records in the abc database, you could use the Jobcode as the _____.”. This question is standard in competitive examination syllabi for Database Systems.

centralized MIS structure is the correct answer to “The Management Information system (MIS) structure with one main computer system is called a”. This question is standard in competitive examination syllabi for Database Systems.

the calculations are stored with the form is the correct answer to “If a calculation is embedded in a form”. This question is standard in competitive examination syllabi for Database Systems.

privacy invasion is the correct answer to “Data security threats include”. This question is standard in competitive examination syllabi for Database Systems.

Insert is the correct answer to “An operation that will increase the length of a list is”. This question is standard in competitive examination syllabi for Database Systems.

ALTER TABLE is the correct answer to “In SQL, which command is used to add a column/integrity constraint to a table”. This question is standard in competitive examination syllabi for Database Systems.

UPDATE is the correct answer to “In SQL, which command is used to changes data in a table”. This question is standard in competitive examination syllabi for Database Systems.

Database is the correct answer to “What name is given to the collection of facts, items of information or data which are related in some way”. This question is standard in competitive examination syllabi for Database Systems.

each user can "see" only a small part of the entire database is the correct answer to “In a large DBMS”. This question is standard in competitive examination syllabi for Database Systems.

ALTER PROCEDURE is the correct answer to “Which of the following command(s) is(are) used to recompile a stored procedure in SQL”. This question is standard in competitive examination syllabi for Database Systems.

All of the above is the correct answer to “Internal auditors should review data system design before they are”. This question is standard in competitive examination syllabi for Database Systems.

One-to-many relationship is the correct answer to “A _____ means that one record in a particular record type may be related to more than one record of another record type.”. This question is standard in competitive examination syllabi for Database Systems.

ALTER TABLE is the correct answer to “Which command(s) is(are) used to redefine a column of the table in SQL”. This question is standard in competitive examination syllabi for Database Systems.

ALTER TABLE is the correct answer to “Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL”. This question is standard in competitive examination syllabi for Database Systems.

All of the above is the correct answer to “In SQL, the ALTER TABLESPACE command is used”. This question is standard in competitive examination syllabi for Database Systems.

DML is the correct answer to “The language used in application programs to request data from the DBMS is referred to as the”. This question is standard in competitive examination syllabi for Database Systems.

BPL is the correct answer to “A database management system might consist of application programs and a software package called”. This question is standard in competitive examination syllabi for Database Systems.

is the recorded history of operations performed on a file is the correct answer to “An audit trail”. This question is standard in competitive examination syllabi for Database Systems.

Two concurrent activities interact to cause a processing error is the correct answer to “A race condition occurs when”. This question is standard in competitive examination syllabi for Database Systems.

establishes an index for a file is the correct answer to “An indexing operation”. This question is standard in competitive examination syllabi for Database Systems.

on demand report is the correct answer to “The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a”. This question is standard in competitive examination syllabi for Database Systems.

CREATE SYNONYM is the correct answer to “In SQL, which command(s) is(are) used to create a synonym for a schema object”. This question is standard in competitive examination syllabi for Database Systems.

Object-Oriented is the correct answer to “If you want your database to include methods, you should use a _____ database.”. This question is standard in competitive examination syllabi for Database Systems.

CREATE is the correct answer to “In SQL, which of the following is not a data Manipulation Language Commands”. This question is standard in competitive examination syllabi for Database Systems.

treelike structure is the correct answer to “Which of the following is not characteristic of a relational database model”. This question is standard in competitive examination syllabi for Database Systems.

Fields is the correct answer to “A computer file contains several records. What does each record contain”. This question is standard in competitive examination syllabi for Database Systems.

to define a view of one or more tables or views is the correct answer to “In SQL, the CREATE VIEW command is used”. This question is standard in competitive examination syllabi for Database Systems.

Fields is the correct answer to “A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.”. This question is standard in competitive examination syllabi for Database Systems.

processing functions is the correct answer to “In the DBM approach, application programs perform the”. This question is standard in competitive examination syllabi for Database Systems.

CREATE USER is the correct answer to “In SQL, which command is used to create a database user”. This question is standard in competitive examination syllabi for Database Systems.

you enter the search value into the form is the correct answer to “When performing a look-up operation using a form”. This question is standard in competitive examination syllabi for Database Systems.

One-to-one relationship is the correct answer to “A _____ means that one record in a particular record type is related to only one record of another record type.”. This question is standard in competitive examination syllabi for Database Systems.

Relational is the correct answer to “A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.”. This question is standard in competitive examination syllabi for Database Systems.