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>

Related MCQs

• This statement fails when executed: CREATE OR REPLACE TRI GGER CALC_TEAM_AVG AFTER I NSERT ON PLAYER BEGIN INSERT INTO PLAYER_BATSTAT ( PLAYER_I D, SEASON_YEAR, AT_BATS, HI TS) VALUES ( : NEW. I D, 1 997, 0, 0) ; END; To which type must you convert the trigger to correct the error?
• To select all column from the table the syntax is:
• You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?
• What is the syntax to load data into the database? (Consider D as the database and a, b, c as datA:)
• 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;
• If the attribute phone number is included in the relation all the values need not be entered into the phone number column. This type of entry is given as
• Which of the following is the right syntax for the assertion?
• Which one of the following is the right syntax for DECODE?
• To select all columns from the table the syntax is:
• Syntax for creating views is __________