Oracle Computer Technology Quiz Questions
- 1.
which sql statement generates the alias annual salary for the calculated column salary*12?
- A.
Select ename,salary*12'annual salary' from employee
- B.
Select ename,salary*12 as initcap(annual salary)from employee
- C.
Select ename,salary*12"annual salary" from employee
- D.
Select ename,salary*12 as annual salary from employee
Correct Answer
C. Select ename,salary*12"annual salary" from employee -
- 2.
in which scenario would an index be most useful?
- A.
When indexed columns are part of an expression
- B.
When indexed xolumns are declared as not null
- C.
When indexed column contains wide range of values
- D.
The indexed columns are used in FROM clause
Correct Answer
C. When indexed column contains wide range of values -
- 3.
what are two reasons to create synonyms?
- A.
Your table names are too long
- B.
You have too many tables
- C.
Your table have difficult names
- D.
You have too many columns on the table
Correct Answer(s)
A. Your table names are too long
C. Your table have difficult names -
- 4.
what is necessary for your query on an existing view to execute successfully?
- A.
The underlying tables must be in the same schema
- B.
The underlying tables must have data
- C.
You need select privileges on the view
- D.
You need select privileges only on underlying tables
Correct Answer
C. You need select privileges on the view -
- 5.
your table contains these columns EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR(25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this sql statement SELECT EMPNAME,HIRE_DATE,SALARY FROM EMP ORDER BY HIRE_DATE; How will the results be sorted?
- A.
Descending alphabetically
- B.
Descending by date
- C.
Randomly
- D.
Ascending by date
- E.
Ascending alphabetically
Correct Answer
D. Ascending by date -
- 6.
what does the force option for creating a view do?
- A.
Creates a view with constraints
- B.
Creates a view in another schema
- C.
Creates a view even if the underlying parents table has constraints
- D.
Creates a view regardless of whether or not the base tables exists
Correct Answer
D. Creates a view regardless of whether or not the base tables exists -
- 7.
which view should a user query to display the columns associted with the cons on tyable ownd by user
- A.
USER_COLUMNS
- B.
USER_CONS_COLUMNS
- C.
ALL_CONSTRAINTS
- D.
USER_OBJECTS
Correct Answer
B. USER_CONS_COLUMNS -
- 8.
which two statements complete a transaction?(choose two)
- A.
ROLLBACK TO SAVEPOINT C;
- B.
SELECT MAX(SAL) FROM employees WHERE DEPARTMENT_ID=20;
- C.
GRANT SELECT ON employees TO SCOTT;
- D.
DESCRIBE employee;
- E.
ALTER TABLE employee SET UNUSED COLUMNS SAL;
Correct Answer(s)
C. GRANT SELECT ON employees TO SCOTT;
E. ALTER TABLE employee SET UNUSED COLUMNS SAL; -
- 9.
WHAT IS TRUE REGARDING Subqueries
- A.
The inner query must always return a value or outer query will return an error
- B.
The inner query wil return values to the outer query
- C.
The inner query always sorts the result of the outer query
- D.
The outer query must return a value to the inner query
Correct Answer
B. The inner query wil return values to the outer query -
- 10.
which two are attributes of single row functions?
- A.
Manipulate data items
- B.
Accept only one argument and returns only one value
- C.
Returns one result per row
- D.
Cannot be nested
Correct Answer(s)
A. Manipulate data items
C. Returns one result per row -
- 11.
you can update a view with group functions?
- A.
True
- B.
False
Correct Answer
B. False -
- 12.
evaluate the sql statement ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; what will be displayed
- A.
0.00
- B.
Error
- C.
0
- D.
1
Correct Answer
C. 0 -
- 13.
which two are character manipulation functions?(choose two)
- A.
TRUNC
- B.
REPLACE
- C.
TRIM
- D.
MOD
- E.
CASE
Correct Answer(s)
B. REPLACE
C. TRIM -
- 14.
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
- A.
The line numbers reported match the line numbers you see in your text editor.
- B.
SQL*Plus will automatically show the errors to you.
- C.
To see the errors, enter SHOW ERRORS in SQL*Plus.
- D.
If there are no syntax errors, you will receive the message "NO ERRORS."
Correct Answer
C. To see the errors, enter SHOW ERRORS in SQL*Plus. -
- 15.
Which of the following is NOT an Oracle-supported trigger?
- A.
BEFORE
- B.
AFTER
- C.
DURING
- D.
INSTEAD OF
Correct Answer
C. DURING -
- 16.
Which SQL phrase is not supported by Oracle?
- A.
ON DELETE CASCADE
- B.
ON UPDATE CASCADE
- C.
CREATE SEQUENCE[sequence name]
- D.
DROP SEQUENCE[sequence name]
Correct Answer
B. ON UPDATE CASCADE -
- 17.
To obtain the structure of an Oracle table, the command to use is:
- A.
STRUCTURE [TableName].
- B.
DESCRIBE [TableName].
- C.
DESCRIBE STRUCTURE [TableName].
- D.
DESC TABLE [TableName].
Correct Answer
B. DESCRIBE [TableName]. -
- 18.
To see the contents of the SQL*Plus buffer, type:
- A.
Contents
- B.
Buffer
- C.
List
- D.
Current
Correct Answer
C. List -
- 19.
data pump import is a server based bulk data movement
- A.
True
- B.
False
Correct Answer
A. True -
- 20.
Which syntax is used to recover the table from recycle bin?
- A.
RECYCLE BIN
- B.
FLASHBACK TABLE.......TO DROP
- C.
FLASHBACK TABLE........TO BEFORE DROP
- D.
FLASHBACK TABLE ....FROM RECYCLEBIN
Correct Answer
C. FLASHBACK TABLE........TO BEFORE DROP -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 20, 2022Quiz Edited by
ProProfs Editorial Team -
Nov 24, 2011Quiz Created by
Sherlin
Back to top