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 Oracle RDBMS uses the           statement to declare a new transaction start and its properties.
set transaction
click to copy
If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
cannot be done
click to copy
Who developed the normalization process:
e.f. codd
click to copy

DBMS → Database Architecture 3

         means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
isolation
click to copy
Each modification done in database transaction are first recorded into the
log
click to copy
E.F.Codd developed the normalization process in the which early:
1970
click to copy

DBMS → Data Models 3

In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
create schema
click to copy
When the transaction finishes the final statement the transaction enters into
partially committed state
click to copy
Which is the process of breaking a relation into multiple relations:
decomposition
click to copy

DBMS → ER Model 3

In SQL, the CREATE TABLESPACE is used
to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
click to copy
The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called
opt. exe
click to copy
Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:
deadlock
click to copy

DBMS → Relational Model 2

Which character function can be used to return a specified portion of a character string?
substr
click to copy
Which of the following is an atomic sequence of database actions?
transaction
click to copy

DBMS → Normalization 2

Which of the following is TRUE for the System Variable $date$?
can be assigned to any field only during design time
click to copy
               means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
isolation
click to copy

DBMS → Functional Dependency 2

What are the different events in Triggers?
insert, update, delete
click to copy
Which of the following is not a state in transaction?
terminated
click to copy

DBMS → SQL Basics 2

Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?
data definition language
click to copy
                               joins are SQL server default
inner
click to copy

DBMS → DDL Commands 2

The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’),
2345
click to copy
The                                  is essentially used to search for patterns in target string.
like predicate
click to copy

DBMS → DML Commands 2

Which of the following SQL command can be used to modify existing data in a database table?
update
click to copy
                         is a combination of two of more attributes used as a primary key
composite key
click to copy

DBMS → Joins 2

                               provides option for entering SQL queries as execution time, rather than at the development stage.
dynamic sql
click to copy
Which of the following is not the function of client?
query optimization
click to copy

DBMS → Views 2

The storage structure which do not survive system crashes are              
volatile storage
click to copy
                         is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.
trigger
click to copy

DBMS → Indexes 2

For a transaction to be durable, its changes need to be written to                  storage.
stable storage
click to copy
                             requires that data should be made available to only authorized users.
security
click to copy

DBMS → Transactions 2

The unit of storage that can store one are more records in a hash file organization are
buckets
click to copy
                         allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.
curser
click to copy

DBMS → Concurrency Control 2

A              file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content.
cluster
click to copy
Which s essential a business problem not a data problem:
database design
click to copy

DBMS → Deadlock 2

A file produced by a spreadsheet
is generally stored on disk in an ascii text format
click to copy
McFadden has defined normalization in his which book                       
modern database management
click to copy

DBMS → Database Security 2

SDL means                            
storage definition language
click to copy
The database design prevents some data from being represented due to                
insertion anomalies
click to copy

DBMS → PL/SQL 2

The process of saving information onto secondary storage devices is referred to as
writing
click to copy
How many types of insertion anomalies:
2
click to copy