Prepladder interview question

they just ask basic question, what is array what is join in dbms , write program for pettern printing pyramid,etc ...and basic diff in groupby and distinct in sql query