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 → Functional Dependency 3

………………….. operator is basically a join followed by a project on the attributes of first relation.
Semi-Join
click to copy
Minimal data redundancy means improved _________:
Data consistency
click to copy
DA stands for:
Data administrator
click to copy

DBMS → SQL Basics 3

Which of the following is not a binary operator in relational algebra?
Project
click to copy
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 3

Centralizing the integrity checking directly under the DBMS ………….. duplication and ensures the consistency and validity of the database.
Reduces
click to copy
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 3

Which of the following is/are the DDL statements?
All of the above
click to copy
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

---------------- is used to retrieve tuples from the relation.
Select
click to copy
Who interact with the system by invoking one of the permanent application program:
Naïve users
click to copy

DBMS → Views 2

……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
Constraint
click to copy
The main interface that a naive user uses is a form interface using___:
GUI
click to copy

DBMS → Indexes 2

For like predicate which of the following is true. i) % matches zero of more characters. ii) _ matches exactly one character.
Both of them
click to copy
The provision of _______ is a major objective for database system:
Data independence
click to copy

DBMS → Transactions 2

The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….
Relations
click to copy
____ is a translates into low-level instruction that a query processor understands:
DDL compiler
click to copy

DBMS → Concurrency Control 2

……………….. contains information that defines valid values that are stored in a column or data type.
Index
click to copy
Retrieval of data is done by using a ____:
Query
click to copy

DBMS → Deadlock 2

Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
Both of them
click to copy
DML is a language by which user accesses or manipulates the ________:
Data model
click to copy

DBMS → Database Security 2

………………. first proposed the process of normalization.
Edgar F. Codd
click to copy
Which is the central component of the DBMS software that can also be termed as the database control system?
Data manager
click to copy

DBMS → PL/SQL 2

For using a specific database …………… command is used.
Use database
click to copy
Which is stored information about description of data in the database:
Data dictionary
click to copy

DBMS → Introduction to DBMS 2

Which of the following is not comparison operator?
=<
click to copy
After conversion of high level queries into low level commands for file access and is called compiled_____:
DML
click to copy

DBMS → Database Architecture 2

An outstanding functionality of SQL is its support for automatic ………… to the target data.
Navigation
click to copy
Which is installs, configures, troubleshoots and maintains a database system:
DBA
click to copy

DBMS → Data Models 2

………………… 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

DBMS → ER Model 2

……………..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

DBMS → Relational Model 2

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

DBMS → Normalization 2

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