Databases - Upwork

Question: What are the columns of a table called in a relational model?
A
Attributes

B
Rows

C
Tuples

D
Constraints

E
Keys

F
Indexes

G
Sets

H
Elements

Note: Not available
1. Report
Question: The level of data abstraction which describes how the data is actually stored is?
A
Physical level

B
Conceptual level

C
Storage level

D
File level

Note: Not available
1. Report
Question: Which of the following is not a set operator?
A
Union

B
Union all

C
Intersect

D
Minus

E
Minus all

Note: Not available
1. Report
Question: View the following Create statement: 1 Create table Pers 2 (EmpNo Number(4) not null, 3 EName Char not null, 4 Join_dt Date not null, 5 Pay Number) Which line contains an error?
A
1

B
2

C
3

D
4

E
5

Note: Not available
1. Report
Question: For which SQL operation is Alter Table used?
A
To add a column

B
To add an integrity constraint

C
To modify storage characteristics

D
To enable/disable or drop an integrity constraint

E
all of the above

Note: Not available
1. Report
Question: < and > are examples of _________ type of operators.
A
Logical

B
Assignment

C
Ternary

D
Relational

E
Numeric

F
Comparison

G
None of the above

H
Arithmetic

Note: Not available
1. Report
Question: Examine the two SQL statements given below: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC What is true about them?
A
The two statements produce identical results

B
The second statement returns an error

C
There is no need to specify DESC because the results are sorted in descending order by default

Note: Not available
1. Report
Question: What does MOD() function do?
A
Returns the remainder after division

B
Modifies the column definition

C
Modifies the definition of a table

D
None of the above

Note: Not available
1. Report
Question: The names of those departments where there are more than 100 employees have to be displayed. Given two relations, employees and departments, what query should be used? Employee --------- Empno Employeename Salary Deptno Department --------- Deptno Departname
A
Select departname from department where deptno in (select deptno from employee group by deptno having count(*) > 100);

B
Select departname from department where deptno in (select count(*) from employee group by deptno where count(*) > 100);

C
Select departname from department where count(deptno) > 100;

D
Select departname from department where deptno in (select count(*) from employee where count(*) > 100);

Note: Not available
1. Report
Question: An association of several entities in a Entity-Relation model is called?
A
Tuple

B
Record

C
Relationship

D
Field

Note: Not available
1. Report

First Prev 27 28 29 30 31 Next Last

Question: What are the columns of a table called in a relational model?

Question: The level of data abstraction which describes how the data is actually stored is?

Question: Which of the following is not a set operator?

Question: View the following Create statement: 1 Create table Pers 2 (EmpNo Number(4) not null, 3 EName Char not null, 4 Join_dt Date not null, 5 Pay Number) Which line contains an error?

Question: For which SQL operation is Alter Table used?

Question: < and > are examples of _________ type of operators.

Question: Examine the two SQL statements given below: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC What is true about them?

Question: What does MOD() function do?

Question: The names of those departments where there are more than 100 employees have to be displayed. Given two relations, employees and departments, what query should be used? Employee --------- Empno Employeename Salary Deptno Department --------- Deptno Departname

Question: An association of several entities in a Entity-Relation model is called?