What is the error message that you would get if you try to assign “Null” to an integer variable ? Answer : error message: cannot convert null to int… View Answer
What is the difference between shell script and perl ? Answer : Shell script is platform(OS) only for Unix flavour… View Answer
Difference between Procedure and Function ? Answer : A procedure is a named PL/SQL block… View Answer
Lazy writer in Memory ? Answer : Lazy write is an effect caused by the use of a write-back cache… View Answer
What is the difference between the SubQuery and Corelated SubQuery ? Answer : The inner query is executed only once… View Answer
What is the Difference between join and union ? Answer : The union operator combines the results of two or more queries into a single result set… View Answer
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE ? Answer : The HAVING clause sets conditions on the GROUP BY… View Answer
Difference between Clustered and Non-clustered index ? Answer : Cluster index: Clustered index will be created… View Answer
What is an Index ? Answer : Index is a database object which improves the efficiency of the query… View Answer
What is the difference between primary, partition and clustering key in Cassandra ? Answer : In Cassandra, a table contain a number of rows. View Answer
What is the difference between Cassandra and Hadoop ? Answer : All nodes are same in Peer-to-Peer Distributed architecture. Master/Slave. Name Node act as Master and data node act as worker node. View Answer
What is the virtual node in Cassandra ? Answer : Prior to Cassandra 1.2, every node was allocate to a particular token range. View Answer
What is the use of Cassandra database ? Answer : Apache Cassandra is a high-performance provides database to manage large number of data among many commodity servers and then it is highly scalable View Answer
What is the replica placement strategy in Cassandra ? Answer : Once you’ve absorbed that the strategy should fit the kind of environment you are placing your cluster in… View Answer
What is the relationship between Apache Hadoop, HBase, Hive and Cassandra ? Answer : It is a Big Data framework which uses Hadoop Distributed File System to Store the data and MapReduce framework to process that data View Answer
What is the most widely used API to write data to Cassandra ? Answer : Java makes the write procedure locked into the Java program. View Answer
What is the internal architecture of the Cassandra database ? Answer : Cassandra is build to manage big data workloads among multiple nodes with no single point of failure View Answer