Query MCQs

Showing 18 questions (Total: 18)

Janata Bank Ltd #1

In SQL, the ___ command is used to recompile a view.

A: COMPILE VIEW
B: DEFINE VIEW
C: ALTER VIEW
D: CREATE VIEW
Janata Bank Ltd #2

Which tool could be used for detecting vulnerability through SQl Injection?

A: minap
B: metasloit
C: bit defender
D: UML
Combined Bank #3

The result of a SQL SELECT statement is a __ .

A: report
B: form
C: file
D: table
Combined Bank #4

To remove duplicate rows from the results of an SQL SELECT statement , the __ qualifier specified must be included.

A: ONLY
B: DISTINCT
C: UNIQUE
D: SINGLE
Combined Bank #5

which data structure is used for indexing

A: Binary Tree
B: B-Tree
C: stack
D: Link list
Combined Bank #6

The term push and pop is related to the

A: array
B: lists
C: stacks
D: All of these
Combined Bank #7

Dark data represents __

A: Unused data
B: Harmful data
C: Highlighted data
D: Important data
Combined Bank #8

All of the following logical connectives are included in SQL except.

A: and
B: or
C: nor
D: not
Sonali Bank Ltd #9

The _______clause is used to list the attributes desired in the result of a query.

A: Where
B: select
C: From
D: Distint
Sonali Bank Ltd #10

In SQL_____, aggregate function can be used in the select list or the _____clause of a select statement of sub query. They cannot be used in a _____clause.

A: where, having
B: having, where
C: Group by, having
D: Group by, where
Sonali Bank Ltd #11

The data structure required to check whether an expression contains balanced parenthesis is?

A: Stack
B: Queue
C: Array
D: Tree
Sonali Bank Ltd #12

When is linear search used/

A: When the list has only a few elements
B: When performing a single earch in an unordered list
C: Used all the time
D: When list has only a few elements and when performing a single search in an underdone ist
Combined Bank #13

Flat file data bases are most useful for......

A: Large scale uses
B: Banking
C: Small group situation
D: Chain stores
Government Job and Other Recruitment Exams #14

Last- In First -Out (LIFO) data structure কোনটি?

A: Queue
B: Stack
C: File
D: কোনোটি নয়
Government Job and Other Recruitment Exams #15

Hill Climbing search এর প্রধান সমস্যা কোনটি?

ক: Local Maxima
খ: Infinite Loop
গ: No Solution
ঘ: Slowness
Government Job and Other Recruitment Exams #16

Array date structure এ কোন ধরনের data রাখা যায়?

ক: একই ধরনের অনেকগুলো data
খ: বিভিন্ন ধরনের data
গ: শুধু printer ধরনের data
ঘ: Class এর data
44th BCS Preliminary Test #17

নিচের কোনটি Structured Query Language নয়?

ক: Java
খ: MySQL
গ: Oracle
ঘ: উপরের সবগুলো
Government Job and Other Recruitment Exams #18

Max- Heap data structure এর সবচেয়ে বড় নম্বরটি কোথায় থাকে?

ক: Leaf
খ: Internal node
গ: Root
ঘ: Outside
← Previous Page 1 of 1 Next →