Shared Flashcard Set

Details

Oracle 9i
Exam Review Set
57
Computer Science
11th Grade
05/12/2010

Additional Computer Science Flashcards

 


 

Cards

Term
Single row functions can be used in the __________ clauses.
Definition
SELECT, WHERE, ORDER BY, DECODE
Term
INITCAP ___________.
Definition
Converts alpha character values to uppoercase for the first letter of each word.
Term
SUBSTR
Definition
Extracts a string of a determined link. ie. SUBSTR('HelloWorld',1,5) = Hello
Term
INSTR
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
NVL2 function _______.
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
NULLIF function _______.
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
Case and Decode.
Term
Case is like C++'s ______.
Definition
If-Then-Else.
Term
Decode compares _______.
Definition
An expression to each of the search values.
Term
Equijoin is sometimes called _____ or ______.
Definition
simple or inner
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
IN OR
Term
An outer join cannot use the ____ operator or be linked to another condition by the __ operator.
Definition
IN OR
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
equijoin
Term
A Cartesian Product is the same as the ANSI _____.
Definition
Cross Join
Term
Group functions cannot be used in the ____ clause.
Definition
WHERE
Term
Group functions _____ NULL values.
Definition
Ignore
Term
_____ and _____ group functions can be used with any datatype.
Definition
MIN and MAX
Term
COUNT ______ NULL values in a column.
Definition
ignores
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
cannot
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
rollup
Term
True
Definition
A composite primary key may only be defined at the table level. True or False?
Term
False
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
True
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
False
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
False
Definition
When you drop a view, the data it contains is also deleted. True or False?
Term
False
Definition
When you drop a table referenced by a view, the view is automatically dropped as well. True or False?
Term
False
Definition
A sequence is a window through which data can be queried or changed. True or False?
Term
NoCache
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
False
Definition
All tables must have indexes on them otherwise they cannot be queried. True or False?
Term
B
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
False
Definition
You must use a synonym to access another users table. True or False?
Term
Select
Definition
Which Object Privilege apart from Alter can be granted to a Sequence?
Select, Update, INsert, or Delete?
Term
Create Index
Definition
Which of these is not a System Privilege granted by the DBA?
Create Sequence, Create Index, Create Procedure, Create Session?
Term
D
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
False
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
True
Definition
REGULAR EXPRESSIONS can be used as a part of contraint definitions? (True or False)
Term
B and D
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
True
Definition
If Oracle crashes your changes are automatically rolled back. True or False?
Term
False
Definition
When you log out of Oracle, your data changes are automatically rolled back. True or False?
Term
False
Definition
As soon as UserA has entered data into a table UserB has privileges to see, UserB can see that data. True or False?
Supporting users have an ad free experience!