Search Your Question...!

Cassandra Brass Track MCQ's

1. Which among the following is a NoSQL db?

   View Answer   

   All of the Option



2. Cassandra is a __________ architecture.

   View Answer   

   Peer to Peer



3. What is meant by 'Active everywhere design'?

   View Answer   

   All nodes can be written to and read from



4. Which of the following statements about NoSQL databases is true?

   View Answer   

   Support unstructured data



5. Cassandra is not suitable for IoT applications.

   View Answer   

   False



Power ISO 5 Free Download + Serial Key

PowerISO is a powerful CD / DVD / BD image file processing tool, which allows you to open, extract, burn, create, edit, compress, encrypt, split and convert ISO files, and mount ISO files with internal virtual drive. It can process almost all CD / DVD / BD image files including ISO and BIN files.

Power iso

NoSQL - Database Revolution MCQ's

1. Hbase main server components include all except _

   View Answer   

   Hbase Memstore



2. In column-oriented stores, data is stored on a basis.

   View Answer   

   Column Family 



3. In Hbase, 'Columns' are named and specified in table definition. 

   View Answer   

   False



4. HBase Tables are divided _ by row key range into .

   View Answer   

   horizontally - regions 



5. Columnar databases are preferable for OLTP systems.

   View Answer   

   False 



SQL Interview Questions -1

 1. Explain about your SQL Server DBA Experience.

§  This is a generic question often asked by many interviewers. Explain what are the different SQL Server Versions you have worked on, what kind of administration of those instances has been done by you. Your role and responsibilities carried out in your earlier projects that would be of significance to the potential employer. This is the answer that lets the interviewer know how suitable are you for the position to which you are being interviewed.

2. What are the different SQL Server Versions you have worked on?

§  The answer would be depending on the versions you have worked on, I would say I have experience working in SQL Server 7, SQL Server 2000, 2005 and 2008. If you have worked only the some version be honest in saying that, remember, no one would be working on all versions, it varies from individual to individual.

3. What are the different types of Indexes available in SQL Server?

§  The simplest answer to this is “Clustered and Non-Clustered Indexes”. There are other types of Indexes what can be mentioned such as Unique, XML, Spatial and Filtered Indexes. More on these Indexes later.

Kibana - Data Exquisites MCQ's

1. Is it necessary to use curl command while querying in Kibana?

a) Yes, it is necessary.
b) No, not necessary.
   View Answer   

   No, not necessary



2. Default location to run Kibana is _.

a) localhost:0000
b) localhost:8888
c) localhost:5601
d) localhost:5602

   View Answer   

   localhost:5601



3. If Elasticsearch is not visible via Kibana, what could be the problem?

a) url should match to localhost:9200 if it has not been changed manually
b) Both of these
c) None of these
d) elasticsearch.url is not set correct

   View Answer   

   Both of these



4. What can be created with the help of Kibana?

a) Histograms
b) Line Graphs
c) All of these
d) Pie Charts

   View Answer   

   All of these



5. Kibana is an independent tool nothing to do with ELK stack.

a) True
b) False
   View Answer   

   False



What is DBMS?

A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.

A database is an organized collection of data. It is the collection of schemes, tables, queries, reports, views and other objects. The data is typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase and IBM DB2. A database is not generally portable across different DBMSs, but different DBMS can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Database management systems are often classified according to the database model that they support; the most popular database systems since the 1980s have all supported the relational model as represented by the SQL language. [disputed – discuss] Sometimes a DBMS is loosely referred to as a 'database'.

A DBMS makes it possible for end users to create, read, update and delete data in a database. The DBMS essentially serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remains easily accessible.

Bundling with Webpack (002) MCQ's

1. Executing the following command will automatically create a file named: webpack_practice >>

   View Answer   

    npm init  -->Package.json



2. Which of these softwares is necessary to install webpack

   View Answer   

    Node.js



3. Webpack supports third party libraries

   View Answer   

   True



4. The distinct feature of webpack is

   View Answer   

   code splitting



5. Webpack supports third party libraries

   View Answer   

   True



Microprocessor Terminologies

Data Transfer Instructions

MOV -- This instruction copies the contents of the source register into the destination register

MVI -- The 8-bit data is stored in the destination register or memory.

LDA -- The contents of a memory location, specified by a in the operand, are copied to the accumulator.

LDAX -- The contents of the designated register pair point to a memory location. This instruction copies the contents of that memory location into the accumulator.

How to Hide Any Drive in Windows Using Command Prompt

There are Two Method to Hide Drive in Windows Using Command Prompt Lets Follow Each Steps:

Method 1 of 2

Step 1: Type CMD in Start menu search area and hit Enter to launch Command Prompt. You can also find the Command Prompt under Accessories category in Start menu. In Windows 10 and 8.1, you can right-click on the Start button, and then click Command Prompt to open the same.

Step 2: In the Command Prompt, type Diskpart and hit enter key. Click Yes if you are prompted with UAC (User Account Control) dialog-box.

Kafka MCQ's

1. A hashing-based Partitioner takes ___ and generates a hash to locate which partition the message should go

   View Answer   

   Partition Key



2. Banking industry can leverage Kafka Streams for detecting fraudulent transactions.

   View Answer   

   True



3. Which messaging semantics do Kafka use to handle failure to any broker in cluster?

   View Answer   

   acks



4. Kafka only provides a total order over records within a partition, not between different partitions in a topic.

   View Answer   

   True



5. The only metadata retained on a per-consumer basis is the position of the consumer in the log, called :

   View Answer   

   Offset