Exam (elaborations)
QUALITY CONTROL QUESTIONS AND ANSWERS
- Course
- Institution
QUALITY CONTROL QUESTIONS AND ANSWERS
[Show more]
Content preview
QUALITY CONTROL QUESTIONS AND ANSWERSDefine 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller GEEKA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
56326 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now