Snowflake Practice questions

Q.1 How does Snowflake store data internally? a. In CSV format b. In JSON format c. In a proprietary formatAns: c. proprietary format Q.2 Snowflake has tightly coupled storage and compute a. False b. TrueAns: a. False Q.3 The physical storage structure, compression and statistics of data is handled by DBAs? a. True b. FalseAns: ...

The ‘protected’ questions in Java…

Let’s discuss a few questions about using protected in Java in combination with other keywords. Q1. Can we have methods declared as ‘protected final’ in Java? Q2. Protected members are not accessible outside the package. How do I write JUnits for them? Q1. Can we have methods declared as ‘protected final’ in Java? Short Answer: ...

Protected access modifier in Java

As per the official java documentation from Oracle: “The protected modifier specifies that the member can only be accessed within its own package (as with package-private) and, in addition, by a subclass of its class in another package.” What this means is: Say, a concrete class Parent in package com.coddicted has a protected method named ...

OnePlus One : The Review

Hello Everyone, We finally bring you the much awaited review of the super hyped and ‘The Flagship Killer’ titled mobile phone device. The OnePlus One. While the specs are astonishing compared to its contemporary phones, with 3 GB RAM, Qualcomm Snapdragon 2.5 GHz Quad Core CPU chip, 13 MP Rear and 5MP front camera, 5.5″ ...

Lossless Dependency Preserving 3NF decomposition Algorithm 2

The minimal cover of F is given 1. Search for dependencies in F-having the same attribute set on the left hand side A: A->B1, A->B2, A->B3, …, A->Bk And construct relation as (A, B1, B2, B3,…, Bk) 2. Construct a relation with remainder attributes. 3. In case none of the relations has a candidate key, ...

Python newline caveat

Hello Everyone, This will be a small post about a caveat in Python language (v2.7) for writing output to files. On Windows the new line character is actually treated as ‘\r\n‘ or CRLF as we know it (Carriage Return followed by a Newline). Sometimes however you may not want to output this newline character into ...

Samsung Tab3 311 Kitkat Update Issue…

The much awaited Android Kitkat update (v4.4.2) for Samsung’s latest Tab in the market so far ‘SM-T311’ was made available sometime towards the end of August-2014. While it was highly anticipated, there seems to have occurred many problems to devices after updating the firmware for Android v4.4.2. Our team experienced one such issue and the ...

ConcurrentHashMap 1

ConcurrentHashMap
Javadoc says… “A hash table except supporting full concurrency of retrievals and adjustable expected concurrency for updates. This class obeys the same functional specification as Hashtable, and includes versions of methods corresponding to each method of Hashtable. However, even though all operations are thread-safe, retrieval operations do not entail locking, and there is not any ...

Emulation vs Simulation

While both the terms refer to mimicking the behavior of something, they, however, are not the same in the sense of- degree to which they duplicate the behavior along with some traditional meaning associated with them. In the earlier years of its inception, the term Emulation was used only for hardware based simulations, which has ...

Samsung Tab3 311 Charging problem 30

Last month I bought the Samsung’s latest launch Galaxy Tab3 311. It has an 8 inch screen with 1.5 GHz dual core processor. (More details here). However, within a fortnight of purchasing the device, it began showing charging problem. On primary investigation I found the problem was with the USB charging adapter which came with ...