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 → Joins 3

Database management systems are intended to
all of the options
click to copy
A logical description of some portion of database that is required by a user to perform task is called as
user view
click to copy
The                operator takes the results of two queries and returns only rows that appear in both result sets.
intersect
click to copy

DBMS → Views 3

The language used application programs to request data from the DBMS is referred to as the
dml
click to copy
A transaction completes its execution is said to be
committed
click to copy
A                  is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
schema diagram
click to copy

DBMS → Indexes 3

A set of programs that handle a firm's database responsibilities is called
all of the options
click to copy
A                  in a table represents a relationship among a set of values.
row
click to copy
The                    provides a set of operations that take one or more relations as input and return a relation as an output.
relational algebra
click to copy

DBMS → Transactions 3

In a large DBMS
each user can "see" only a small part of the entire database
click to copy
The term                is used to refer to a row.
tuple
click to copy
Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
dml(data manipulation langauge)
click to copy

DBMS → Concurrency Control 2

In an Entity-Relationship Diagram Rectangles represents
entity sets
click to copy
For each attribute of a relation, there is a set of permitted values, called the                   of that attribute.
domain
click to copy

DBMS → Deadlock 2

Which of the following represents a relationship among a set of values.
a row
click to copy
A domain is atomic if elements of the domain are considered to be                           units.
indivisbile
click to copy

DBMS → Database Security 2

A Relation is a
subset of a cartesian product of a list of domains
click to copy
The subset of a super key is a candidate key under what condition?
no proper subset is a super key
click to copy

DBMS → PL/SQL 2

In mathematical term Table is referred as
relation
click to copy
A            is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
key
click to copy

DBMS → Introduction to DBMS 2

In mathematical term Row is referred as
tuple
click to copy
Which one of the following attribute can be taken as a primary key?
id
click to copy

DBMS → Database Architecture 2

Which of the following is Relation-algebra Operation
all of the above
click to copy
Which one of the following cannot be taken as a primary key?
street
click to copy

DBMS → Data Models 2

Who proposed the relational model?
e.f. codd
click to copy
An attribute in a relation is a foreign key if the                key from one relation is used as an attribute in that relation.
primary
click to copy

DBMS → ER Model 2

Snapshot of the dta in the database at a given instant of time is called
database instance
click to copy
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called                              
referenced relation
click to copy

DBMS → Relational Model 2

In an Entity-Relationship Diagram “Ellipses” represents
attributes
click to copy
The              is the one in which the primary key of one relation is used as a normal attribute in another relation.
referenced relation
click to copy

DBMS → Normalization 2

In an Entity-Relationship Diagram “Diamonds” represents
relationship sets
click to copy
A                    integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
referential
click to copy

DBMS → Functional Dependency 2

Which algebra is widely used in DBMS?
relational algebra
click to copy
The           operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
join
click to copy

DBMS → SQL Basics 2

In DBMS FD stands for _______
functional dependency
click to copy
The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
cartesian product
click to copy

DBMS → DDL Commands 2

A relation that has no partial dependencies is in which normal form
second
click to copy
The               operation performs a set union of two “similarly structured” tables
union
click to copy

DBMS → DML Commands 2

A functional dependency between two or more non-key attributes is called
transitive dependency
click to copy
The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
select
click to copy