What is the maximum number of Triggers can be applied in a table ?

Correct Answer: DocumentDB is a NoSQL document-oriented database and records saves in key-value pairs It's same as the other NoSQL document-oriented such as MongoDB

Correct Answer: All the above

Correct Answer: Insert image into a table Create the following table: create table pics_table ( bfile_id number, bfile_desc varchar2(30), bfile_loc bfile, bfile_type varchar2(4)) TABLESPACE appl_data storage (initial 1m next 1m pctincrease 0) Insert Query: INSERT INTO pics_table VALUES(4,'test image',bfilename('GIF_FILES','TestJPG'),'JPEG');

Correct Answer: Oracle supports 3 transaction isolation levels: - Read committed (default) - Serializable transactions - Read only

Correct Answer: A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database The trigger is mostly used for maintaining the integrity of the information on the database Syntax: CREATE OR REPLACE TRIGGER [Trigger Name] [Before / After / Instead Of] ON [schema][table] Types of PL/SQL triggers : > Row trigger - The trigger fires for each ROW affected > Statement trigger - The trigger is fired once when the condition is matched > Before and After trigger - The BEFORE trigger run the trigger action before the insert, update or delete statement The AFTER trigger runs the trigger action after the insert, update or delete statement is executes

Correct Answer: PATH and CLASSPATH are operating system level environment variables PATH is used to define where the system can find the executables (exe) files whereas CLASSPATH is used to specify the location of class files

Correct Answer: Java uses primitive data types and hence is not a pure object oriented language

Correct Answer: The variable should be declared as static and final So only one copy of the variable exists for all instances of the class and the value can't be changed also static final int PI = 214; is an example for constant

Correct Answer: A protected method can be accessed by the classes within the same package or by the subclasses of the class in any package

Correct Answer: A method declared as final can't be overridden A sub-class can't have the same method signature with a different implementation