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 → Data Models 3

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
click to copy
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 3

Which of the following command makes the updates performed by the transaction permanent in the database?
COMMIT
click to copy
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 3

Which TCL command undo all the updates performed by the SQL in the transaction?
ROLLBACK
click to copy
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 3

SQL query to find all the cities whose humidity is 95.
SELECT city FROM weather WHERE humidity = 95
click to copy
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 query to find the temperature in increasing order of all cities.
SELECT city, temperature FROM weather ORDER BY city
click to copy
SQL Server has mainly how many types of views?
two
click to copy

DBMS → SQL Basics 2

What is the meaning of LIKE ‘%0%0%’?
Feature has two 0’s in it, at any position
click to copy
Dynamic Management View is a type of ___________
System Defined Views
click to copy

DBMS → DDL Commands 2

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.
SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
click to copy
Syntax for creating views is __________
CREATE VIEW AS SELECT
click to copy

DBMS → DML Commands 2

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
click to copy
You can delete a view with ___________ command.
DROP VIEW
click to copy

DBMS → Joins 2

Find all the tuples having a temperature greater than ‘Paris’.
SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’
click to copy
What is SCHEMABINDING a VIEW?
These are stored only in the Master database
click to copy

DBMS → Views 2

Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.
SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
click to copy
Which of the following is not a SQL Server INFORMATION_SCHEMA view?
sys.dm_exec_connections
click to copy

DBMS → Indexes 2

The command to remove rows from a table ‘CUSTOMER’ is __________________
DELETE FROM CUSTOMER WHERE
click to copy
___________ is stored only in the Master database.
None of the mentioned
click to copy

DBMS → Transactions 2

What type of join is needed when you wish to include rows that do not have matching values?
Outer join
click to copy
In the __________ normal form, a composite attribute is converted to individual attributes.
First
click to copy

DBMS → Concurrency Control 2

What type of join is needed when you wish to return rows that do have matching values?
All of the Mentioned
click to copy
Tables in second normal form (2NF):
Eliminate all hidden dependencies
click to copy

DBMS → Deadlock 2

Which of the following is one of the basic approaches for joining tables?
All of the Mentioned
click to copy
Which-one ofthe following statements about normal forms is FALSE?
Loss less, dependency – preserving decomposition into BCNF is always possible
click to copy

DBMS → Database Security 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 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

DBMS → PL/SQL 2

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

DBMS → Introduction to DBMS 2

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

DBMS → Database Architecture 2

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