SELECT * FROM employee WHERE dept_name="Comp Sci";
In the SQL given above there is an error . Identify the error.
Dept_name
Employee
“Comp Sci”
From
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
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 |
2
Discuss
|
The term _______ is used to refer to a row.
Solution |
3
Discuss
|
This query can be replaced by which of the following ?
Solution |
4
Discuss
|
The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Solution |
5
Discuss
|
The term attribute refers to a ___________ of a table.
Solution |
6
Discuss
|
_____ operator is used for appending two strings.
Solution |
7
Discuss
|
Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?
Solution |
8
Discuss
|
The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Solution |
9
Discuss
|
The _________ provides a set of operations that take one or more relations as input and return a relation as an output.
Solution |
10
Discuss
|
The ________ clause is used to list the attributes desired in the result of a query.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved