SELECT instructor.*
FROM instructor, teaches
WHERE instructor.ID= teaches.ID;
This query does which of the following operation?
All attributes of instructor and teaches are selected
All attributes of instructor are selected on the given condition
All attributes of teaches are selected on given condition
Only the some attributes from instructed and teaches are selected
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
A relational database consists of a collection of
Solution |
2
Discuss
|
The tuples of the relations can be of ________ order.
Solution |
3
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 |
4
Discuss
|
The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Solution |
5
Discuss
|
Using which language can a user request information from a database?
Solution |
6
Discuss
|
The term attribute refers to a ___________ of a table.
Solution |
7
Discuss
|
In SQL the spaces at the end of the string are removed by _______ function.
Solution |
8
Discuss
|
The ________ clause is used to list the attributes desired in the result of a query.
Solution |
9
Discuss
|
’_____’ matches any string of ______ three characters. ’_____%’ matches any string of at ______ three characters.
Solution |
10
Discuss
|
_____ operator is used for appending two strings.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved