Description : What is the use of break group? What are the various sub events a mouse double click event involves?
Last Answer : A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.
Description : What is the use of hidden column? What are the various sub events a mouse double click event involves?
Last Answer : A hidden column is used to when a column has to embed into boilerplate text.
Description : What is the use of place holder column? What are the various sub events a mouse double click event involves?
Last Answer : A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.
Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?
Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.
Description : What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?
Last Answer : An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.
Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?
Last Answer : Destype and Desname.
Description : Use the add_group_column function to add a column to record group that was created at a design time?
Last Answer : 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
Description : If a break order is set on a column would it affect columns which are under the column?
Last Answer : No
Description : State any three mouse events system variables?
Last Answer : System.mouse_button_pressedSystem.mouse_button_shift
Description : If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?
Last Answer : It won't, Because SYSDATE format contains time attached with it.
Description : By default, to run an application through mouse, which one of the following has to be done ? (1) Right click (2) Left click (3) Single click (4) Double dick
Last Answer : Double dick
Description : Which one of the following is the easiest method to select a column: a) Double click any cell in the column b) Click the column heading c) Click the column label d) None of The Above
Last Answer : c) Click the column label
Description : Can a formula column referred to columns in higher group?
Last Answer : Yes
Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
Description : What is the Maximum allowed length of Record group Column?
Last Answer : Record group column names cannot exceed 30 characters.
Description : Write the order of precedence for validation of a column in a table ?
Last Answer : I. done using Database triggers. ii. done using Integarity Constraints.?
Description : What is the purpose of the product order option in the column property sheet?
Last Answer : To specify the order of individual group evaluation in a cross products.
Description : Can a repeating frame be created without a data group as a base?
Description : Is it possible to link two groups inside a cross products after the cross products group has been created?
Last Answer : no
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
Description : How will you swap objects into a different table space for an existing database ?
Last Answer : Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.
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.
Description : In mapping of ERD to DFD a) entities in ERD should correspond to an existing entity/store in DFD b) entity in DFD is converted to attributes of an entity in ERD c) relations in ERD has 1 to 1 correspondence to processes in DFD d) relationships in ERD has 1 to 1 correspondence to flows in DFD
Last Answer : a) entities in ERD should correspond to an existing entity/store in DFD
Description : Can u change the mouse pointer ? How?
Last Answer : Yes. Specifies the mouse cursor style. Use this property to dynamically change the shape of the cursor.
Description : Which trigger related to mouse?
Last Answer : When-Mouse-Click When-Mouse-DoubleClick When-Mouse-Down When-Mouse-Enter When-Mouse-Leave When-Mouse-Move When-Mouse-Up
Description : What is mouse navigate property of button?
Last Answer : When Mouse Navigate is True (the default), Oracle Forms performs standard navigation to move the focus to the item when the operator activates the item with the mouse. When Mouse Navigate is set ... the resulting validation) to move to the item when an operator activates the item with the mouse.
Description : How does one backout events and jobs during maintenance slots? (for DBA
Last Answer : Managemnet and data collection activity can be suspended by imposing a blackout. Look at these examples: agentctl start blackout # Blackout the entrire agent agentctl stop blackout # Resume normal monitoring ... management agentctl start blackout -s jobs -d 00:20 # Blackout jobs for 20 minutes
Description : How does one tune Oracle Wait events? (for DBA
Last Answer : Some wait events from V$SESSION_WAIT and V$SYSTEM_EVENT views: Event Name: Tuning Recommendation: db file sequential read Tune SQL to do less I/O. Make sure all objects are analyzed. Redistribute ... SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks
Description : What database events can be set? (for DBA
Last Answer : The following events are frequently used by DBAs and Oracle Support to diagnose problems: " 10046 trace name context forever, level 4 Trace SQL statements and show bind variables in trace output. " 10046 ... . On Unix, you can type "oerr ora 10053" from the command prompt to get event details.
Description : What are the different windows events activated at runtimes?
Last Answer : When_window_activated When_window_closed When_window_deactivated When_window_resized Within this triggers, you can examine the built in system variablesystem. event_window to determine the name of the window for which the trigger fired.
Description : What is correlated sub-query ?
Last Answer : Correlated sub query is a sub query which has reference to the main query.
Description : Name the sub-systems of a RDBMS
Last Answer : I/O, Security, Language Processing, Process Control, Storage Management, Logging and Recovery, Distribution Control, Transaction Control, Memory Management, Lock Management
Description : Now that every bank in America has electronic banking services, and you can check your balance with the click of a mouse, does anyone still actually do the whole "check reconciliation" thing?
Last Answer : answer:I have to write several checks a month to the snowplow guy, to most of my home contractors (roofers, guys who installed my new skylights, arborists), the man who mows the lawn of a pocket park ... the occasional month that I get it down to the penny, I can hear my dead father praising me.
Description : My mouse is being recognized by my laptop, but it won't allow me to click on any icons. How do I fix this?
Last Answer : Is it a wireless mouse? If it is put fresh batteries in it.
Description : Is there anyway to use my Mac single click mouse with Vista?
Last Answer : I’m told by my fiends that there sadly is no way. It only has one click…
Description : On Facebook I have seen a lot of things, so why can't we have a mickey mouse face on the front of Facebook page that when you click on it you will see more about Disney fantasy deck plans?
Last Answer : Anything can be shared on social networks. Disney Fantasy Deck Plans would be a great idea on social networks, such as Facebook. It would be great for customers with children.
Description : The wheel located between the two standard buttons on a mouse is used to ________ A. click in Web pages. B. scroll. C. click and select items. D. jump to different Web pages
Last Answer : B. scroll.
Description : What is a program, when installed on a computer, records every keystroke and mouse click? a. Key logger software b. Hardware key logger c. Cookie d. Adware
Last Answer : a. Key logger software
Description : What column differentiates the V$ views to the GV$ views and how?
Last Answer : The INST_ID column which indicates the instance in a RAC environment the information came from.
Description : Can a formula column be obtained through a select statement?
Description : There is a % sign in one field of a column. What will be the query to find it?
Last Answer : '' Should be used before '%'.
Description : To execute row from being displayed that still use column in the row which property can be used?
Last Answer : Format trigger.
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.
Description : SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?
Last Answer : The table has a BLOB column.
Description : What are the roles and user accounts created automatically with the database?
Last Answer : DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary ... administrative information and internal tables and views used by oracle tools are created using this username.
Description : What is a trace file and how is it created ?
Last Answer : Each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information about the error to its trace. This can be used for tuning the database.
Description : Name a tablespace automatically created when you create a database.
Last Answer : The SYSTEM tablespace.
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.