COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following query would display all the students whose first name starts with the character ‘A’?
|
|
select first____name from students where first____name like ‘A%’;
|
|
|
select first____name from students where first____name like ‘%A’;
|
|
|
select first____name from students where first____name like ‘%A%’;
|
|
|
select first____name from students where first____name like ‘A’;
|
Explanation:
Detailed explanation-1: -Q 48-Which of the following code would allocate the privileges of creating tables and view to the role named student admin? A-grant create table, create view to student admin; B-grant to student admin create table, create view; C-grant role student admin create table, create view; D-None of the above.
Detailed explanation-2: -The correct answer to the question “Which of the SQL statements is correct” is option (b). SELECT Username, Password FROM Users.
There is 1 question to complete.