Term
| Single row functions can be used in the __________ clauses. |
|
Definition
| SELECT, WHERE, ORDER BY, DECODE |
|
|
Term
|
Definition
| Converts alpha character values to uppoercase for the first letter of each word. |
|
|
Term
|
Definition
| Extracts a string of a determined link. ie. SUBSTR('HelloWorld',1,5) = Hello |
|
|
Term
|
Definition
| Finds the numeric position of a named character. ie. INSTR('HelloWorld',W) = 6 |
|
|
Term
| NVL function converts ________. |
|
Definition
| a null value to a known value of a fixed datatype (the datatype of the null value column). |
|
|
Term
|
Definition
| evaluates an expression with three values. If the first value is not null, then the NVL2 function returns the second value. If the first value is null, the 3rd value is returned. |
|
|
Term
| An easy way to remember NVL2 is________. |
|
Definition
| If expression 1 has a value, substitute expression 2; if expression 1 is null, substitute expression 3. |
|
|
Term
|
Definition
| compares two funtions. If they are equal the function returns Null. If they are not equal, the function returns the first expression. |
|
|
Term
| Coalesce fucntion _______. |
|
Definition
| Is an extension of the NVL function. If the 1st expresstion is null, the function continues down the line until a not null expression is found. |
|
|
Term
| The two conditional expressions are ______ and _______. |
|
Definition
|
|
Term
| Case is like C++'s ______. |
|
Definition
|
|
Term
|
Definition
| An expression to each of the search values. |
|
|
Term
| Equijoin is sometimes called _____ or ______. |
|
Definition
|
|
Term
| An equijoin is a table join that _______. |
|
Definition
| combines rows that have the same values for the specified columns. |
|
|
Term
| In a nonequijoin there is no ______. |
|
Definition
| exact match between the two columns in each table. |
|
|
Term
| In a nonequjoin, the _ operator cannot be used. |
|
Definition
|
|
Term
| In a nonequijoin comparison conditions such as _______ and _______ can be used. |
|
Definition
| <= and >= , and BETWEEN...AND |
|
|
Term
| An outer join cannot use the ____ operator or be linked to another condition by the __ operator. |
|
Definition
|
|
Term
| An outer join cannot use the ____ operator or be linked to another condition by the __ operator. |
|
Definition
|
|
Term
| Hierarchical queries have their own 2 keywords, which are _____, ______, and _____. |
|
Definition
| START WITH, CONNECT BY PRIOR, and LEVEL. |
|
|
Term
| START WITH in a hierarchical query is used to _______. |
|
Definition
| tell Oracle which row to use as the starting point. |
|
|
Term
| CONNECT BY PRIOR is used to tell Oracle ____. |
|
Definition
| Hoe to do their inter-row joins. |
|
|
Term
| LEVEL is used by Oracle to show _____. |
|
Definition
| How many steps down from the top of the tree we have taken. |
|
|
Term
| NATURAL JOIN is the ANSI join that accomplishes the same result as a ______. |
|
Definition
|
|
Term
| A Cartesian Product is the same as the ANSI _____. |
|
Definition
|
|
Term
| Group functions cannot be used in the ____ clause. |
|
Definition
|
|
Term
| Group functions _____ NULL values. |
|
Definition
|
|
Term
| _____ and _____ group functions can be used with any datatype. |
|
Definition
|
|
Term
| COUNT ______ NULL values in a column. |
|
Definition
|
|
Term
| Group fucntions require that |
|
Definition
| any column listed in the SELECT clause that is not part of a group function must be listed in a GROUP BY clause. |
|
|
Term
| You (can/cannot) use a column alias in a group by clause. |
|
Definition
|
|
Term
| The WHERE clause is used to restrict _______, while the HAVING clause is used to restrict ________. |
|
Definition
| rows; groups returned from a group by clause. |
|
|
Term
| What creates subtotals that roll up from the most detailed level to a grand total, following a grouping list specified in the rollup clause? |
|
Definition
|
|
Term
|
Definition
| A composite primary key may only be defined at the table level. True or False? |
|
|
Term
|
Definition
| If a Primary Key is made up of more than one column, one of the columns can be null. True or False? |
|
|
Term
| Referential Integrity Constraints |
|
Definition
Foreign Key Constraints are also known as:
Parental Key Constraints
Child Key Constraints
Referential Integrity Constraints
Multi-Table Constraints |
|
|
Term
|
Definition
| Any select statement can be stored in the database as a view. True or False |
|
|
Term
| To provide restricted data access. |
|
Definition
| What is one advantage of using views? |
|
|
Term
|
Definition
| There is only one kind of view. True or false? |
|
|
Term
| C. Select, Update of some columns, Delete |
|
Definition
CREATE OR REPLACE VIEW emp_dept
AS SELECT SUBSTR(e.first_name,1,1) ||' '||e.last_name emp_name,
e.salary,
e.hire_date,
d.department_name
FROM employees e, departments d
WHERE e.department_id = d.department_id
AND d.department_id >=50;
What operations would be allowed?
A) Select, Update
B) Select, Update, of all columns
C) Select, Update of some columns, DELETE
D) Select, Insert |
|
|
Term
|
Definition
| When you drop a view, the data it contains is also deleted. True or False? |
|
|
Term
|
Definition
| When you drop a table referenced by a view, the view is automatically dropped as well. True or False? |
|
|
Term
|
Definition
| A sequence is a window through which data can be queried or changed. True or False? |
|
|
Term
|
Definition
In order to be able to generate primary key values that are not likely to contain gaps, which phrase should be included in the sequence creation statement?
A) NoCache
B) Cache
C) Maxvalue |
|
|
Term
|
Definition
| All tables must have indexes on them otherwise they cannot be queried. True or False? |
|
|
Term
|
Definition
Which of the following statements best describes indexes and their use?
A)They are just random copies of data in no particular order.
B)They contain the column value and pointers to the data in the table, but the data is sorted.
C) They contain all the rows and columns from the table. |
|
|
Term
|
Definition
| You must use a synonym to access another users table. True or False? |
|
|
Term
|
Definition
Which Object Privilege apart from Alter can be granted to a Sequence?
Select, Update, INsert, or Delete? |
|
|
Term
|
Definition
Which of these is not a System Privilege granted by the DBA?
Create Sequence, Create Index, Create Procedure, Create Session? |
|
|
Term
|
Definition
Which of the following statements about granting object privileges is false?
A) To grant privileges on an object, the object must be in your own schema, or you must have been granted the object privileges WITH GRANT OPTION.
B)An object owner can grant any object privilege on the object to any other user or role of the database.
C) The owner of an object automatically acquires all object privileges on that object.
D)Object privileges can only be granted through roles. |
|
|
Term
|
Definition
| When a user is logged into one database, they are restricted to working with objects found in that database. True or False? |
|
|
Term
| allow users to work on remote database objects without having to log into the other database. |
|
Definition
| Database Links_____________. |
|
|
Term
|
Definition
| REGULAR EXPRESSIONS can be used as a part of contraint definitions? (True or False) |
|
|
Term
|
Definition
Select the correct REGULAR EXPRESSION functions: (Choose two)
A)REGEXP_LIKE, REGEXP_NEAR
B)REGEXP_LIKE, REGEXP_REPLACE
C)REGEXP_REPLACE, REGEXP_REFORM
D)REGEXP_INSTR, REGEXP_SUBSTR |
|
|
Term
|
Definition
| If Oracle crashes your changes are automatically rolled back. True or False? |
|
|
Term
|
Definition
| When you log out of Oracle, your data changes are automatically rolled back. True or False? |
|
|
Term
|
Definition
| As soon as UserA has entered data into a table UserB has privileges to see, UserB can see that data. True or False? |
|
|
