Question

Which of the following syntax of the basic query is correct? *

1 point

a) select <relation> from <attribute>

b) select <attribute> from <elation>

c) select <tuple> from <relation>

d) select <tuple> from <attribute>​

Answer 1

Answer:

select <relation> from <attribute

Answer 2

Answer:

Option b) select <attribute> from <relation> is correct.

Explanation:

What is relation?

Relational database, a type of database software stores and retrieve data based on relations. Relations are nothing, but the table itself. Relations are the tables used to store and manage the data in RDBMS (Relational Database Management System).

What are attributes and tuples?

Every table is a collection of rows and columns. Similarly, every relation is also a collection of rows and columns.

Each column in a relation is known as attributes. In other words, attributes are the database fields which describes the column data.

Each row in a relation, is known as tuples. A tuple is a database record which contain the data in each attribute.

SELECT statement:

Select statement in DBMS is used to retrieve the data stored in a table. The data returned is stored in a table called the result-set.

Syntax:

SELECT column_name FROM table_name;

As we have seen that, a relation is the table in database and attributes are the columns or fields in that relation, this statement can be written as:

SELECT attribute FROM relation;

Learn more about select statements:

https://brainly.in/question/8491656

https://brainly.in/question/36167444