Add office photos
i
GlobalLogic
Compare
Filter interviews by
GlobalLogic Plsql Developer Interview Questions, Process, and Tips
GlobalLogic Plsql Developer Interview Experiences
1 interview found
(4 Questions)
- Q1. Difference between delete, drop and truncate
- Ans.
Delete removes rows from a table, drop removes the entire table, and truncate removes all rows from a table.
Delete is a DML operation and can be rolled back, but it is slower than truncate.
Drop is a DDL operation and cannot be rolled back. It removes the table and all associated objects.
Truncate is a DDL operation and cannot be rolled back. It removes all rows from the table but keeps the table structure.
Delete and tru...
- Q2. Difference between table and view
- Ans.
Table stores data in a structured format while view is a virtual table created from a query.
Table is a physical object while view is a logical object.
Table can be modified while view cannot be modified directly.
Table can have indexes while view cannot have indexes.
Table can have constraints while view cannot have constraints.
View can be used to simplify complex queries by joining multiple tables.
View can be used to res...
- Q3. What type of cursors did you use
- Ans.
I have used both implicit and explicit cursors in PL/SQL development.
Implicit cursors are used for single-row queries while explicit cursors are used for multi-row queries.
I have used explicit cursors with parameters to make the query more dynamic.
I have also used cursor variables to pass cursors as parameters to procedures and functions.
Examples of cursor types I have used include FOR LOOP, FETCH, and UPDATE cursors.
- Q4. What is primary key and unique key
- Ans.
Primary key uniquely identifies a record in a table, while unique key ensures uniqueness of a column or set of columns.
Primary key is a column or set of columns that uniquely identifies each record in a table
Unique key ensures that a column or set of columns have unique values
Primary key cannot have null values, while unique key can have null values
A table can have only one primary key, but multiple unique keys
Interview Preparation Tips
Frame your answer correctly.if you don't know any complex question ask the interviewer at the end
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Monster
(3 Questions)
- Q1. Write query to get result based on hughest salary
- Ans.
Use SQL query with ORDER BY clause to get result based on highest salary
Use SELECT statement to retrieve data from the table
Use ORDER BY clause with DESC keyword to sort salaries in descending order
Use LIMIT or FETCH FIRST clause to limit the result to only one row
- Q2. Writw merge query
- Q3. Bulk collect and bulk binding difference
- Ans.
Bulk collect is used to fetch multiple rows into collections at once, while bulk binding is used to bind collections to SQL statements for improved performance.
Bulk collect fetches multiple rows into collections in a single operation, reducing context switches and improving performance.
Bulk binding binds collections to SQL statements, reducing the number of context switches between the PL/SQL engine and SQL engine.
Bulk...
Skills evaluated in this interview
Plsql Developer Interview Questions & Answers
Virtusa Consulting Services
Anonymous
posted on 30 Aug 2024
I applied via Job Portal
(1 Question)
- Q1. What is plsql and sql
- Ans.
PL/SQL is a procedural extension of SQL used for writing stored procedures, functions, triggers, and packages in Oracle databases.
PL/SQL stands for Procedural Language/Structured Query Language
It is used to write procedural code like stored procedures, functions, triggers, and packages in Oracle databases
SQL (Structured Query Language) is a standard language for accessing and manipulating databases
SQL is used to query,...
Questions on plsql and sql in general
Skills evaluated in this interview
Selected
I applied via Job Portal and was interviewed before Mar 2023. There were 3 interview rounds.
(1 Question)
- Q1. Sql questions basic
(1 Question)
- Q1. Sql intermediate questions and jira and other daily tools
(1 Question)
- Q1. Salary and other basic
Interview Preparation Tips
Customer Service Executive Interview Questions & Answers
Sutherland Global Services
bhagya sri
posted on 7 Jan 2025
I applied via Walk-in and was interviewed in Dec 2024. There were 2 interview rounds.
(4 Questions)
- Q1. If fresher your introduction they will check your communication and your graduate or not if experienced they will check work responsibilities of your last job and communication but in hightech city sutherl...
- Q2. Tell me something about yourself
- Q3. Tell me about your college days
- Q4. Tell me about ur best friend
Its actually based on your voice actually they are hiring for international voice process so you need to have an idea of how international people speak in their language if you have experience in email writing and able to understand british english then its easy for you to clear
Interview Preparation Tips
- coomunication for confidence
- prepare about your college days
- learn about your best friend
Qa Automation Testing Engineer Interview Questions & Answers
Nagarro
Anonymous
posted on 30 Jan 2025
I was interviewed in Dec 2024.
Basic quant and reasoning questions
Selenium MCQ
Java programs with MCQ
(23 Questions)
- Q1. Tell me about yourself
- Q2. Where you initialise driver
- Q3. Driver is static or non static
- Q4. Difference between static and non static
- Q5. Disadvantages of static and non static
- Q6. Parallel execution in TestNG
- Q7. Write the code for Parallel testing in TestNG
- Q8. Difference between parallel methods and parallel tests
- Q9. Upload file using rest assured
- Q10. Postman basic questions
- Q11. Parameter for post method in postman
- Q12. BDD Framework cucumber
- Q13. Cucumber execution process
- Q14. How cucumber know step defination file placed
- Q15. Parameters used in cucumber
- Q16. Datatable in cucumber
- Q17. Have u created the testplan document when porject was started
- Q18. Testing cycle when project was on initial level
- Q19. Risk management and risk based testing
- Q20. Which estimate technique you follow , if fibonacci then why it is in 1 2 3 5 8 13 ?? Not in 12345678
- Q21. What is testing matrix and automation ROI
- Q22. Cicd tool
- Q23. Handle team ?
Consultant Interview Questions & Answers
Bosch Global Software Technologies
Anonymous
posted on 9 Jan 2025
Selected
I applied via Company Website and was interviewed in Dec 2024. There were 4 interview rounds.
(1 Question)
- Q1. 1 hr interview divided into 4 sections - Intro - Backend - .NET & OOPS Concepts (Was given a code to analyze) - SQL - Write a sql query & some sql questions on joins etc. - Frontend - Angular related quest...
(1 Question)
- Q1. Bit low level Design Patterns Questions, SQL Questions, Angular Questions Checking your confidence while answering
(1 Question)
- Q1. This was Manegerial Round, asked about projects worked upon and some questions over the projects
(1 Question)
- Q1. For this round I was being called to their base location. Salary Discussion
Interview Preparation Tips
- .NET
- SQL
- Angular
- Azure
The aptitude test lasts 30 minutes and focuses on topics relevant to data engineering, including Spark, SQL, Azure, and PySpark.
The coding test is a one-hour examination on PySpark.
(3 Questions)
- Q1. What is the difference between Cache() and Persist()?
- Q2. What does the purpose of the Spark Submit command in Apache Spark?
- Q3. What are window functions in SQL?
(2 Questions)
- Q1. Could you provide more details about the daily responsibilities associated with this role?
- Q2. How would you describe your work culture?
Windows Server Administrator Interview Questions & Answers
DXC Technology
Anonymous
posted on 7 Jan 2025
I applied via Job Portal and was interviewed in Dec 2024. There was 1 interview round.
(5 Questions)
- Q1. What is the potential of artificial intelligence (AI)?
- Q2. What is advanced Excel?
- Q3. What is the Hardwear Installation
- Q4. What is the software installation process
- Q5. Different between Software and Hardware
2JR19EC420_SPOORTI
Selected
It was basic questions of maths and logical reasoning
It’s related to behavioural question fully
(2 Questions)
- Q1. Interviewer asked questions related to the field which I studied 3 to 4 questions example fullwave and half wave difference
- Q2. Also checked our communication through the story telling
Interview Preparation Tips
GlobalLogic Interview FAQs
Tell us how to improve this page.
GlobalLogic Interviews By Designations
- GlobalLogic Associate Analyst Interview Questions
- GlobalLogic Software Engineer Interview Questions
- GlobalLogic Senior Software Engineer Interview Questions
- GlobalLogic Analyst Interview Questions
- GlobalLogic Consultant Interview Questions
- GlobalLogic Associate Consultant Interview Questions
- GlobalLogic Software Developer Interview Questions
- GlobalLogic Associate Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle SQL and PLSQL Developer Interview Questions
- Senior Plsql Developer Interview Questions
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Software Developer Intern Interview Questions
- Backend Developer Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- Show more
GlobalLogic Plsql Developer Interview Process
based on 1 interview
Interview experience
Plsql Developer Interview Questions from Similar Companies
Fast track your campus placements
|
Associate Analyst
3.8k
salaries
|  ₹1 L/yr - ₹4 L/yr |
|
Senior Software Engineer
3.3k
salaries
| ₹5.2 L/yr - ₹22 L/yr |
|
Analyst
3.1k
salaries
| ₹1 L/yr - ₹5.5 L/yr |
|
Software Engineer
2.9k
salaries
| ₹3 L/yr - ₹13 L/yr |
|
Associate Consultant
2.8k
salaries
| ₹9 L/yr - ₹33 L/yr |
TCS
Wipro
Infosys
HCLTech
- Home >
- Interviews >
- GlobalLogic Interview Questions >
- GlobalLogic Plsql Developer Interview Questions
