Quiz
Untitled
Questions in this quiz (4)
1View the Exhibit and examine the structure of the products table.
Using the products table, you issue the following query to generate the names, current list price, and discounted list price for all those products whose list price falls below $10 after a discount of 25% is applied on it
The query generates an error. What is the reason for the error?
- AThe parenthesis should be added to enclose the entire expression
- BThe double quotation marks should be removed from the column alias.
- CThe column alias should be replaced with the expression in the where clause.
- DThe column alias should be put in uppercase and enclosed within double quotation marks in the where clause.
- AThe parenthesis should be added to enclose the entire expression
2Examine the structure proposed for the transactions table:
Which two statements are true regarding the creation and storage of data in the above table structure?
- AThe CUST_STATUS column would give an error.
- BThe TRANS_VALIDITY column would give an error.
- CThe CUST_STATUS column would store exactly one character.
- DThe CUST_CREDIT_LIMIT column would not be able to store decimal values.
- EThe TRANS_VALIDITY column would have a maximum size of one character.
- FThe TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds
3You need to create a table for a banking application. One of the columns in the table has the following requirements:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column should be stored in a format such that it can be easily added and subtracted with
date data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30 days.
4) The interest has to be calculated for the number of days an individual has taken a credit for.
Which data type would you use for such a column in the table?- ADATE
- BNUMBER
- CTIMESTAMP
- DINTERVAL DAY TO SECOND
- EINTERVAL YEAR TO MONTH
4Which three tasks can be performed using SQL functions built into Oracle Database?
- ADisplaying a date in a nondefault format
- BFinding the number of characters in an expression
- CSubstituting a character string in a text expression with a specified string
- DCombining more than two columns or expressions into a single column in the output
Information
- Description
- Quiz on Untitled, created by Mario Ruíz4313 on 28/11/2015.
- Author
- Mario Ruíz4313
- Language
- Español
- Views
- 0
- History
- Created on 28 Nov 2015 · updated on 19 Feb 2016
- Rating
- No ratings yet Rate this quiz