Database Management System MCQs
Database Management System MCQs
These Database Management System multiple-choice questions and their answers will help you strengthen your grip on the subject of Database Management System. You can prepare for an upcoming exam or job interview with these Database Management System MCQs.
So scroll down and start answering.
1: Data Manipulation Language (DML) is not to
A. Create information table in the Database
B. Deletion of information in the Database
C. Insertion of new information into the Database
D. Modification of information in the Database
2: Report generators are used to
A. Retrieve information from files
B. None of these
C. Both retrieve information from files and answer queries
D. Store data input by a user
E. Answer queries
3: Database locking concept is used to solve the problem of?
A. Lost Update
B. Inconsistent Data
C. All of these
D. Uncommitted Dependency
4: The Primary key must be
A. Option Non Null or Unique
B. UNIQUE
C. Non Null
D. Option Non Null and Unique
5: Administrate supervision of database activities is the responsibility of the
A. DP Manager
B. DB Manager
C. Database Administrator
D. None of these
E. DP administration
6: In SQL, which of the following is not a data definition language commands?
A. GRANT
B. Revoke
C. RENAME
D. UPDATE
E. None of these
7: Snapshot of the dta in the database at a given instant of time is called
A. Database Instance
B. Database Schema
C. Database Snapshot
D. All of these
8: A command that lets you change one or more fields in a record is
A. INSERT
B. Modify
C. Look-up
D. All of these
E. None of these
9: What is ACID properties of Transactions?
A. Atomicity, Consistency, Isolation, Durability
B. Atomicity, Consistency, Inconsistent, Durability
C. Atomicity, Consistency, Isolation, Database
D. Automatically, Concurrency, Isolation, Durability
10: Data integrity control
A. All of these
B. Requires the use of passwords to prohibit unauthorized access to the file
C. Is used to set upper and lower limits on numeric data
D. None of these
E. Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
11: A command to remove a relation from an SQL database
A. Drop table < table name >
B. Erase table < table name >
C. Alter table < table name >
D. Delete table < table name >
12: In DBMS FD stands for _______
A. Functional dependency
B. Functional data
C. Facilitate dependency
D. Facilitate data
13: The attribute that can be divided into other attributes is called
A. Simple Attribute
B. Derived Attribute
C. Multi-valued Attribute
D. Composite Attribute
14: How many types of keys in Database Design?
A. Foreign key
B. All of these
C. Candidate key
D. Primary key
15: Which of the following in true regarding Null Value?
A. Null < 0
B. Null > 0
C. Null = 0
D. Null < > 0
16: A _____ DBMS distributes data processing tasks between the workstation and a network server.
A. Hierarchical
B. Relational
C. Network
D. Client server
E. None of these
17: In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
A. None of these
B. CREATE SCHEMA
C. All of these
D. CREATE CLUSTER
E. CREATE PACKAGE
18: If every non-key attribute is functionally dependent on the primary key, the relation will be in
A. Third Normal Form
B. Fourth Formal Form
C. Second Normal Form
D. First Normal Form
19: Which of the following is not a level of data abstraction?
A. View Level
B. Logical Level
C. Physical Level
D. Critical Level
20: Which of the following in true regarding Referential Integrity?
A. Every primary-key value must match a primary-key value in an associated table
B. Every foreign-key value must match a foreign-key value in an associated table
C. Every primary-key value must match a foreign-key value in an associated table
D. Every foreign-key value must match a primary-key value in an associated table
21: ____ is used to reveal the meaning of data.
A. Relationship
B. Information
C. Composite
D. Unstructured
22: ______ databases are the most frequently used electronic databases.
A. Flat-file
B. Object-oriented
C. Multidimensional
D. Relational
23: ________ databases are the most commonly used electronic databases.
A. Flat-file
B. Object-oriented
C. Multidimensional
D. Relational
24: ________ involves searching for patterns and relationships among data.
A. Data mining
B. Data marting
C. Data processing
D. Knowledge management
E. Data warehousing
25: ________ is used to ensure that data is organized most efficiently in a database.
A. Artificial intelligence
B. Centralization
C. Relational
D. Normalization
26: _________ maintains information about various types of objects, events, people, and places.
A. Web analytics
B. Infographics
C. Database
D. Classification
27: __________ are the most commonly used database clients.
A. Operational
B. Incorrect
C. Browsers
D. Primary key
28: A ____ database supports data distributed across several different sites.
A. Desktop
B. Workgroup
C. Distributed
D. Enterprise
29: A ____ is a program that lets computer users create and access a collection of organized data.
A. Database management system
B. Data warehouse
C. Database
D. Management system
30: A ______ is the highest level of data hierarchy.
A. Bits
B. Character
C. Database
31: A ________ is a collection of related data that can be stored, sorted, organized, and queried.
A. Database
B. Spreadsheet
C. Memo
D. Macro
32: A ________ is a group of related data that can be stored, sorted, organized, and queried.
A. Database
B. Spreadsheet
C. Memo
D. Macro
33: A ________ is a highly structured collection of data values organized into separate tables.
A. False
B. Database
C. Data cube
D. Timeline
34: A collection of related records in a database is referred to as a _____.
A. Field
B. Table
C. Primary Key
D. Report
35: A consistent database is ____.
A. One in which all tables have foreign keys
B. One in which all data integrity constraints are satisfied
C. One in which all data integrity constraints are not satisfied
36: A data ____ table describes the fields you plan to maintain in a table.
A. Dialog box
B. Two or four
C. Definition
D. Contains
37: A database administrator (dba) is responsible for _____.
A. True
B. Used for analytical purposes.
C. Hierarchy
D. Developing recovery procedures in case data is lost or corrupted
38: A distributed _____ can reference several different local or remote data processing sites.
A. Request
B. Site
C. Data location
D. Transaction
39: A(n) ____ synonym is used by others to access an individual's database objects.
A. PUBLIC
B. CURRVAL
C. PUBLCI
D. PRIVATE
40: A(n) ______ is an item that contains data, as well as the actions that read or process the data.
A. Attribute
B. Table
C. Object
D. Field
41: After a dbms detects a deadlock, the ____ should break the deadlock.
A. First user
B. Second user
C. Database administrator
D. DBMS
42: An attribute is also referred to as a ________.
A. Field
B. Data mart
C. False
D. True
43: An electronic storage file where firms keep customer information is known as a(n) ________.
A. Database
B. Worksheet
C. Program
44: An entity that exists to implement a many-to-many relationship is called a(n) ____.
A. Weak entity
B. Minimum
C. Composite entity
D. Independent entity
45: Another name for a composite entity is a(n) _____ entity.
A. Bridge
B. False
C. Attribute
D. Unique
46: Another term for a database row is a(n) ________.
A. Attribute
B. Primary key
C. Hadoop
D. Record
47: As part of a dbms, a(n) _________ documents information about a database.
A. Data cleansing
B. Data mining
C. Data warehouse
D. Data dictionary
48: Big data analytics is usually associated with ________ services.
A. Decision support
B. Data warehouse
C. Office support
D. Management information
49: A ____ is a group of interrelated files.
A. False
B. The System Development Life Cycle
C. True
D. Database
50: Browser-based applications ________.
A. Support querying using graphics
B. Process queries using C++
C. Are thick-client applications
D. Can only display static content
List of Database Management Sy...
Available in:
Database Management System MCQs
Вопросы и ответы по системе управления базами данных MCQ
Preguntas y Respuestas de Sistemas de Gestión de Bases de Datos MCQ
データベース管理システムMCQの質問と回答
Domande e Risposte sul Sistema di Gestione dei Database MCQ
Questions et Réponses de Systèmes de Gestion de Base de Données MCQ
Perguntas e Respostas de Sistemas de Gerenciamento de Banco de Dados MCQ
Fragen und Antworten zur Datenbankverwaltung MCQ
数据库管理系统MCQ问题与答案
أسئلة وأجوبة نظام إدارة قواعد البيانات MCQ
Pertanyaan dan Jawaban Sistem Manajemen Basis Data MCQ
Veritabanı Yönetim Sistemi MCQ Soruları ve Cevapları
