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
