Databases - Upwork

Question: Consider the following table structure of students: rollno number(4) name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?
A
Select course from students where count(course) > 5;

B
Select course from students where count(*) > 5 group by course;

C
Select course from students group by course;

D
Select course from students group by course having count(*) > 5;

E
Select course from students group by course where count(*) > 5;

F
Select course from students where count(group(course)) > 5;

G
Select count(course) > 5 from students;

H
None of the above

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 which Authors have written at least 1 book with a popularity rating of less than 5?
A
select authorname from authors where authorid in (select authorid from books where popularityrating<5)

B
select authorname from authors where authorid in (select authorid from books where popularityrating<=5)

C
select authorname from authors where authorid in (select BookId from books where popularityrating<5)

D
select authorname from authors where authorid in (select authorid from books where popularityrating in (0,5))

Note: Not available
1. Report
Question: Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statements is correct with regard to this code?
A
It returns employees whose salary is 50% more than $23,000

B
It returns employees who have 50% commission rate or salary greater than $23,000

C
It returns employees whose salary is 50% less than $23,000

D
None of the above

Note: Not available
1. Report
Question: Which component of an RDBMS validates the syntax of the user's query?
A
Query Parse

B
The Database Manage

C
Query Optimization

D
Database Administrato

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: Which of the following is not a SQL operator?
A
Between..and..

B
Like

C
In

D
Is null

E
Having

F
Not in

Note: Not available
1. Report
Question: Which of the following operation is invalid with respect to dates?
A
date + numbe

B
date * numbe

C
date - numbe

D
date - date

E
date + number/24

Note: Not available
1. Report
Question: What does the term DDL stand for?
A
Data Description Language

B
Dynamic Data Language

C
Data Definition Language

D
Data Derived Language

E
Descriptive Data Language

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 which German books(if any) are more popular than all the French?
A
select bookname from books where language='German' and popularityrating = (select popularityrating from books where language='French')

B
select bookname from books where language='German' and popularityrating > (select popularityrating from books where language='French')

C
select bookname from books where language='French' and popularityrating > (select max(popularityrating) from books where language='German')

D
select bookname from books where language='German' and popularityrating > (select max(popularityrating) from books where language='French')

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 which is the most popular book written in French?
A
select bookname from books where language='French' and popularityrating = (select max(popularityrating) from books where language='French')

B
select bookname from books where language='French' and popularityrating = (select max(popularityrating) from books Having language='French')

C
select bookname,max(popularityrating) from books where language='French' and max(popularityrating)

D
select bookname,max(popularityrating) from books where language='French' having max(popularityrating)

Note: Not available
1. Report

First Prev 23 24 25 26 27 Next Last

Question: Consider the following table structure of students: rollno number(4) name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?

Question: Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statements is correct with regard to this code?

Question: Which component of an RDBMS validates the syntax of the user's query?

Question: What does MOD() function do?

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

Question: Which of the following operation is invalid with respect to dates?

Question: What does the term DDL stand for?