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
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
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
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 Answernpm init -->Package.json
2. Which of these softwares is necessary to install webpack
View AnswerNode.js
3. Webpack supports third party libraries
View AnswerTrue
4. The distinct feature of webpack is
View Answercode splitting
5. Webpack supports third party libraries
View AnswerTrue
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.
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 AnswerPartition Key
2. Banking industry can leverage Kafka Streams for detecting fraudulent transactions.
View AnswerTrue
3. Which messaging semantics do Kafka use to handle failure to any broker in cluster?
View Answeracks
4. Kafka only provides a total order over records within a partition, not between different partitions in a topic.
View AnswerTrue
5. The only metadata retained on a per-consumer basis is the position of the consumer in the log, called :
View AnswerOffset
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.
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
Snowflake Server
2. __________ configuration is faster than ___________ configuration
a) Automated, Manual
b) Manual, Hybrid
c) Manual, Automated
d) Automated, Hybrid
Automated, Manual
3. For quick configurations, the servers must be
a) Well configured
b) Automated
c) Identical
d) Different
Identical
4. Which is directly proportional to your business?
a) Clarity
b) Security
c) None of the options
d) Availability
Availability
5. IaC is frequently referred to as, _
a) infrastructure automation
b) Infrastructure Programming
c) Programmable infrastructure
d) Automated Infrastructure
Programmable infrastructure