Oracle Database Interview Questions - 1 | Snaprecruit.com

Oracle Database Interview Questions - 1 | Snaprecruit.com

Oracle Database interview questions part 1

Oracle Database interview questions part 1

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

1. In an E-R diagram an entity set is represent by a

Correct Answer is : Rectangle

2. A relational database developer refers to a record as

Correct Answer is : A tuple

3. The relational model feature is that there

Correct Answer is : is much more data independence than some other database models

4. E-R model uses this symbol to represent weak entity set ?

Correct Answer is : Doubly outlined rectangle

5. Which of the following is record based logical model?

Correct Answer is : Network Model

6. A ___________ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.

Correct Answer is : Third

7. Identify the criteria for designing database from the point of view of user

Correct Answer is : All of the Mentioned

8. The relational model is based on the concept that data is organized and stored in two-dimensional tables called _____________

Correct Answer is : Records

9. An aggregation association is drawn using which symbol:

Correct Answer is : small open diamond at the end of a line connecting two tables

10. An n-array relationship is drawn using which symbol:

Correct Answer is : A diamond

11. A BI reporting system does not _____________

Correct Answer is : Use statistical procedures to predict future events

12. The “curse of dimensionality” relates to which problem of using operational data for BI reporting?

Correct Answer is : Too much data

13. A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

Correct Answer is : Pull

14. Business Intelligence (BI) reporting systems cannot do which of the following operations?

Correct Answer is : Modify data

15. Which of the following is not a component of a data warehouse?

Correct Answer is : Data metadata

16. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?

Correct Answer is : One row has the value “He is interested in a Silver Porsche from the years 1978-1988” in a column

17. The wildcard in a WHERE clause is useful when?

Correct Answer is : An exact match is not possible in a SELECT statement

18. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;

Correct Answer is : SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);

19. There are two sessions currently connected to your database instance. In the first session, the following UPDATE statement is executed: SQL> UPDATE dept SET deptno=80 WHERE dname='SALES'; The UPDATE statement above waits to complete the execution. Investigations reveal the following facts: – The UPDATE statement is waiting to acquire a lock – There is referential integrity constraint between the DEPT and EMP table – Department number 30 represents the SALES department – The EMP table is updated in the second session as follows: SQL> UPDATE emp SET sal=sal*0.17 WHERE deptno=30; Which action would you perform to avoid waiting in the first session ?

Correct Answer is : Create an index on the deptno column of the EMP table

20. The Oracle environment of database is called as ___________

Correct Answer is : Database Instances

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon