The SQL-92 wildcards are Select one: question mark (?); an asterisk (*) percent sign (%) ;...

Transcribed Image Text:

The SQL-92 wildcards are Select one: question mark (?); an asterisk (*) percent sign (%) ; underscore (__) underscore(); question mark (?) asterisk (*); percent sign (%) and H This Query can be replaced by which one of the following? SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID; Select one: Select name, course_id from instructor; Select name,course_id from teaches, instructor where instructor_id=course_id; Select course_id from instructor join teaches; Select name, course_id from instructor natural join teaches; The SQL-92 wildcards are Select one: question mark (?); an asterisk (*) percent sign (%) ; underscore (__) underscore(); question mark (?) asterisk (*); percent sign (%) and H This Query can be replaced by which one of the following? SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID; Select one: Select name, course_id from instructor; Select name,course_id from teaches, instructor where instructor_id=course_id; Select course_id from instructor join teaches; Select name, course_id from instructor natural join teaches;

Answer rating: 100% (QA)

1ans option a asterisk and question mark Wildcards are used to search for ... View the full answer