Technical Sample Questions : C |  C++ |  Oracle |  Java | Unix |  Operating Systems |  Data Structure

Oracle Sample Questions ›› Oracle Interview Questions

Technical Sample Questions

Oracle Sample Questions : Oracle Interview Questions

71. Can a trigger written for a view ?

    Answer: No

72. If all the values from a cursor have been fetched and another fetch is issued, the output will be : error, last record or first record ?

    Answer: Last Record

73. A table has the following data : [[5, Null, 10]].What will the average function return ?

    Answer: 7.5

74. Is Sysdate a system variable or a system function?

    Answer: System Function

75. Consider a sequence whose currval is 1 and gets incremented by 1 by using the nextval reference we get the next number 2.Suppose at this point we issue an rollback and again issue a nextval.What will the output be ?

    Answer: 3

76. Definition of relational DataBase by Dr.Codd (IBM)?

    Answer: A Relational Database is a database where all data visible to the user is organized strictly as tables of data values and where all database operations work on these tables.

77. What is Multi Threaded Server (MTA) ?

    Answer: In a Single Threaded Architecture (or a dedicated server configuration) the database manager creates a separate process for each database user.But in MTA the database manager can assign multiple users (multiple user processes) to a single dispatcher (server process), a controlling process that queues request for work thus reducing the databases memory requirement and resources.

78. Which are initial RDBMS, Hierarchical & N/w database ?

    Answer:

    • RDBMS - R system
    • Hierarchical - IMS
    • N/W - DBTG

79. Difference between Oracle 6 and Oracle 7

    Answer:

    ORACLE 7	ORACLE 6
    Cost based optimizer	Rule based optimizer
    Shared SQL Area	SQL area allocated for each user
    Multi Threaded Server	Single Threaded Server
    Hash Clusters	Only B-Tree indexing
    Roll back Size Adjustment	No provision
    Truncate command	No provision
    Distributed Database	Distributed Query
    Table replication & snapshots	No provision
    Client/Server Tech	No provision

80. What is Functional Dependency

    Answer: Given a relation R, attribute Y of R is functionally dependent on attribute X of R if and only if each X-value has associated with it precisely one -Y value in R