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 → DDL Commands 3

Which of the following is not a DCL statement?
Rollback
click to copy
Which of the following is IBM’s first RDBMS?
SQL/DS
click to copy
By relation cardinality we mean
number of relationships in which an entity can appear
click to copy

DBMS → DML Commands 3

Which of the following is the result of a select statement?
Table
click to copy
Which of the following company now known as the Oracle Corporation?
Relational Software Inc.
click to copy
If an entity appears in only one relationship then it is
a 1:1 relationship
click to copy

DBMS → Joins 3

Which of the following clause specifies the table or tables from where the data has to be retrieved?
From
click to copy
What is the process that is done to SQL before execution, to check for proper syntax and to optimize the request called?
Parsing
click to copy
In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
Parent
click to copy

DBMS → Views 3

How many tables can be joined to create a view?
1
click to copy
Which of the following is a valid SQL data type?
All of the above
click to copy
Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?
ID
click to copy

DBMS → Indexes 2

Which of the following can be used to get those items that fall within a range?
DISTINCT
click to copy
Which of the following is not a data definition language statement?
SELECT
click to copy

DBMS → Transactions 2

Which of the following constitutes a basic set of operations for manipulating relational data?
Relational algebra
click to copy
Which of the following is a comparison operator?
All of the above
click to copy

DBMS → Concurrency Control 2

Which of the following is not a relational algebraic operation that is not form the set theory?
SELECT
click to copy
Which of the following consists of a row of column headings, together with zero or more rows of data values?
TABLE
click to copy

DBMS → Deadlock 2

Which of the following is not a relational algebraic operation that is developed specifically for the relational databases?
UNION
click to copy
In which of the following cases will the RDBMS specify a default value for the column if there are no values for it?
NOT NULL UNIUE
click to copy

DBMS → Database Security 2

Which is the symbol used to denote the SELECT operation?
Sigma
click to copy
Which of the following database object does not physically exist?
View
click to copy

DBMS → PL/SQL 2

Which of the following operations need the participating relations to be union compatible?
All of the above
click to copy
Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
Index
click to copy

DBMS → Introduction to DBMS 2

What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?
12
click to copy
Which of the following index is made up of more than one column?
Composite index
click to copy

DBMS → Database Architecture 2

What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 20 rows respectively?
100
click to copy
Which of the following index can occur only one per table?
Unique index
click to copy

DBMS → Data Models 2

Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?
PROJECT
click to copy
Which question corresponds best to the following query? SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2
Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order.
click to copy

DBMS → ER Model 2

Which of the following is not a procedural language?
Relational calculus
click to copy
What is the default order of Order by clause?
Ascending
click to copy

DBMS → Relational Model 2

Who developed QBE?
M.M. Zloof
click to copy
View the Exhibit and examine the structure of the EMPLOYEES and DEPARTMENTS tables.<br>Which SET operator would you use in the blank space in the following SQL statement to list the departments where all the employees have managers?<br>SELECT department_id FROM departments ____ SELECT department_id FROM employees WHERE manager_id IS NULL;
MINUS
click to copy

DBMS → Normalization 2

What is the expansion of QBE?
Query by Example
click to copy
View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.
click to copy

DBMS → Functional Dependency 2

Who developed Structured English Query Language?
D. Chamberlain
click to copy
Which CREATE TABLE statement is valid?
CREATE TABLE ord_details (ord_no NUMBER(2), item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL, CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no));
click to copy

DBMS → SQL Basics 2

Which of the following is the first commercial RDBMS?
None of the above
click to copy
Pick entities from the following: I. vendor II. student III. attends IV. km/hour
i and ii
click to copy