QA Test

JSON

1. Do JSON support all the platforms?
   1. Answer:JSON almost supports all the platforms and programming languages because of its text format and most of the technologies mainly work with data transmission between the systems that support JSON format. There are many languages like PHP, Java, javascript etc.
2. How JSON has been built?
   1. Answer:This is the basic JSON Interview Questions asked in an interview. JSON is built on two structures that are the collection of name/value pairs and ordered list of values. These are the universal data structures like object, array, string, number, and value.
3. What developers preferred to use JSON over XML?
   1. JSON is faster and lighter than XML.
   2. JSON has typed objects whereas in XML objects are typically less.
   3. In JSON, there are different object types like integer, string, array etc. whereas in XML there is only one object type that is String only.
   4. JSON data can be easily available or accessible as JSON object using in JavaScript but in XML data needs to be parsed and allocated to variables using APIs.
   5. In JSON, retrieving the values is as simple as reading it from the property of the object from the javascript code.
4. What are the limitations and uses of JSON?
   1. Answer:It has its own limitations:It is not suitable for handling very large and complex data. When the data gets complex with several nested and hierarchical structures, it becomes complex for human readability. JSON does not support the comments. It does not support to handle the multimedia formats like image or rich text format.
5. Explain Newtonsoft in JSON?
   1. Answer:Newtonsoft is referred to as the framework which is mainly used in the .net framework for performing the operations with JSON. It is also called as Json.net. There are a lot of features using Newtonsoft like it enables the user to parse, create, modify and query the JSON using its internal framework. It is simple and easy to use. It enables the user to serialize and de serialize any object with JSON serializer. It is faster than other serializers. It supports the conversion from XML to JSON and vice versa. Its syntax is simple and provides an easier way to query the JSON. It is a free and open source. To convert the data into JSON structure, a creation of an object is required to store data and once the object has been created then we can store the variables and keys in an object. After storing data in the object then we can serialize that data that is how serialization is done and de-serialization is reverse of it.

SQL

1. What is SQL?
   1. SQL stands for Structured Query Language , and it is used to communicate with the Database. This is a standard language used to perform tasks such as retrieval, updation, insertion and deletion of data from a database.
2. What is a primary key?
   1. A primary key is a combination of fields which uniquely specify a row. This is a special kind of unique key, and it has implicit NOT NULL constraint. It means, Primary key values cannot be NULL.
3. What is a foreign key?
   1. A foreign key is one table which can be related to the primary key of another table. Relationship needs to be created between two tables by referencing foreign key with the primary key of another table.
4. What is a join?
   1. This is a keyword used to query data from more tables based on the relationship between the fields of the tables. Keys play a major role when JOINs are used.
5. Types of joins
   1. Inner Join.Inner join return rows when there is at least one match of rows between the tables.
   2. Right Join.Right join return rows which are common between the tables and all rows of Right hand side table. Simply, it returns all the rows from the right hand side table even though there are no matches in the left hand side table.
   3. Left Join.Left join return rows which are common between the tables and all rows of Left hand side table. Simply, it returns all the rows from Left hand side table even though there are no matches in the Right hand side table.
   4. Full Join.Full join return rows when there are matching rows in any one of the tables. This means, it returns all the rows from the left hand side table and all the rows from the right hand side table.
6. What is a View?
   1. A view is a virtual table which consists of a subset of data contained in a table. Views are not virtually present, and it takes less space to store. View can have data of one or more tables combined, and it is depending on the relationship.
7. What is an Index?
   1. An index is performance tuning method of allowing faster retrieval of records from the table. An index creates an entry for each value and it will be faster to retrieve data.