SELECT name ____ instructor name, course id
FROM instructor, teaches
WHERE instructor.ID= teaches.ID;
Which keyword must be used here to rename the field name?
From
Rename
As
Join
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
Using which language can a user request information from a database?
Solution |
2
Discuss
|
The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
Solution |
3
Discuss
|
This query does which of the following operation?
Solution |
4
Discuss
|
The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Solution |
5
Discuss
|
By default, the order by clause lists items in ______ order.
Solution |
6
Discuss
|
Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
Solution |
7
Discuss
|
The ________ clause is used to list the attributes desired in the result of a query.
Solution |
8
Discuss
|
This query can be replaced by which of the following ?
Solution |
9
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 |
10
Discuss
|
’_____’ matches any string of ______ three characters. ’_____%’ matches any string of at ______ three characters.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved