choose the correct answers for sql

Which statement about a self-join is true? O a. Table aliases cannot be used to qualify table names O b. The NATURAL JOIN clause must be used C. A self join must be implemented by defining a view O d. Table aliases must be used to qualify table names You need to display the current year as a character value (Example: Twenty Twenty). Which of the following date format will you set in the database? O a. YYYY O b. YY O C. YEAR O d. RR AnyDe Imagine that you are using a select clause with where condition. The data you wish to retrieve is available in only one or two columns. Which SQL capability you should implement in-order to satisfy your requirements? PDE azhar: O a. Joining only O b.Selection only O c. Projection and Selection O d. Projection only Adob Creati RE Which logical operator returns true, if any one of the condition is satisfied? O a. OR O b. NOT O C. IN O d. AND Evaluate the statement: Select LPAD ('FINAL EXAM',12,'$); Identify which one of the following will the outcome after the statement is executed in SQL? O a. FINAL EXAM$$$ O b. $$FINAL EXAM O C. $$$FINAL EXAM O d. FINAL EXAM$$