Can we create two blocks with the same name in form 3.0 ?

Can we create two blocks with the same name in form 3.0 ?
by

1 Answer

Answer :

No
by

Related questions

What is Oracle Block? Can two Oracle Blocks have the same address?

Description : What is Oracle Block? Can two Oracle Blocks have the same address?

Last Answer : Oracle formats the database files into a number of Oracle blocks when they are first created-making it easier for the RDBMS software to manage the files and easier to read data into the memory areas ... at 1. Two blocks can have the same block address if they are in different database files.

While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Description : While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Last Answer : True

Is space acquired in blocks or extents ?

Description : Is space acquired in blocks or extents ?

Last Answer : In extents

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr

How do you create a new session while open a new form?

Description : How do you create a new session while open a new form?

Last Answer : Using open_form built-in setting the session option Ex. Open_form('Stocks ',active,session). when invoke the mulitiple forms with open form and call_form in the same application, state whether the following are true/False

How does one create a standby database? (for DBA)

Description : How does one create a standby database? (for DBA)

Last Answer : While your production database is running, take an (image copy) backup and restore it on duplicate hardware. Note that an export will not work!!! On your standby database, issue ... the standby database, stop the recovery process and activate it: ALTER DATABASE ACTIVATE STANDBY DATABASE;

Name a tablespace automatically created when you create a database.

Description : Name a tablespace automatically created when you create a database.

Last Answer : The SYSTEM tablespace.

What command would you use to create a backup control file?

Description : What command would you use to create a backup control file?

Last Answer : Alter database backup control file to trace.

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Description : A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Last Answer : Disable the foreign key constraint to the parent, drop the table, re- create the table, enable the foreign key constraint.

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

How does one create and drop database users?

Description : How does one create and drop database users?

Last Answer : Look at these examples: CREATE USER scott IDENTIFIED BY tiger -- Assign password DEFAULT TABLESACE tools -- Assign space for table and index segments TEMPORARY TABLESPACE temp; -- Assign sort space ... give the user some space quota on its tablespaces: ALTER USER scott QUOTA UNLIMITED ON tools;

What utility is used to create a physical backup?

Description : What utility is used to create a physical backup?

Last Answer : Either rman or alter tablespace begin backup will do..

The following describes means to create a OEM V1.x (very old!!!) repository on WindowsNT:

Description : The following describes means to create a OEM V1.x (very old!!!) repository on WindowsNT:

Last Answer : Create a tablespace that would hold the repository data. A size between 200- 250 MB would be ideal. Let us call it Dummy_Space. . Create an Oracle user who would own this repository. Assign ... would trigger the creation of the repository. From now on, Enterprise manager is ready to accept jobs.

How does one create a repository? (for DBA

Description : How does one create a repository? (for DBA

Last Answer : For OEM v2 and above, start the Oracle Enterprise Manager Configuration Assistant (emca on Unix) to create and configure the management server and repository. Remember to setup a backup for the repository database after creating it.

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 does one create a RMAN recovery catalog? (for DBA

Description : How does one create a RMAN recovery catalog? (for DBA

Last Answer : Start by creating a database schema (usually called rman). Assign an appropriate tablespace to it and grant it the recovery_catalog_owner role. Look at this example: sqlplus sys SQL>create user ... . Look at this example: rman catalog rman/rman target backdba/backdba RMAN> register database;

Why is it preferable to create a fewer no. of queries in the data model?

Description : Why is it preferable to create a fewer no. of queries in the data model?

Last Answer : Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

How does one create a password file? (for DBA

Description : How does one create a password file? (for DBA

Last Answer : The Oracle Password File ($ORACLE_HOME/dbs/orapw or orapwSID) stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be ... visible in the process table of many systems. Administrators needs to be aware of this!

How does one create a new database? (for DBA)

Description : How does one create a new database? (for DBA)

Last Answer : One can create and modify Oracle databases using the Oracle "dbca" (Database Configuration Assistant) utility. The dbca utility is located in the $ORACLE_HOME/bin directory. The Oracle Universal ... ='/u02/oradata/'; ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2='/u03/oradata/'; CREATE DATABASE;

A Column is having many repeated values which type of index you should create on this column, if you have to?

Description : A Column is having many repeated values which type of index you should create on this column, if you have to?

Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.

A table is having few rows, should you create indexes on this table

Description : A table is having few rows, should you create indexes on this table

Last Answer : Small tables do not require indexes; if a query is taking too long, then the table might have grown from small to large. You can create an index on any column; however, if the ... , creating an index on the column does not increase performance and the index takes up resources unnecessarily.

On which columns you should create Indexes?

Description : On which columns you should create Indexes?

Last Answer : In general, you should create an index on a column in any of the following situations: ▪ The column is queried frequently ▪ A referential integrity constraint exists on the column ▪ A UNIQUE key ... ORDER BY clauses ▪ On columns that have few of the same values or unique values in the table

Which default Database roles are created when you create a Database?

Description : Which default Database roles are created when you create a Database?

Last Answer : CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role. The following query lists all the roles in ... ------------ -------- CONNECT NO RESOURCE NO DBA NO SECURITY_ADMIN YES

What is the minimum number of instances you need to have in order to create a RAC?

Description : What is the minimum number of instances you need to have in order to create a RAC?

Last Answer : 1. You can create a RAC with just one server.

How to create a server so that a friend in the game Zumbi Blocks can connect there ??

Description : Every time I want to play Zumbi Blocks with a friend, I create a server and he can't connect there and vice versa, you don't know what it can be? (here is a link to the game http://www.superhry.cz/eng/5645-zumbi-blocks-3d )

Last Answer : Need Answer

To read a file in HDFS, a user sends an _______ request to the NameNode toget the location of file blocks. a) access b) open c) authentication d) create

Description : To read a file in HDFS, a user sends an _______ request to the NameNode toget the location of file blocks. a) access b) open c) authentication d) create

Last Answer : open

Is it possible to attach same library to more than one form?

Description : Is it possible to attach same library to more than one form?

Last Answer : Yes

How do you use the same lov for 2 columns

Description : How do you use the same lov for 2 columns

Last Answer : We can use the same lov for 2 columns by passing the return values in global values and using the global values in the code

Can a button have icon and lable at the same time ?

Description : Can a button have icon and lable at the same time ?

Last Answer : NO

If you have property class attached to an item and you have same trigger written for the item . Which will fire first?

Description : If you have property class attached to an item and you have same trigger written for the item . Which will fire first?

Last Answer : Item level trigger fires , If item level trigger fires, property level trigger won't fire. Triggers at the lowest level are always given the first preference. The item level trigger fires first and then the block and then the Form level trigger.

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Description : Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Last Answer : a. ON-INSERT b. POST-INSERT c. PRE-INSERT

Can objects of the same Schema reside in different tablespaces.?

Description : Can objects of the same Schema reside in different tablespaces.?

Last Answer : Yes.

Can objects of the same schema reside in different tablespaces?

Description : Can objects of the same schema reside in different tablespaces?

Last Answer : Yes.

Are the resulting relations of PRODUCT and JOIN operation the same?

Description : Are the resulting relations of PRODUCT and JOIN operation the same?

Last Answer : No. PRODUCT: Concatenation of every row in one relation with every row in another. JOIN: Concatenation of rows from one relation and related rows from another

Can you have many database versions in the same RAC?

Description : Can you have many database versions in the same RAC?

Last Answer : Yes, but Clusterware version must be greater than the greater database version.

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

Description : What should be the return type for a cursor variable.Can we use a scalar data type as return type?

Last Answer : The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE

Can we use GO-BLOCK package in a pre-field trigger ?

Description : Can we use GO-BLOCK package in a pre-field trigger ?

Last Answer : No

Can we use a restricted package procedure in ON- VALIDATE-FIELD Trigger ?

Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

Last Answer : No

List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Description : List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Last Answer : SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operational tables. INDEXES1 - Indexes of ... - Temporary purpose tablespace TEMP_USER - Temporary tablespace for users. USERS - User tablespace.

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Cascade Isolate Non-isolate

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

How can we reduce the network traffic?

Description : How can we reduce the network traffic?

Last Answer : Replication of data in distributed environment. - Using snapshots to replicate data. - Using remote procedure calls.

How can we specify the Archived log file name format and destination?

Description : How can we specify the Archived log file name format and destination?

Last Answer : By setting the following values in init.ora file. LOG_ARCHIVE_FORMAT = arch %S/s/T/tarc (%S - Log sequence number and is zero left paded, %s - Log sequence number not padded. %T - Thread number lef ... not padded). The file name created is arch 0001 are if %S is used. LOG_ARCHIVE_DEST = path.

What are roles? How can we implement roles ?

Description : What are roles? How can we implement roles ?

Last Answer : Roles are the easiest way to grant and manage common privileges needed by different groups of database users. Creating roles and assigning provides to roles. Assign each role to group of users. This will simplify the job of assigning privileges to individual users.

Which command will we use to manage (stop, start…) RAC services in command-line mode?

Description : Which command will we use to manage (stop, start…) RAC services in command-line mode?

Last Answer : srvctl

In linux, how can we change which databases are started during a reboot?

Description : In linux, how can we change which databases are started during a reboot?

Last Answer : - Edit /etc/oratab

How can you execute the user defined triggers in forms 3.0 ?

Description : How can you execute the user defined triggers in forms 3.0 ?

Last Answer : Execute Trigger (trigger-name)

What is the main diff. bet. Reports 2.0 & Reports 2.5?

Description : What is the main diff. bet. Reports 2.0 & Reports 2.5?

Last Answer : Report 2.5 is object oriented.

There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

Description : There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

Last Answer : INSTR('120000 12 0 .125',1,'.') output 13

How image_items can be populate to field in forms 4.0?

Description : How image_items can be populate to field in forms 4.0?

Last Answer : A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.