What type of join is needed when you wish to include rows that do not have matching values?

Related MCQs

• What type of join is needed when you wish to include rows that do not have matching values?
• What type of join is needed when you wish to return rows that do have matching values?
• Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• Which are the join types in join condition:
• How many join types in join condition:
• In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
• Which of the following consists of a row of column headings, together with zero or more rows of data values?
• Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
• In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;