i need help with this sql quiz please 1.When modeling an object, person or thing
ID: 3876407 • Letter: I
Question
i need help with this sql quiz please
1.When modeling an object, person or thing in a database, we refer to it as a
2.An advantage of a database is that you can change its underlying structure without having to modify the programs which access the database. This is know an
3.A database is often referred to as a collection of _______ which can often have _______ with each other.
4.if Given a table of Customers, what statement would help me retrieve all columns from the customer table?
5.When sorting on more than one column in a query, any sort after the first sort is known as the
6.This type of query modifies existing data with changes to specified column values.
7.Which relational algebra operation joins customers and reps and takes the vertical subset of customernum and repnum
8.In order to bring together select records that share the same characteristics, we use the _____ operator.
9.To get all the rows that are common in two tables, we need to use the ______ in relational algebra.
Explanation / Answer
ANS 1.
When modeling an object, person or thing in a database, we refer to it as a__(table)__.(the data model focuses on what data is required and how it should be organized rather than what operations will be performed on the data.)
ANS 2.
Using ALTER TABLE Statement.
ANS 3.
A database is often referred to as a collection of __(data/tables)__ which can often have __(relations)___ with each other.
ANS 4.
SELECT *
FROM customer(Considering this as the name of the table)
ANS5.
Can be done using ORDER BY command. Firstly sorted on the basis of first column and then internally on the basis of second column.
ANS 6.
Can be done using UPDATE command.
ANS 7.
PROJECTION (pie)
ANS 8.
INTERSECT operator
ANS 9.
To get all the rows that are common in two tables, we need to use the __(Intersection,reverse U sign)__ in relational algebra.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.