SQL, Databases

Question: Which of the following is not a numeric group function?
A
Avg

B
Count

C
Highest

D
Max

E
Stdev

F
Sum

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
Question: Which of the following constraints cannot be applied at the table level?
A
Primary key

B
Foreign key

C
Not null

D
Check

E
Unique

Note: Not available
1. Report
Question: A construction company is currently executing three projects- hotel construction, residential construction and business towers. The construction company employs both Civil Engineers and Structural Engineers. A Civil Engineer can work on only one project at a time, but each project can accomodate more than one Civil Engineer. On the other hand, a Structural Engineer can work on more than one project and a project could accomodate several Structural Engineers. Define the nature of relationship between (Civil Engineers and Projects) and (Structural Engineers and Projects)
A
one to many, one to one

B
one to one, one to many

C
many to one, many to many

D
many to one, many to one

Note: Not available
1. Report
Question: If entity x is existence-dependent on entity y then what is x said to be?
A
Dominant entity

B
Subordinate entity

C
Primary entity

D
Secondary entity

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 these 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 how many books have been written on each subject. Displaying Name of Subject and count of the Books?
A
select subject,count(*) from books,subjects where books.subjectid=subjects.subjectid group by books.subjectid

B
select count(*),subject from books,subjects where books.subject.id=subjects.subject.id group by subjects.subject

C
select subject,count(*) from books,subjects where books.Authorid=subjects.Authorid group by books.subjectid,subjects.subject

D
select subject,count(*) from books,subjects where books.BookId=subjects.BookId group by books.subjectid,subjects.subject

Note: Not available
1. Report
Question: Which of the following statements are true?
A
With DDL you can create and remove tables, schemas, domains, indexes and views

B
Select, Insert and Update are DCL commands

C
Grant and Revoke are DML commands

D
Commit and Rollback are DCL commands

Note: Not available
1. Report
Question: Which logical operator can reverse the result?
A
AND

B
OR

C
NOT

D
ANY

Note: Not available
1. Report

First Prev 5 6 7 8 9 Next Last

Question: Which of the following is not a numeric group function?

Question: Which of the following constraints cannot be applied at the table level?

Question: If entity x is existence-dependent on entity y then what is x said to be?

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 of the following statements are true?

Question: Which logical operator can reverse the result?