1 . Which of the below is not a single row function?
| a. | ROWNUM
| |
| b. | SYSDATE
| |
| c. | MONTHS_BETWEEN
| |
| d. | SQRT
|
2. Which of the below clauses of an SQL statement is the 3rd one in the order of execution?
| a. | WHERE
| |
| b. | FROM
| |
| c. | ORDER BY
| |
| d. | SELECT
|
3. Which of the below is not a property of Referential Integrity?
| a. | Preventing a record in a parent table from being deleted if it is currently being referenced by a child table
| |
| b. | Cascading insert from parent to child record
| |
| c. | Cascading delete from parent to child record
| |
| d. | Ensuring that values entered into child table attributes already exist in the parent table
|
4. Which of the below does not form the basis of a relational model?
| a. | Every column in a table represents an attribute of the entity
| |
| b. | All rows in a table combine together to represent a single instance of the entity in the table
| |
| c. | Data is represented by a series of two dimensional tables
| |
| d. | Each column and row intersection should have an atomic value
|
pls give me the correct answer
