Which key represents the relationship between 2 tables? O a. Foreign key O b. Primary key O c. Secondary Key O d. Unique Which table is used to view all constraints created on a user table? a. USER table b. USER_CONSTRAINTS table OC. PRIMARY table O d. FOREIGN table Identify the SQL statement used to add a new record to the table. a. CREATE O b. INSERT O C. ALTER O d. UPDATE Choose the correct output for the given SQL Query. SELECT LPAD ("Ahad', 6.'*')FROM DUAL; a. O b. **Ahad O c. *Ahad* d. Ahad** Identify the DML statement used to retrieve and display records from table. a. INSERT O b. SELECT C. DELETE O d. UPDATE Which of the following clause is used to sort column values in alphabet order? a. GROUP BY O b. HAVING O c. ORDER BY O d. WHERE Identify the constraint that uniquely identifies each row in a table. a. PRIMARY KEY O b. CHECK O c. UNIQUE KEY O d. FOREIGN KEY Which comparison operator allows you to select rows that match either characters, dates, or number patterns? O a. || O b. Like O c. IN O d. Between ., And Choose the correct output for the given SQL Query. Select ROUND (44.865, -10 FROM DUAL; O a. 45 O b. 44.9 O c. 50 O d. 40 Identify the type of join that results all possible combination from both the tables. a. INNER Join O b. CROSS Join O c. OUTER Join O d. NATURAL Join