Oracle 2 Flashcards

character data type
Terms Definitions
What initialization parameter defined at the creation time has the standard size of of DB Block for the SYSTEM and SYSAUX table spaces?
db_block_size
What operator condition is considered a wild card search?
Like
What operator condition is considered a wild card search?
Like
What DD VIEWS CONTAIN TABLESPACE INFORMATION?
1-DBA_TABLESPACES
2-DBA_DATA_FILES
3-DBA_TEMP_FILES
4-V$TABLESPACE
B
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.
Rules of Precedence are?
1 Arithmetic
2 Concatenation
3 Comparison conditions
4 IS (NOT) NULL, LIKE ,IN
5 (NOT) BETWEEN
6 NOT (logical)
7 AND (logical)
8 Or (logical)
The EMP table contains these columns:
EMPLOYEE_ID NUMBER(4)
EMPNAME VARCHAR2 (25)
SALARY NUMBER(9,2)
HIRE_DATE DATE
You query the database with this SQL statement:
SELECT empname,hire_date HIREDATE, salary
FROM EMP
ORDER BY hire_date;
How will the results
Answer: D
Describe Startup MOUNT?
1-Parameter file is read
2-Memory Structure and background processes are initiated.
3-Starts communicating with the db structures.
What are the major categories of datatype in 10g?
1-Character
2-Numeric
3-Datetime
4-LOB(Large Object)
5-ROWID
6-Binary
NVL2 function _______.
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.
False
As soon as UserA has entered data into a table UserB has privileges to see, UserB can see that data. True or False?
True
Any select statement can be stored in the database as a view. True or False
When saving script files in the iSQL*Plus environment what files types can be used?
HTM (html)SQLTXT
Are indents a recommended way to make code more readable?
Yes
What is ASM?
ASM stands for Automated Storage Management; Oracle manages the storage definitions of the database within a second database used exclusively by ASM to keep track of the disk group allocations.
Describe Dictionary extent management?
With Dictionary extent management database tracks used and free extents in the data dictionary by changing FET$ AND UET$ tables by using recursive SQL.
What determines operator precedence?
Operator presedence is multiply and divide before adding and subtracting. When operators have the same priority then left to right determines priority and parentneses are used to force prioritized evaluation.
Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID NUMBER
SAL NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column
of the DEPARTMENTS t
Answer: E,F
Explanation:
the EMP_ID_SEQ sequence is not affected by modification to the EMPLOYEES table. Any other
column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
Incorrect answer :
* EMP_ID_SEQ sequence can be use to populate JOB_ID
* EMP_ID_SEQ sequence will not be invalidate when column in EMPLOYEE_ID is modify.
* EMP_ID_SEQ sequence will be dropped automatically when you drop the EMPLOYEES table.
* EMP_ID_SEQ sequence will be dropped automatically when you drop the EMPLOYEE_ID
column.
What tabs are preseneted to update the innitialization parameters at the time of installation?
1-Memory
2-Sizing
3-Character Sets
4-Connection Mode
What file contains the summary of all the ports used by Oracle components?
%ORACLE_HOME/install dir/portlilst.ini
What are the optios available for shutting down the database?
1-Shutdown NORMAL
2-Shutdown TRANSACTIONAL
3-Shutdown IMMEDIATE
4-Shutdown ABORT
Define Schema?
A schema is a collection of objects owned by a specifi database user.

Schema objects could be segmented(table, index,) and nonsegment(views, synonyms, procedures) objects.
Decode compares _______.
An expression to each of the search values.
Using the SELECT statement can do three operations, what are they?
Projection, Selection and Joining
What is a concatenation operator?
||
A concatination character (||) can link columns, arithmetic, expressions, or constant values to create a character expression. Columns on either side of the operator are combined to make a single output column.
A. ALTER TABLE students
ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
B. ALTER TABLE students
MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
C. ALTER TABLE students
ADD CONSTRAINT PRIMARY KEY (student_id);
D. ALTER TABLE students
You need to m
Answer: E
ALTER TABLE table_name
ADD [CONSTRAINT constraint] type (coloumn);
Incorrect answer :
A wrong syntax
B wrong syntax
C wrong syntax
D no such MODIFY keyword
What are two reasons to create synonyms? (Choose two.)
A. You have too many tables.
B. Your tables names are too long.
C. Your tables have difficult names.
D. You want to work on your own tables.
E. You want to use another schema's tables.
F. You have too
Answer: B,C
Explanation:
to achieve the result you must add 100 to sal before multiply with 12.
Select ename, sal, 12*(sal+100) from EMP;
Incorrect answer :
* Multiplication and division has priority over addition and subtraction in Operator precedence.
C Give wrong results
D Wrong syntax
What is the term for fully qualified database name?
Global Database Name
What is the SQL Command used for shutting down the oracle instance?
SQL> SHUTDOWN [NORMAL|IMMEDIATE|RESTRICT|ABORT]
What are the two options of local extent management?
1- UNIFORM
2- AUTOALLOCATE
An outer join cannot use the ____ operator or be linked to another condition by the __ operator.
IN OR
The WHERE clause doe what?
The where clause contains a condition that must be met if the condition is true then the row meeting the condition is returned.
What are three main catagories of SQL*Plus environment?
Execute SQL statementsQuery results from reportsCreate script files.
What are three main catagories of SQL*Plus environment?
Execute SQL statements
Query results from reports
Create script files.
You need to create a table named ORDERS that contains four columns:

1. an ORDER_ID column of number data type
2. a CUSTOMER_ID column of number data type
3. an ORDER_STATUS column that contains a character data type
4. a DATE_ORDERED column to contain th
Answer:B
Requirement that Order_Status should be a character data type
Not E: Order_status must be a character data type. There is also a syntax error.
What does .dbc extension files contain?
These are the seed template files.
What are the types of extent management?
1- Local extent management
2- Dictionary extent management.
When writing an SELECT statement using the alias command what are the rules for using it?
Alias renames a column nameIt is useful with calculationsImmediatley follows the column nameCan use the "AS" optionally between column name and aliasRequires double quotation marks if the alias contains spaces or special characters or is case sensitive
Are Keywords generally entered in lower case followed by other words entered in upper case?
No, Keywords are generally entered in uppercase followed by other words in lowercase.
Which two are attributes of iSQL*Plus? (Choose two.)
A. /SQL*Plus commands cannot be abbreviated.
B. /SQL*Plus commands are accessed from a browser.
C. /SQL*Plus commands are used to manipulate data in table.
E. /SQL*Plus is the Oracle proprietary interfa
Answer: D,E
D: SQL*Plus commands can be used to manipulate data in tables .
E: iSQL*Plus is a proprietary interface for executing SQL Statements
Incorrect Answers:
A: SQL*Plus commands can be abbreviated. Like command DESCRIBE can be abbreviated as
DESC, or SELECT as SELE.
B: SQL*Plus commands are not accessed from a browser.
C: SQL DML not SQL Plus is used to manipulate data defintionsOCP Introduction to Oracle 9i:
SQL Exam Guide, Jason Couchman, p. 38-48Chapter 1: Overview of Oracle Databases
Describe Managed Targets interms of Oracle Management Framework?
Entities which can be monitor and managed using oracle management framework.
These entities include:
1-Databases
2-Application Servers
3-Web Servers
4-Applications
5-Oracle Agents(Net Listener, Connection Manager)
What are the types of Character data?
1-Fixed Width(the column is padded with spaces): - CHAR(BYTE|CHAR), NCHAR(Size, it uses Unicode character set)
2-Variable Width:- VARCHAR (byte|char), VARCHAR2(size|byte), NVARCHAR2(size, used for unicode)
3-Legacy datatype:- LONG it stores variable length alpha numeric data up to 2GB.
CONNECT BY PRIOR is used to tell Oracle ____.
Hoe to do their inter-row joins.
When using the describe command, how many types are there and what do they mean?
4Number (p,s) p represent max digits to display and s is the digits to the rigt of the decimal point.VARCHAR (s) variable length character with max length sDate from 4712BC to 9999ADCHAR (s)Fixed-length character value of size s
When writing an SELECT statement using the alias command what are the rules for using it?
Alias renames a column name
It is useful with calculations
Immediatley follows the column name
Can use the "AS" optionally between column name and alias
Requires double quotation marks if the alias contains spaces or special characters or is case sensitive
What is the benefit of using OMF(Oracle Managed File Tablespaces)
Admin does not explicitly specify the name of datafiles or temp files.
Admin specify operations in terms of tablespaces.
Oracle creates the unique names of datafiles such as:
01_hr_data_0dc3z9wl_.dbf
The file is autoextend enable and the default size will be 100MB unless a different size is specified.

SQL>Create BIGFILE TABLESPACE hr_data;
What is the ORDER BY clause?
The ORDER BY clause can be used to sort the rows and it musrt be the last clause of the statement.
What are the explanations of a Keyword, Clause and, Statement in SQL commands.
A keyword refers to an individual SQL element. A Cause refers to part of a SQL statement. A statement is the combination of two or more clauses.
Which SQL statement accepts user input for the columns to be displayed, the table name, and the
WHERE condition?
A. SELECT &1, &2
FROM &3
WHERE last_name = '&4';
B. SELECT &1, '&2'
FROM EMP
WHERE last_name = '&4';
C. SELECT &am
Answer: A
In a WHERE clause, date and characters values must be enclosed within single quotation marks.
Sample of the correct syntax
SELECT EMPLOYEE_ID, &COLUMN_NAME
FROM EMPLOYEES
The WHERE clause is used to restrict _______, while the HAVING clause is used to restrict ________.
rows; groups returned from a group by clause.
What is the main difference between SQL and iSQL*Plus?
SQL is a language and iSQL*Plus is an environment. Therefore commands do not manipulate data in the iSQL*Plus environment
What is the use of a from statement?
The FROM keyword can follow the SELECT keyword to tell from which table to pull data.
ex. FROM employees;
What is the difference between EM Grid Control and EM Database Control
EM Grid Control is used for multiple database instances, while EM Database Control is used to manage a single instance of database.
What are two variables for the ORDER BY clause?
They are the ASC and DESC which mean ascending and descending order.
When using these symbols _ and % what do they represent in a clause?
an _ represents one character where as a % represents many characters or zero additional characters.
/ 55
Term:
Definition:
Definition:

Leave a Comment ({[ getComments().length ]})

Comments ({[ getComments().length ]})

{[comment.username]}

{[ comment.comment ]}

View All {[ getComments().length ]} Comments
Ask a homework question - tutors are online