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 following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID?
Equi-join
click to copy
Functional Dependencies are the types of constraints that are based on______
Key
click to copy
The normal form which satisfies multivalued dependencies and which is in BCNF is
4 NF
click to copy

DBMS → PL/SQL 3

A UNION query is which of the following?
Combines the output from multiple queries and must include the same number of columns
click to copy
Which is a bottom-up approach to database design that design by examining the relationship between attributes:
Normalization
click to copy
Which of the following is a tuple-generating dependencies?
Equality-generating dependencies
click to copy

DBMS → Introduction to DBMS 3

Which of the following statements is true concerning subqueries?
Involves the use of an inner and outer query
click to copy
Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:
3NF
click to copy
The main task carried out in the __________ is to remove repeating attributes to separate tables.
First Normal Form
click to copy

DBMS → Database Architecture 3

Which of the following is a correlated subquery?
Uses the result of an inner query to determine the processing of an outer query
click to copy
Which forms has a relation that possesses data about an individual entity:
4NF
click to copy
Which forms has a relation that possesses data about an individual entity?
3NF
click to copy

DBMS → Data Models 2

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T?
Cartesian join
click to copy
Which forms are based on the concept of functional dependency:
3NF
click to copy

DBMS → ER Model 2

Which is not a type of join in T-SQL?
Natural join
click to copy
Empdt1(empcode, name, street, city, state, pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
2 NF and hence also in 1 NF
click to copy

DBMS → Relational Model 2

What is a view?
A view is a virtual table which results of executing a pre-compiled query
click to copy
We can use the following three rules to find logically implied functional dependencies. This collection of rules is called
Armstrong’s axioms
click to copy

DBMS → Normalization 2

Which of the following is not a limitation of view?
Index Created on View Used Often
click to copy
Which of the following is not Armstrong’s Axiom?
Pseudotransitivity rule
click to copy

DBMS → Functional Dependency 2

SQL Server has mainly how many types of views?
two
click to copy
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

DBMS → SQL Basics 2

Dynamic Management View is a type of ___________
System Defined Views
click to copy
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

DBMS → DDL Commands 2

Syntax for creating views is __________
CREATE VIEW AS SELECT
click to copy
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

DBMS → DML Commands 2

You can delete a view with ___________ command.
DROP VIEW
click to copy
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

DBMS → Joins 2

What is SCHEMABINDING a VIEW?
These are stored only in the Master database
click to copy
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

DBMS → Views 2

Which of the following is not a SQL Server INFORMATION_SCHEMA view?
sys.dm_exec_connections
click to copy
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

DBMS → Indexes 2

___________ is stored only in the Master database.
None of the mentioned
click to copy
Which of the following is not a key?
B, C
click to copy

DBMS → Transactions 2

In the __________ normal form, a composite attribute is converted to individual attributes.
First
click to copy
If a relation is in BCNF, then it is also in
All of the above
click to copy

DBMS → Concurrency Control 2

Tables in second normal form (2NF):
Eliminate all hidden dependencies
click to copy
The____condition allows a general predicate over the relations being joined.
On
click to copy

DBMS → Deadlock 2

Which-one ofthe following statements about normal forms is FALSE?
Loss less, dependency – preserving decomposition into BCNF is always possible
click to copy
Which of the join operations do not preserve non matched tuples?
Right outer join
click to copy