10+ Citicorp Officer Interview Questions and Answers

Procedure is a set of instructions that performs a specific task, while function returns a value after performing a task.

• Procedure does not return a value, while function does.

• Functions can be called from within expressions, while procedures cannot.

• Functions can have parameters passed to them, while procedures can have both parameters and arguments.

• Examples of procedures include printing to the console, while examples of functions include calculating a sum or finding the leng...read more

Soft links are pointers to the original file while hard links are additional names for the same file.

• Soft links are created using the 'ln -s' command while hard links are created using the 'ln' command.

• Soft links can point to files on different file systems while hard links cannot.

• Deleting the original file will render a soft link useless while a hard link will still work.

• Soft links have different inode numbers while hard links have the same inode number as the original file.

To replace male with female in Oracle, use the UPDATE statement with the SET clause.

• Use the UPDATE statement with the SET clause to replace male with female in Oracle

• Example: UPDATE employees SET gender='female' WHERE gender='male'

• Make sure to specify the table name and column name correctly

• Use WHERE clause to specify the condition for replacement

Delete removes specific rows while truncate removes all rows from a table.

• Delete is a DML command while truncate is a DDL command.

• Delete is slower than truncate as it logs each row deletion while truncate does not.

• Delete can be rolled back while truncate cannot be rolled back.

• Delete can have a WHERE clause to specify which rows to delete while truncate removes all rows.

• Delete does not reset the identity of the table while truncate resets the identity of the table.

Command to replace Sam with vam on 5th line

• sed '5s/Sam/vam/' filename.txt

• awk 'NR==5 {sub(/Sam/, "vam")} 1' filename.txt

A cursor is a database object used to manipulate data in a result set.

• A cursor is used to traverse through a result set one row at a time.

• There are two types of cursors: static and dynamic.

• Static cursors are read-only and scroll forward only.

• Dynamic cursors are updatable and can scroll in any direction.

• Cursors can be used in stored procedures, triggers, and functions.

Use the 'du' command to display biggest file on server.

• Open terminal or SSH into server

• Navigate to directory to search from

• Run 'du -a . | sort -n -r | head -n 1' command

• The output will display the biggest file on the server

Query to display 3rd highest salary

• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to limit the result to the third row

• Use a subquery to exclude the top two salaries

Display second last line of a file using command line.

• Use the tail command with -n option to display last two lines of the file.

• Then use head command with -n option to display the second last line.

• Example: tail -n 2 file.txt | head -n 1

Command to display blank line in file

• Use echo command with empty quotes to create a blank line in a file

• Syntax: echo '' >> filename

• Alternatively, use printf command with newline character

• Syntax: printf ' ' >> filename

VSAM is a file management system used in mainframe computers. It has different types like KSDS, ESDS, and RRDS.

• VSAM stands for Virtual Storage Access Method.

• It is a file management system used in IBM mainframe computers.

• VSAM provides efficient access to large volumes of data.

• It supports different types of datasets like Key Sequenced Data Set (KSDS), Entry Sequenced Data Set (ESDS), and Relative Record Data Set (RRDS).

• KSDS is used for direct access and is organized based on a ...read more

NAV stands for Net Asset Value.

• NAV is a financial term used to describe the value of an investment fund's assets minus its liabilities.

• It is calculated by dividing the total value of the fund's assets by the number of outstanding shares.

• NAV is used to determine the price at which shares in the fund are bought and sold.

• It is also used to calculate the performance of the fund over time.

• For example, if a mutual fund has assets worth $100 million and liabilities worth $10 million...read more