More MCQs
1101.

Consequently R.Boyce-Codd jointly launched powerful definition for the third normal form called______:

A. Boyce-Codd normal form
B. First normal form
C. Second normal form
D. All of these
Answer» A. Boyce-Codd normal form
1102.

BCNF stands for:

A. Basic -Codd normal form
B. Build -Codd normal form
C. Boyce-Codd normal form
D. None of these
Answer» C. Boyce-Codd normal form
1103.

Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:

A. 1NF
B. 2NF
C. 3NF
D. All of these
Answer» A. 1NF
1104.

Which forms every non-prime attribute is fully dependent functionally on the candidate key of a relational schema:

A. 1NF
B. 2NF
C. 3NF
D. 5NF
Answer» B. 2NF
1105.

PJNF stands form:

A. Practically –join normal form
B. Project –join normal form
C. Pages –join normal form
D. programming –join normal form
Answer» B. Project –join normal form
1106.

Which forms are based on the concept of functional dependency

A. 1NF
B. 2NF
C. 3NF
D. 4NF
Answer» C. 3NF
1107.

The DBMS utility, ____________ allows to reconstruct the correct state of database from the backup and history of transactions.

A. Backup
B. Recovery
C. Monitoring
D. Data loading
Answer» B. Recovery
1108.

In the ........... normal form, a composite attribute is converted to individual attributes.

A. First
B. Second
C. Third
D. Fourth
Answer» A. First
1109.

In RDBMS, Data is presented as a collection of ............

A. Table
B. Attributes
C. Relations
D. Entities
Answer» C. Relations
1110.

A .................. normal form, normalization will be needed where all attributes in a relation are not functionally dependent only on the key attribute.

A. First
B. Second
C. Third
D. Fourth
Answer» C. Third
1111.

To select all column from the table the syntax is:

A. Select all from table_name
B. Select * from table_name
C. Select from table_name
D. Non of the above
Answer» B. Select * from table_name
1112.

For using a specific database …………… command is used.

A. use database
B. databasename use
C. Both A &B
D. None of them
Answer» A. use database
1113.

………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

A. Entity Integrity Constraints
B. Referential Integrity Constraints
C. Domain Integrity Constraints
D. Key Constraints
Answer» B. Referential Integrity Constraints
1114.

____ ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure.

A. Atomicity
B. Consistency
C. Durability
D. Isolation
Answer» C. Durability
1115.

Deadlocks are possible only when one of the transactions wants to obtain a(n) ____ lock on a data item.

A. binary
B. exclusive
C. shared
D. Complete
Answer» B. exclusive
1116.

If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.

A. atomicity
B. consistency
C. isolation
D. Durability
Answer» C. isolation
1117.

A DBMS uses a transaction ____ to keep track of all transactions that update the database

A. log
B. table
C. block
D. Statement
Answer» A. log
1118.

When a program is abnormally terminated, the equivalent of a ____ command occurs.

A. COMMIT
B. ROLLBACK
C. QUIT
D. EXIT
Answer» A. COMMIT
1119.

In a(n) ____ backup of the database, only the last modifications to the database are copied.

A. full
B. incomplete
C. differential
D. transaction log
Answer» C. differential
1120.

Although the ____ locking approach improves the availability of data, its management requires high overhead.

A. database-level
B. table-level
C. page-level
D. row-level
Answer» D. row-level
1121.

A(n) ____ lock exists when concurrent transactions are granted Read access on the basis of a common lock.

A. binary
B. field-level
C. shared
D. Exclusive
Answer» C. shared
1122.

A ____ database state is one in which all data integrity constraints are satisfied.

A. fixed
B. complete
C. consistent
D. Secure
Answer» C. consistent
1123.

The ____ statement is used to end a successful transaction.

A. COMMIT
B. DONE
C. END
D. QUIT
Answer» A. COMMIT
1124.

____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

A. Atomicity
B. Consistency
C. Durability
D. Isolation
Answer» D. Isolation
1125.

The three basic techniques to control deadlocks are: deadlock ____, deadlock detection, and deadlock avoidance.

A. prevention
B. prohibition
C. rollback
D. Commits
Answer» A. prevention
1126.

All transactions are controlled and executed by the DBMS (subject to some limitations) to guarantee database ____.

A. integrity
B. uniqueness
C. consistency
D. Design
Answer» A. integrity
1127.

In a ____ lock, the DBMS will lock an entire disk page.

A. database-level
B. table-level
C. page-level
D. row-level
Answer» C. page-level
1128.

According to the ANSI SQL standard, when does a transaction begin?

A. with use of the START command
B. when the first SQL statement is encountered
C. with the BEGIN command
D. with the BEGIN TRANSACTION command
Answer» B. when the first SQL statement is encountered
1129.

The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.

A. table-level
B. page-level
C. row-level
D. field-level
Answer» D. field-level
1130.

What is ACID properties

A. Atomicity
B. Consistency
C. Isolation
D. All of the above
Answer» D. All of the above
1131.

Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other:

A. Concurrency
B. Deadlock
C. Backup
D. Recovery
Answer» A. Concurrency
1132.

Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:

A. Concurrency
B. Deadlock
C. Backup
D. Recovery
Answer» B. Deadlock
1133.

Which is a duplicate copy of a file program that is stored on a different storage media than the original location:

A. Concurrency
B. Deadlock
C. Backup
D. Recovery
Answer» C. Backup
1134.

............... joins are SQL server default

A. Outer
B. Inner
C. Equi
D. None of the above
Answer» B. Inner
1135.

The ..................... is essentially used to search for patterns in target string.

A. Like Predicate
B. Null Predicate
C. In Predicate
D. Out Predicate
Answer» A. Like Predicate
1136.

................. requires that data should be made available to only authorized users.

A. Data integrity
B. Privacy
C. Security
D. None of the above
Answer» C. Security
1137.

.............. is a combination of two of more attributes used as a primary key

A. Composite Key
B. Alternate Key
C. Candidate Key
D. Foreign Key
Answer» A. Composite Key
1138.

To delete a database ................... command is used

A. delete database database_name
B. Delete database_name
C. drop database database_name
D. drop database_name
Answer» C. drop database database_name
1139.

Some of the utilities of DBMS are ............. i) Transaction ii) Backup iii) File organization iv) Process Organization

A. i, ii, and iv only
B. i, ii and iii only
C. ii, iii and iv only
D. All i, ii, iii, and iv
Answer» C. ii, iii and iv only
1140.

There are _________ number of Normal forms that has been defined

A. 5
B. 6
C. 4
D. 3
Answer» B. 6
1141.

The primary key must be

A. Unique
B. Not Null
C. Both A & B
D. None of these
Answer» C. Both A & B
1142.

Which of the following is not unary operation?

A. Select
B. Union
C. Project
D. Rename
Answer» B. Union
1143.

Which is relation calculus:

A. Tuple relational calculus
B. Domain relational calculus
C. Both
D. None
Answer» C. Both
1144.

Which calculus is based on specifying a number of tuple variables:

A. Tuple relation calculus
B. Domain relational calculus
C. Both
D. None
Answer» A. Tuple relation calculus
1145.

SQL outputs a single table known as the ______:

A. View
B. Column
C. Tablespace
D. Result set
Answer» D. Result set
1146.

Which of the following is related to information?

A. Data
B. Communication
C. Knowledge
D. All of these
Answer» A. Data
1147.

Data is:

A. A piece of fact
B. Metadata
C. Information
D. None of these.
Answer» A. A piece of fact
1148.

Which of the following is element of the database?

A. Data
B. Constraints and schema
C. Relationships
D. All of these.
Answer» D. All of these.
1149.

What represent a correspondence between the various data elements?

A. Data
B. Constraints
C. Relationships
D. Schema
Answer» C. Relationships
1150.

Which of the following is an advantage of using database system?

A. Security enforcement
B. Avoidance of redundancy
C. Reduced inconsistency
D. All of these.
Answer» D. All of these.
1151.

Which of the following is characteristic of the data in a database?

A. Independent
B. Secure
C. Shared
D. All of these.
Answer» D. All of these.
1152.

Relationships could be of the following type:

A. One-to-one relationship
B. One-to-many relationships
C. Many-to-many relationships
D. All of these.
Answer» D. All of these.
1153.

In a file-oriented system there is:

A. Data inconsistency
B. Duplication of data
C. Data independence
D. Al of these.
Answer» D. Al of these.
1154.

In a database system there is:

A. Increased productivity
B. Improved security
C. Economy of scale
D. All of these.
Answer» D. All of these.
1155.

VDL is used to specify:

A. Internal schema
B. External schema
C. Conceptual schema
D. None of these.
Answer» D. None of these.
1156.

The DML provides following functional access to the database:

A. Retrieve data and/or records
B. Add (or insert) records
C. Delete records from database files
D. All of these
Answer» B. Add (or insert) records
1157.

4GL has the following components inbuilt in it:

A. Query languages
B. Report generators
C. Spreadsheets
D. All of these.
Answer» D. All of these.
1158.

Which of the following is database element?

A. Data
B. Constraints and schema
C. Relationships
D. All of these.
Answer» D. All of these.
1159.

What separates the physical aspects of data storage from the logical aspects of data representation?

A. Data
B. Schema
C. Constraints
D. Relationships
Answer» D. Relationships
1160.

What scheme defines how and where the data are organized in a physical data storage?

A. External
B. Internal
C. Conceptual
D. None of these.
Answer» A. External
1161.

Which of the following schemas defines the stored data structures in terms of the database model used?

A. External
B. Conceptual
C. Internal
D. None of these
Answer» B. Conceptual
1162.

Which of the following schemas defines a view or views of the database for particular users?

A. External
B. Conceptual
C. Internal
D. None of these
Answer» B. Conceptual
1163.

A collection of data designed to be used by different people is called.

A. Database
B. RDBMS
C. DBMS
D. None of these
Answer» A. Database
1164.

Which of the following is an object-oriented feature?

A. Inheritance
B. Abstraction
C. Polymorphism
D. All of these
Answer» B. Abstraction
1165.

A physical data models are used to

A. Specify overall logical structure of the database
B. Describe data and its relationships
C. Higher-level description of storage structure and access mechanism
D. All of these
Answer» D. All of these
1166.

Which data model organizes the data in the form of tables and relations?

A. Relational Model
B. Hierarchical Model
C. Network Model
D. none of the above
Answer» A. Relational Model
1167.

Which company has developed the hierarchical model?

A. Oracle
B. IBM
C. Sun MicroSystems
D. Microsoft
Answer» B. IBM
1168.

The name of the system database that contains descriptions of data in the database is

A. Data dictionary
B. Metadata
C. Table
D. None of these
Answer» B. Metadata
1169.

System catalog is a system-created database that describes:

A. Database objects
B. Data dictionary information
C. User access information
D. All of these
Answer» D. All of these
1170.

Following is the type of metadata:

A. Operational
B. EDW
C. Data mart
D. All of these
Answer» D. All of these
1171.

What is refined data?

A. Knowledge
B. Information
C. Statistics
D. None of the above
Answer» B. Information
1172.

Which of the following is a database element?

A. Data
B. Relationships
C. Constraints and Schema
D. All of the above
Answer» D. All of the above
1173.

What defines how and where data are organized in physical data storage?

A. Internal schema
B. External schema
C. Conceptual schema
D. None of the above
Answer» A. Internal schema
1174.

What defines a view or views of the database for particular users?

A. Internal schema
B. External schema
C. Conceptual schema
D. None of the above
Answer» B. External schema
1175.

To access information from a database, you need a ___________

A. EIS
B. DBMS
C. MIS
D. None of the above
Answer» B. DBMS
1176.

Which of the following is an advantage of a database?

A. Reduction in Redundancy
B. Avoidance of inconsistency
C. Security enforcement
D. All of the above
Answer» D. All of the above
1177.

Which of the following is an example of a database application?

A. Computerized library systems
B. ATMs
C. Flight reservation systems
D. All of the above
Answer» D. All of the above
1178.

DBMS stands for________________?

A. Data blocking and Management Systems
B. Database Management Systems
C. Database Business Management Systems
D. None of the above
Answer» B. Database Management Systems
1179.

What is the name of the system database that contains descriptions of the data in the database?

A. Metadata
B. Data dictionary
C. Table
D. None of the above
Answer» B. Data dictionary
1180.

IMS stands for ___________

A. Information Management System
B. Internal Mechanical Security
C. International Managers Society
D. None of the above
Answer» A. Information Management System
1181.

Which of the following is the oldest database model?

A. Hierarchical
B. Network
C. Relational
D. Object Oriented
Answer» A. Hierarchical
1182.

Which category of users need not be aware of the presence of the database system?

A. DBA
B. Naive
C. Casual
D. Application Programmers
Answer» B. Naive
1183.

Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.

A. Instance, Schema
B. Relation, Schema
C. Relation, Domain
D. Schema, Instance
Answer» D. Schema, Instance
1184.

Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________ .

A. Relations, Attribute
B. Attributes, Relation
C. Tuple, Relation
D. Tuple, Attributes
Answer» B. Attributes, Relation
1185.

Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.

A. Attributes of common
B. Tuple of common
C. Tuple of distinct
D. Attributes of distinct
Answer» C. Tuple of distinct
1186.

A domain is atomic if elements of the domain are considered to be ____________ units.

A. Different
B. Indivisbile
C. Constant
D. Divisible
Answer» B. Indivisbile
1187.

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

A. IDMS
B. DB2
C. dBase-II
D. R:base
Answer» B. DB2
1188.

The following are components of a database except ________

A. user data
B. Metadata
C. Reports
D. Indexes
Answer» C. Reports
1189.

An application where only one user accesses the database at a given time is an example of a(n) ________ .

A. single-user database application
B. multiuser database application
C. e-commerce database application
D. data mining database application
Answer» A. single-user database application
1190.

An on-line commercial site such as Amazon.com is an example of a(n) ________ .

A. single-user database application
B. multiuser database application
C. e-commerce database application
D. data mining database application
Answer» C. e-commerce database application
1191.

SQL stands for ________ .

A. Structured Query Language
B. Sequential Query Language
C. Structured Question Language
D. Sequential Question Language
Answer» A. Structured Query Language
1192.

Because it contains a description of its own structure, a database is considered to be ________

A. Described
B. metadata compatible
C. self-describing
D. an application program
Answer» C. self-describing
1193.

The following are functions of a DBMS except ________ .

A. creating and processing forms
B. creating databases
C. processing data
D. administrating databases
Answer» A. creating and processing forms
1194.

Helping people keep track of things is the purpose of a(n) ________ .

A. Database
B. Table
C. Instance
D. Relationship
Answer» A. Database
1195.

A DBMS that combines a DBMS and an application generator is ________ .

A. Microsoft's SQL Server
B. Microsoft's Access
C. IBM's DB2
D. Oracle Corporation's Oracle
Answer» B. Microsoft's Access
1196.

Let us consider phone_number ,which can take single or several values . Treating phone_numberasan _________ permits instructors to have several phone numbers (including zero) associated with them.

A. Entity
B. Attribute
C. Relation
D. Value
Answer» C. Relation
1197.

Given the basic ER and relational models, which of the following is INCORRECT?

A. An attribute of an entity can have more than one value
B. An attribute of an entity can be composite
C. In a row of a relational table, an attribute can have more than one value
D. In a row of a relational table, an attribute can have exactly one value or a NULL value
Answer» A. An attribute of an entity can have more than one value
1198.

In an object-oriented model, one object can access data of another object by passing:

A. Instance variable
B. Message
C. Variable
D. None of these
Answer» B. Message
1199.

A view of database that appears to an application program is known as:

A. Schema
B. Subschema
C. virtual table
D. none of the above
Answer» B. Subschema
1200.

An abstraction concept for building composite object from their component object is called:

A. Specialization
B. Normalization
C. Generalization
D. Aggregation
Answer» D. Aggregation
Tags
Question and answers in DataBase Management System (DBMS), DataBase Management System (DBMS) multiple choice questions and answers, DataBase Management System (DBMS) Important MCQs, Solved MCQs for DataBase Management System (DBMS), DataBase Management System (DBMS) MCQs with answers PDF download