Prev 1 2 3 4 5 Next
1. What is full form DBMS?
A. Database Management Structure
B. Database Management System
C. Database Manual System
D. None of these
ANSWER:B
SOLUTION : DBMS stands for Database Management System. It is a software system that stores, retrieves, and runs queries on data.
2. The ascending order of data hierarchy is ?
A. Bit -> byte -> record -> field -> file -> database
B. Bit -> byte -> field -> record -> file -> database
C. byte -> bit -> record -> field -> file -> database
D. Bit -> byte -> file->field -> record ->database
ANSWER: B
SOLUTION:Bit-bytes-field-record-file-database.
3. Duplication of data at several places is called______.
A. Data redundancy
B. Data mining
C. Data inconsistency
D. Data repository
ANSWER:A
SOLUTION:Additional InformationData Redundancy:- The situation of having an identical piece of data stored in two different locations is known as data redundancy and is created by databases or other data storage technologies.
4. A large store of data accumulated from a wide range of sources is called_______.
A. Data warehouse
B. Data mining
C. Data management
D. All of the above
ANSWER:A
SOLUTION:A large store of data accumulated from a wide range of sources is called a data warehouse.
5. DBA stands for ______.
A. Database access
B. Database administrator
C. Data Bank administrator
D. None of these
ANSWER:B
SOLUTION: DBA stands for database administrator. DBAs are responsible for the security, performance, and integrity of databases.
6. Data about data is known as __________.
A. Directory
B. Sub data
C. Meta data
D. Data bank
ANSWER:C
SOLUTION : Data about data is known as metadata. Metadata is structured information that describes, explains, locates, or makes it easier to retrieve, use, or manage information.
7. The tool which is used to extract the data & information from the data warehouse is ________.
A. Data warehouse
B. Data redundancy
C. Data mining
D. Data management
ANSWER: C
SOLUTION:Data mining is the process of extracting valuable information from large data sets.
8. Rows of relation are called ____.
A. Entity
B. Tuples
C. Degree
D. None of the above
ANSWER:B
SOLUTION:Rows of a relation are called tuples. A tuple is also known as a record or row.
9. DML stands for_______.
A. Data Management Language
B. Data Multipurpose Language
C. Data Manipulation Language
D. None of the above
ANSWER:C
SOLUTION:DML stands for Data Manipulation Language. It is a programming language that is used to make changes to a database.
10. TCL stands for ______.
A. Transmission control Language
B. Transactions Central Language
C. Ternary Control Language
D. Transaction Control Language
ANSWER:D
SOLUTION: TCL stands for Transaction Control Language. It is a set of commands used in SQL to manage and control database transactions.