Expert Global Solutions Design and Application Engineer Interview Questions and Answers

Frequent test as of studied in privious company learnt

Q1. Describe the 'delete' command In oracle.
Ans. 
The 'delete' command in Oracle is used to remove rows from a table based on specified conditions.
• The 'delete' command is used to remove rows from a table in Oracle.

• It is important to specify the conditions for deletion using a WHERE clause.

• After executing the delete command, the rows are permanently removed from the table.

• It is recommended to use a commit statement after executing the delete command to make the changes
Answered by AI
Add your answer
Q2. 'Grep' command in brief
Ans. 
Grep command is used in Unix/Linux to search for specific patterns in files or output.
• Used to search for specific patterns in files or output

• Can be used with regular expressions to refine search results

• Commonly used with options like -i (case-insensitive) and -r (recursive)

• Example: grep 'keyword' filename.txt
Answered by AI
Add your answer