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.
Schema diagram
Relational algebra
Database diagram
Schema flow
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
|
Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
Solution |
3
Discuss
|
The tuples of the relations can be of ________ order.
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
|
To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Solution |
6
Discuss
|
Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Solution |
7
Discuss
|
The term _______ is used to refer to a row.
Solution |
8
Discuss
|
_____ operator is used for appending two strings.
Solution |
9
Discuss
|
The ________ clause is used to list the attributes desired in the result of a query.
Solution |
10
Discuss
|
By default, the order by clause lists items in ______ order.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved