Q80. Why is schema design for HBase is different from relational database design? A80. HBase is a columnar NoSQL database. This means no two rows in a table need to have the same columns. In a columnar database table, each row contains cells containing
|
1 2 3 |
row-key (unique) + column-family + column qualifier + timestamp |
Values are stored against each...
Q1. How do you restrict an element in XSD? A1. With “xs:restriction”. In the XSD shown below, the “AddressType” is restricted to “Mailing”, “Office”, and “Home”.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
<?xml version="1.0" encoding="UTF-8"?> <xs:schema xmlns="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.mycompany.com" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://www.mycompany.com" elementFormDefault="qualified" attributeFormDefault="unqualified"> <xs:element name="Party" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="id" type="xs:string"></xs:element> <xs:element name="PartyName" type="xs:string" /> <xs:element name="PartyType" type="xs:string" /> <xs:element name="AddressDetails" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence> <xs:element name="AddressType"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:enumeration value="Mailing" /> <xs:enumeration value="Office" /> <xs:enumeration value="Home" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AddressLine1" type="xs:string"></xs:element> <xs:element name="AddressLine2" type="xs:string"></xs:element> <xs:element name="Suburb" type="xs:string"></xs:element> <xs:element name="State" type="xs:string"></xs:element> <xs:element name="Postcode" type="xs:string"></xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> <xs:element name="Adviser" type="tns:Ref_Adviser" /> <xs:complexType name="Ref_Adviser"> <xs:sequence> <xs:element name="firstName" type="xs:string" /> <xs:element name="surname" type="xs:string" /> </xs:sequence> </xs:complexType> </xs:schema> |
Q2. Can you explain as per the XSD shown above the term “targetNamespace”? … Read more ›...
LEAD(..) & LAG(..) are Window functions, which perform operations for each row of the partition or window. LEAD() and LAG() are used to accesses a value stored in a row below and a value stored in a row above respectively. An ORDER BY clause is required when working with LEAD...
Q1. What is ssh? A1. SSH is a secure protocol used for remotely connecting to Linux servers. For example, creating an ssh connection from your local laptop to an ec2 instance running on AWS or any server on the cloud.
|
1 2 |
$ ssh user@<public-ip-or-domain-name-of-a-remote-mchine> |
You will be prompted for a password, … Read...
This extends 50+ SQL scenarios based interview Q&As on Nth value with some variations to practice. Problem statement & considerations Find the 5th highest salary for each department. If the number of highest value for a particular department is less than 5, then display the lowest salary for that department....
Q1. What do you understand by the terms symbol and currency pairs in relation to FX trading?
A1. Every traded instrument has a “symbol”. For example, in stocks “IBM” is a symbol and you can buy or sell “IBM” stocks. In the FIX protocol, the symbol is represented by tag number “55”.
…
Let’s try solving a problem statement given below by creating sample data & then an SQL query on db-fiddle using MySQL v8 database. You can also look at a hierarchical (i.e. tree structure) employees example using a self-join at 50+ SQL scenarios based interview Q&As on joins, CDC and recursive...
This post reiterates the importance of understanding the order of execution of the SQL statements. Also, always think of the data granularity (aka grain). This post also demonstrates that the final query may look complex, but if you break it down it is much easier to comprehend.
…
The investment banks and financial organizations do pay a very competitive remunerations and many of you aspire to work for such organizations. Here are a few questions and answers on different securities, derivatives, and FIX engine/trading system basics to familiarize yourself with some of the terminologies. Q1. What are the different asset...
Q1. What is normalization? When to denormalize? A1. Normalization is a design technique that is widely used as a guide in designing relational databases. Normalization is essentially a two step process that puts data into tabular form by removing repeating groups and then removes duplicated data from the relational tables....
In this post let’s look at an SQL scenario, and three different ways to solve this scenario. There could be more ways to solve an SQL scenario. Problem Statement Given the below “orders” table write a query to find the order status.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
line_item_id order_id line_item_status ---------------------------------------------- 1 ORD123 DELIVERED 2 ORD123 DELIVERED 3 ORD123 DELIVERED 1 ORD124 DELIVERED 2 ORD124 SHIPPED 1 ORD125 PENDING 2 ORD125 SHIPPED 3 ORD125 DELIVERED 1 ORD126 SHIPPED 2 ORD126 SHIPPED 1 ORD127 PENDING 2 ORD127 PENDING |
1) If all line items are ‘DELIVERED’...
Q01. What is an Amazon EC2 Service? A01. EC2 stands for Elastic Cloud Computing that provides resizable (i.e. scalable) computing capacity in the cloud. You can use Amazon EC2 to launch as many virtual servers as you need. In EC2 you can configure security and networking as well as manage...
Below questions are based on the above diagram, and extends AWS Q&As on VPC, Subnets, Availability Zones, VPN, Route tables, NACLs & Security Groups: Q1. What is the difference between CloudWatch & CloudTrail? A1. Both provide logging capabilities. … Read more ›...
I have a good news, I got job offer. I like to share with you from my bottom of my heart feeling thankful to you.