3
Q:

Give the sequence of execution of the various report triggers? 

Answer:



Q:

In a database table, the category of information is called

A) Record B) Field
C) Tuple D) None of the above
 
Answer & Explanation Answer: B) Field

Explanation:

In a database table, the category of information is called Field.

Report Error

View Answer Report Error Discuss

0 1606
Q:

The database schema is written in

A) DDL B) HLL
C) DCL D) DML
 
Answer & Explanation Answer: A) DDL

Explanation:

The database schema is written in DDL. A data definition language or data description language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.

Report Error

View Answer Report Error Discuss

4 7960
Q:

What is BCP ? When is it used ?

Answer

The Bulk Copy Program (BCP) is a command-line utility that ships with Microsoft SQL Server. It is a tool used to duplicate enormous quantity of information from tables and views. It does not facsimile the structures same as foundation to target.
BULK INSERT command helps to bring in a data folder into a record, table or view in a user-specific arrangement. With BCP, you can import and export large amounts of data in and out of SQL Server databases quickly and easily. Any DBA who has utilized this functionality will agree that BCP is an essential tool.

Report Error

View answer Workspace Report Error Discuss

3 1546
Q:

What is WHEN-Database-record trigger?

Answer

Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

Report Error

View answer Workspace Report Error Discuss

2 2949
Q:

What are the built-ins used for finding Object ID function?

Answer

FIND_GROUP(function) FIND_COLUMN(function)

Report Error

View answer Workspace Report Error Discuss

0 1631
Q:

What is relation between the window and canvas views?

Answer

Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

Report Error

View answer Workspace Report Error Discuss

0 1575
Q:

What is the difference between OLE Server & OLE Container?

Answer

An OLE server application creates ole Objects that are embedded or linked in OLE Containers ex. OLE servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an OLE Container.

Report Error

View answer Workspace Report Error Discuss

1 2878
Q:

What is user Account in Oracle database?

Answer

An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges. 95. When will the data in the snapshot log be used? - We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges. We cannot specify snapshot log name because oracle uses the name of the master table in the name of the database objects that support its snapshot log. The master table name should be less than or equal to 23 characters. (The table name created will be MLOGS_tablename, and trigger name will be TLOGS name).

Report Error

View answer Workspace Report Error Discuss

0 1477