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 2

Changing cardinalities in a database is:
a common database design task.
click to copy
In the relational modes, cardinality is termed as:
Number of tuples.
click to copy

DBMS → SQL Basics 2

Which one of the following sorts rows in SQL?
ORDER BY
click to copy
Relational calculus is a
Non- Procedural language.
click to copy

DBMS → DDL Commands 2

The SQL keyword(s) ________ is used with wildcards.
LIKE only
click to copy
In a relational database a referential integrity constraint can be specified with the help of
foreign key
click to copy

DBMS → DML Commands 2

If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
the primary key
click to copy
A super key is a set of one or more attributes that, taken collectively, allow us
to identify uniquely an entity in the entity set
click to copy

DBMS → Joins 2

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Six
click to copy
4NF is designed to cope with:
Multi valued dependency
click to copy

DBMS → Views 2

In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
To see the errors, enter SHOW ERRORS in SQL*Plus.
click to copy
A relational database developer refers to a record as
a tuple.
click to copy

DBMS → Indexes 2

Which of the following is not true about indexes?
Indexes are created with the ALTER TABLE command.
click to copy
The relational model feature is that there
is much more data independence than some other database models.
click to copy

DBMS → Transactions 2

In ……….. normal forms, any multivalued attributes have been removed.
First
click to copy
SET concept is used in :
Network Model
click to copy

DBMS → Concurrency Control 2

A (n) …………….. is an attribute in a relation that serves as a primary key of another relation in the same.
Identifier key
click to copy
Relational Algebra is
Procedural query Language
click to copy

DBMS → Deadlock 1

In the process of decomposition is called as
Normalization
click to copy

DBMS → Database Security 1

A relation Schema R is in ……….. if it is in 3NF and satisfies an additional constant thatfor every FD X->A. X must be a candidate key.
BCNF
click to copy

DBMS → PL/SQL 1

A relation between 2 set of attributes is called as
Functional Dependency
click to copy

DBMS → Introduction to DBMS 14

In 1NF, the value of the attribute must be
Null
click to copy
Which best describes the impedance mismatch problem?
Mismatch between data structures of programming languages and the relational model
click to copy
In three-schema architecture which layer provides logical independence?
Conceptual schema
click to copy
Which is NOT a property of ACID transactions?
Concurrency
click to copy
What is the primary difference between a data warehouse and a traditional DBMS?
Data warehouses are optimized for analytical read-heavy workloads; DBMS for transactional write-heavy workloads
click to copy
Which catalog component stores metadata about tables, views, and indexes?
System catalog / Metadata repository
click to copy
Data abstraction in DBMS provides which primary advantage?
Shielding users from physical storage complexity while maintaining logical clarity
click to copy
Which correctly describes the difference between DDL and DML?
DDL defines schema structure; DML retrieves and manipulates data
click to copy
Physical data independence in DBMS means:
Ability to change internal/physical schema without changing the conceptual schema
click to copy
Who is responsible for defining the conceptual schema?
Database Administrator (DBA)
click to copy
A view in DBMS primarily provides which level of abstraction?
View/External level
click to copy
Which is a disadvantage of file-based systems compared to DBMS?
Data redundancy and inconsistency
click to copy
The closed world assumption in DBMS means:
Any data not stored is assumed to be false/non-existent
click to copy
Which best defines data integrity in DBMS?
Ensuring accuracy, consistency, and validity of data throughout its lifecycle
click to copy

DBMS → Database Architecture 1

The process of Normalization is
Iterative
click to copy

DBMS → Data Models 1

Which normal form is most desirable ?
3 NF
click to copy

DBMS → ER Model 1

A functional dependency is a relationship between
Attributes
click to copy

DBMS → Relational Model 1

Two or more attributes that can be a key are called :
Composite key
click to copy

DBMS → Normalization 1

Cartesian product in relational algebra is
a Binary operator.
click to copy