Accenture SQL Interview Questions and Answers

Q1. Self introduction
Add your answer
Q2. What are your current roles and responsibilities?
Add your answer

Q1. What is property and casualty insurance?
Ans. 
Property and casualty insurance provides coverage for property damage and liability risks.
• Property insurance covers damage to physical property such as homes, buildings, and personal belongings.

• Casualty insurance covers liability risks such as bodily injury or property damage caused to others.

• Examples include homeowners insurance, auto insurance, and commercial property insurance.
Answered by AI
Add your answer
Q2. What is the endorsement and policy lifecycle in insurance?
Ans. 
Endorsement and policy lifecycle in insurance involves making changes to an existing policy and managing it throughout its duration.
• Endorsements are changes made to an existing insurance policy, such as adding or removing coverage, changing policy limits, or updating personal information.

• The policy lifecycle includes the issuance of the policy, endorsements, renewals, and eventual cancellation or expiration.

• Insurance c...read more
Answered by AI
Add your answer

Q1. What is lvm how it is work?
Ans. 
LVM stands for Logical Volume Manager, a tool used to manage disk storage in Linux systems.
• LVM allows for dynamic resizing of logical volumes without downtime.

• It consists of physical volumes, volume groups, and logical volumes.

• Commands like pvcreate, vgcreate, lvcreate are used to create and manage LVM.

• LVM provides flexibility in managing storage space by allowing logical volumes to span multiple physical disks.
Answered by AI
Add your answer
Q2. How to mount nfs?
Ans. 
To mount NFS, use the 'mount' command with the NFS server IP address and the mount point on the local machine.
• Use the 'mount' command followed by the NFS server IP address and the mount point on the local machine

• For example: sudo mount 192.168.1.100:/shared_folder /mnt/nfs_share

• Ensure that the NFS server is properly configured and accessible from the local machine
Answered by AI
Add your answer
Q3. How to do patching.
Ans. 
Patching involves applying updates to software to fix vulnerabilities and improve performance.
• Identify the software that needs to be patched

• Download the appropriate patches from the vendor's website

• Test the patches in a non-production environment before applying them to production systems

• Schedule downtime for applying patches to minimize disruption

• Document the patching process for future reference
Answered by AI
Add your answer
Q4. How to rollback package
Ans. 
To rollback a package, use package manager to uninstall current version and install previous version.
• Use package manager to uninstall current version of the package

• Install the previous version of the package using package manager

• Check for any dependencies that may need to be rolled back as well
Answered by AI
Add your answer
Q5. How to remove older kernel
Ans. 
To remove older kernels in Linux, use package management tools like apt or yum.
• Use 'apt autoremove' command in Debian-based systems to remove old kernels

• Use 'yum remove ' command in Red Hat-based systems to remove old kernels

• Check available kernels with 'uname -r' command before removing
Answered by AI
Add your answer

Q1. How can I grant SFTP access exclusively to the user David?
Ans. 
Grant SFTP access exclusively to user David
• Create a new group specifically for David, e.g. 'davidgroup'

• Set the ChrootDirectory in the SSH configuration file to restrict David's access to a specific directory

• Add David to the 'davidgroup' and configure the necessary permissions for SFTP access
Answered by AI
Add your answer
Q2. How can a user be locked out after 6 unsuccessful password attempts for a duration of 30 minutes?
Ans. 
To lock a user out after 6 unsuccessful password attempts for 30 minutes, modify the PAM configuration file.
• Edit the PAM configuration file (/etc/pam.d/common-auth) to include the 'pam_tally2' module.

• Set the 'deny' option in the 'pam_tally2' module to lock the user out after 6 failed attempts.

• Specify the 'unlock_time' option in the 'pam_tally2' module to set the duration of the lockout period to 30 minutes.

• Example: aut
Answered by AI
Add your answer

Q1. How to configure NFS
Ans. 
NFS can be configured by setting up the NFS server, exporting directories, and configuring client access.
• Install NFS server package on the server

• Edit /etc/exports file to specify directories to be shared

• Restart NFS service to apply changes

• Configure client access by mounting NFS shares on client machines
Answered by AI
Add your answer
Q2. How to perform patching
Ans. 
Patching involves applying updates to software to fix vulnerabilities and improve performance.
• Identify the software that needs to be patched

• Download the necessary patches from the vendor's website

• Test the patches in a non-production environment before applying them to production systems

• Schedule a maintenance window to apply the patches

• Apply the patches using tools like yum, apt-get, or Windows Update

• Verify that the pat...read more
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer
Q2. Location discussion
Add your answer

Q1. What are the skills that you have?
Add your answer
Q2. Why do you want to join wipro?
Add your answer

Pearson test where our verbal skills are tested

Q1. Why want to work in Tech m
Add your answer
Q2. Why want to work in Tech M
Add your answer

Q1. About your self
Add your answer
Q2. Family background
Add your answer
Q3. About product specialist
Add your answer
Q4. Why are you joining our company
Add your answer

Q1. Discribe boot process
Add your answer
Q2. User management
Add your answer

Q1. Describe about acl
Ans. 
ACL stands for Access Control List, a set of permissions attached to an object that specifies which users or system processes are granted access to that object.
• ACLs are used to control access to files, directories, and other resources on a system.

• They define who can read, write, or execute a file or directory.

• ACLs can be set on a per-user or per-group basis, allowing for more granular control over access permissions.

• Ex...read more
Answered by AI
Add your answer
Q2. Discribe about lvm
Ans. 
LVM (Logical Volume Manager) is a tool used in Linux to manage storage by creating logical volumes from physical volumes.
• LVM allows for dynamic resizing of logical volumes without downtime.

• It provides features like snapshots, striping, mirroring, and thin provisioning.

• Physical volumes are divided into extents, which can be allocated to logical volumes.

• Commands like pvcreate, vgcreate, lvcreate are used to create physic...read more
Answered by AI
Add your answer