Oracle Introduction to Oracle9i SQL Set 3

Question - 15 Maximum mark : - 30

Home
All Exams
Oracle Introduction to Oracle9i SQL Online Mock Tests
Oracle Introduction to Oracle9i SQL Set 3

Which object privileges can be granted on a view?

none ✘ DELETE, INSERT,SELECT ✘ ALTER, DELETE, INSERT, SELECT ✘ DELETE, INSERT, SELECT, UPDATE ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which is an iSQL*Plus command?

INSERT ✘ UPDATE ✘ SELECT ✘ DESCRIBE ✔ DELETE ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Evaluate these two SQL statements:
SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name,
salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them?

The two statements produce identical results. ✘ The second statement returns a syntax error. ✘ There is no need to specify DESC because the results are sorted in descending order by default. ✘ The two statements can be made to produce identical results by adding a column alias for the salarycolumn in the second SQL statement. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
NEW_EMPLOYEES
EMPLOYEE_ID NUMBER Primary Key
NAME VARCHAR2(60)

Which MERGE statement is valid?

MERGE INTO new_employees c
USING employees e
ON (c.employee_id = e.employee_id)
WHEN MATCHED THEN
UPDATE SET

✘

name = e.first_name ||','|| e.last_nameWHEN NOT MATCHED THEN
INSERT
value
S(e.employee_id, e.first_name ||',
'||e.last _ name);

✘

MERGE new_employees cUSING employees e
ON (c.employee_id = e.employee_id)
WHEN EXISTS THEN
UPDATE SET

✘

name = e.first_name ||','|| e.last_nameWHEN NOT MATCHED THEN INSERT
valueS(e.employee_id, e.first_name ||',
'||e.last _ name);

✔

MERGE INTO new_employees cUSING employees eON (c.employee_id = e.employee_id)
WHEN EXISTS THEN
UPDATE SET

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001
12:00:00 AM"?

SELECT
TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth
"of" Month YYYY fmHH:MI:SS AM') NEW_DATE
FROM dual;

✘

SELECTTO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth
"of" Month YYYY fmHH:MI:SS AM') NEW_DATE
HH:MI:SS AM') NEW _ DATE FROM dual;

✘

SELECTTO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY NEW _ DATE FROM
dual;

✘

SELECTTO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM')
NEW_DATE FROM dual;

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which one is a system privilege?

SELECT ✘ DELETE ✘ EXECUTE ✘ ALTER TABLE ✔ CREATE TABLE ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You need to perform these tasks:

1. Create and assign a MANAGER role to Blake and Clark
2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements

achieves the desired results?

CREATE ROLE manager;
GRANT create table, create view
TO manager;
GRANT manager TO BLACK, CLARK;

✘

CREATE ROLE manager;GRANT create table, create voew
TO manager;
GRANT manager ROLE TO BLACK, CLARK;

✘

GRANT manager ROLE TO BLACK, CLARK;GRANT create table, create voew
TO BLACK CLARK;
***MISSING***

✘

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement correctly describes SQL and /SQL*Plus?

Both SQL and /SQL*plus allow manipulation of values in the database.

✘

/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interfacefor executing SQL statements.

✘

/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQLstatements and sends them to the server.

✘

/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation ofvalues in the database.

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Examine the structure of the STUDENTS table:

STUDENT_ID NUMBER NOT NULL, Primary Key
STUDENT_NAME VARCHAR2(30)
COURSE_ID VARCHAR2(10) NOT NULL
MARKS NUMBER
START_DATE DATE
FINISH_DATE DATE

You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and
who completed the course in the year 1999.
Which SQL statement accomplishes this task?

SELECT student_ id, marks, ROWNUM "Rank"
FROM students
WHERE ROWNUM <= 10
AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99
AND course_id = 'INT_SQL'
ORDER BY mark DESC;

✘

SELECT student_id, marks, ROWID "Rank"FROM students
WHERE ROWID <= 10
AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99'
AND course_id = 'INT_SQL'
ORDER BY mark;

✘

SELECT student_id, marks, ROWNUM "Rank"FROM (SELECT student_id, marks
FROM students
WHERE ROWNUM <= 10
AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-
99'
AND course_id = 'INT_SQL'
ORDER BY mark DESC;

✘

SELECT student_id, marks, ROWNUM "Rank"FROM (SELECT student_id, marks
FROM students
WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99'
AND course_id = 'INT_SQL'
ORDER BY marks DESC)
WHERE ROWNUM <= 10;

✔

SELECT student id, marks, ROWNUM "Rank"FROM (SELECT student_id, marks
FROM students
ORDER BY marks)
WHERE ROWNUM <= 10
AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99'
AND course _ id 'INT_SQL';

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Examine the structure of the EMPLOYEES table:

EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE

Which INSERT statement is valid?

INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John',
'smith','01/01/01);

✘

INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John','smith','01 january 01');

✘

INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, 'John', 'smith',To_ date ('01/01/01));

✘

INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John','smith','01-Jan-01');

✔ DELETE ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle Introduction to Oracle9i SQL Set 3

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner