ANSI SQL, Databases

Question: You want to display the titles of books that meet the following criteria: 1. Purchased before November 11, 2002 2. Price is less than $500 or greater than $900 You want to sort the result by the date of purchase, starting with the most recently bought book. Which of the following statements should you use?
A
SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '11/11/2002' ORDER BY purchase_date;

B
SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date< '11/11/2002' ORDER BY purchase_date ASC;

C
SELECT book_title FROM books WHERE (price < 500 OR price >900) AND purchase_date DESC;

D
SELECT Book_title FROM books WHERE (price < 500 OR price >900) AND purchase_date<'11/11/2002' ORDER BY purchase_date DESC;

Note: Not available
1. Report
Question: Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp
A
+

B
-

C
/

D
*

Note: Not available
1. Report
Question: What clause should be used to display the rows of a table in ascending order of a particular column?
A
Where

B
Order By

C
Group By

D
Having

E
First Group By and then Having

F
Like

G
Between

Note: Not available
1. Report
Question: What is the correct order of clauses in the select statement? 1 select 2 order by 3 where 4 having 5 group by
A
1,2,3,4,5

B
1,3,5,4,2

C
1,3,5,2,4

D
1,3,2,5,4

E
1,3,2,4,5

F
1,5,2,3,4

G
1,4,2,3,5

H
1,4,3,2,5

Note: Not available
1. Report
Question: Which of the following statements is true? (a)The Insert statement creates new rows (b)The Update statement modifies the table structure
A
only (a) is true

B
only (b) is true

C
oth (a) and (b) are true

D
oth (a) and (b) are false

Note: Not available
1. Report
Question: A table Students has a column called name which stores the names of the students. What will be the correct query to display the names of the students in reverse order?
A
Select name from students reverse;

B
Select name from students reverse name;

C
Select name from students order by name descending;

D
Select name from students order by name reverse;

E
Select name from students order by name desc;

F
Select desc name from students;

G
Select reverse name from students;

Note: Not available
1. Report
Question: Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in descending order of the CurrentStock column.
A
Select * from Products order by CurrentStock,ProductGroup

B
Select * from Products order by CurrentStock DESC,ProductGroup

C
Select * from Products order by ProductGroup,CurrentStock

D
Select * from Products order by ProductGroup,CurrentStock DESC

E
None of the above

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: The overall logical structure of a database can be expressed graphically by:
A
Data Flow Chart

B
Flow Chart

C
Directed Chart

D
Entity-Relationship Diagram

E
None of the above

Note: Not available
1. Report
Question: In an RDBMS, which term is used to describe 'data about data'?
A
Meta data

B
Data dictionary

C
Database

D
None of the above

Note: Not available
1. Report

First Prev 1 2 3 Next Last

Question: Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp

Question: What clause should be used to display the rows of a table in ascending order of a particular column?

Question: What is the correct order of clauses in the select statement? 1 select 2 order by 3 where 4 having 5 group by

Question: Which of the following statements is true? (a)The Insert statement creates new rows (b)The Update statement modifies the table structure

Question: A table Students has a column called name which stores the names of the students. What will be the correct query to display the names of the students in reverse order?

Question: Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in descending order of the CurrentStock column.

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: The overall logical structure of a database can be expressed graphically by:

Question: In an RDBMS, which term is used to describe 'data about data'?