SQL, Databases

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
Question: Which of the following statements regarding views are incorrect?
A
A view is like a window through which data on tables can be viewed or changed

B
A view is derived from another table

C
A view cannot be derived from another view

D
A view is stored as a select statement only

E
A view has no data of its own

F
A view is another name for a table

Note: Not available
1. Report
Question: Consider the following tables: Books ------ BookId BookName AuthorId SubjectId PopularityRating (the popularity of the book on a scale of 1 to 10) Language (such as French, English, German etc) Subjects --------- SubjectId Subject (such as History, Geography, Mathematics etc) Authors -------- AuthorId AuthorName Country What is the query to determine the names of the Authors who have written more than 1 book?
A
select AuthorName from Authors where AuthorId in (select AuthorId from Books group by AuthorId having count(*)>1)

B
select AuthorName from Authors, Books where Authors.AuthorId=Books.AuthorId and count(BookId)>1

C
select AuthorName from Authors, Books where Authors.AuthorId=Books.AuthorId group by AuthorName having count(*)>1

D
select AuthorName from Authors where AuthorId in (select AuthorId from Books having count(BookId)>1)

Note: Not available
1. Report

First Prev 1 2 3 4 5 Next Last

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?

Question: Which of the following statements regarding views are incorrect?