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

A line of PL/SQL text contains groups of characters known as
lexical units
click to copy
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 3

We use                              name PL/SQL program objects and units.
identifiers
click to copy
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 3

A                                        is an explicit numeric, character, string or Boolean value not represented by an identifier.
literals
click to copy
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 3

If no header is specified, the block is said to be an                                PL/SQL block.
anonymous
click to copy
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

                                   is a sequence of zero or more characters enclosed by single quotes.
string literal
click to copy
The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’),
2345
click to copy

DBMS → DML Commands 2

In                                the management of the password for the account can be handled outside of oracle such as operating system.
operating system authentication
click to copy
Which of the following SQL command can be used to modify existing data in a database table?
update
click to copy

DBMS → Joins 2

In                                  of Oracle, the database administrator creates a user account in the database for each user who needs access.
database authentication
click to copy
                               provides option for entering SQL queries as execution time, rather than at the development stage.
dynamic sql
click to copy

DBMS → Views 2

Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?
both 1 and 2 individually
click to copy
The storage structure which do not survive system crashes are              
volatile storage
click to copy

DBMS → Indexes 2

A transaction is delimited by statements (or function calls) of the form                      
begin transaction and end transaction
click to copy
For a transaction to be durable, its changes need to be written to                  storage.
stable storage
click to copy

DBMS → Transactions 2

Identify the characteristics of transactions
all of the mentioned
click to copy
The unit of storage that can store one are more records in a hash file organization are
buckets
click to copy

DBMS → Concurrency Control 2

Which of the following has “all-or-none” property?
atomicity
click to copy
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

DBMS → Deadlock 2

The property of a transaction that persists all the crashes is
durability
click to copy
A file produced by a spreadsheet
is generally stored on disk in an ascii text format
click to copy

DBMS → Database Security 2

                     states that only valid data will be written to the database.
consistency
click to copy
SDL means                            
storage definition language
click to copy

DBMS → PL/SQL 2

Transaction processing is associated with everything below except
confirming an action or triggering a response
click to copy
The process of saving information onto secondary storage devices is referred to as
writing
click to copy

DBMS → Introduction to DBMS 2

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

DBMS → Database Architecture 2

         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

DBMS → Data Models 2

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

DBMS → ER Model 2

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