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

The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into <br>employee1 (ID, name)<br>employee2 (name, street, city, salary) This type of decomposition is called
None of the mentioned
click to copy
Where is metadata stored in MySQL?
in the mysql database mysql
click to copy
Which of the following is true regarding Null Value?
null<>0
click to copy

DBMS → SQL Basics 3

Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under
Both Lossy and Lossy-join decomposition
click to copy
What MySQL property is used to create a surrogate key in MySQL?
auto_increment
click to copy
Logical design of database is called
database schema
click to copy

DBMS → DDL Commands 3

There are two functional dependencies with the same set of attributes on the left side of the arrow:<br>A->BC A->B <br> This can be combined as
A->BC
click to copy
A Database Management System (DBMS) is:
all options are correct
click to copy
Snapshot of the data in the database at a given instant of time is called
database instance
click to copy

DBMS → DML Commands 3

Consider a relation R(A,B,C,D,E) with the following functional dependencies:<br>ABC -> DE and<br>D -> AB The number of superkeys of R is:
10
click to copy
Which of the following is not a level of data abstraction?
critical level
click to copy
Which of the following is not Unary operation?
union
click to copy

DBMS → Joins 2

Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?
Both I and II
click to copy
Disadvantages of File systems to store data is:
all options are correct
click to copy

DBMS → Views 2

Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively<br>(again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
0 <= m <= min(r,s)
click to copy
In an Entity Relationship Diagram Rectangles represents
entity sets
click to copy

DBMS → Indexes 2

Which of the following is not a key?
B, C
click to copy
Which of the following is not a Storage Manager Component?
logical manager
click to copy

DBMS → Transactions 2

If a relation is in BCNF, then it is also in
All of the above
click to copy
Data Manipulation Language enables users to
all the options are correct
click to copy

DBMS → Concurrency Control 2

The____condition allows a general predicate over the relations being joined.
On
click to copy
Which of the following is not an Schema?
critical schema
click to copy

DBMS → Deadlock 2

Which of the join operations do not preserve non matched tuples?
Right outer join
click to copy
Which of the following is Database Language?
all of the options
click to copy

DBMS → Database Security 2

The normal form which satisfies multivalued dependencies and which is in BCNF is
4 NF
click to copy
Which of the following in not a function of DBA?
network maintenance
click to copy

DBMS → PL/SQL 2

Which of the following is a tuple-generating dependencies?
Equality-generating dependencies
click to copy
A Database Management System (DBMS) is
all of the options
click to copy

DBMS → Introduction to DBMS 2

The main task carried out in the __________ is to remove repeating attributes to separate tables.
First Normal Form
click to copy
Column header is refer as
attributes
click to copy

DBMS → Database Architecture 2

Which forms has a relation that possesses data about an individual entity?
3NF
click to copy
_______ allow us to identify uniquely a tuple in the relation.
superkey
click to copy

DBMS → Data Models 2

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
A many-to-many relationship set
click to copy
Minimal Superkeys are called
candidate keys
click to copy

DBMS → ER Model 2

Fifth Normal form is concerned with
Multivalued dependency
click to copy
Which of the following is not Modification of the Database
sorting
click to copy

DBMS → Relational Model 2

n which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
A multivalued attribute of an entity set
click to copy
Which of the following in not Outer join?
all of the options
click to copy

DBMS → Normalization 2

In 2NF
No multivalued dependencies (MVDs) exist
click to copy
Set of premitted values of each attribute is called
domain
click to copy