If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

If you update an assignment record multiple times in a single day, can you still track the record, if yes how?
by

1 Answer

Answer :

For some objects, such as assignments, more than one update per day is maintained by creating a physical record for each update. Such objects include an effective sequence number in each physical record to show the order in which updates made to an object on a single day were applied.
by

Related questions

What a SELECT FOR UPDATE cursor represent.?

Description : What a SELECT FOR UPDATE cursor represent.?

Last Answer : SELECT......FROM......FOR......UPDATE[OF column-reference][NOWAIT] The processing done in a fetch loop modifies the rows that have been retrieved by the cursor. A convenient way of ... the FOR UPDATE clause in the cursor declaration, WHERE CURRENT OF CLAUSE in an UPDATE or declaration statement.

What is the usage of an ON-INSERT,ON-DELETE and ON- UPDATE TRIGGERS ? These triggers are execu

Description : What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ? These triggers are execu

Last Answer : These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default function of insert, delete or update respectively. For Eg, instead of inserting a row in a table an existing row can be updated in the same table.

The join defined by the default data link is an outer join yes or no?

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

Can a view be updated/inserted/deleted? If Yes under what conditions ?

Description : Can a view be updated/inserted/deleted? If Yes under what conditions ?

Last Answer : A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.

Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Description : Can you attach an lov to a field at run-time? if yes, give the build-in name.?

Last Answer : Yes. Set_item_proprety

Can you make a Datafile auto extendible? If yes how?

Description : Can you make a Datafile auto extendible? If yes how?

Last Answer : YES. A Datafile can be auto extendible. Here's how to enable auto extend on a Datafile: SQL>alter database datafile '/u01/app/oracle/product/10.2.0/oradata/DBSID/EXAMPLE01.DBF' autoextend on; ... 'alter database datafile '|| file_name|| ' '|| ' autoextend on;' from dba_data_files; SQL>@runts

Who is responsible for delivering the situation status update and operational assignment to the TF?

Description : Who is responsible for delivering the situation status update and operational assignment to the TF?

Last Answer : tf

There is one application, which runs on a single terminal. There is another application that works on multiple terminals. What are the test techniques you will use on the second application that you would not do on the first application? A. Integrity, Response time B. Concurrency test, Scalability C. Update & Rollback, Response time D. Concurrency test, Integrity

Description : There is one application, which runs on a single terminal. There is another application that works on multiple terminals. What are the test techniques you will use on the second application that ... B. Concurrency test, Scalability C. Update & Rollback, Response time D. Concurrency test, Integrity

Last Answer : C. Update & Rollback, Response time

Which of the following types of Organizational Charts can be BEST used to track project costs : A. Hierarchical-type Organizational Chart B. Organizational Breakdown Structure C. Resource Breakdown Structure D. Responsibility Assignment Matrix

Description : Which of the following types of Organizational Charts can be BEST used to track project costs : A. Hierarchical-type Organizational Chart B. Organizational Breakdown Structure C. Resource Breakdown Structure D. Responsibility Assignment Matrix

Last Answer : C. Resource Breakdown Structure

Which of the following types of Organizational Charts can be BEST used to track project costs : A. Hierarchical-type Organizational Chart B. Organizational Breakdown Structure C. Resource Breakdown Structure D. Responsibility Assignment Matrix

Description : Which of the following types of Organizational Charts can be BEST used to track project  costs : A. Hierarchical-type Organizational Chart B. Organizational Breakdown Structure C. Resource Breakdown Structure D. Responsibility Assignment Matrix

Last Answer : C. Resource Breakdown Structure

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Last Answer : Only for 10 records.

Use the add_group_column function to add a column to record group that was created at a design time?

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

What is a Query Record Group?

Description : What is a Query Record Group?

Last Answer : A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns ... rows retrieved by the query associated with that record group. What is a Non Query Record Group?

How many number of columns a record group can have?

Description : How many number of columns a record group can have?

Last Answer : A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.

What is Current record attribute property?

Description : What is Current record attribute property?

Last Answer : Specifies the named visual attribute used when an item is part of the current record. Current Record Attribute is frequently used at the block level to display the current row in a multi-record ... current record, but you cannot dynamically highlight the current item, as the input focus changes.

What are record groups ? * Can record groups created at run-time?

Description : What are record groups ? * Can record groups created at run-time?

Last Answer : A record group is an internal Oracle Forms data structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to ... you define its structure and row values at design time, and they remain fixed at runtime.

Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Description : Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE

Last Answer : I) FALSE

Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Description : Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Last Answer : II) FALSE

What is difference between % ROWTYPE and TYPE RECORD ?

Description : What is difference between % ROWTYPE and TYPE RECORD ?

Last Answer : % ROWTYPE is to be used whenever query returns a entire row of a table or view. TYPE rec RECORD is to be used whenever query returns columns of different table or views and variables. E.g. ... emp ename %type ); e_rec emp% ROWTYPE cursor c1 is select empno,deptno from emp; e_rec c1 %ROWTYPE.

What is a record Group?

Description : What is a record Group?

Last Answer : A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table

Give built-in routine related to a record groups?

Description : Give built-in routine related to a record groups?

Last Answer : Create_group (Function) Create_group_from_query(Function) Delete_group(Procedure) Add_group_column(Function) Add_group_row(Procedure) Delete_group_row(Procedure) Populate_group(Function) Populate_group_with_query(Function) Set_group_Char_cell(procedure)

What is a record Group?

Description : What is a record Group?

Last Answer : A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table

What are the different type of a record group?

Description : What are the different type of a record group?

Last Answer : Query record group Static record group Non query record group

What is the use of RECORD option in EXP command?

Description : What is the use of RECORD option in EXP command?

Last Answer : For Incremental exports, the flag indirects whether a record will be stores data dictionary tables recording the export.

What is the use of RECORD LENGTH option in EXP command ?

Description : What is the use of RECORD LENGTH option in EXP command ?

Last Answer : Record length in bytes.

What is a record group?

Description : What is a record group?

Last Answer : A record group is an internal Oracle Forms that structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to the form module which they are defined.

What is a Static Record Group?

Description : What is a Static Record Group?

Last Answer : A static record group is not associated with a query, rather, you define its structure and row values at design time, and they remain fixed at runtime.

Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Description : Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Last Answer : False

What is WHEN-Database-record trigger?

Description : What is WHEN-Database-record trigger?

Last 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 ... the first item in the record, and after the operator attempts to navigate out of the item.

What are the different types of Record Groups?

Description : What are the different types of Record Groups?

Last Answer : Query Record Groups NonQuery Record Groups State Record Groups

What is the Maximum allowed length of Record group Column?

Description : What is the Maximum allowed length of Record group Column?

Last Answer : Record group column names cannot exceed 30 characters.

What are the primitive operations common to all record management systems?

Description : What are the primitive operations common to all record management systems?s?

Last Answer : Addition, deletion and modification.

What is Record-at-a-time?

Description : What is Record-at-a-time?

Last Answer : The Low level or Procedural DML can specify and retrieve each record from a set of records. This retrieve of a record is said to be Record-at-a-time.

How will you create multiple rollback segments in a database ?

Description : How will you create multiple rollback segments in a database ?

Last Answer : Create a database which implicitly creates a SYSTEM Rollback Segment in a SYSTEM tablespace. Create a Second Rollback Segment name R0 in the SYSTEM tablespace. Make new rollback segment ... ) for rollback segments. Deactivate Rollback Segment R0 and activate the newly created rollback segments.

How to implement the multiple control files for an existing database ?

Description : How to implement the multiple control files for an existing database ?

Last Answer : Shutdown the database Copy one of the existing control file to new location Edit Config ora file by adding new control file. name Restart the database.

Can one export to multiple files?/ Can one beat the Unix 2 Gig limit? (for DBA

Description : Can one export to multiple files?/ Can one beat the Unix 2 Gig limit? (for DBA

Last Answer : From Oracle8i, the export utility supports multiple output files. This feature enables large exports to be divided into files whose sizes will not exceed any operating system limits (FILESIZE= parameter). When ... > scott.exp.gz & # feed the pipe exp userid=scott/tiger file=exp.pipe ...

Which parameter can be used to set read level consistency across multiple queries?

Description : Which parameter can be used to set read level consistency across multiple queries?

Last Answer : Read only

Weather protection of track is required during block for execution of AT Welding? (i) Yes.* (ii) No (iii) As decided by site supervisor (iv) As per site condition

Description : Weather protection of track is required during block for execution of AT Welding? (i) Yes.* (ii) No (iii) As decided by site supervisor (iv) As per site condition

Last Answer : (i) Yes.*

If I am going to have a data table with million records and every record is going to be update every 30 seconds. Where should I save all this table data?

Description : If I am going to have a data table with million records and every record is going to be update every 30 seconds. Where should I save all this table data?

Last Answer : What I think is that you’d better be talking to professionals who have a stake in the answer they give, rather than a bunch of random strangers on the Interwebz.

will iPhone camera ever be able to record video? Maybe on a future software update?

Description : will iPhone camera ever be able to record video? Maybe on a future software update?

Last Answer : It seems like this could be added via software update.

what do i need to do to find out what i may be entitled to as far as benefits from the military and to update my record to the current pay grade and i have a honorable discharge. i need some guidance in the direction needed to go in. ?

Description : what do i need to do to find out what i may be entitled to as far as benefits from the military and to update my record to the current pay grade and i have a honorable discharge. i need some guidance in the direction needed to go in. ?

Last Answer : contact Veterans Affairs for help 1434 N Limestone St, Gaffney, SC - (864) 487-2579

Is it legal to record songs when listening to Internet radio stations - And if yes, how is it done?

Description : Is it legal to record songs when listening to Internet radio stations - And if yes, how is it done?

Last Answer : I would think it is legal as long as it it just for your use and not being sold. I don’t see how it is different than recording a movie on my tv, or making a cassette tape from the radio like back in the day.

Supposing you are a journalist, is it ethical to use a tape record your Interview process without the consent of the person concerned?a) Yes b) No c) Do not know d) None of these

Description : Supposing you are a journalist, is it ethical to use a tape record your Interview process without the consent of the person concerned?a) Yes b) No c) Do not know d) None of these

Last Answer : b) No

If a View on a single base table is manipulated will the changes be reflected on the base table ?

Description : If a View on a single base table is manipulated will the changes be reflected on the base table ?

Last Answer : If changes are made to the tables which are base tables of a view will the changes be reference on the view.

How many pages you can in a single form ?

Description : How many pages you can in a single form ?

Last Answer : Unlimited

Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER The above is a) Not an error b) Error - the string in single quotes ‘NORTH’ and ‘SOUTH’ c) Error - the string should be in double quotes d) Error - ORDER BY clause

Description : Select NORTH', CUSTOMER From CUST_DTLS Where REGION = N' Order By CUSTOMER Union Select EAST', CUSTOMER From CUST_DTLS Where REGION = E' Order By CUSTOMER The above is a) Not an error b) Error - ... ' and SOUTH' c) Error - the string should be in double quotes d) Error - ORDER BY clause

Last Answer : d) Error - ORDER BY clause

Three gods, A, B, and C, are called, in some order, True, False, and Random. True always speaks truly, False always speaks falsely, but whether Random speaks truly or falsely is completely random. You must determine the identities of A, B, and C by asking three yes-or-no questions, and each question must be posed to exactly one god. The gods understand English, but will answer all questions in their own language. In their unknown language, the words for 'yes' and 'no' are 'da' and 'ja', in some order. You do not know which word means which. So, which questions would you ask to identify each god? And no, it’s not a trick question. As a matter of fact, there are multiple ways to get the correct answer. -Riddles

Description : Three gods, A, B, and C, are called, in some order, True, False, and Random. True always speaks truly, False always speaks falsely, but whether Random speaks truly or falsely is completely random. ... a trick question. As a matter of fact, there are multiple ways to get the correct answer. -Riddles

Last Answer : 1. To god A: Does da' mean yes' if and only if you are True and if and only if B is Random? (We supposed A said, ja, making B True or False). 2. To god B: Does da mean yes' if and ... only if A is Random? Since B's True, he must say da, which means A is Random, leaving C to be False.

You want to understand if users use their mobile phone to access your site. Which of the following approach is preferable? A. Ask "Are you using a mobile phone to access our site?" Yes/No B. Ask "Which type of device are you using to access our site?" with choices: Desktop computer/Mobile Phone/Tablet C. Look at the report Audience/Mobile/Overview D. This cannot be known because people use multiple devices to browse the Web

Description : You want to understand if users use their mobile phone to access your site. Which of the following approach is preferable? A. Ask "Are you using a mobile phone to access our site?" ... report Audience/Mobile/Overview D. This cannot be known because people use multiple devices to browse the Web

Last Answer : C. Look at the report Audience/Mobile/Overview

To execute row from being displayed that still use column in the row which property can be used?

Description : To execute row from being displayed that still use column in the row which property can be used?

Last Answer : Format trigger.