Multiple Choice Questions

vibssingh

Advance Selenium Multiple Choice Questions – MCQ1

Last Updated On

HOME

Welcome to the Advance Selenium Quiz! This blog post features 25 multiple-choice questions that explore essential concepts of Selenium.

1. What are the different types of frameworks in Selenium?

Select the best answer

a) Data Driven Framework
b) Keyboard Driven Framework
c) Hybrid Framework
d) Page Object Model Framework
e) All

Answer

2. Is it possible to test APIs or web services using Selenium Webdriver?

Choose one option

a) Yes
b) No

Answer

3. Is it possible to test the database using Selenium?

Choose one option

a) Yes
b) No

Answer

4. Does Selenium come with built-in reporting capabilities?

Choose one option

a) Yes
b) No

Answer

5. Is cross-browser testing supported by Selenium?

Choose one option

a) Yes
b) No

Answer

6. Is parallel testing supported by Selenium?

a) Yes
b) No

Answer

7. Can Selenium handle Security Testing on its own?

a) Yes
b) No

Answer

8. Can we integrate Selenium Framework with CI/CD pipelines?

Choose one option

a) Yes
b) No

Answer

9. What is the purpose of using the PageFactory class in Selenium?

Choose one option

a) To find elements on a page using CSS selectors
b) To manage the browser cookies
c) To initialize web elements defined in a Page Object class
d) To handle browser pop-ups

Answer

10. Which WebDriver method is used to wait until a web element is visible on the page?

Choose one option

a)  driver.waitForElement()

b)  new WebDriverWait().until(ExpectedConditions.elementToBeClickable())

c)  Thread.sleep()

d)  new WebDriverWait().until(ExpectedConditions.visibilityOfElementLocated())

Answer

11. Which WebDriver method simulates a right-click (context click) action on a web element?

Choose one option

a)  Actions.doubleClick(element)

b)  WebElement.contextClick()

c)  Actions.moveToElement(element).click()

d)  Actions.contextClick(element)

Answer

12.  How do you take a screenshot in Selenium WebDriver?

Choose one option

a)  driver.takeScreenshot()

b)  ((TakesScreenshot) driver).getScreenshotAs(OutputType.FILE)

c)  driver.getScreenshot()

d)  driver.captureScreen()

Answer

13. Is it possible to integrate Selenium with JUnit?

Choose one option

a) Yes
b) No

Answer

14. Is it possible to integrate Selenium with TestNG?

Choose one option

a) Yes
b) No

Answer

15. How can data-driven tests be achieved in Selenium with TestNG?

Choose one option

a) By using the @DataProvider annotation
b) By using the @DataDriven annotation
c) By using the @Test annotation with parameters attribute
d) By using the @TestData annotation

Answer

16. How can you run Selenium tests in parallel using TestNG?

Choose one option

a) Modify the test class constructor
b) Use the synchronized keyword
c) Configure the testng.xml file with parallel execution settings
d) Use the parallel=true annotation

Answer

17. Which CI/CD tool is widely used for integrating Selenium tests in an automated build process?

Choose one option

a) Jenkins
b) Microsoft Excel
c) PowerPoint
d) Oracle Database

Answer

18. In Jenkins, which plugin is commonly used to visualize test results generated by Selenium tests?

Choose one option

a) HTML Publisher Plugin
b) CSV Export Plugin
c) Spreadsheet Plugin
d) Diagram Generator Plugin

Answer

 19. Which Selenium Grid capability is particularly useful in a CI/CD pipeline for executing tests in parallel across different browsers and platforms?

a) Browser Synthetic Testing
b) Remote WebDriver
c) Cross-Browser Testing
d) Selenium IDE

Answer

20. When integrating Selenium with a CI/CD pipeline, what is the role of the Headless browser mode?

Choose one option

a) To execute browser tests without a graphical user interface, reducing resource consumption
b) To run tests exclusively on mobile devices
c) To make browsers invisible while the graphical interface is still running
d) To configure user sessions on virtual machines

Answer

21. How can you store sensitive information, such as Selenium Grid credentials, securely in GitHub Actions?

a) Directly hardcode the credentials into the YAML file
b) Use GitHub Secrets to store and access sensitive information
c) Email the credentials to team members
d) Store the credentials in a public repository

Answer

22. Is it possible to run Selenium tests using Cucumber?

a) Yes
b) No

Answer

23. Can we use Selenium for Performance Testing?

a) Yes
b) No

Answer

24. Does Selenium has inbuilt functionality to test excel?

a) Yes
b) No

Answer

25. Does Selenium have built-in functionality to test PDF files?

a) Yes
b) No

Answer

====================================================================

Don’t keep your scores a secret! Share them and let us know your thoughts by commenting below.

vibssingh

Advance Selenium Multiple Choice Answers – MCQ1

Last Updated On

HOME

Welcome to the SQL Quiz!

Advance Selenium Multiple Choice Questions – MCQ1

Answers

1) e) All

2) b) No

It is not possible to test APIs or web services directly using Selenium WebDriver. Selenium is primarily designed for automating web browser interactions and performing functional testing of web applications by simulating user actions.

3) b) No

4) b) No

5) a) Yes

6) a) Yes

By using testing frameworks such as TestNG or JUnit, you can configure and run your Selenium tests in parallel.

7) b) No

Selenium cannot handle security testing on its own. However, it can assist in certain aspects of security testing when integrated with specialized security tools.

8) a) Yes

9) c) To initialize web elements defined in a Page Object class

10) d) new WebDriverWait().until(ExpectedConditions.visibilityOfElementLocated())

11) d) Actions.contextClick(element)

12) b) ((TakesScreenshot) driver).getScreenshotAs(OutputType.FILE)

13) a) Yes

14) a) Yes

15) a) By using the @DataProvider annotation

16) c) Configure the testng.xml file with parallel execution settings

17) a) Jenkins

18) a) HTML Publisher Plugin

19) c) Cross-Browser Testing

20) a) To execute browser tests without a graphical user interface, reducing resource consumption

21) b) Use GitHub Secrets to store and access sensitive information

22) a) Yes

23) b) No

Selenium is not designed for performance testing. For performance testing, specialized tools such as JMeter, Gatling, and LoadRunner are more appropriate.

24) b) No

Selenium does not have inbuilt functionality specifically for testing Excel files. We can use external libraries in conjunction with Selenium to work with Excel files, like Apache POI.

25) b) No

vibssingh

JMeter Multiple Choice Answers – MCQ1

Last Updated On

HOME

Welcome to the JMeter Quiz!

JMeter Multiple Choice Questions – MCQ1

Answers

1) a) Apache

2) b) Performance and load testing

3) d) All of the above

4) c) Both A and B

5) d) All of the above

6) d) Bluetooth

7) d) All of the above

8) d) All of the above

9) d) Desktop

10) c) To define the number of users and the duration of the test

11) a) Non-functional

12) d) All of the above

13) c) Both A and B

14) d) Fatigue

15) c) Both (a) and (b)

16) a) True

17) a) True

18) a) True

19) a) True

20) a) Load

21) a) True

22) b) REACT OS

23) c) FTP Cookie Manager

24) d) All of the above

25) d) All of the above

vibssingh

JMeter Multiple Choice Questions – MCQ1

Last Updated On

HOME

Welcome to the JMeter Quiz! This blog post features 25 multiple-choice questions that explore essential concepts of Performance Testing and JMeter.

1. This graphical application is 100% Java-based and open source, also known as __ JMeter.

Select the best answer

Apache
Java
Ajax
SQL

Answer

2. What is Apache JMeter primarily used for?

Choose one option

a) Editing text files
b) Performance and load testing
c) Virus scanning
d) Image editing

Answer

3. Which of the following is a component of the JMeter Distributed Testing?

Choose one option

a) Slave
b) Target
c) Master
d) All of the above

Answer

4. Testing __ applications are the primary use of JMeter, but other uses are functional testing, JDBC database connections, Web services, generic TCP connections, and OS native processes as well.

Choose one option

a) Web
b) FTP
c) Both a and b
d) None of the above

Answer

5. The JMeter performance testing tool offers various test activities, such as __, Regression, and Functional testing, in order to determine your web server’s performance metrics accurately.

Choose one option

a) Performance
b) Load
c) Stress
d) All of the above

Answer

6. Which of the following protocols is NOT supported by JMeter?

a) HTTP/HTTPS
b) FTP
c) SMTP
d) Bluetooth

Answer

7. What is/are the feature(s) of JMeter?

a) Open source application
b) User-friendly GUI
c) Support various testing approaches
d) All of the above

Answer

8. What types of apps can be tested using JMeter?

Choose one option

a) Websites
b) Databases(JDBc)
c) Web services both – REST and SOAP
d) All of the above

Answer

9. ________type is not supported by the JMeter

Choose one option

a) Web
b) JAR
c) LDAP
d) Desktop

Answer

10. What is the purpose of the Thread Group in JMeter?

Choose one option

a) To define the test plan
b) To define the target system
c) To define the number of users and the duration of the test
d) To define the type of test to be performed

Answer

11. Tests of software performance evaluate the application’s performance under expected or higher loads as a __ test.

Choose one option

a) Non-functional
b) Semi-functional
c) Functional
d) None of the above

Answer

12.  Different performance attributes of the system are measured during performance testing, such as __, scalability, and stability.

Choose one option

a) Response time (speed)
b) Reliability
c) Resource Use
d) All of the above

Answer

13. Why is Performance Testing needed?

Choose one option

a) It is important to test the final software product for speed, scalability, and stability under a variety of load conditions before launching it into the market.
b) It’s likely to cause slow processing and poor usability if the product goes live without performing performance testing, which can negatively affect the sales goal.
c) Both A and B
d) None of the above

Answer

14. Stress Testing is also known as __.

Choose one option

a) Fatal
b) Crucial
c) Former
d) Fatigue

Answer

15. What is/are the type(s) of Performance Testing?

Choose one option

a) Load
b) Stress
c) Both (a) and (b)
d) None of the above

Answer

16. Stress testing forces loading by bouncing system loading, you can determine how well the server can marshal resources to meet very high demand.

Choose one option

a) True
b) False

Answer

17. Load testing examines real-world loading at a variety of load levels and in a variety of combinations.

Choose one option

a) True
b) False

Answer

18. A variation of stress testing is sometimes referred to as spike/bounce testing.

Choose one option

a) True
b) False

Answer

 19. By bouncing system loading, you can determine how well the server can marshal resources to meet very high demand.

a) True
b) False

Answer

20. During __ testing, different systems can be compared or a single system’s capabilities can be accurately measured in controlled lab conditions.

Choose one option

a) Load
b) Stress
c) Reference
d) Data

Answer

21. Stress testing forces loading to be increased to the breaking point to determine how much capacity the WebApp environment can handle.

a) True
b) False

Answer

22. JMeter does not support which of the following platforms?

a) Linux
b) REACT OS
c) Windows
d) MAC OS X

Answer

23. In JMeter, choose the INVALID configuration element.

a) FTP Request Defaults
b) HTTP Request Defaults
c) FTP Cookie Manager
d) HTTP Cookie Manager

Answer

24. __, logic controllers, and configuration elements make up a test plan.

a) Assertions
b) Listeners
c) Timers
d) All of the above

Answer

25. The major components of JMeter is/are –

a) Test Plan
b) Thread Group
c) Controllers
d) All of the above

Answer

====================================================================

vibssingh

Jenkins Multiple Choice Answers – MCQ2

Last Updated On

HOME

Welcome to the Jenkins Quiz!

Jenkins Multiple Choice Questions – MCQ2

Answers

1) B) Blue Ocean Plugin

2) C) Jenkins notifies you and allows you to decide when to restart

3) C) Use Global Tool Configuration to add different Git versions

4) A) SonarQube Scanner Plugin

5) C) Go to Manage Plugins and uninstall the plugin from the Installed tab

6) C) To store build artifacts generated by the build process

7) A) To provide a log of the builds that have been performed in Jenkins

The Jenkins Build History provides a log of the builds that have been performed in Jenkins. It allows users to view the status of previous builds and identify any issues that occurred

8) C) A tool used to manage the installation of software on Jenkins nodes

The Jenkins Global Tool Configuration is a tool used to manage the installation of software on Jenkins nodes. It allows users to specify which software tools are required for builds and ensures that they are installed on the nodes.

9) A) To provide an overview of the status of Jenkins jobs

The Jenkins Dashboard provides an overview of the status of Jenkins jobs. It allows users to monitor the progress of builds and view the results of tests.

10) B) A folder where Jenkins builds and stores files for a job

11) D) All of the above

12) B) SCM polling trigger

13) B) Groovy

14) B) A machine that Jenkins can use to execute jobs

15) C) A more structured and simplified way to define pipelines

16) A) Jenkins Master is the central server, while Jenkins Slave is a remote agent

17) C) Jenkinsfile

18) A) A syntax used to define the build process in Jenkins

The Jenkins Pipeline Syntax is a syntax used to define the build process in Jenkins. It is used to create pipelines that automate the building, testing, and deployment of software.

19) A) To validate the syntax of Jenkinsfiles

The Jenkinsfile Validator is used to validate the syntax of Jenkinsfiles. It ensures that the syntax is correct and identifies any errors or issues.

20) B) To execute Jenkins jobs on Jenkins Nodes

The Jenkins Build Executor is used to execute Jenkins jobs on Jenkins Nodes. It is responsible for running the build process and executing the commands specified in the job configuration.

21) D) To queue Jenkins jobs for execution by the Build Executor

The Jenkins Build Queue is used to queue Jenkins jobs for execution by the Build Executor. Jobs are placed in the queue when there are no Build Executors available to execute them, and are executed in the order in which they were added to the queue.

22) C) To store build artifacts generated by the build process

Jenkins Artifacts are used to store build artifacts generated by the build process. Artifacts can include compiled code, test results, and documentation, and are stored in the Jenkins workspace.

23) D) A mechanism used to authenticate users in Jenkins

The Jenkins Authentication Mechanism is used to authenticate users in Jenkins. It can be configured to use a variety of authentication methods, including LDAP and Active Directory.

24) D) The machine on which the Jenkins server is installed

The Jenkins Master is the machine on which the Jenkins server is installeD) It is responsible for managing the Jenkins configuration, scheduling builds, and distributing work to Jenkins slaves.

25) C) A machine that is configured to execute builds for a Jenkins Master

A Jenkins Slave is a machine that is configured to execute builds for a Jenkins Master. It receives work from the Jenkins Master and executes it in a separate process or container.

vibssingh

Jenkins Multiple Choice Questions – MCQ2

Last Updated On

HOME

Welcome to the Jenkins Quiz! This blog post features 25 multiple-choice questions that explore essential concepts of Jenkins.

1. Which plugin helps in visually modeling your Jenkins pipeline and improving the user experience?

Select the best answer

A) Pipeline Plugin
B) Blue Ocean Plugin
C) Job DSL Plugin
D) Pipeline Stage View Plugin

Answer

2. What happens when a plugin update requires a restart in Jenkins?

Choose one option

A) Jenkins automatically restarts without notification
B) The update is applied immediately without any restart
C) Jenkins notifies you and allows you to decide when to restart
D) The plugin is updated only after all builds are completed

Answer

3. How can you configure multiple versions of Git in Jenkins?

Choose one option

A) Install the Git Plugin and configure versions in each job
B) Install multiple versions in the system and select one during job configuration
C) Use Global Tool Configuration to add different Git versions
D) Jenkins does not support multiple Git versions

Answer

4. In Jenkins, which plugin would you use to set up static code analysis?

Choose one option

A) SonarQube Scanner Plugin
B) GitHub Plugin
C) Email Extension Plugin
D) Pipeline Plugin

Answer

5. How do you remove an installed plugin in Jenkins?

Choose one option

A) Manually delete the plugin from the Jenkins directory
B) Use the CLI to remove it
C) Go to Manage Plugins and uninstall the plugin from the Installed tab
D) Plugins cannot be uninstalled

Answer

6. What is the purpose of the Jenkins Artifacts?

A) To provide a log of the builds that have been performed in Jenkins
B) To manage the configuration of Jenkins
C) To store build artifacts generated by the build process
D) To enable Jenkins to communicate with external systems

Answer

7. What is the purpose of the Jenkins Build History?

A) To provide a log of the builds that have been performed in Jenkins
B) To manage the configuration of Jenkins
C) To generate reports on the status of Jenkins jobs
D) To enable Jenkins to communicate with external systems

Answer

8. What is the Jenkins Global Tool Configuration?

Choose one option

A) A feature that allows users to configure global settings in Jenkins
B) A plugin that provides additional functionality to Jenkins
C) A tool used to manage the installation of software on Jenkins nodes
D) A tool used to manage the distribution of work to Jenkins slaves

Answer

9. What is the purpose of the Jenkins Dashboard?

Choose one option

A) To provide an overview of the status of Jenkins jobs
B) To manage the configuration of Jenkins
C) To generate reports on the status of Jenkins jobs
D) To enable Jenkins to communicate with external systems

Answer

10. What does the “workspace” in Jenkins refer to?

Choose one option

A) A specific plugin’s settings page
B) A folder where Jenkins builds and stores files for a job
C) A project created by Jenkins users
D) A shared Jenkins repository for storing jobs

Answer

11. Jenkins can be integrated with which of the following version control systems?

Choose one option

A) Git
B) Subversion (SVN)
C) Mercurial
D) All of the above

Answer

12.  Which type of trigger can be used in Jenkins to start a job automatically?

Choose one option

A) Manual trigger
B) SCM polling trigger
C) Post-build trigger
D) Automated backup trigger

Answer

13. Jenkins pipelines are defined using which language?

Choose one option

A) YAML
B) Groovy
C) XML
D) Python

Answer

14. What is a Jenkins “node”?

Choose one option

A) A code block in a Jenkins pipeline
B) A machine that Jenkins can use to execute jobs
C) A Jenkins plugin
D) A configuration file

Answer

15. What is a “Declarative Pipeline” in Jenkins?

Choose one option

A) A pipeline defined in a Jenkins job configuration
B) A pipeline that uses the Groovy DSL for defining steps
C) A more structured and simplified way to define pipelines
D) A pipeline written in YAML format

Answer

16. Given the following Selenium WebDriver code, what does `.sendKeys(Keys.TAB)` achieve?

Choose one option

A) Jenkins Master is the central server, while Jenkins Slave is a remote agent
B) Jenkins Master is responsible for building the software, while Jenkins Slave is responsible for testing it
C) Jenkins Master is a component of Jenkins, while Jenkins Slave is a separate tool
D) Jenkins Master is used for local builds, while Jenkins Slave is used for cloud-based builds

Answer

17. Which of the following is not a Jenkins plugin?

Choose one option

A) Git
B) Maven
C) Jenkinsfile
D) Slack

Answer

18. What is the Jenkins Pipeline Syntax?

Choose one option

A) A syntax used to define the build process in Jenkins
B) A syntax used to define the configuration of Jenkins
C) A syntax used to define the structure of Jenkins plugins
D) A syntax used to define the communication protocols used by Jenkins

Answer

 19. What is the purpose of the Jenkinsfile Validator?

A) To validate the syntax of Jenkinsfiles
B) To validate the configuration of Jenkins
C) To validate the functionality of Jenkins plugins
D) To validate the results of Jenkins builds

Answer

20. What is the purpose of the Jenkins Build Executor?

Choose one option

A) To manage the configuration of Jenkins
B) To execute Jenkins jobs on Jenkins Nodes
C) To generate reports on the status of Jenkins jobs
D) To enable Jenkins to communicate with external systems

Answer

21. What is the purpose of the Jenkins Build Queue?

A) To manage the configuration of Jenkins
B) To execute Jenkins jobs on Jenkins Nodes
C) To generate reports on the status of Jenkins jobs
D) To queue Jenkins jobs for execution by the Build Executor

Answer

22. What is the purpose of the Jenkins Artifacts?

A) To provide a log of the builds that have been performed in Jenkins
B) To manage the configuration of Jenkins
C) To store build artifacts generated by the build process
D) To enable Jenkins to communicate with external systems

Answer

23. What is the Jenkins Authentication Mechanism?

A) A tool used to manage the installation of software on Jenkins nodes
B) A feature that allows users to configure global settings in Jenkins
C) A tool used to manage the distribution of work to Jenkins slaves
D) A mechanism used to authenticate users in Jenkins

Answer

24. What is the Jenkins Master?

A) The primary node in a Jenkins cluster
B) A tool used to manage the installation of software on Jenkins nodes
C) A tool used to manage the distribution of work to Jenkins slaves
D) The machine on which the Jenkins server is installed

Answer

25. What is a Jenkins Slave?

A) A tool used to manage the installation of software on Jenkins nodes
B) A tool used to manage the distribution of work to Jenkins slaves
C) A machine that is configured to execute builds for a Jenkins Master
D) The primary node in a Jenkins cluster

Answer

====================================================================

vibssingh

SQL Multiple Choice Answers – MCQ3

Last Updated On

HOME

Welcome to the SQL Quiz!

SQL Multiple Choice Questions – MCQ3

Answers

1) d) We can insert and delete rows in a view

2) d) Order By

Order By clause is used to sort the retrieved data in ascending or descending order. Group By clause is used to group the result-set by one or more columns. Order and Group are not valid SQL commands.

3) a) True

NULL signifies an unknown value or a value which doesn’t exist during the creation of the record.

4) c) Drop

5) a) <>

6) c) Select top

7) d) Limit

All database systems does not supports SELECT TOP clause. It can be used in SQL. Mysql supports the LIMIT clause to fetch a limited number of records from the database table.

8) d) All correct

9) b) Selects a record if both conditions are true

10) b) Adds a value to a column’s existing value

11) a) True

12) d) No syntax error

13) d) No error

14) a) XOR operator

SQL does not have an XOR logical operator. Use AND/OR instead.

15) d) All Correct

The compound operator ‘*=’ is correctly used to double the salary of specified employees.

16) a) It functions as a WHERE clause

Without GROUP BY, HAVING functions like a WHERE clause, filtering rows based on specified conditions.

17) a) The query fails

Using a column in SELECT that is not part of GROUP BY without an aggregate function causes the query to fail.

18) c) GROUP BY Salary

GROUP BY should be used with the column mentioned in SELECT, here it should be GROUP BY Department.

19) d) HAVING AverageSalary > 50000

HAVING should be used with an aggregate function directly, not with an alias.

20) a) SELECT Name

Name should be included in the GROUP BY clause or used within an aggregate function.

21) d) No Error

The query correctly groups by Department and uses HAVING to filter groups.

22) d) All Correct

ORDER BY 3 is correct, indicating ordering by the third column in the SELECT list.

23) c) WHERE MAX(Salary) > 50000

Aggregate functions such as MAX should be used in the HAVING clause when filtering groups created by the GROUP BY clause.

24) c) No error

The query correctly uses HAVING with ALL to compare counts across departments.

25) c) HAVING clause misuse

The original statement had an error in the HAVING clause. It incorrectly used the alias ‘TotalEmployees’. The correct HAVING clause should be “HAVING COUNT(*) > 5”.

vibssingh

SQL Multiple Choice Questions – MCQ3

Last Updated On

HOME

Welcome to the SQL Quiz! This blog post features 25 multiple-choice questions that explore essential concepts of SQL.

1. Which of the following statement is true about views in SQL?

Select the best answer

a) We can delete but not insert rows in a view
b) We cannot insert and delete rows in a view
c) We can insert but not delete rows in a view
d) We can insert and delete rows in a view

Answer

2. Which SQL keyword is used to sort the data returned by a SELECT statement?

Choose one option

a) Group
b) Order
c) Group By
d) Order By

Answer

3. NULL value is different from a zero value.

Choose one option

a) True
b) False

Answer

4. WHERE clause cannot be used with _

Choose one option

a) Select
b) Delete
c) Drop
d) Update

Answer

5. Which operator in the where clause signifies “Not Equal”?

a) <>
b)
c) <_>
d) <->

Answer

6. Which clause is used in SQL to fetch limited number of records from a table?

Choose one option

a) Select
b) Select limit
c) Select top
d) Top

Answer

7. Mysql supports which of the following clause to select a limited number of rows from a table?

a) Select
b) Select top
c) Top
d) Limit

Answer

8. What is missing in

ALTER TABLE Employees ADD CHECK (Age >= 18);

Choose one option

a) ALTER TABLE
b) ADD CHECK
c) (Age >= 18)
d) All Correct

Answer

9. In SQL, what does the logical operator AND do when used in a WHERE clause?

Choose one option

a) Selects a record if either condition is true
b) Selects a record if both conditions are true
c) Negates a condition
d) None of the above

Answer

10. In SQL, how does the compound operator ‘+=’ function?

Choose one option

a) Adds two values
b) Adds a value to a column’s existing value
c) Subtracts one value from another
d) Concatenates strings

Answer

11. The NOT NULL constraint enforces a) column to not accept NULL values.

Choose one option

a) True
b) False

Answer

12.  Correct the syntax error in

UPDATE Products SET Price = Price * 1.1 WHERE Price < 100 OR Price > 200;

Choose one option

a) * 1.1
b) WHERE
c) OR
d) No syntax error

Answer

13. Identify the error

SELECT Name FROM Employees WHERE NOT (Age < 30 AND Department = 'Sales');

Choose one option

a) NOT operator
b) < 30
c) AND
d) No error

Answer

14. Identify the mistake in

SELECT * FROM Employees WHERE Department = 'HR' XOR Department = 'Finance';

Choose one option

a) XOR operator
b) = ‘HR’
c) = ‘Finance’
d) No mistake, the statement is correct

Answer

15. What needs to be changed in

UPDATE Employees SET Salary *= 2 WHERE YearsOfExperience > 5;

Choose one option

a) *= 2
b) WHERE
c) YearsOfExperience > 5
d) All Correct

Answer

16. In an SQL query, what role does HAVING play without a GROUP BY clause?

Choose one option

a) It functions as a WHERE clause
b) It has no effect
c) It causes an error
d) It filters aggregated results

Answer

17. What happens if you use a column in the SELECT statement that is not in the GROUP BY clause?

Choose one option

a) The query fails
b) The query succeeds, and the column shows arbitrary values
c) The query is automatically corrected
d) The column is ignored

Answer

18. Identify the error in

SELECT Department, COUNT(*) FROM Employees GROUP BY Salary;

Choose one option

a) SELECT Department
b) COUNT(*)
c) GROUP BY Salary
d) No error

Answer

 19. What needs to be corrected in

SELECT AVG(Salary) AS AverageSalary FROM Employees HAVING AverageSalary > 50000;

Choose one option

a) SELECT AVG(Salary)
b) AS AverageSalary
c) FROM Employees
d) HAVING AverageSalary > 50000

Answer

20. Correct the syntax error in

SELECT Name, Department, COUNT(*) FROM Employees WHERE Department = 'Sales' GROUP BY Department;

Choose one option

a) SELECT Name
b) Department
c) COUNT(*)
d) WHERE Department = ‘Sales’

Answer

21. Identify the error

SELECT Department, SUM(Salary) FROM Employees GROUP BY Department HAVING COUNT(*) > 5;

Choose one option

a) SELECT Department
b) SUM(Salary)
c) GROUP BY Department
d) No Error

Answer

22. What is incorrect in

SELECT * FROM Employees ORDER BY 3;

Choose one option

a) SELECT *
b) FROM Employees
c) ORDER BY 3
d) All Correct

Answer

23. Identify the mistake in

SELECT Department, MAX(Salary) FROM Employees WHERE MAX(Salary) > 50000 GROUP BY Department;

Choose one option

a) SELECT Department
b) MAX(Salary)
c) HERE MAX(Salary) > 50000
d) GROUP BY Department

Answer

24. What needs correction?

SELECT Department, COUNT(EmployeeID) FROM Employees GROUP BY Department HAVING COUNT(EmployeeID) > ALL (SELECT COUNT(EmployeeID) FROM Employees GROUP BY Department);

Choose one option

a) ALL operator
b) COUNT(EmployeeID)
c) No error
d) subquery

Answer

25. What is wrong in

SELECT Department, COUNT(*) AS TotalEmployees FROM Employees GROUP BY Department HAVING TotalEmployees > 5 ORDER BY TotalEmployees;

Choose one option

a) SELECT Department
b) COUNT(*) AS TotalEmployees
c) HAVING clause misuse
d) ORDER BY TotalEmployees

Answer

====================================================================

Additional MCQ for SQL

SQL Multiple Choice Questions – MCQ2
SQL Multiple Choice Questions – MCQ3 

vibssingh

Jenkins Multiple Choice Answers – MCQ1

Last Updated On

HOME

Welcome to the Jenkins Quiz!

Jenkins Multiple Choice Questions – MCQ1

Answers

1) B) A continuous integration/continuous delivery (CI/CD) tool

2) C) Java

3) C) Automating parts of the software development process

4) B) java -jar jenkins.war

5) D) Jenkins Client

Jenkins Client is not a core component of Jenkins. The core components of Jenkins include Jenkins Master, Jenkins Slave, and Jenkins Node.

6) B) A unit of work that Jenkins executes

7) C) Source Code Management

8) D) All of the above

9) B) A piece of software that provides additional functionality to Jenkins

A Jenkins plugin is a piece of software that provides additional functionality to Jenkins. There are thousands of plugins available for Jenkins, including plugins for source control, build tools, and notification systems.

10) C) Manage Plugins under Manage Jenkins

11) B) A tool used to manage the installation of plugins in Jenkins

The Jenkins Plugin Manager is a tool used to manage the installation of plugins in Jenkins. It allows users to search for and install new plugins, update existing plugins, and configure plugin settings.

12) C) Access “Manage Plugins” in Jenkins and install from the available plugins list

13) D) All of the above

14) C) To define tools like JDK, Maven, and Git that are available to Jenkins jobs

15) D) To manage security settings for Jenkins

The Jenkins Security Plugin is used to manage security settings for Jenkins. It allows users to define users, groups, and permissions for accessing Jenkins resources, ensuring that only authorized users can perform actions in Jenkins.

16) D) To create backups of Jenkins configurations and jobs

The Jenkins Backup Plugin is used to create backups of Jenkins configurations and jobs. It allows users to easily restore a Jenkins server in the event of a failure or to migrate to a new server.

17) B) To enable Jenkins to communicate with external systems

The Jenkins Notification Plugins are used to enable Jenkins to communicate with external systems. They allow users to send notifications, such as build results or deployment status, to other systems, such as chat services or email.

18) A) An interface used to interact with Jenkins via HTTP requests

The Jenkins REST API is an interface used to interact with Jenkins via HTTP requests. It allows users to perform common tasks, such as triggering builds or retrieving build results, using simple HTTP calls.

19) A) A command-line interface used to interact with a Jenkins server

The Jenkins CLI is a command-line interface used to interact with a Jenkins server. It allows users to perform common tasks, such as creating jobs or triggering builds, from the command line.

20) C) Docker Pipeline Plugin

21) B) Manage Plugins > Updates tab

22) D) All of the above

23) C) Global Tool Configuration

24) D) All of the above

25) B) Manage Jenkins > Global Tool Configuration

vibssingh

Jenkins Multiple Choice Questions – MCQ1

Last Updated On

HOME

Welcome to the Jenkins Quiz! This blog post features 25 multiple-choice questions that explore essential concepts of Jenkins.

1. What is Jenkins?

Select the best answer

A) A database management tool
B) A continuous integration/continuous delivery (CI/CD) tool
C) A programming language
D) An integrated development environment (IDE)

Answer

2. Which programming language is Jenkins written in?

Choose one option

A) Python
B) C#
C) Java
D) Ruby

Answer

3. Jenkins is primarily used for which of the following purposes?

Choose one option

A) Code debugging
B) Managing cloud infrastructure
C) Automating parts of the software development process
D) Version control

Answer

4. Which of the following commands is used to start Jenkins on a local machine?

Choose one option

A) jenkins -start
B) java -jar jenkins.war
C) python start jenkins.py
D) jenkins start server

Answer

5. Which of the following is not a core component of Jenkins?

A) Jenkins Master
B) Jenkins Slave
C) Jenkins Node
D) Jenkins Client

Answer

6. In Jenkins, what is a “job”?

Choose one option

A) A process to install plugins
B) A unit of work that Jenkins executes
C) A repository of version-controlled code
D) A test automation tool

Answer

7. What does SCM stand for in Jenkins?

A) Server Configuration Management
B) Software Configuration Monitoring
C) Source Code Management
D) Secure Content Management

Answer

8. Jenkins can be integrated with which of the following version control systems?

Choose one option

A) Git
B) Subversion (SVN)
C) Mercurial
D) All of the above

Answer

9. What is a Jenkins plugin?

Choose one option

A) A set of scripts that automate the building of software
B) A piece of software that provides additional functionality to Jenkins
C) A configuration file that defines the build process in Jenkins
D) A report generated by Jenkins after a build is complete

Answer

10. Where can you manage plugins in Jenkins?

Choose one option

A) Jenkins CLI
B) Global Tool Configuration
C) Manage Plugins under Manage Jenkins
D) Jenkins Dashboard Home Page

Answer

11. What is the Jenkins Plugin Manager?

Choose one option

A) A feature that allows users to configure global settings in Jenkins
B) A tool used to manage the installation of plugins in Jenkins
C) A tool used to manage the installation of software on Jenkins nodes
D) A tool used to manage the distribution of work to Jenkins slaves

Answer

12.  How can you install a new plugin in Jenkins?

Choose one option

A) Manually download the plugin file and move it to the Jenkins installation directory
B) Use the “Install Plugin” option in Global Tool Configuration
C) Access “Manage Plugins” in Jenkins and install from the available plugins list
D) Jenkins does not support plugin installations

Answer

13. Which of the following plugins allows integration between Jenkins and Git?

Choose one option

A) Git Plugin
B) GitHub API Plugin
C) GitLab Plugin
D) All of the above

Answer

14. What is the purpose of the “Global Tool Configuration” in Jenkins?

Choose one option

A) To configure global security settings
B) To manage system logs
C) To define tools like JDK, Maven, and Git that are available to Jenkins jobs
D) To configure job-level parameters

Answer

15. What is the purpose of the Jenkins Security Plugin?

Choose one option

A) To manage the installation of plugins in Jenkins
B) To manage the distribution of work to Jenkins slaves
C) To enable Jenkins to communicate with external systems
D) To manage security settings for Jenkins

Answer

16. What is the purpose of the Jenkins Backup Plugin?

Choose one option

A) To manage the installation of plugins in Jenkins
B) To manage the distribution of work to Jenkins slaves
C) To enable Jenkins to communicate with external systems
D) To create backups of Jenkins configurations and jobs

Answer

17. What is the purpose of the Jenkins Notification Plugins?

Choose one option

A) To manage the installation of plugins in Jenkins
B) To enable Jenkins to communicate with external systems
C) To define Jenkins jobs in code
D) To extend the functionality of Jenkins

Answer

18. What is the Jenkins REST API?

Choose one option

A) An interface used to interact with Jenkins via HTTP requests
B) A tool used to manage the installation of software on Jenkins nodes
C) A tool used to manage the distribution of work to Jenkins slaves
D) A graphical user interface used to interact with a Jenkins server

Answer

 19. What is the Jenkins CLI?

Choose one option

A) A command-line interface used to interact with a Jenkins server
B) A graphical user interface used to interact with a Jenkins server
C) A tool used to manage the installation of software on Jenkins nodes
D) A tool used to manage the distribution of work to Jenkins slaves

Answer

20. Which plugin would you use for integrating Jenkins with Docker?

Choose one option

A) Docker Plugin
B) Kubernetes Plugin
C) Docker Pipeline Plugin
D) Docker Hub Plugin

Answer

21. Where would you go to install updates for Jenkins plugins?

Choose one option

A) Jenkins CLI
B) Manage Plugins > Updates tab
C) Global Tool Configuration > Updates
D) Jenkinsfile configuration

Answer

22. Which of the following plugins provides support for building and testing Java projects in Jenkins?

Choose one option

A) Ant Plugin
B) Maven Plugin
C) JUnit Plugin
D) All of the above

Answer

23. If you want to use different versions of the JDK in your Jenkins jobs, where would you configure these?

Choose one option

A) Job-level configuration
B) Manage Plugins section
C) Global Tool Configuration
D) Configure System settings

Answer

24. Which of the following plugins is essential for generating test reports in Jenkins?

Choose one option

A) TestNG Plugin
B) JUnit Plugin
C) Performance Plugin
D) All of the above

Answer

25. Jenkins supports multiple tool configurations such as JDK and Maven under which of the following sections?

Choose one option

A) Jenkins Job Configuration
B) Manage Jenkins > Global Tool Configuration
C) Build Triggers
D) Configure Security

Answer

====================================================================