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 → Joins 3

Which of the following is not binary operation?
project
click to copy
How many types of keys in Database Design?
all of the options
click to copy
The function of a database is ...
to collect and organize input data
click to copy

DBMS → Views 3

Which of the following is correct regarding Aggregate functions?
it takes a list of values and return a single values as result
click to copy
Which of the following is based on Multi Valued Dependency?
fourth
click to copy
A command that lets you change one or more fields in a record is
modify
click to copy

DBMS → Indexes 3

The Primary key must be
option a and b
click to copy
Which of the following is the structure of the Database?
schema
click to copy
What is the language used by most of the DBMSs for helping their users to access data?
query language
click to copy

DBMS → Transactions 3

A command to remove a relation from an SQL database
drop table
click to copy
The minimal set of super key is called
candidate key
click to copy
Information can be transferred between the DBMS and a
all of the options
click to copy

DBMS → Concurrency Control 2

which of the following is not an Aggregate function?
select
click to copy
______________ is a classical approach to database design?
top – down approach
click to copy

DBMS → Deadlock 2

The attribute that can be divided into other attributes is called
composite attribute
click to copy
_____________ refers to the correctness and completeness of the data in a database?
data integrity
click to copy

DBMS → Database Security 2

What is ACID properties of Transactions?
atomicity, consistency, isolation, durability
click to copy
A table that displays data redundancies yields ____________ anomalies
all of the options
click to copy

DBMS → PL/SQL 2

If every non-key attribute is functionally dependent on the primary key, the relation will be in
third normal form
click to copy
A lock that allows concurrent transactions to access different rows of the same table is known as a
field-level lock
click to copy

DBMS → Introduction to DBMS 2

Database locking concept is used to solve the problem of
all of the options
click to copy
A type of query that is placed within a WHERE or HAVING clause of another query is called
sub query
click to copy

DBMS → Database Architecture 2

UML is stands for
unified modeling language
click to copy
A form defined
where data is placed on the screen
click to copy

DBMS → Data Models 2

Data Manipulation Language (DML) is not to
create information table in the database
click to copy
Which of the following is a problem of file management system?
all of the options
click to copy

DBMS → ER Model 2

Which of the following in true regarding Referential Integrity?
every foreign-key value must match a primary-key value in an associated table
click to copy
Which of the following is not an advantage of the database approach
all of the above
click to copy

DBMS → Relational Model 2

Which of the following option is use to retrieval of data?
query
click to copy
An audit trail
is the recorded history of operations performed on a file
click to copy

DBMS → Normalization 2

ODBC stands for ______
open database connection
click to copy
One approach to standardization storing of data?
codasyl specification
click to copy

DBMS → Functional Dependency 2

Which of the following is an unary operation?
generalized selection
click to copy
Report generators are used to
both retrieve information from files and answer queries
click to copy

DBMS → SQL Basics 2

Which SQL Query is use to remove a table and all its data from the database?
drop table
click to copy
Which of the following is true of a network structure?
it allows a many-to-many relationship
click to copy

DBMS → DDL Commands 2

In precedence of set operators the expression is evaluated from:
left to right
click to copy
A record management system
can be used to extract information stored in a computer file
click to copy

DBMS → DML Commands 2

In DBMS, FD stands for _______
functional dependency
click to copy
One data dictionery software package is called
db/dc dictionary
click to copy