SELECT *
FROM instructor
ORDER BY salary ____, name ___;
To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Ascending, Descending
Asc, Desc
Desc, Asc
Descending, Ascending
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
Solution |
2
Discuss
|
_____ operator is used for appending two strings.
Solution |
3
Discuss
|
Which one of the following is procedural language?
Solution |
4
Discuss
|
Student(ID, name, dept name, tot_cred)
Solution |
5
Discuss
|
A relational database consists of a collection of
Solution |
6
Discuss
|
The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Solution |
7
Discuss
|
This query does which of the following operation?
Solution |
8
Discuss
|
Using which language can a user request information from a database?
Solution |
9
Discuss
|
A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
Solution |
10
Discuss
|
The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved