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 → Introduction to DBMS 3

The three basic techniques to control deadlocks are: deadlock ____, deadlock detection, and deadlock avoidance.
prevention
click to copy
Which of the following is related to information?
Data
click to copy
Which of the following is an object-oriented feature?
Abstraction
click to copy

DBMS → Database Architecture 3

All transactions are controlled and executed by the DBMS (subject to some limitations) to guarantee database ____.
integrity
click to copy
Data is:
A piece of fact
click to copy
A physical data models are used to
All of these
click to copy

DBMS → Data Models 3

In a ____ lock, the DBMS will lock an entire disk page.
page-level
click to copy
Which of the following is element of the database?
All of these.
click to copy
Which data model organizes the data in the form of tables and relations?
Relational Model
click to copy

DBMS → ER Model 3

According to the ANSI SQL standard, when does a transaction begin?
when the first SQL statement is encountered
click to copy
What represent a correspondence between the various data elements?
Relationships
click to copy
Which company has developed the hierarchical model?
IBM
click to copy

DBMS → Relational Model 2

The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
field-level
click to copy
Which of the following is an advantage of using database system?
All of these.
click to copy

DBMS → Normalization 2

What is ACID properties
All of the above
click to copy
Which of the following is characteristic of the data in a database?
All of these.
click to copy

DBMS → Functional Dependency 2

Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other:
Concurrency
click to copy
Relationships could be of the following type:
All of these.
click to copy

DBMS → SQL Basics 2

Which is a duplicate copy of a file program that is stored on a different storage media than the original location:
Backup
click to copy
In a file-oriented system there is:
Al of these.
click to copy

DBMS → DDL Commands 2

............... joins are SQL server default
Inner
click to copy
In a database system there is:
All of these.
click to copy

DBMS → DML Commands 2

The ..................... is essentially used to search for patterns in target string.
Like Predicate
click to copy
VDL is used to specify:
None of these.
click to copy

DBMS → Joins 2

................. requires that data should be made available to only authorized users.
Security
click to copy
The DML provides following functional access to the database:
Add (or insert) records
click to copy

DBMS → Views 2

.............. is a combination of two of more attributes used as a primary key
Composite Key
click to copy
4GL has the following components inbuilt in it:
All of these.
click to copy

DBMS → Indexes 2

To delete a database ................... command is used
drop database database_name
click to copy
Which of the following is database element?
All of these.
click to copy

DBMS → Transactions 2

Some of the utilities of DBMS are ............. i) Transaction ii) Backup iii) File organization iv) Process Organization
ii, iii and iv only
click to copy
What separates the physical aspects of data storage from the logical aspects of data representation?
Relationships
click to copy

DBMS → Concurrency Control 2

There are _________ number of Normal forms that has been defined
6
click to copy
What scheme defines how and where the data are organized in a physical data storage?
External
click to copy

DBMS → Deadlock 2

Which is relation calculus:
Both
click to copy
Which of the following schemas defines the stored data structures in terms of the database model used?
Conceptual
click to copy

DBMS → Database Security 2

Which calculus is based on specifying a number of tuple variables:
Tuple relation calculus
click to copy
Which of the following schemas defines a view or views of the database for particular users?
Conceptual
click to copy

DBMS → PL/SQL 2

SQL outputs a single table known as the ______:
Result set
click to copy
A collection of data designed to be used by different people is called.
Database
click to copy