Quick Revision

GK One-Line Question & Answer

15541+ short questions with short answers, covering every category and sub-category on the site — no long articles to scroll through. Good for a fast recap before an exam, or a few minutes of daily practice.

Looking for exam process/strategy questions instead? Try the Exam Preparation FAQ →

DBMS → Data Models 3

………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
Referential Integrity Constraints
click to copy
Which is incorporated to create an appropriate physical database that is transformed by a logical data model:
None
click to copy
The related and interconnected software components of a DBMS are described by the _______:
Both
click to copy

DBMS → ER Model 3

……………..specifies a search condition for a group or an aggregate.
HAVING Clause
click to copy
In which end is really just any application that runs on top of the DBMS and acts as a user interface:
Front end
click to copy
Which are the types of physical DBMS architecture can be split :
Both
click to copy

DBMS → Relational Model 3

Drop Table cannot be used to drop a table referenced by a …………… constraint.
Foreign Key
click to copy
Data are stored in________ as database:
Data files
click to copy
The DML is called:
Sublanguages
click to copy

DBMS → Normalization 3

Which are the not features of a DBMS which provide a number of advantages for data management:
None of these
click to copy
ACID properties of transactions are
Durability
click to copy
The overall description of a database is called______:
Database schema
click to copy

DBMS → Functional Dependency 2

Minimal data redundancy means improved _________:
Data consistency
click to copy
DA stands for:
Data administrator
click to copy

DBMS → SQL Basics 2

Who access the database occasionally and have different needs each time:
Casual users
click to copy
Which is the person responsible for overall control f the database system:
DBA
click to copy

DBMS → DDL Commands 2

System analyst and application programmers are commonly referred to as …………………….
Software engineers
click to copy
DBA stands for:
Database administrator
click to copy

DBMS → DML Commands 2

Who interact with the system without writing a program:
Sophisticated user
click to copy
Transaction is an action used to perform some manipulation on data stored in the____:
Database
click to copy

DBMS → Joins 2

Who interact with the system by invoking one of the permanent application program:
Naïve users
click to copy
The data in the database at a particular moment in time is called a ________________
Database state
click to copy

DBMS → Views 2

The main interface that a naive user uses is a form interface using___:
GUI
click to copy
Which is a DBMS keeps back-up copies of the database:
Backup
click to copy

DBMS → Indexes 2

The provision of _______ is a major objective for database system:
Data independence
click to copy
In which the database can be restored up to the last consistent state after the system failure:
Recovery
click to copy

DBMS → Transactions 2

____ is a translates into low-level instruction that a query processor understands:
DDL compiler
click to copy
How many levels of abstraction in DBMS:
3
click to copy

DBMS → Concurrency Control 2

Retrieval of data is done by using a ____:
Query
click to copy
Which are the three levels of abstraction:
All of these
click to copy

DBMS → Deadlock 2

DML is a language by which user accesses or manipulates the ________:
Data model
click to copy
How many types of data independence:
2
click to copy

DBMS → Database Security 2

Which is the central component of the DBMS software that can also be termed as the database control system?
Data manager
click to copy
Which are the types of data independence:
Both
click to copy

DBMS → PL/SQL 2

Which is stored information about description of data in the database:
Data dictionary
click to copy
Which is the transformation of requests and results between different levels of abstraction:
Mapping
click to copy

DBMS → Introduction to DBMS 2

After conversion of high level queries into low level commands for file access and is called compiled_____:
DML
click to copy
Which mapping exists between the conceptual and internal levels:
Both
click to copy

DBMS → Database Architecture 2

Which is installs, configures, troubleshoots and maintains a database system:
DBA
click to copy
Which mapping exists between the external and conceptual levels:
Both
click to copy