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

The granularity of a database item can be chosen to be
All of the above.
click to copy
A 3 NF relation is converted to BCNF by
dependent attributes of overlapping composite keys are put in a separateRelation
click to copy
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 3

If the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called:
Consistency preservation
click to copy
BCNF is needed because
when there is dependent attributes in two possible composite keys one of the attributes is unnecessarily duplicated in the tuples
click to copy
A relation between 2 set of attributes is called as
Functional Dependency
click to copy

DBMS → Introduction to DBMS 3

Which of the following is not the state that the transaction undergoes?
Non active
click to copy
Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
i and iii
click to copy
In 1NF, the value of the attribute must be
Null
click to copy

DBMS → Database Architecture 3

Timestamp can be generated by:
Both (a) and (b)
click to copy
A relation project guidance Project Guidance(professor, project, student no. st-name, dept) A professor can give many projects to many students A project will have many students A project may be guided by many professors The 4 NF relation corresponding to this are
Prof_stud (professor, student no) Proj_stud (project, student no)
click to copy
The process of Normalization is
Iterative
click to copy

DBMS → Data Models 2

Which of the following is the formal process for deciding which attributes should be grouped together in a relation?
Normalization
click to copy
A 3 NF relation is split into 4 NF
by splitting into relations which do not have more than one independent multi valued dependency
click to copy

DBMS → ER Model 2

Who developed normalization process?
E.F. Codd
click to copy
Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
The inconsistent values problem
click to copy

DBMS → Relational Model 2

Who developed the BCNF?
Boyce and Codd
click to copy
What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
click to copy

DBMS → Normalization 2

What is the expansion of BCNF?
Boyce-Codd Normal Form
click to copy
The NOT EXISTS keyword will be true if:
all rows in the subquery fail the condition.
click to copy

DBMS → Functional Dependency 2

Which of the following is the result of a transitive dependency?
All of the above
click to copy
Changing cardinalities in a database is:
a common database design task.
click to copy

DBMS → SQL Basics 2

How many inference rules are there for functional dependencies?
6
click to copy
Which one of the following sorts rows in SQL?
ORDER BY
click to copy

DBMS → DDL Commands 2

Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?
Dependency preservation property
click to copy
The SQL keyword(s) ________ is used with wildcards.
LIKE only
click to copy

DBMS → DML Commands 2

Every relation in BCNF is also in
3NF
click to copy
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

DBMS → Joins 2

A table that contains one or more repeating groups is in which normal form?
Unnormalized Form
click to copy
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Six
click to copy

DBMS → Views 2

A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency
i and ii
click to copy
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

DBMS → Indexes 2

Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address)
non-key attributes course no and course max. marks are functionally dependent
click to copy
Which of the following is not true about indexes?
Indexes are created with the ALTER TABLE command.
click to copy

DBMS → Transactions 2

Given the following relation Student (roll no, name, course no, course max. marks, year of study, address) The corresponding 3 NF relations are
student ( roll no, name, year of study, address) student (roll no, course no) course (course no, course max. marks)
click to copy
In ……….. normal forms, any multivalued attributes have been removed.
First
click to copy

DBMS → Concurrency Control 2

BoyeCodd Normal Form (BCNF) is needed when
there are two or more possible composite overlapping keys and one attributeof a composite key is dependent on an attribute of another composite key
click to copy
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

DBMS → Deadlock 2

A relation is said to be in BCNF when
it has no overlapping composite keys which have related attributes
click to copy
In the process of decomposition is called as
Normalization
click to copy