___________ is the highest level of a transaction isolation implemented by SQL Server.
Read Uncommitted 0%
Read Committed 0%
Repeatable Read 0%
Serializable 0%
A company has the following departments: marketing, Designing, production, Packing What will be the result of the following query? select * from table where department < 'marketing';
The query will return "Designing, Packing" 0.0%
The query will return "Designing, production, Packing" 0.0%
The query will return "packing" 0.0%
Strings cannot be compared using < operator 100.0%
The query will return "Designing" 0.0%
A production house needs a sale report where total sale of the day is more than $20,000. Which of the following query should be used?
select OrderDate,Amount from orders where sum(amount) > 20000 0%
select OrderDate,Amount from orders where sum(amount) > 20000 order by OrderDate 0%
select count(OrderDate),sum(amount) from orders group by OrderDate having sum(amount) > 20000 0%
select count(OrderDate),sum(amount) from orders group by OrderDate where sum(amount) > 20000 0%
A table has following values for its department field: marketing, production, production, sales, NULL, NULL, Marketing, Null What will the following query return: Select distinct(department) fro...
marketing, production, sales 0%
marketing, production, sales, NULL 0%
marketing, production, sales, NULL, NULL 0%
marketing, production, sales, NULL, Marketing 0%
marketing, production, sales, NULL, NULL, Marketing 0%
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 Cu...
Select * from Products order by CurrentStock,ProductGroup 0%
Select * from Products order by CurrentStock DESC,ProductGroup 0%
Select * from Products order by ProductGroup,CurrentStock 0%
Select * from Products order by ProductGroup,CurrentStock DESC 0%
None of the above 0%
Consider the following queries: 1. select * from employee where department LIKE "[^F-M]%"; 2. select * from employee where department = '[^F-M]%'; Select the correct option:
Query 2 will return an error 0%
Both the queries will return the same set of records 0%
Query 2 is perfectly correct 0%
Query 2 would return one record less than Query 1 0%
Consider the following statements and pick the correct answer: 1. ceiling() - returns the smallest integer greater than or equal to the specified value 2. floor() - returns the largest integer les...
1 is true and 2 is false 0%
1 is false and 2 is true 0%
Both 1 and 2 are true 0%
Both 1 and 2 are false 0%
Consider the following table structure of students: rollno int name varchar(20) course varchar(20) What will be the query to display the courses in w...
Select course from students where count(course) > 5; 0.0%
Select course from students where count(*) > 5 group by course; 0.0%
Select course from students group by course; 0.0%
Select course from students group by course having count(*) > 5; 100.0%
Select course from students group by course where count(*) > 5; 0.0%
Select course from students where count(group(course)) > 5; 0.0%
Select count(course) > 5 from students; 0.0%
None of the above 0.0%
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, Eng...
select subject,count(*) from books,subjects where books.subjectid=subjects.subjectid group by books.subjectid 0%
select subject,count(*) from books,subjects where books.subjectid=subjects.subjectid group by books.subjectid,subjects.subject 0%
select subject,count(*) from books,subjects where books.Authorid=subjects.Authorid group by books.subjectid,subjects.subject 0%
select subject,count(*) from books,subjects where books.BookId=subjects.BookId group by books.subjectid,subjects.subject 0%
select subject,count(*) as Books from books,subjects where books.popularityrating > 7 group by subjects.subject 0%
select subject,count(*) as Books from books,subjects where books.authorid=subjects.authorid and books.popularityrating > 7 group by subjects.subject 0%
select subject,count(*) as Books from books,subjects where books.subjectid=subjects.subjectid and books.popularityrating = 7 group by subjects.subject 0%
select subject,count(*) as Books from books,subjects where books.subjectid=subjects.subjectid and books.popularityrating > 7 group by subjects.subject 0%
select AuthorName from Authors where AuthorId in (select AuthorId from Books group by AuthorId having count(*)>1) 0%
select AuthorName from Authors, Books where Authors.AuthorId=Books.AuthorId and count(BookId)>1 0%
select AuthorName from Authors, Books where Authors.AuthorId=Books.AuthorId group by AuthorName having count(*)>1 0%
select AuthorName from Authors where AuthorId in (select AuthorId from Books having count(BookId)>1) 0%
select authorname from authors where authorid in (select authorid from books where popularityrating<5) 0%
select authorname from authors where authorid in (select authorid from books where popularityrating<=5) 0%
select authorname from authors where authorid in (select BookId from books where popularityrating<5) 0%
select authorname from authors where authorid in (select authorid from books where popularityrating in (0,5)) 0%
select bookname from books where language='French' and popularityrating = (select max(popularityrating) from books where language='French') 0%
select bookname from books where language='French' and popularityrating = (select max(popularityrating) from books Having language='French') 0%
select bookname,max(popularityrating) from books where language='French' and max(popularityrating) 0%
select bookname,max(popularityrating) from books where language='French' having max(popularityrating) 0%
Consider the following transaction code: Begin Transaction Update names_table set employee_name = "Ramesh" where employee_name = "Mahesh" Save Transaction SAVE_POINT ...
"Ramesh" will be updated to "Mahesh", but salaries of engineers will not be updated. 0%
Neither "Ramesh" will be updated to "Mahesh", nor the salary of engineers will be updated. 0%
"Ramesh" will be updated to "Mahesh" and salary of engineers will also be updated. 0%
"Mahesh" will be updated to "Ramesh", but salaries of engineers will not be updated. 0%
Consider the following two tables: 1. customers( customer_id, customer_name) 2. branch ( branch_id, branch_name ) What will be the output if the following query is executed: Select *, bran...
It will return the fields customer_id, customer_name, branch_name 0%
It will return the fields customer_id, customer_name, branch_id, branch_name 0%
It will return the fields customer_id, customer_name, branch_id, branch_name, branch_name 0%
It will return an empty set since the two tables do not have any common field name 0%
It will return an error since * is used alone for one table only 0%
Consider the query: SELECT name FROM Student WHERE name LIKE '_a%'; Which names will be displayed?
Names starting with "a" 0%
Names containing "a" as the second letter 0%
Names starting with "a" or "A" 0%
Names containing "a" as any letter except the first 0%
Consider the transaction: Begin Transaction Create table A ( x smallint , y smallint ) Create table B ( p smallint , q smallint ) Update A...
The transaction will work perfectly fine 0%
It will report an error 0%
The error handling routine contains a syntax error 0%
None of the above 0%
Both b and c 0%
Does SQL Server support user-defined datatypes?
No, SQL doesn't support user-defined datatypes 0%
Yes, but it allows the user to subclass an existing datatype only 0%
Yes, it allows a user to define new datatypes without new storage characterstics 0%
Yes, it allows a user to define new datatypes with new storage characteristics 0%
Evaluate the following SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_...
The value displayed in the CALC_VALUE column will be lower 0%
The value displayed in the CALC_VALUE column will be higher 0%
There will be no difference in the value displayed in the CALC_VALUE column 0%
An error will be reported 0%
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?
It returns employees whose salary is 50% more than $23,000 0%
It returns employees who have 50% commission rate or salary greater than $23,000 0%
It returns employees whose salary is 50% less than $23,000 0%
None of the above 0%
Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 King ...
SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id); 0%
SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id); 0%
SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id); 0%
SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id); 0%
SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY)); 0%
Examine the description of the STUDENTS table: STD_ID INT COURSE_ID VARCHAR (10) START_DATE DATETIME END_DATE DATETIME The aggregate functions valid on the ST...
SUM(start_date) 0%
AVG(start_date) 0%
COUNT(start_date) 0%
AVG(start_date, end_date) 0%
MIN(start_date) 0%
Examine the query:- select (2/2/4) from tab1; where tab1 is a table with one row. This would give a result of:
4 0%
2 0%
1 0%
.5 0%
.25 0%
0 0%
8 0%
24 0%
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 tru...
The two statements produce identical results 0%
The second statement returns an error 0%
There is no need to specify DESC because the results are sorted in descending order by default 0%
None of the above 0%
How can you change "Hansen" into "Nilsen" in the LastName column in the Persons Table?
UPDATE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen' 0%
UPDATE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen' 0%
SAVE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen' 0%
SAVE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen' 0%
How can you view the structure of a table named "myTable" in SQL Server?
desc myTable 0%
desc table myTable 0%
sp_columns myTable 0%
None of the above 0%
Using either option a or c 0%
In a query, which of the following is/are executed first?
Parenthesis 0%
Multiplication, Division and Exponents 0%
Addition and Subtraction 0%
Logical Operations 0%
In which sequence are queries and sub-queries executed by the SQL Engine?
primary query -> sub query -> sub sub query and so on 0%
sub sub query -> sub query -> prime query 0%
the whole query is interpreted at one time 0%
there is no fixed sequence of interpretation, the query parser takes a decision on the fly 0%
Is it possible to insert several rows into a table with a single INSERT statement?
Is the following statement true or false? A column that allows NULLs requires more space to store a value.
Is the FROM clause necessary in every SELECT statement?
Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
It is time for the annual sales awards at your company. The awards include certificates awarded for the five sales of the highest sale amounts. You need to produce a list of the five highest revenu...
SELECT TOP 5 OrderAmount, SalesPersonID FROM orders 0%
SELECT TOP 5 OrderAmount, SalesPersonID FROM orders ORDER BY OrderAmount DESC 0%
SELECT TOP 5 WITH TIES OrderAmount, SalesPersonID From Orders 0%
SELECT TOP 5 WITH TIES OrderAmount, SalesPersonID From Orders ORDER BY OrderAmount 0%
Sample Code CREATE TABLE table1( column1 varchar(50), column2 varchar(50), column3 varchar(50), column4 varchar(50)); Which one of the following is the correct syntax for adding the column named ...
ALTER TABLE table1 ADD column2a varchar(50); 0%
MODIFY TABLE table1 ADD column2a; 0%
INSERT INTO table1 column2a AS varchar(50); 0%
ALTER TABLE table1 INSERT column2a varchar(50); 0%
CHANGE TABLE table1 INSERT column2a; 0%
State which of the following are true
Views are a logical way of looking at the logical data located in the tables 0%
Views are a logical way of looking at the physical data located in the tables 0%
Tables are physical constructs used for storage and manipulation of data in databases 0%
Tables are logical constructs used for storage and manipulation of data in databases 0%
Study the situation described below and identify the nature of relationship? Each student can enroll into more than one class. Each class can accommodate more than one student.
1 to N 0%
1 to 1 0%
M to N to 1 0%
M to M 0%
N to 1 0%
The AND operator displays a row if ANY conditions listed are true. The OR operator displays a row if ALL of the conditions listed are true
The IF UPDATE (column_name) parameter in a trigger definition will return TRUE in case of an INSERT statement being executed on the triggered table:
Yes 0%
No 0%
It returns TRUE only if an UPDATE query is executed 0%
Both b and c 0%
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 Empl...
Select departname from department where deptno in (select deptno from employee group by deptno having count(*) > 100); 0%
Select departname from department where deptno in (select count(*) from employee group by deptno where count(*) > 100); 0%
Select departname from department where count(deptno) > 100; 0%
Select departname from department where deptno in (select count(*) from employee where count(*) > 100); 0%
The sales database contains a customer table and an order table. For each order there is one and only one customer, and for each customer there can be zero or more orders. How should primary and ...
A primary key should be created for the customer_id field in the customer table and also for the customer_id field in the order table 0%
A primary key should be created for the order_id field in the customer table and also for the customer_id field in the order table 0%
A primary key should be created for the customer_id field in the customer table and a foreign key should be created for the customer_id field in the order table 0%
A primary key should be created for the customer_id field in the customer table and a foreign key should be created for the order_id field in the order table 0%
None of these 0%
The simplest query must include at least ________ and _________.
A select clause 0%
A where clause 0%
A from clause 0%
A group by clause 0%
A having clause 0%
An order by clause 0%
The STUDENT_GRADES table has these columns: STUDENT_ID INT SEMESTER_END DATETIME GPA FLOAT Which of the following statements finds the highest Grade Point Average (G...
SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL 0%
SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL 0%
SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end 0%
SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades 0%
SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL 0%
View the following Create statement: 1 Create table Pers 2(EmpNo Int not null, 3 EName Char not null, 4 Join Datetime not null, 5 Pay Smallmoney) Which line contains an error?
What does BLOB stand for?
Binary Large Object 0%
Binary Lower Byte 0%
Bit Large Object 0%
Bit Lower Byte 0%
What does referential integrity (also called relational integrity) prevent?
Loss of data from employee sabotage 0%
Loss of data from any one corrupted table 0%
Recursive joins 0%
One-to-many or many-to-many relationships between columns in a table 0%
Data redundancy 0%
What happens if you type the following statement at the T-SQL prompt? SELECT getdate()
It will print the current date 0%
It will generate an 'Undefined Function' error message 0%
It will generate an 'Incorrect Syntax' error message because you cannot write a function name after SELECT 0%
What is the correct order of clauses in the select statement? 1 select 2 order by 3 where 4 having 5 group by
1,2,3,4,5 0%
1,3,5,4,2 0%
1,3,5,2,4 0%
1,3,2,5,4 0%
1,3,2,4,5 0%
1,5,2,3,4 0%
1,4,2,3,5 0%
1,4,3,2,5 0%
What is the correct SQL syntax for returning all the columns from a table named "Persons" sorted REVERSE alphabetically by "FirstName"?
SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC 0%
SELECT * FROM Persons SORT REVERSE 'FirstName' 0%
SELECT * FROM Persons ORDER BY -'FirstName' 0%
SELECT * FROM Persons ORDER BY FirstName DESC 0%
What is the correct SQL syntax for selecting all the columns where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
SELECT * FROM Persons WHERE LastName > 'Hansen', LastName < 'Pettersen' 0%
SELECT LastName > 'Hansen' AND LastName < 'Pettersen' FROM Persons 0%
SELECT * FROM customers WHERE LastName > 'Hansen' AND LastName > 'Pettersen' 0%
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' 0%
What is the maximum value that can be stored for a datetime field?
Dec 31, 9999 0%
Jun 6, 2079 0%
Jan 1, 2753 0%
Jan 1, 2100 0%
What is the numeric range that is supported by the datatype tinyint?
0-25 0%
0-100����� 0%
0-255 0%
0-3276 0%
What is the order of precedence among the following operators? 1 IN 2 NOT 3 AND 4 OR
1,2,3,4 0%
2,3,4,1 0%
1,2,4,3 0%
1,4,3,2 0%
4,3,2,1 0%
4,1,2,3 0%
4,2,1,3 0%
3,2,1,4 0%
What is wrong with the following query: select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)
In the sub query, '*' should be used instead of 'OrderID' 0%
The sub query can return more than one row, so, '=' should be replaced with 'in' 0%
The sub query should not be in parenthesis 0%
None of the above 0%
What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;
EMPNO, unique value of ENAME and then SALARY are displayed 0%
EMPNO, unique value ENAME and unique value of SALARY are displayed 0%
DISTINCT is not a valid keyword in SQL 0%
No values will be displayed because the statement will return an error 0%
When designing a database table, how do you avoid missing column values for non-primary key columns?
Use UNIQUE constraints 0%
Use PRIMARY KEY constraints 0%
Use DEFAULT and NOT NULL constraints 0%
Use FOREIGN KEY constraints 0%
Use SET constraints 0%
Which of the following are aggregate functions in SQL?
Avg 0%
Select 0%
Order By 0%
Sum 0%
Union 0%
Group by 0%
Having 0%
Which of the following are false for batches (batch commands)?
Statements in a batch are parsed, compiled and executed as a group 0%
None of the statements in the batch is executed if there are any syntax errors in the batch 0%
None of the statements in the batch is executed if there are any parsing errors in the batch 0%
None of the statements in the batch is executed if there are any fatal errors in the batch 0%
Which of the following are not date parts?
quarter 0%
dayofweek 0%
dayofyear 0%
weekday 0%
Which of the following commands is used to change the structure of table?
CHANGE TABLE 0%
MODIFY TABLE 0%
ALTER TABLE 0%
UPDATE TABLE 0%
Which of the following constraints can be used to enforce the uniqueness of rows in a table?
DEFAULT and NOT NULL constraints 0%
FOREIGN KEY constraints 0%
PRIMARY KEY and UNIQUE constraints 0%
IDENTITY columns 0%
CHECK constraints 0%
Which of the following datatypes is not supported by SQL-Server?
Character 0%
Binary 0%
Logical 0%
Date 0%
Numeric 0%
All are supported 0%
Which of the following is an invalid statement for manipulation of binary data?
displaytext 0%
readtext 0%
writetext 0%
updatetext 0%
Which of the following is false with regards to sp_help?
When a procedure name is passed to sp_help, it shows the parameters 0%
When a table name is passed to sp_help, it shows the structure of the table 0%
When no parameter is passed, it provides a list of all objects and user-defined datatypes in a database 0%
All of the above are true 0%
Which of the following is not a column property?
Null 0%
Not Null 0%
Default 0%
Identity 0%
Which of the following is not a control statement?
if...else 0%
if exists 0%
do...while 0%
while 0%
begin...end 0%
Which of the following is not a global variable?
@@colcount 0%
@@error 0%
@@rowcount 0%
@@version 0%
All are valid global variables 0%
Which of the following is not a SQL operator?
Between..and.. 0%
Like 0%
In 0%
Is null 0%
Having 0%
Not in 0%
Which of the following is not a valid Arithmetic operator in SQL Server?
Which of the following is not a valid binary datatype in SQL Server?
BINARY 0%
VARBINARY 0%
BIT 0%
IMAGE 0%
TMESTAMP 0%
Which of the following is not a valid character datatype in SQL Server?
BLOB 0%
CHAR 0%
VARCHAR 0%
TEXT 0%
VARTEXT 0%
Which of the following is the syntax for creating an Index?
CREATE [UNIQUE] INDEX index_name OF tbl_name (index_columns) 0%
CREATE [UNIQUE] INDEX OF tbl_name (index_columns) 0%
CREATE [UNIQUE] INDEX ON tbl_name (index_columns) 0%
CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns) 0%
Which of the following is/are true with reference to Triggers?
A trigger cannot maintain cascading referential integrity 0%
Manipulating columns of datatype IMAGE / TEXT does not cause triggers to be executed 0%
Only the database owner can create triggers 0%
Triggers are executed on INSERT, UPDATE, DELETE and SELECT statements 0%
Which of the following options is correct about identity(seed, increment)?
The increment parameter can never be negative 0%
The increment can be 0 0%
More than one columns in a table can be assigned the identity property 0%
The identity property value for a column assures uniqueness of a row 0%
None of the above 0%
Which of the following options is not correct about the DATEDIFF() function?
It returns the difference between parts of two specified dates 0%
It takes three arguments 0%
It returns a signed integer value equal to second date part minus first date part 0%
It returns a signed integer value equal to first date part minus second date part 0%
Which of the following queries is valid?
Select * from students where marks > avg(marks); 0%
Select * from students order by marks where subject = 'SQL'; 0%
Select * from students having subject ='SQL'; 0%
Select name from students group by subject, name; 0%
Select group(*) from students; 0%
Select name,avg(marks) from students; 0%
None of the above 0%
Which of the following statements about SQL Server comments is false?
/* ... */ are used for multiline comments 0%
// is used for single line comments 0%
-- is used for single line comments 0%
Nested comments are allowed i.e. /* comment 1 /* comment 2 */ comment 1*/ 0%
' is used for single line comments 0%
Which of the following statements are false?
trim() function is used to remove leading and trailing spaces from a string 0%
ltrim() function is used to remove leading spaces from a string 0%
rtrim() function is used to remove trailing spaces from a string 0%
alltrim() function is used to remove leading and trailing spaces from a string 0%
Which of the following statements are true?
soundex(Smith) is the same as soundex(Smithson) 0%
soundex(SMITH) is different from soundex(smith) 0%
soundex(smith) is the same as soundex(smyth) 0%
soundex(smith) is different from soundex(smythe) 0%
All are false 0%
Which of the following statements is not true about the table object in SQL Server?
A table can have only 1024 columns 0%
Multiple Tables with the same name can be created within the same database 0%
A column in a table can have the same name as that of the table 0%
All statements are true 0%
All statements are false 0%
Which one of the following correctly selects rows from the table myTable that have null in column column1?
SELECT * FROM myTable WHERE column1 is null 0%
SELECT * FROM myTable WHERE column1 = null 0%
SELECT * FROM myTable WHERE column1 EQUALS null 0%
SELECT * FROM myTable WHERE column1 NOT null 0%
SELECT * FROM myTable WHERE column1 CONTAINS null 0%
Which one of the following fields is the ideal candidate for the primary key in a student record base?
Parent's name 0%
Address 0%
System generated ID 0%
Student name 0%
Phone number 0%
Which one of the following must be specified in every DELETE statement?
Table Name 0%
Database name 0%
LIMIT clause 0%
WHERE clause 0%
Column Names 0%
Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp
Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined between 1/1/2005 and 1/2/2005?
select * from Pers where joining_date from '1/1/2005' to '1/2/2005', job='Analyst or clerk or salesman' 0%
select * from Pers where joining_date between '1/1/2005' to '1/2/2005', job='Analyst' or job='clerk' or job='salesman' 0%
select * from Pers where joining_date between '1/1/2005' and '1/2/2005' and (job='Analyst' or job='clerk' or job='salesman') 0%
None of the above 0%
You are maintaing data for its products in the Products table, and wants to see the products which are 50 or more numbers far from the minimum stock limit. The structure of the Products table is: ...
(a) is correct 0%
(b) is correct 0%
(a) and (b) both are correct 0%
(a) and (b) both are incorrect 0%
You should avoid the use of cursors because:
They are very difficult to implement 0%
Programs with cursors take more time to run, hence performance degrades 0%
programs with cursors are more lengthy, hence they consume more space/memory 0%
No, you must maximize the use of cursors because they improve performance 0%
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 ...
SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '11/11/2002' ORDER BY purchase_date; 0%
SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date < '11/11/2002' ORDER BY purchase date ASC; 0%
SELECT book_title FROM books WHERE (price < 500 OR > 900) AND purchase_date DESC; 0%
SELECT Book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '11/11/2002' ORDER BY purchase_date DESC; 0%