When you execute SELECT statement, it will return sorted result but only by one column.
A)
True
done
clear
B)
False
done
clear
C)
None of these
done
clear
D)
All of the above
done
clear
View Answer play_arrow
When you don't want to consider duplicate rows, then you will use DISTINCT.
A)
True
done
clear
B)
False
done
clear
C)
None of these
done
clear
D)
All of the above
done
clear
View Answer play_arrow
Behaviour of DISTINCT is different from ALL.
A)
True
done
clear
B)
False
done
clear
C)
None of these
done
clear
D)
All of the above
done
clear
View Answer play_arrow
................wild card (symbol) is used for matching multiple characters in a string.
A)
done
clear
B)
done
clear
C)
%
done
clear
D)
_
done
clear
View Answer play_arrow
Choose the option which is used to specify the list of values in SQL commands.
A)
IN
done
clear
B)
Like
done
clear
C)
Or
done
clear
D)
And
done
clear
View Answer play_arrow
You can use ORDER BY with SELECT and as well as with GROUP BY Statements.
A)
True
done
clear
B)
False
done
clear
C)
None of these
done
clear
D)
All of the above
done
clear
View Answer play_arrow
Where is use with Select statement however Having is use with GROUP BY Statement.
A)
True
done
clear
B)
False
done
clear
C)
None of these
done
clear
D)
All of the above
done
clear
View Answer play_arrow
Which command is used to add new column in a table.
A)
Add
done
clear
B)
insert into
done
clear
C)
Alter table.... Add
done
clear
D)
None of the above
done
clear
View Answer play_arrow
...................clause is used to apply condition with Group By statement.
A)
Group by
done
clear
B)
With
done
clear
C)
Where
done
clear
D)
Having
done
clear
View Answer play_arrow
Which command is used to update the size of column in a table?
A)
Add
done
clear
B)
update
done
clear
C)
Alter table.....Modify
done
clear
D)
None of the above
done
clear
View Answer play_arrow
_____clause of SELECT query allows us to select only those rows in the result that satisfy a specified condition.
A)
Where
done
clear
B)
from
done
clear
C)
having
done
clear
D)
like
done
clear
View Answer play_arrow
Drop and Delete are the same thing
A)
True
done
clear
B)
False
done
clear
C)
None of these
done
clear
D)
All of the above
done
clear
View Answer play_arrow
..........................command is used to delete all table with values from memory. After executing this command you will able to create new table with the deleted table name.
A)
delete
done
clear
B)
drop
done
clear
C)
Both a and b
done
clear
D)
none of the following
done
clear
View Answer play_arrow
..........................command is used to delete values from the table, but it lies on memory. After executing this command you will not able to create new table with the same table name.
A)
delete
done
clear
B)
drop
done
clear
C)
Both a and b
done
clear
D)
none of the following
done
clear
View Answer play_arrow
Select the correct option, table name is "Study", Rno is field name, then:
A)
done
clear
B)
done
clear
C)
done
clear
D)
done
clear
View Answer play_arrow
If table name is "Study", Rno is field name, then display all data except whose Rno is 10
A)
done
clear
B)
done
clear
C)
done
clear
D)
done
clear
View Answer play_arrow
By mistake, a teacher wrote 75 as 57 in marks column of "Study" table where roll no (Rno) is 10. Now, choose the correct command to update the above marks
A)
Update Study Set Marks=75;
done
clear
B)
Update Table Study Set Marks=75;
done
clear
C)
Update Study Set Marks=75 where Rno=10;
done
clear
D)
Update From Study Set Marks=75;
done
clear
View Answer play_arrow
In an institute some student didn't pay the fees and in fees column "Null" is automatically filled. Choose the correct statement to display all the students who haven't paid the fees. Table name is "Study", Field name is "Fees"
A)
done
clear
B)
done
clear
C)
done
clear
D)
done
clear
View Answer play_arrow
In an institute some students left who didn't pay the fees, but instead of deleting the record of these students, teacher updated a field called "IsDeleted" to 1. Choose the correct statement to handle the above situation. Table name is "Study", Field name is "Fees" and "IsDeleted".
A)
done
clear
B)
done
clear
C)
done
clear
D)
done
clear
View Answer play_arrow
......................is primary key of some other table and a non-key attribute whose values are derived from the existing table.
A)
Primary Key
done
clear
B)
Candidate Key
done
clear
C)
Foreign Key
done
clear
D)
None of the above
done
clear
View Answer play_arrow