Oracle Database 12c SQL Fundamentals Set 1

Evaluate the following SQL statement:
Which statement is true regarding the outcome of the above query?

You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table? Real 6 Oracle 1z0-061 Exam

You 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?

Which three tasks can be performed using SQL functions built into Oracle Database?

Which three SQL statements would display the value 1890.55 as $1, 890.55?

In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:
What would be the outcome?

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

You execute the following commands:
For which substitution variables are you prompted for the input?

Examine the structure of the transactions table:
You want to display the date, time, and transaction amount of transactions that where done before 12 noon. The value zero should be displayed for transactions
where the transaction amount has not been entered.
Which query gives the required result?

Examine the data in the ename and hiredate columns of the employees table:
You want to generate a list of user IDs as follows:
You issue the following query:
What is the outcome?