Technology Questions

Q:

Explain foreign key constraint.

Answer

A foreign key is a reference to another table. It is used to establish relationships between tables. For example, relationship between employee and professor table. One employee can have multiple professors. The Primary key of employee becomes foreign key of professor.
Example:
create table employee ( id number NOT NULL, professor_id NOT NULL, Name varchar(200) Constraint prim_id Foreign key(id) references professor(professor_id) );

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2263
Q:

What is the concept of Application Cache in HTML5? What are its advantages?

Answer

The Application Cache concept introduced by HTML5 means that a web application is cached, and accessible without an internet connection.


There are three advantages of Application Cache:


1.Offline browsing - users can use the application when they're offline


2.Speed - cached resources load faster


3.Reduced server load - the browser will only download updated/changed resources from the server

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2262
Q:

What is DriverManager ?

Answer

DriverManager is a class in java.sql package. It is the basic service for managing a set of JDBC drivers.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2260
Q:

What are the new attributes provided in HTML5 for "form" tag ?

Answer

The new attributes provided in HTML5 for <form> are: 


a.) autocomplete


– It specifies if a form or input field should have autocomplete as on or off. 


– If autocomplete is on, the browser is able to fill the values based on the values filled by the user earlier. 


– autocomplete works for following input types: text, search, url, tel, email, password, datepickers, range, and color. 


b.) novalidate


- This is a boolean attribute. 


- When present, it signifies that the form-data should not be validated when submitted.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2259
Q:

What is the self-referencing constraint?

Answer

A31. The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.

Report Error

View answer Workspace Report Error Discuss

0 2258
Q:

What are the tasks of a Business Analyst in Software Development Life Cycle?

Answer

Generally a business analyst covers several stages in Software Development Life Cycle.


Like:  Client Consulting, Client Requirement Study, Planning for business needs, Business Requirement Documenting, Work on functional requirement, Prepare test data with inputs from end users, Document use case scenarios, Help Testing team with test plan and testing, Help end users with user acceptance testing UAT, Go live and post production support tasks.

Report Error

View answer Workspace Report Error Discuss

5 2258
Q:

Name any three PL/SQL exceptions?

Answer

Too_many_rows.


No_Data_Found.


Zero_Error.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2255
Q:

Does .NET support multiple inheritance?

Answer

.NET does not support multiple inheritance directly because in .NET, a class cannot inherit from more than one class. .NET supports multiple inheritance through interfaces.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2255