Multiple Choice Quiz Questions Of Oracle

Dirty buffers in the database buffer cache are flushed.

The server process places the commit record in the redo log buffer.

Log Writer (LGWR) writes the redo log buffer entries to the redo log files and data files.

The user process notifies the server process that the transaction is complete

The user process notifies the server process that the resource locks can be released.

Control file

password file

Parameter files

Archived log files

DBA_TAB_PRIVS

ALL_TAB_PRIVS

USER_TAB_PRIVS

ALL_TAB_PRIVS_MADE

Bitmap

Reverse key

Unique B-Tree

Normal B-Tree

DBA

SYSDBA

SYSOPER

RESOURCE

No action is required

Ask user B to abort the statement

Ask user A to commit the transaction

Ask user B to commit the transaction

SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' OR gpa > 3.0;

SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa gt 3.0;

SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa > 3.0;

SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001' AND gpa >= 3.0;

SELECT student_id, gpa FROM student_grades WHERE semester_end > '01-JAN-2001' OR semester_end < '31-DEC-2001' AND gpa >= 3.0;

SELECT * FROM DEPT

SELECT * FROM SCOTT. DEPT

SELECT * FROM DBA.SCOTT.DEPT

SELECT * FROM ALL_USERS WHERE USER_NAME = ‘SCOTT’ AND TABLE NAME= 'DEPT'

Before the WHERE clause

Before the FROM clause

After the ORDER BY clause

After the WHERE clause

You have no rows in the table.

You have an employee with the name of James

You cannot roll back to the same savepoint more than once.

Your last update fails to update any rows because employee ID 180 was already deleted.

Substitution variables

Replacement variables

Prompt variables

Instead-of variables

0

1

0.00

An error statement

SELECT a last_name, a salary, a department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id)b WHERE a department_id = department-id AND a_salary

SELECT a. last name, a salary, a. department_id FROM employees a WHERE a. department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = SELECT max(salary) from employees

SELECT a last_name, a salary, a.department_id FROM employees a WHERE a salary = SELECT max(salary) FROM employees b WHERE a department_id = department_id);

SELECT a last_name, a salary, a.department_id FROM employees a WHERE (a department_id, a salary) IN (SELECT department_id, a salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department_id);

UPDATE employees SET job_id=DEFAULT AND Sal=(SELECT MAX(sal) FROM emoployees WHERE job_id='SA_REP' AND comm_pet=DEFALUT AND department_id =&did WHERE employee_id IN (103, 115),

UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department _id = & did WHERE employee_id IN (103,115) AND ob_id = 'SA_REP'

UPDATE employees SET job_id = DEFAULT Sal = (SELECT MAX (sal) FROM employees WHERE job_id = 'SA_REP') comm_pct = DEFAULT, department _id = &did WHERE employee_id IN (103,115)

UPDATE emplouees SET job_id = DEFAULT sal = MAX (sal) comm_pct = DEFAULT department_id = &did WHERE employee_id IN (103,115) AND job_id = 'SA_REP'

UPDATE employees SET job_id = DEFAULT Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') comm_pct = DEFAULT OR NULL, department_id = &did WHEREemployee_id IN (103,115)

CREATE INDEX NAME_IDX (first_name, last_name)

CREATE INDEX NAME_IDX (first_name AND last_name)

CREATE INDEX NAME_IDX ON (first_name, last_name)

CREATE INDEX NAME_IDX ON employees (first_name AND last_name)

CREATE INDEX NAME_IDX ON employees (first_name, last_name)

ALTER TABLE students ADD PRIMARY KEY student_id;

ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY stuent_id;

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id)

INSERT

DELETE

EXPAND

DESCRIBE

SELECT TO_CHAR(SYSDATE, ‘yyyy’) FROM dual

SELECT TO_DATE(SYSDATE,’yyyy’) FROM dual

SELECT DECODE (SUBSTR (SYSDATE, 8), ‘YYYY’) FROM dual

SELECT TO_CHAR (SUBSTR(SYSDATE, 8,2),’yyyy’) FROM dual

Create groups of data

Sort data in a specific order

Convert data to a different format

Retrieve data based on an unknown condition

WHERE

HAVING

RESTRICT

GROUP BY

SELECT TO_DATE (SYSDATE, ‘FMDAY, DD Month, YYYY’) FROM dual

SELECT TO_CHAR(SYSDATE, ‘FMDD, DY Month ‘YYY’) FROM dual

SELECT TO_CHAR(SYSDATE, ‘FMDay, DD Month YYYY’) FROM dual

SELECT TO_CHAR(SYSDATE, ‘FMDAY, DDD Month, YYYY’) FROM dual

SELECT TO_DATES(SYSDATE,’FMDY, DDD Month, YYYY’) FROM dual

All of the desired results

Two of the desired results

One of the desired results

An error statement