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 → Relational Model 3

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
In a Hierarchical model records are organized as
Tree.
click to copy

DBMS → Normalization 3

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
In an E-R diagram attributes are represented by
ellipse
click to copy

DBMS → Functional Dependency 3

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
In case of entity integrity, the primary key may be
not Null
click to copy

DBMS → SQL Basics 3

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
The language used in application programs to request data from the DBMS is referred to as the
DML
click to copy

DBMS → DDL Commands 2

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 2

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 2

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 2

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 is not a data definition language statement?
SELECT
click to copy
The subset of super key is a candidate key under what condition ?
Subset is a super key
click to copy

DBMS → Transactions 2

Which of the following is a comparison operator?
All of the above
click to copy
Which one of the following attribute can be taken as a primary key ?
Department
click to copy

DBMS → Concurrency Control 2

Which of the following consists of a row of column headings, together with zero or more rows of data values?
TABLE
click to copy
Which one of the following cannot be taken as a primary key ?
Street
click to copy

DBMS → Deadlock 2

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
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
Sub
click to copy

DBMS → Database Security 2

Which of the following database object does not physically exist?
View
click to copy
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called
Referenced relation
click to copy

DBMS → PL/SQL 2

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
The ______ is the one in which the primary key of one relation is used as a normal Attribute in another relation .
Referencing relation
click to copy

DBMS → Introduction to DBMS 2

Which of the following index is made up of more than one column?
Composite index
click to copy
Relations produced from an E-R model will always be in:
Third normal form
click to copy

DBMS → Database Architecture 2

Which of the following index can occur only one per table?
Unique index
click to copy
In ER model the details of the entities are hidden from the user. This process is called:
Abstraction
click to copy

DBMS → Data Models 2

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
‘AS’ clause is used in SQL for
Rename operation.
click to copy

DBMS → ER Model 2

What is the default order of Order by clause?
Ascending
click to copy
ODBC stands for
Open Database Connectivity
click to copy