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

R-dplyrops-fdadata

From a given data set fda which contains data on warning letters sent to doctors by the U.S. Food and Drug Administration, because of problems in the way in which they ran clinical trials testing experimental treatments. Contains the following variables:

name_last name_first name_middle Doctor’s last, first, and middle names.

issued Date letter was sent.

office Office within the FDA that sent the letter.

Now,

(a)Include the packages required and read the data from the data set fda.

(b)Filter the data for letters sent from the start of 2005(1'st January 2005) onwards and print it. 

(c)Count the number of letters issued by year and print it .

Infrastructure as Code MCQ's

1. When a server requires special configuration beyond that covered by automated deployment scripts, it is called

a) Snowflake Server
b) Server Sprawl
c) Automation Fear
d) Configuration Drift

   View Answer   

   Snowflake Server

2. __________ configuration is faster than ___________ configuration

a) Automated, Manual
b) Manual, Hybrid
c) Manual, Automated
d) Automated, Hybrid

   View Answer   

   Automated, Manual

3. For quick configurations, the servers must be

a) Well configured
b) Automated
c) Identical
d) Different

   View Answer   

   Identical

4. Which is directly proportional to your business?

a) Clarity
b) Security
c) None of the options
d) Availability

   View Answer   

   Availability

5. IaC is frequently referred to as, _

a) infrastructure automation
b) Infrastructure Programming
c) Programmable infrastructure
d) Automated Infrastructure

   View Answer   

   Programmable infrastructure

Elements of User Experience MCQ's

1. Which one of the following techniques helps us in understanding user needs?

   View Answer   

   All

2. navigation allows the user to access nearby screens in the architecture.

   View Answer   

   Local

3. The discipline involved in creating a structured experience for the user is know as 

   View Answer   

   ID

4. _________ is getting your users to test what you have produced.

   View Answer   

   UT

5. help us to analyze the precise steps that user performs to complete a task.

   View Answer   

   TA

Git: Stashing changes - Basic (Java)

 Welcome to Git: Stashing changes - Basic (Java).

This question is used to evaluate your skills on stashing the changes in Git.

For this, you will be evaluated based on the following operations. The remote repository has been pre-configured into your local git repository.

1. Your local git repository will be linkedlist_java.
2. Push the master branch of local git repository to the remote repository.
3. Create a new branch with the name new_branch.
4. Make a change to the Java program file (do not remove it), make a commit and push the branch.
5. Make a few more changes to the Java program file and stash those changes.

FOOD FEST Using Python

A food fest is organised at the JLN stadium. The stalls from different states and cities have been set up. To make the fest more interesting, multiple games have been arranged which can be played by the people to win the food vouchers. One such game to win the food vouchers is described below:

There are N number of boxes arranged in a single queue. Each box has an integer I written on it. From the given queue, the participant has to select two contiguous subsequences A and B of the same size. The selected subsequences should be such that the summation of the product of the boxes should be maximum. The product is not calculated normally though. To make the game interesting, the first box of subsequence A is to be multiplied by the last box of subsequence B. The second box of subsequence A is to be multiplied by the second last box of subsequence B and so on. All the products thus obtained are then added together.

If the participant is able to find the correct such maximum summation, he/she will win the game and will be awarded the food voucher of the same value.

Note: The subsequences A and B should be disjoint.