HARD
HSSC Clerk
IMPORTANT
Earn 100

Implicit and Explicit cursor has attribute

50% studentsanswered this correctly

Important Questions on Practice Sets

HARD
HSSC Clerk
IMPORTANT
Professional Knowledge for IBPS & SBI Specialist IT Officer Exam>Chapter 16 - Practice Sets>PRACTICE SET - 15>Q 4
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
HARD
HSSC Clerk
IMPORTANT
Professional Knowledge for IBPS & SBI Specialist IT Officer Exam>Chapter 16 - Practice Sets>PRACTICE SET - 15>Q 5
Suppose a relation R is in three NF. Then an FD: X → A is not valid on R, if:
I. X is a proper subset of some keys.
II. X is not a proper subset of any key.
III. X is a key.
IV A is part of some key.
MEDIUM
HSSC Clerk
IMPORTANT
Professional Knowledge for IBPS & SBI Specialist IT Officer Exam>Chapter 16 - Practice Sets>PRACTICE SET - 15>Q 6
In SQL, which of the following is not a data Definition Language Command?
MEDIUM
HSSC Clerk
IMPORTANT
Professional Knowledge for IBPS & SBI Specialist IT Officer Exam>Chapter 16 - Practice Sets>PRACTICE SET - 15>Q 7
A relation is said to be in 1NF when
MEDIUM
HSSC Clerk
IMPORTANT
Professional Knowledge for IBPS & SBI Specialist IT Officer Exam>Chapter 16 - Practice Sets>PRACTICE SET - 15>Q 8
A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by _____.
HARD
HSSC Clerk
IMPORTANT
Professional Knowledge for IBPS & SBI Specialist IT Officer Exam>Chapter 16 - Practice Sets>PRACTICE SET - 15>Q 9
If the same object name is given to different objects of different classes, then _____.
HARD
HSSC Clerk
IMPORTANT
Professional Knowledge for IBPS & SBI Specialist IT Officer Exam>Chapter 16 - Practice Sets>PRACTICE SET - 15>Q 10
A processor that continuously tries to acquire locks, spinning around a loop till it reaches its success, is known as _____.
HARD
HSSC Clerk
IMPORTANT
Professional Knowledge for IBPS & SBI Specialist IT Officer Exam>Chapter 16 - Practice Sets>PRACTICE SET - 15>Q 11
The lexical analysis for a modern computer language such as Java needs the power of which one of the following machine models in a necessary and sufficient sense?