Quiz
Latest Oracle MINI
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)
1Which SQL statements would display the value 1890.55 as $1, 890.55?
(Choose three.)- ASELECT TO_CHAR(1890.55, ‘$99G999D99’)
FROM DUAL; - BSELECT TO_CHAR(1890.55, ‘$9, 999V99’)
FROM DUAL; - CSELECT TO_CHAR(1890.55, ‘$99, 999D99’)
FROM DUAL; - DSELECT TO_CHAR(1890.55, ‘$99G999D00’)
FROM DUAL; - ESELECT TO_CHAR(1890.55, ‘$0G000D00’)
FROM DUAL;
- ASELECT TO_CHAR(1890.55, ‘$99G999D99’)
2You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:
SELECT ROUND(SYSDATE - promo_begin_date, 0)
FROM promotions
WHERE (SYSDATE - promo_begin_date)/365 > 2
PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table. What is the outcome?- AAn error because the WHERE condition specified is invalid
- BNumber of days since the promo started based on the current Singapore data and time.
- CNumber of days since the promo started based on the current Chicago data and time
- DAn error because the ROUND function specified is invalid
3Which of these commands will prevent other sessions from reading rows in the table?
(Choose the best answer.)- ALOCK TABLE SCOTT.EMP IN EXCLUSIVE MODE;
- BOracle does not provide a lock that will prevent others from reading a table.
- CDELETE FROM SCOTT.EMP;
- DLOCK TABLE SCOTT.EMP IN ROW EXCLUSIVE MODE;
- ESELECT * FROM SCOTT.EMP FOR UPDATE;
4In which two cases would you use an outer join?
(Choose two.)- AThe tables being joined have NOT NULL columns.
- BThe tables being joined have both matched and unmatched data.
- CThe tables being joined have only matched data.
- DThe tables being joined have only unmatched data.
- EOnly when the tables have a primary key/foreign key relationship.
- FThe columns being joined have NULL values.
5Sara wants to update the SALARY column in the OLD_EMPLOYEES table with the value from the EMPLOYEES table for employees in department 90. Which SQL code will accomplish the task?
- AUPDATE old_employees a
FROM employees b
SET a.salary = b.salary
WHERE department_id = 90; - BUPDATE old_employees
SET salary = (SELECT salary FROM employees)
WHERE department_id = 90; - CUPDATE old_employees a
SET salary = (SELECT salary FROM employees b
WHERE a.employee_id = b.employee_id)
WHERE department_id = 90; - DUPDATE old_employees a
SET salary = (SELECT salary FROM employees b
WHERE a.employee_id = b.employee_id
AND department_id = 90);
- AUPDATE old_employees a
6What are the distinguishing characteristics of a public synonym rather than a private synonym?
(Choose two correct answers.)- APublic synonyms are always visible to all users.
- BPublic synonyms can be accessed by name without a schema name qualifier.
- CPublic synonyms can be selected from without needing any permissions.
- DPublic synonyms can have the same names as tables or views.
7Which of the following check constraints will raise an error?
- ACONSTRAINT ck_gender CHECK (gender IN ('M', 'F'))
- BCONSTRAINT ck_profit CHECK (gross_amt > net_amt)
- CCONSTRAINT ck_old_order CHECK (order_date > (SYSDATE -30))
- DCONSTRAINT ck_vendor CHECK (vendor_id IN (SELECT vendor_id FROM vendors))
8When do changes get written to the log buffer?
(Choose all that apply.)- ADuring rollback operations
- BWhen an undo block is updated
- CWhen an index block is updated
- DWhen a table block is updated
- EOn COMMIT
9Which tasks can be performed using SQL functions that are built into Oracle database?
(Choose three.)- Acomparing two expressions to check whether they are equal
- Bchecking whether a specified character exists in a given string
- Cadding a number to a date for a resultant date value
- Dremoving trailing, leading, and embedded characters from a character string
- Efinding the remainder of a division
10
After describing the EMPLOYEES table, you discover that the SALARY column has a data type of NUMBER(8,2).
Which SALARY value(s) will not be permitted in this column?
(Choose all that apply.)- ASALARY=123456.78
- BSALARY=12345.678
- CSALARY=12.34
- DSALARY=12345678
- ESALARY=123456
- FSALARY=1234567.8
11Which tasks are accomplished by the SMON process?
- APerforms cleanup after a user session is terminated
- BCoalesces contiguous free space in dictionary-managed tablespaces
- CPerforms recovery at instance startup
- DStarts any server process that stopped running
12Which two statements are true regarding views?
(Choose two.)- AThe WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.
- BRows cannot be deleted through a view if the view definition contains the DISTINCT keyword.
- CA simple view in which column aliases have been used cannot be updated.
- DThe OR REPLACE option is used to change the definition of an existing view without dropping and recreating it.
- ERows added through a view are deleted from the table automatically when the view is dropped.
13The ORDERS table has 35 rows. The following UPDATE statement updates all 35 rows. Which option best describes what will happen?
UPDATE orders
SET ship_date = TRUNC(ship_date)
WHERE ship_date != TRUNC(ship_date)- ANo other session can query from the table until the transaction ends.
- BBecause all rows are updated, there is no need for any locking; therefore, Oracle does not lock the records.
- CThe statement locks all the rows until the transaction ends.
- DWhen all rows in a table are updated, the LOCK TABLE orders IN EXCLUSIVE MODE statement must be executed before the UPDATE statement.
14Evaluate the following CREATE SEQUENCE statement:
CREATE SEQUENCE seq1
START WITH 100
INCREMENT BY 10
MAXVALUE 200
CYCLE
NOCACHE;
The SEQ1 sequence has generated numbers up to the maximum limit of 200. You issue the following SQL statement: SELECT seq1.nextval FROM dual;
What is displayed by the SELECT statement?- A100
- Ban error
- C1
- D10
15Where may the demonstration schemas be created?
(Choose the best answer.)- AThe demonstration schemas can be created in any database.
- BThe demonstration schemas must be created in a demonstration database.
- CThe demonstration schemas cannot be created in a production database.
- DThe demonstration schemas can be created in any database if the demonstration user is created first.
16Evaluate this SQL statement:
SELECT e.emp_name, d.dept_name
FROM employees e
JOIN departments d
USING (department_id)
WHERE d.department_id NOT IN (10, 40)
ORDER BY dept_name;
The statement fails when executed. Which change fixes the error?- Aremove the table alias prefix from the WHERE clause
- Breplace the condition ”d.department_id NOT IN (10, 40)” in the WHERE clause with
”d.department_id <> 10 AND d.department_id <> 40” - Cremove the ORDER BY clause
- Dprefix the column in the USING clause with the table alias
- Eremove the table alias from the SELECT clause
- Fprefix the column in the ORDER BY clause with the table alias
17Which statement is true regarding the COALESCE function?
- AIt requires that at least one of the expressions in the list must have a NOT NULL value.
- BIt returns the highest NOT NULL value in the list for all rows.
- CIt requires that all expressions in the list must be of the same data type.
- DIt can have a maximum of five expressions in a list.
Information
- Description
- Quiz on Latest Oracle MINI, created by Brandon Gagon on 14/02/2019.
- Author
- Brandon Gagon
- Language
- English
- Views
- 9
- Rating
- No ratings yet Rate this quiz