Dump > Sql 1z0-007 > Sql#1
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Dump > Sql 1z0-007 > Sql#1 as PDF for free.
More details
- Words: 469
- Pages: 4
1.
Your Oracle server has today's date displayed as March 21, 2003. What is the result of the following SELECT statement? SELECT SYSDATE FROM DUAL;
21-Mar-03 2003-March-21 03-21-Mar Nothing will be displayed. March 21, 2003
Answer : 1
2.
What is the result of the following SELECT statement? SELECT ROUND (631.1250, 2), ROUND (631.1250, 0), ROUND (631.1250, -2), ROUND (631.1250, 3) FROM DUAL;
600 0 631.00 631 631.13 631 600 631.125 630 0 631.12 631 2 0 -2 3
Answer : 2 3.
When applied to the GRADEBOOK table that has a GRADE column and a STUDID column, what is the result of the following SELECT statement? select NVL(GRADE,0), STUDID from gradebook;
It will display the NVL and STUDID columns and convert any null value in the NVL column to a zero. It will display the GRADE and STUDID columns with zero space between the columns. It will display the GRADE and STUDID columns and convert any null value in the GRADE column to a zero. It will display the NVL and the STUDID columns with zero space between the columns.
It will display the GRADE and STUDID columns and convert any null value in the STUDID column to a zero.
Answer : 3 4.
Which Oracle9i database object represents data derived from one or more tables?
SEQUENCE VIEW INDEX SCHEMA
Answer : 2 5.
Which statement is true concerning a Multiple-row subquery?
A Multiple-row subquery will only return a single row. A Multiple-row subquery returns multiple rows and multiple columns. A Multiple-row subquery will only return a single column and a single row. A Multiple-row subquery will only use the < > operator. A Multiple-row subquery will only return single column.
Answer : 2 6. The student with STUDID of 200 needs to pass her course with a 90. The grading scale goes from 0-200. Passing is a 90. Which of the SELECT statements will give the student with STUDID 200 a passing score for her FINAL GRADE? (A) SELECT STUDID "STUDENT ID", GRADE "GRADE BEFORE CURVE", GRADE +.50*Grade "FINAL GRADE" FROM GRADEBOOK; (B) SELECT STUDID "STUDENT ID", GRADE "GRADE BEFORE CURVE", (GRADE +.50)*2 "FINAL GRADE" FROM GRADEBOOK;
A B A and B Neither A or B
Answer : 2
7.
What values does the SYSDATE return when used in a SELECT statement? (Select all that apply.)
The date the database was created. The current database server time. The time the database was created. The current database server date
Answer : 2,4 8.
You need to unite the data from the STUDENTS and FACULTY tables for a new report. Which SQL SELECT capability are you using to accomplish this?
Selection Joining Projection Management
Answer : 2
9.
Which of the following are Case-manipulation functions in Oracle9i? (Choose all that apply.)
TRIM SUBSTR INITCAP LENGTH LOWER
Answer : 3,5
Your Oracle server has today's date displayed as March 21, 2003. What is the result of the following SELECT statement? SELECT SYSDATE FROM DUAL;
21-Mar-03 2003-March-21 03-21-Mar Nothing will be displayed. March 21, 2003
Answer : 1
2.
What is the result of the following SELECT statement? SELECT ROUND (631.1250, 2), ROUND (631.1250, 0), ROUND (631.1250, -2), ROUND (631.1250, 3) FROM DUAL;
600 0 631.00 631 631.13 631 600 631.125 630 0 631.12 631 2 0 -2 3
Answer : 2 3.
When applied to the GRADEBOOK table that has a GRADE column and a STUDID column, what is the result of the following SELECT statement? select NVL(GRADE,0), STUDID from gradebook;
It will display the NVL and STUDID columns and convert any null value in the NVL column to a zero. It will display the GRADE and STUDID columns with zero space between the columns. It will display the GRADE and STUDID columns and convert any null value in the GRADE column to a zero. It will display the NVL and the STUDID columns with zero space between the columns.
It will display the GRADE and STUDID columns and convert any null value in the STUDID column to a zero.
Answer : 3 4.
Which Oracle9i database object represents data derived from one or more tables?
SEQUENCE VIEW INDEX SCHEMA
Answer : 2 5.
Which statement is true concerning a Multiple-row subquery?
A Multiple-row subquery will only return a single row. A Multiple-row subquery returns multiple rows and multiple columns. A Multiple-row subquery will only return a single column and a single row. A Multiple-row subquery will only use the < > operator. A Multiple-row subquery will only return single column.
Answer : 2 6. The student with STUDID of 200 needs to pass her course with a 90. The grading scale goes from 0-200. Passing is a 90. Which of the SELECT statements will give the student with STUDID 200 a passing score for her FINAL GRADE? (A) SELECT STUDID "STUDENT ID", GRADE "GRADE BEFORE CURVE", GRADE +.50*Grade "FINAL GRADE" FROM GRADEBOOK; (B) SELECT STUDID "STUDENT ID", GRADE "GRADE BEFORE CURVE", (GRADE +.50)*2 "FINAL GRADE" FROM GRADEBOOK;
A B A and B Neither A or B
Answer : 2
7.
What values does the SYSDATE return when used in a SELECT statement? (Select all that apply.)
The date the database was created. The current database server time. The time the database was created. The current database server date
Answer : 2,4 8.
You need to unite the data from the STUDENTS and FACULTY tables for a new report. Which SQL SELECT capability are you using to accomplish this?
Selection Joining Projection Management
Answer : 2
9.
Which of the following are Case-manipulation functions in Oracle9i? (Choose all that apply.)
TRIM SUBSTR INITCAP LENGTH LOWER
Answer : 3,5
Related Documents
Dump > Sql 1z0-007 > Sql#8
November 2019 2
Dump > Sql 1z0-007 > Sql#2
November 2019 5
Dump > Sql 1z0-007 > Sql#1
November 2019 3
Dump > Sql 1z0-007 > Sql#3
November 2019 5
Dump > Sql 1z0-007 > Sql#4
November 2019 5