Query MCQs
Showing 18 questions (Total: 18)
In SQL, the ___ command is used to recompile a view.
Correct Answer:
C: ALTER VIEW
Which tool could be used for detecting vulnerability through SQl Injection?
Correct Answer:
C: bit defender
Explanation:
Which tool could be used for detecting vulnerability through SQl Injection? Correct Answer bit defender SQL injection is one of the most common attacks against web applications. This is used against websites which use SQL to query data from the database server. Bitdefender এক ধরনের এন্টিভাইরাস সফটওয়্যার যার মাধ্যমে SQL Injection রোধ করা যেতে পারে।
The result of a SQL SELECT statement is a __ .
Correct Answer:
D: table
Explanation:
The result of a SQL SELECT statement is a __ . Correct Answer table The SQL SELECT statement returns a result set of records from one or more tables. A SELECT statement retrieves zero or more rows from one or more database tables or database views. ... As SQL is a declarative programming language, SELECT queries specify a result set, but do not specify how to calculate it.
To remove duplicate rows from the results of an SQL SELECT statement , the __ qualifier specified must be included.
Correct Answer:
B: DISTINCT
Explanation:
To remove duplicate rows from the results of an SQL SELECT statement , the __ qualifier specified must be included. Correct Answer DISTINCT The SQL DISTINCT keyword is used in conjunction with the SELECT statement to eliminate all the duplicate records and fetching only unique records. There may be a situation when you have multiple duplicate records in a table. While fetching such records, it makes more sense to fetch only those unique records instead of fetching duplicate records. Syntax The basic syntax of DISTINCT keyword to eliminate the duplicate records is as follows − SELECT DISTINCT column1, column2,.....columnN FROM table_name WHERE [condition]
which data structure is used for indexing
Correct Answer:
C: stack
Explanation:
which data structure is used for indexing Correct Answer stack The data structure most commonly used for database indexes are B - trees, a specific kind of self - balancing tree. A picture's worth a thousand words, so here's an example. The main benefit of a B - tree is that it allows logarithmic selections, insertions, and deletions in the worst case scenario.
The term push and pop is related to the
Correct Answer:
C: stacks
Explanation:
The term push and pop is related to the Correct Answer stacks Considered as a linear data structure, or more abstractly a sequential collection, the push and pop operations occur only at one end of the structure, referred to as the top of the stack. This data structure makes it possible to implement a stack as a singly linked list and a pointer to the top element.
Dark data represents __
Correct Answer:
A: Unused data
Explanation:
Dark data represents __ Correct Answer Unused data Dark data is data which is acquired through various computer network operations but not used in any manner to derive insights or for decision making. The ability of an organisation to collect data can exceed the throughput at which it can analyse the data. In some cases the organisation may not even be aware that the data is being collected. IBM estimate that roughly 90 percent of data generated by sensors and analog - to - digital conversions never get used.
All of the following logical connectives are included in SQL except.
Correct Answer:
C: nor
The _______clause is used to list the attributes desired in the result of a query.
Correct Answer:
B: select
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.
Correct Answer:
D: Group by, where
The data structure required to check whether an expression contains balanced parenthesis is?
Correct Answer:
A: Stack
Explanation:
The data structure required to check whether an expression contains balanced parenthesis is? Correct Answer Stack The data structure required to check whether an expression contains balanced parenthesis is a stack. This is a simple data structure in which elements can be added and removed in a specific order. In other words, it follows a LIFO or a FILO structure.
When is linear search used/
Correct Answer:
D: When list has only a few elements and when performing a single search in an underdone ist
Flat file data bases are most useful for......
Correct Answer:
C: Small group situation
Last- In First -Out (LIFO) data structure কোনটি?
Correct Answer:
B: Stack
Hill Climbing search এর প্রধান সমস্যা কোনটি?
Correct Answer:
ক: Local Maxima
Array date structure এ কোন ধরনের data রাখা যায়?
Correct Answer:
ক: একই ধরনের অনেকগুলো data
নিচের কোনটি Structured Query Language নয়?
Correct Answer:
ক: Java
Explanation:
নিচের কোনটি Structured Query Language নয়? সঠিক উত্তর Java SQL কে আমরা Structured Query Language বলি। সাধারণত আমরা একে সংক্ষেপে SQL বলি। তথ্যভান্ডারের সঙ্গে যোগাযোগ করতে এসকিউএল ব্যবহার করা হয়। ডেটাবেসের বেশিরভাগ কাজ এসকিউয়েল স্টেটমেন্ট এর দ্বারা করা যায়।
Max- Heap data structure এর সবচেয়ে বড় নম্বরটি কোথায় থাকে?
Correct Answer:
গ: Root