Which of the following options are correct regarding these three keys (Primary Key, Super Key, and Candidate Key) in a database?

Category: SQLWhich of the following options are correct regarding these three keys (Primary Key, Super Key, and Candidate Key) in a database?
Editor">Editor Staff asked 2 years ago

Which statement is used to get all data from the student table whose name starts with p?

  1. SELECT * FROM student WHERE name LIKE ‘%p%’;
  2. SELECT * FROM student WHERE name LIKE ‘p%’;
  3. SELECT * FROM student WHERE name LIKE ‘_p%’;
  4. SELECT * FROM student WHERE name LIKE ‘%p’;