MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Consider the below schema:-STUDENTS(student ____ code, first ____ name, last ____ name, email, phone ____ no, date ____ of ____ birth, honours ____ subject, percentage ____ of ____ marks) ____ Which of the following query would display names of all the students whose honours subject is English, or honours subject is Spanish and percentage of marks more than 80?
A
select first ____ name, last name from students where (honours ____ subject = “English” or honours ____ subject = “Spanish” ) and percentage ____ of ____ marks > 80;
B
select first ____ name, last name from students where honours ____ subject = “English” or honours ____ subject = “Spanish” and percentage ____ of ____ marks > 80;
C
select first ____ name, last name from students where honours ____ subject = “English” and honours ____ subject = “Spanish” or percentage ____ of ____ marks > 80;
D
select * from students where honours ____ subject = “English” or honours ____ subject = “Spanish” and percentage ____ of ____ marks > 80;
Explanation: 

Detailed explanation-1: -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%’;

Detailed explanation-2: -D-Indexes should ideally be created on small tables. Q 39-Which of the following code will create an index named stu marks ind on the columns student code and percentage of marks of the STUDENTS table? stu marks ind on the columns student code and percentage of marks of the STUDENTS table.

Detailed explanation-3: -Answer : A Q 16-Which of the following is not true about database synonyms? A-Synonyms are used for shortening lengthy object names.

Detailed explanation-4: -The correct answer is Select, where, group by, having.

There is 1 question to complete.
Previous
Next