Given a relational database with a person table that contains an id, name, and age. What do each of the following return?
1. Select * from person.
2. Select age from person.
3. Select id from person.
4. Select name, age from person.
5. Select * from person where age > 20.
6. Select name from person where age < 20.
1. This returns all the columns of the table “person”, which would be “id, name, and age”.
2. This returns just the column “age” from the table “person”
3. This returns just the column “id” from the table “person”.
4. This returns the columns “name”, and “age” from the table “person”.
5. This returns all the rows from “person” where the “age” value is greater than 20.
6. This returns all the values from the “name” column of “person” where the “age” value for that row is less than 20.
You might also like to view...
What is the difference between a spanning tree and a minimum spanning tree?
What will be an ideal response?
the size argument is too large c) This is not a call to make_2, it is a string constant. e) nets a warning that an int has been passed to a pointer parameter without a cast.
``` int k = 0; for(int i =0; i < 3; i++) for (int j=0, j < 4; j++) matrix[i][j] = k++; ``` The value of matrix[0][0] is a) 0 b) 1 c) 2 d) 3 e) 4
Most personal computer operating systems use the mandatory access control (MAC) model.
Answer the following statement true (T) or false (F)
Note that each set of data members has its own starting address in memory, which corresponds to the address of the object's ____.
A. name B. declaration section C. implementation section D. first data member