Description : what are the datatypes supported By oracle (INTERNAL)
Last Answer : Varchar2, Number,Char , MLSLABEL.
Description : • Describe Referential Integrity?
Last Answer : A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a ... data and the action to be performed on dependent data as a result of any action on referenced data.
Description : What are the components of logical database structure of Oracle database?
Last Answer : There are tablespaces and database's schema objects.
Description : High-Performance Oracle SQL Performance Tuning Tools for Databases?
Last Answer : database configuration monitoring, DBMS hardware configuration (a DBMS and related database may span computers, networks, and storage units) and related database mapping
Description : Is there accounting software that has ready-made compatibility with Oracle databases?
Last Answer : Microsoft Excel and Access offer the ability to interface with a Oracle database. This is provided through the Office Suite.
Description : Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully -managed web service that allows you to create , ... large applications into logical components that can be share stateful services and communicate in secure fashion.
Last Answer : A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud
Description : How many rows will the following SQL return
Last Answer : Select * from emp Where rownum < 10; 9 rows.
Description : Can you use %RowCount as a parameter to a cursor
Last Answer : Yes
Description : What are the various types of RollBack Segments ?
Last Answer : Public Available to all instances Private Available to specific instance
Description : Can you pass a parameter to a cursor ?
Last Answer : Explicit cursors can take parameters, as the example below shows. A cursor parameter can appear in a query wherever a constant can appear. CURSOR c1 (median IN NUMBER) IS SELECT job, ename FROM emp WHERE sal > median
Description : What is the significance of the & and && operators in PL SQL ?
Last Answer : The & operator means that the PL SQL block requires user input for a variable. The && operator means that the value of this variable should be the same as inputted by the user previously ... span across different rollback segments or will it terminate ? It will terminate (Please check ).
Description : What is the maximum no. of columns a table can have ?
Last Answer : 254.
Description : Can you Rollback to any savepoint ?
Last Answer : Yes.
Description : Can you define multiple savepoints ?
Description : An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?
Last Answer : No.
Description : What is the difference between unique key and primary key ?
Last Answer : Unique key can be null; Primary key cannot be null.
Description : What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?
Last Answer : The various states of a rollback segment are : ONLINE, OFFLINE, PARTLY AVAILABLE, NEEDS RECOVERY and INVALID.
Description : What are the min. extents allocated to a rollback extent ?
Last Answer : Two
Description : Can Check constraint be used for self referential integrity ? How ?
Last Answer : ? Yes. In the CHECK condition for a column of a table, we can reference some other column of the same table and thus enforce self referential integrity.
Description : Can null keys be entered in cluster index, normal index ?
Description : Can Long/Long RAW be clustered ?
Description : What are the disadvantages of clusters ?
Last Answer : The time for Insert increases.
Description : What are the advantages of clusters ?
Last Answer : Access time reduced for joins.
Description : What is the use of Data Dictionary ?
Last Answer : Used by Oracle to store information about various physical and logical Oracle structures e.g. Tables, Tablespaces, datafiles, et
Description : What is the use of Control files ?
Last Answer : Contains pointers to locations of various data files, redo log files, etc.
Description : Can you increase the size of datafiles ? How ?
Last Answer : No (for Oracle 7.0)
Description : Can you increase the size of a tablespace ? How ?
Last Answer : Yes, by adding datafiles to it.
Description : What are constraining triggers ?
Last Answer : A trigger giving an Insert/Updat e on a table having referential integrity constraint on the triggering table.
Description : What are mutating triggers ?
Last Answer : A trigger giving a SELECT on the table on which the trigger is written.
Description : What are cascading triggers? What is the maximum no of cascading triggers at a time?
Last Answer : When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading. Max = 32.
Description : Can views be specified in a trigger statement ?
Last Answer : No
Description : What is the maximum no. of statements that can be specified in a trigger statement?
Last Answer : One.
Description : What is the advantage of a stored procedure over a database trigger ?
Last Answer : We have control over the firing of a stored procedure but we have no control over the firing of a trigger.
Description : What are the various types of database triggers ?
Last Answer : There are 12 types of triggers, they are combination of : Insert, Delete and Update Triggers. Before and After Triggers. Row and Statement Triggers. (3*2*2=12)
Description : What are the parts of a database trigger ?
Last Answer : The parts of a trigger are: A triggering event or statement A trigger restriction A trigger action
Description : Can you pass parameters in packages ? How ?
Last Answer : Yes. You can pass parameters to procedures or functions in a package.
Description : Why Create or Replace and not Drop and recreate procedures ?
Last Answer : So that Grants are not dropped.
Description : What are the constructs of a procedure, function or a package ?
Last Answer : The constructs of a procedure, function or a package are : variables and constants cursors exceptions
Description : Can 2 functions have same name & input parameters but differ only by return datatype
Description : Can functions be overloaded ?
Description : What is Over Loading and what are its restrictions ?
Last Answer : OverLoading means an object performing different functions depending upon the no. of parameters or the data type of the parameters passed to it.
Description : What are the various types of parameter modes in a procedure ?
Last Answer : IN, OUT AND INOUT.
Description : Can you call a stored function in the constraint of a table ?
Last Answer : no
Description : Can you have two stored functions with the same name ?
Description : Can you have two functions with the same name in a PL/SQL block
Description : What is the difference between a procedure and a function ?
Last Answer : Functions return a single variable by value whereas procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter
Description : Can we define exceptions twice in same block ?
Description : What are the various types of Exceptions ?
Last Answer : User defined and Predefined Exceptions.
Description : Can you use select in FROM clause of SQL select ?
Description : What are attributes of cursor?
Last Answer : %FOUND , %NOTFOUND , %ISOPEN,%ROWCOUNT