ANSI SQL, Databases

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
Question: How many foreign key constraints can a table have?
A
1

B
2

C
3

D
4

E
5

F
6

G
None of the above

Note: Not available
1. Report
Question: When a table is dropped using a simple DROP statement, SQL performs some more operations simultaneously, select all the valid operations?
A
Removes all rows from the table

B
Drops all the table's indexes

C
Removes all dependent views

D
Removes all dependent procedures

Note: Not available
1. Report

First Prev 1 2 3 Next Last

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?

Question: How many foreign key constraints can a table have?

Question: When a table is dropped using a simple DROP statement, SQL performs some more operations simultaneously, select all the valid operations?