Application Developer 2 Interview Questions and Answers

SQL query to copy table structure without data

• Use CREATE TABLE AS SELECT statement

• Include WHERE clause to avoid copying data

• Example: CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1=0

Print the first non-repeating character in a given string.

• Create a hash table to store the frequency of each character in the string.

• Iterate through the string and update the frequency of each character in the hash table.

• Iterate through the string again and return the first character with a frequency of 1.