Topic: Database Administration >> Query for some question
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Query for some question |
| |
Posted: Mar 26, 2008 05:21:53 AM |
Total Post: 24
Joined: Feb, 2008
|
Hi,
ALL OF TEHM
Plese help me i am very confuse for this question
Please tell me the accuarate answer of this question
Q1. Top N analysis requires _____ and _____. (Choose two.)
A. the use of rowed
B. a GROUP BY clause
C. an ORDER BY clause
D. only an inline view
E. an inline view and an outer query
Q2.:- Which three is true regarding the use of outer joins? (Choose three.)
A. You cannot use IN operator in a condition that involves an outer join.
B. You use (+) on both sides of the WHERE condition to perform an outer join.
C. You use (*) on both sides of the WHERE condition to perform an outer join.
D. You use an outer join to see only the rows that do not meet the join condition.
E. In the WHERE condition, you use (+) following the name of the column in the table
without matching rows, to perform an outer join.
F. You cannot link a condition that is involved in an outer join to another condition by using
the OR operator.
Q3.:- Which statement adds a constraint that ensures the CUSTOMER_NAME column of the
CUSTOMERS table holds a value?
A. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name
IS NOT NULL;
B. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK
customer_name IS NOT NULL;
C. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT
NULL;
D. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS
NOT NULL;
E. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
F. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name
NOT NULL;
Q4.: Mark for review. Which two statements are true about WHERE and HAVING clauses?
(Choose two.)
A. A WHERE clause can be used to restrict both rows and groups.
B. A WHERE clause can be used to restrict rows only.
C. A HAVING clause can be used to restrict both rows and groups.
D. A HAVING clause can be used to restrict groups only.
E. A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.
F. A HAVING clause CANNOT be used in Subqueries.
Q5.;:- . Which two are attributes of /SQL*Plus? (Choose two)
A. /SQL*Plus commands cannot be abbreviated.
B. /SQL*Plus commands are accesses from a browser.
C. /SQL*Plus commands are used to manipulate data in tables.
D. /SQL*Plus commands manipulate table definitions in the database.
E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.
Q6.:- You want to display the titles of books that meet these criteria:
1. Purchased before January 21, 2001
2. Price is less than $ 500 or greater than $ 900
You want to sort the result by their date of purchase, starting with the most recently
bought book. Which statement should you use?
A. SELECT book_title FROM books WHERE price between 500 and 900 AND
purchase_date < '21 - Jan-2001' ORDER BY purchase_date;
B. SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date< '21-
jan-2001' ORDER BY purchase date ASC;
C. SELECT book_title FROM books WHERE price < 500 OR>900 AND purchase_date
DESC;
D. SELECT Book_title FROM books WHERE price < 500 OR>900 AND purchase_date<'21-
JAN-2001' ORDER BY purchase date DESC;
E. SELECT book_title FROM books WHERE (price< 500 OR price> 900) AND purchase
date> '21 - JAN-2001' ORDER BY purchase date ASC;
Q7.:- Mark for review Examine the structure of the STUDENTS table:
STUDENT_ID NUMBER NOT NULL, Primary Key
STUDENT_NAME VARCHAR2 (30)
COURSE_ID VARCHAR2 (10) NOT NULL
MARKS NUMBER
START_DATE DATE
FINISH_DATE DATE
You need to create a report of the 10 students who achieved the highest ranking in the
course INT_SQL and who completed the course in the year 1999.
Which SQL statement accomplishes this task?
A. SELECT student_id, marks, ROWNUM "Rank" FROM students WHERE ROWNUM <=
10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id =
'INT_SQL'ORDER BY marks DESC;
B. SELECT student_id, marks, ROWID "Rank" FROM students WHERE ROWID <= 10
AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99'AND course_id =
'INT_SQL'ORDER BY marks;
C. SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks
FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND
'31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC);
D. SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks
FROM students WHERE finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND
course_id = 'INT_SQL' ORDER BY marks DESC)WHERE ROWNUM <= 10 ;
E. SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks
FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish_date
BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL';
|
|
|
 Raj |
| Posted: Mar 28, 2008 01:46:02 AM |  |
|
Total Post: 17
Joined: Jan, 2007
|
The answers are
1) C, E
2) A, E, F
3) C
4) B, C
5) I assume it is iSQL* Plus, B, E
6) None is the correct answer with option D being the closest one, the only modification required is "WHERE (price< 500 OR price> 900) ".
7) D
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
