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 → Database Security 3

If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ................ is needed.
BCNF
click to copy
…………………… is the process of organizing data into related tables.
Normalization
click to copy
………………. first proposed the process of normalization.
Edgar F. Codd
click to copy

DBMS → PL/SQL 3

Identify the criteria for designing database from the point of view of user
All of the above
click to copy
A ………………. does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.
Weak entity
click to copy
For using a specific database …………… command is used.
Use database
click to copy

DBMS → Introduction to DBMS 3

The ............ operator preserves unmatched rows of the relations being joined.
Outer join
click to copy
…………….. is the complex search criteria in the where clause.
Predicate
click to copy
Which of the following is not comparison operator?
=<
click to copy

DBMS → Database Architecture 3

Which are the not user in End-user:
All of these
click to copy
………………… is preferred method for enforcing data integrity
Constraints
click to copy
An outstanding functionality of SQL is its support for automatic ………… to the target data.
Navigation
click to copy

DBMS → Data Models 2

DBMS is a collection of ………….. that enables user to create and maintain a database.
Programs
click to copy
The number of tuples in a relation is called it’s …………. While the number of attributes in a relation is called it’s ………………..
Cardinality, Degree
click to copy

DBMS → ER Model 2

In a relational schema, each tuple is divided into fields called
Domains
click to copy
State true or false. i) Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation.
i-False, ii-True
click to copy

DBMS → Relational Model 2

In an ER model, ……………. is described in the database by storing its data.
Entity
click to copy
…………… database is used as template for all databases created.
Model
click to copy

DBMS → Normalization 2

DFD stands for
Data Flow Diagram
click to copy
One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as
Domain Integrity
click to copy

DBMS → Functional Dependency 2

……………… table store information about database or about the system.
System
click to copy
………………….. operator is basically a join followed by a project on the attributes of first relation.
Semi-Join
click to copy

DBMS → SQL Basics 2

…………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Schema
click to copy
Which of the following is not a binary operator in relational algebra?
Project
click to copy

DBMS → DDL Commands 2

……………… clause is an additional filter that is applied to the result.
Having
click to copy
Centralizing the integrity checking directly under the DBMS ………….. duplication and ensures the consistency and validity of the database.
Reduces
click to copy

DBMS → DML Commands 2

A logical schema
is a standard way of organizing information into accessible parts.
click to copy
Which of the following is/are the DDL statements?
All of the above
click to copy

DBMS → Joins 2

………………… is a full form of SQL.
Structured query language
click to copy
---------------- is used to retrieve tuples from the relation.
Select
click to copy

DBMS → Views 2

The candidate key is that you choose to identify each row uniquely is called ……………..
Primary Key
click to copy
……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
Constraint
click to copy

DBMS → Indexes 2

…………….. is used to determine whether of a table contains duplicate rows.
Unique predicate
click to copy
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

DBMS → Transactions 2

To eliminate duplicate rows ……………… is used
DISTINCT
click to copy
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….
Relations
click to copy

DBMS → Concurrency Control 2

State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
i-true, ii-true
click to copy
……………….. contains information that defines valid values that are stored in a column or data type.
Index
click to copy

DBMS → Deadlock 2

DCL stands for
Data Control Language
click to copy
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