Quiz
Oracle Fatality
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (17)
1SELECT NVL2(NULLIF('CODA','SID'),'SPANIEL','TERRIER') FROM DUAL;
(Choose the best answer.)- ASPANIEL
- BNone of the above
- CTERRIER
- DNULL
2Which values are returned after executing the following statement?
SELECT COUNT(*), COUNT(SALARY) FROM EMPLOYEES;
Assume there are ten employee records and each contains a SALARY value of 100, except for one, which has a null value in the SALARY field.
(Choose all that apply.)- A10 and 10
- B10 and NULL
- C10 and 9
- DNone of the above
3Which of these statements regarding SQL Developer are correct?
(Choose two answers.)- ASQL Developer can be installed outside an Oracle Home.
- BSQL Developer cannot connect to databases earlier than release 10g.
- CSQL Developer relies on an LDAP directory for name resolution.
- DSQL Developer can store passwords.
4What languages can run within the database?
(Choose all that apply.)- APL/SQL
- BJava
- CSQL
- DC
5Which best describes an inline view?
- Aa sub query that is part of the FROM clause of another query
- Banother name for a view that contains group functions
- Ca sub query that can contain an ORDER BY clause
- Da schema object
6What types of segments are protected by redo?
(Choose all that apply.- AIndex Segments
- BUndo Segments
- CTable Segments
- DTemporary Segments
7Which two statements are true regarding the count function?
- ACount (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column.
- BCount (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column.
- CCount (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns.
- DThe count function can be used only for CHAR, VARCHAR2, and NUMBER data types.
- EA select statement using the COUNT function with a DISTINCT keyword cannot have a where clause.
8Which three tasks can be performed using SQL functions built into Oracle Database?
- ACombining more than two columns or expressions into a single column in the output
- BFinding the number of characters in an expression
- CSubstituting a character string in a text expression with a specified string
- DDisplaying a date in a nondefault format
9If you suspect that undo generation is a performance issue, what can you do to reduce the amount of undo data generated?
(Choose the best answer.)- AConvert from use of rollback segments to automatic undo management.
- BThere is nothing you can do because all DML statements must generate undo.
- CReduce the size of the undo segments.
- DSet the UNDO_MANAGEMENT parameter to NONE.
10In which three situations does a transaction complete?
- AWhen a ROLLBACK command is executed
- BWhen a data definition language (DDL) statement is executed
- CWhen a DELETE statement is executed
- DWhen a TRUNCATE statement is executed after the pending transaction
- EWhen a PL/SQL anonymous block is executed
11The LRU algorithm is used to manage what part of the Oracle architecture?
- AThe tables that users rarely access so that they can be moved to a less active tablespace
- BThe shared pool and database buffer cache portions of the SGA
- CUsers who log on to the database infrequently and may be candidates for being dropped
- DThe data file that stores the least amount of information and will need the least frequent backup
12Which two statements are true regarding constraints?
- AA table can have only one primary key and one foreign key.
- BThe foreign key and parent table primary key must have the same name.
- CA table can have only one primary key but multiple foreign keys.
- DBoth primary key and foreign key constraints can be defined at both column and table levels.
- EOnly the primary key can be defined at the column and table levels.
13Consider this statement:
SELECT last_name, (SELECT count(*) FROM departments) FROM employees WHERE salary = (SELECT salary FROM employees);
What is wrong with it?- AThe statement will fail if the second query returns more than one row.
- BNothing is wrong—the statement should run without error.
- CThe statement will run but is extremely inefficient because of the need to run the second subquery once for every row in EMPLOYEES.
- DThe statement will fail because the subquery in the SELECT list references a table that is not listed in the FROM clause.
14Which DELETE statement is valid?
- ADELETE FROM employees
WHERE employee_id = . (SELECT employee_id
. FROM employees); - BDELETE * FROM employees
WHERE employee_id IN . (SELECT employee_id
. FROM new_employees
. WHERE last_name = ‘Carrey’); - CDELETE * FROM employees
WHERE employee_id = . (SELECT employee_id
. FROM new_employees); - DDELETE FROM employees
WHERE employee_id IN. (SELECT employee_id
. FROM new_employees
. WHERE name = ‘Carrey’);
- ADELETE FROM employees
15Which of the following is not a benefit of Oracle Database 12c?
- APlug and unplug databases
- BPatch each pluggable database separately
- CFast provisioning of cloned databases
- DManage multiple databases as one
16Which join is performed by the following query?
SELECT E.JOB_ID,J.JOB_ID FROM EMPLOYEES E JOIN JOBS J ON (E.SALARY < J.MAX_SALARY);- ACross join
- BNonequijoin
- COuter join
- DEquijoin
17If SYS DATE returns 12-JUL-2016, what is returned by the following statement?
SELECT DECODE(TO_CHAR(SYSDATE,'MM'),'02','TAX DUE','PARTY') FROM DUAL;- APARTY
- BTAX DUE
- C02
- DNone of the above
Information
- Description
- Quiz on Oracle Fatality, created by Brandon Gagon on 21/04/2019.
- Author
- Brandon Gagon
- Language
- English
- Views
- 5
- Rating
- No ratings yet Rate this quiz