Royal Bank of Scotland International Plsql Developer Interview Questions and Answers

Q1. How to find difference between two dates?
Ans. 
To find the difference between two dates, subtract the earlier date from the later date.
• Subtract the earlier date from the later date

• Use a date library or built-in functions to perform the subtraction

• Consider time zones and daylight saving time if applicable
Answered by AI
Add your answer
Q2. How to use gather stats?
Ans. 
Gather stats is used to collect statistics about database objects in order to optimize query performance.
• Gather stats is a command in database management systems like Oracle and PostgreSQL.

• It collects information about the distribution of data in tables and indexes.

• This information helps the query optimizer to generate efficient execution plans.

• Gather stats can be used on individual tables, indexes, or the entire datab...read more
Answered by AI
Add your answer
Q3. How to reverse a string in Unix?
Ans. 
To reverse a string in Unix, you can use the 'rev' command.
• Use the 'rev' command followed by the string you want to reverse.

• The 'rev' command reads the input from right to left and outputs it in reverse order.

• The 'rev' command can be used with pipes to reverse the output of other commands.
Answered by AI
Add your answer

Was given a bar raiser round where been asked problems on dp, create a crud shopping cart type webapp in react, and one css problem to align all boxes across diagonal

Mostly around resume and performance optimisation

Q1. Verbally design infinte scroll in react
Ans. 
Implementing infinite scroll in React involves dynamically loading content as the user scrolls down the page.
• Use a scroll event listener to detect when the user reaches the bottom of the page

• Fetch more data from the server and append it to the existing content

• Update the state to reflect the new content and trigger a re-render of the component
Answered by AI
Add your answer
Q2. Flatten array deeply nested
Ans. 
Flatten deeply nested array of strings
• Use recursion to iterate through each element in the array

• Check if each element is an array, if so, recursively call the function

• Concatenate the strings from each nested array into a single flat array
Answered by AI
Add your answer

Q1. Spring, spring boot, java, Junit5
Add your answer
Q2. Angular if going forFullstack
Add your answer

Q1. Prototype inheritance
Add your answer

Q1. Tell me full form of html and CSS and types
Ans. 
HTML stands for Hypertext Markup Language and CSS stands for Cascading Style Sheets.
• HTML is used for creating the structure and content of a webpage.

• CSS is used for styling and formatting the appearance of a webpage.

• HTML and CSS are the fundamental building blocks of web development.

• HTML tags are used to define elements on a webpage, while CSS is used to apply styles to those elements.

• There are different types of HTML
Answered by AI
View 1 more answer
Q2. Hyper text markup language and cascading style sheets
Add your answer
Q3. Types is internal, external and inline css

Ans. 

Types of CSS are internal, external and inline.

• Internal CSS is defined within the HTML document using the