QUALITY CONTROL QUESTIONS AND ANSWERS
Define Static non-access modifier? - Answers - keywords that provides a special
functionality when specified. With Static, no object is required to access a field/method.
The class members belongs to the class itself rather than a specific object.
What are the difference between aggregate and scaler functions? (SQL) - Answers -
Aggregate functions operate against a collection of values and return a single
summarizing value.
Scalar functions return a single value based on scalar input arguments
What are some HTTP verbs? - Answers - GET - Used to retrieve data from the server
POST - Used to submit data to the server
PUT - Replaces/updated the existing data on the server
DELETE - Deletes existing data on the server
HEAD - it is like a get method, but I will only give you the header
How can you configure your pipeline to include SonarCloud/Code Coverage? - Answers
- Sonar cloud provides you a token that you insert into the pipeline that will deploy the
code coverage into the sonar cloud profile.
What is SOLID? - Answers - basic design principles.
Single Responsibility Principle
A class should have one and only one reason to change
Open/Closed Principle
A class should be open for extensions but closed for modifications
Liskov Substitution Principle
The child class should be substitutable for their parent class.
It just means the child class should not behave in such a way that it will cause problems
when you replace it with its parent class.
Interface Segregation Principle
You should not be forced to implement methods that you dont need in an interface
Dependency Inversion Principle
High-level and low-level modules should depend on abstractions and not on each other
, What is a HTTP request/response? - Answers - HTTP messages: requests sent by the
client to trigger an action on the server, and responses, the answer from the server.
Difference between union and union-all? - Answers - UNION ALL command is equal to
UNION command, except that UNION ALL selects all the values. The difference
between Union and Union all is that Union all will not eliminate duplicate rows, instead it
just pulls all the rows from all the tables fitting your query specifics and combines them
Difference between primary and foreign key? - Answers - A primary key is used to
ensure data in the specific column is unique. A foreign key is a column or group in
database table that provides a link between data in two tables.
What is the smallest portion of a K8s cluster can you work with? - Answers - Pods are
the smallest, most basic deployable objects in Kubernetes. A Pod represents a single
instance of a running process in your cluster.
Diff between arraylist and array and list? - Answers - The List is an interface, and the
ArrayList is a class in a Collection framework. The List creates a static array, and the
ArrayList creates a dynamic array for storing the objects.
What are transactions? (SQL) - Answers - a logical unit of work that contains one or
more SQL statements that access data using read and write operations.
What are the SQL sublanguages and define each? - Answers - DDL-Data Definition
Language
- Used to define Database objects (CREATE,ALTER,DROP,TRUNCATE,RENAME)
DML - Data Manipulation Language
Used to manipulate the data in Database objects like table (INSERT, UPDATE,
DELETE)
TCL - Transaction Control Language
-Transaction control statement are use to apply the changes permanently save into
database.
(COMMIT, ROLLBACK, SAVEPOINT)
DCL - Data Control Language
Data control statements are use to give privileges to access limited data or share the
information between users.
SCL- Session Control Language
Session control statement are manage properties dynamically of a user session.
(ALTER SESSION,SET ROLL)
DRL/DQL-Data Retrieval Language/Data Query Language
Define Static non-access modifier? - Answers - keywords that provides a special
functionality when specified. With Static, no object is required to access a field/method.
The class members belongs to the class itself rather than a specific object.
What are the difference between aggregate and scaler functions? (SQL) - Answers -
Aggregate functions operate against a collection of values and return a single
summarizing value.
Scalar functions return a single value based on scalar input arguments
What are some HTTP verbs? - Answers - GET - Used to retrieve data from the server
POST - Used to submit data to the server
PUT - Replaces/updated the existing data on the server
DELETE - Deletes existing data on the server
HEAD - it is like a get method, but I will only give you the header
How can you configure your pipeline to include SonarCloud/Code Coverage? - Answers
- Sonar cloud provides you a token that you insert into the pipeline that will deploy the
code coverage into the sonar cloud profile.
What is SOLID? - Answers - basic design principles.
Single Responsibility Principle
A class should have one and only one reason to change
Open/Closed Principle
A class should be open for extensions but closed for modifications
Liskov Substitution Principle
The child class should be substitutable for their parent class.
It just means the child class should not behave in such a way that it will cause problems
when you replace it with its parent class.
Interface Segregation Principle
You should not be forced to implement methods that you dont need in an interface
Dependency Inversion Principle
High-level and low-level modules should depend on abstractions and not on each other
, What is a HTTP request/response? - Answers - HTTP messages: requests sent by the
client to trigger an action on the server, and responses, the answer from the server.
Difference between union and union-all? - Answers - UNION ALL command is equal to
UNION command, except that UNION ALL selects all the values. The difference
between Union and Union all is that Union all will not eliminate duplicate rows, instead it
just pulls all the rows from all the tables fitting your query specifics and combines them
Difference between primary and foreign key? - Answers - A primary key is used to
ensure data in the specific column is unique. A foreign key is a column or group in
database table that provides a link between data in two tables.
What is the smallest portion of a K8s cluster can you work with? - Answers - Pods are
the smallest, most basic deployable objects in Kubernetes. A Pod represents a single
instance of a running process in your cluster.
Diff between arraylist and array and list? - Answers - The List is an interface, and the
ArrayList is a class in a Collection framework. The List creates a static array, and the
ArrayList creates a dynamic array for storing the objects.
What are transactions? (SQL) - Answers - a logical unit of work that contains one or
more SQL statements that access data using read and write operations.
What are the SQL sublanguages and define each? - Answers - DDL-Data Definition
Language
- Used to define Database objects (CREATE,ALTER,DROP,TRUNCATE,RENAME)
DML - Data Manipulation Language
Used to manipulate the data in Database objects like table (INSERT, UPDATE,
DELETE)
TCL - Transaction Control Language
-Transaction control statement are use to apply the changes permanently save into
database.
(COMMIT, ROLLBACK, SAVEPOINT)
DCL - Data Control Language
Data control statements are use to give privileges to access limited data or share the
information between users.
SCL- Session Control Language
Session control statement are manage properties dynamically of a user session.
(ALTER SESSION,SET ROLL)
DRL/DQL-Data Retrieval Language/Data Query Language
