ORACLE RDBMS/SQL MCQ QUESTION AND ANSWERS

 ORACLE RDBMS/SQL EXAM         

1)       Identify the SELECT statements that execute successfully.                        Download                Each question carry 1 Mark   20                                                                                                                                                                  20 questions

a.SELECT first_name, last_name, job_id, salary*12 AS Yearly Sal

FROM   employees;

b.SELECT first_name, last_name, job_id, salary*12

 "yearly sal"  FROM   employees;

c.SELECT first_name, last_name, job_id, salary AS

 "yearly sal" FROM   employees;

d.SELECT first_name+last_name AS name, job_Id,

 salary*12 yearly sal FROM   employees;

2)       Which four of the following are valid operators for the WHERE clause?

a.>=

b.IS NULL

c.!=

d.IS LIKE

e.IN BETWEEN

f.<>

3)       Which four of the following statements are true about single-row functions?

a.Manipulate data items

b.Accept arguments and return one value per argument

c.Act on each row that is returned

d.Return one result per set of rows

e.Never modifies the data type

f.Can be nested

 g.Accept arguments that can be a column or an expression

4)        The TO_NUMBER function converts either character strings or date values to a number in the format specified by the optional format model.

a.True

b.False

5)       Identify the two guidelines for group functions and the GROUP BY clause.

a.You cannot use a column alias in the GROUP BY clause.

b.The GROUP BY column must be in the SELECT clause.

c.By using a WHERE clause, you can exclude rows before dividing them into groups.

d.The GROUP BY clause groups rows and ensures order of the result set.

e.If you include a group function in a SELECT clause, you must include a GROUP BY clause.

6)       If you join a table to itself, what kind of join are you using?

a.Nonequijoin

b.Left OUTER join

c.Right OUTER join

d.Full OUTER join

e.Self-join

f.Natural join

g.Cartesian products

7)       Identify two set operator guidelines.

a.The expressions in the SELECT lists must match in number.

b.Parentheses may not be used to alter the sequence of execution.

c.The data type of each column in the second query must match the data type of its corresponding column in the first query.

d.The ORDER BY clause can be used only once in a compound query, unless a UNION ALL operator is used.

8)       The following statement produce the same results:

DELETE FROM TABLE_A;

TRUNCATE TABLE TABLE_A;

A)True

B)False

9)       To do which three of the following can you use constraints?

a.Enforce rules on the data in a table whenever a row is inserted, updated, or deleted.

b.Prevent the dropping of a table.

c.Prevent the creation of a table.

d.Prevent the creation of data in a table.

10)    Indexes must be created manually and serve to speed up access to rows in a table.

a.True

b.False

11)    A relation in 2nd normal form when

A) It is in 1st normal form

B) No partial dependency

C) It has no transitive dependency

D) Both A and B

12)    You issue a select statement on the BANK_ACCT table containing the order by clause.

Which of  the following uses of the order by clause * would produce an error?

A.order by acctno DESC;                                      

B.order by 1;

C.order by length(1);                                                           

D.order by acctno ASC;

E.None of the above.

13)    When you drop a table with DROP TABLE command, the views based on those tables are also dropped automatically along with the table.

A.True                                                                                    

B.False.

C.You can’t drop such table

D.View can’t be drop

14)    The commit and rollback commands are not applicable for 

A.Insert

B.Create

C.Delete

D.Update

15)    To write a query that performs an outer join of tables A and B and returns all rows from B, You need to write

A.any outer join                   

B.a left outer join

C.a right outer join              

D.an inner join

16)    Which Query is will give error.

A.select count(sysdate) from tab;

B.select count(8) from emp;

C.select count(‘d’) from dual;

D.SELECT COUNT(+) FROM DUAL;

17)    A Student  table’s name column having values

Ajay

Aman

Brajesh

ManmeetSingh

Navneet

Khusboo

Zawed

   What will be the result of this Queiry?

Select max(name) from student;

A.Aman

B.Zawed

C.ManmeetSingh

D.Ajay

18)    All the complex view are unupdatable

A.True

B.False

19)    Which Is False about the following statements

A.       You can use natural join ,join and outer on any two table in database

B.       We can grant sequence to other user

C.        Altering sequence is  always possible

D.       All the constraints on a table can be written at column level except null

2

20)Which statement is true regarding external tables?

A. The default REJECT LIMIT for external tables is UNLIMITED.

B. The data and metadata for an external table are stored outside the database.

C. ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.

D. The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table.

******************************************BEST OF LUCK****************************************