Give two methods you could use to determine what DDL changes have been made.

Give two methods you could use to determine what DDL
changes have been made.
by

1 Answer

Answer :

You could use Logminer or Streams
by

Related questions

Say two examples of DML, two of DCL and two of DDL

Description : Say two examples of DML, two of DCL and two of DDL

Last Answer : Say two examples of DML, two of DCL and two of DDL

Can you issue DDL in forms?

Description : Can you issue DDL in forms?

Last Answer : yes, but you have to use FORMS_DDL. Referencing allows you to create objects that inherit their functionality and appearance from other objects. Referencing an object is similar to copying an ... values of bind variables can be concatenated into the string before passing the result to FORMS_DDL.

What is DDL Interpreter?

Description : What is DDL Interpreter?

Last Answer : It interprets DDL statements and record them in tables containing metadata.

What is DDL (Data Definition Language)?

Description : What is DDL (Data Definition Language)?

Last Answer : A data base schema is specifies by a set of definitions expressed by a special language called DDL.

How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database with ADO.NET?

Description : How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database with ADO.NET?

Last Answer : You must use a Command object to execute DDL commands. You can set the CommandType property to Text and enter the appropriate DDL command in the CommandText property. Then call Command.ExecuteNonQuery to execute the command.

Give two examples of how you might determine the structure of the table DEPT.

Description : Give two examples of how you might determine the structure of the table DEPT.

Last Answer : Use the describe command or use the dbms_metadata.get_ddl package.

What are the different methods of backing up oracle database ?

Description : What are the different methods of backing up oracle database ?

Last Answer : Logical Backups - Cold Backups - Hot Backups (Archive log)

What are the various methods of performing a calculation in a report ?

Description : What are the various methods of performing a calculation in a report ?

Last Answer : 1. Perform the calculation in the SQL statements itself. 2. Use a calculated / summary column in the data model.

Which of the above methods is the faster method?

Description : Which of the above methods is the faster method?

Last Answer : performing the calculation in the query is faster.

What view would you use to determine free space in a tablespace?

Description : What view would you use to determine free space in a tablespae?

Last Answer : DBA_FREE_SPACE

Write the full forms of the following: (i) DDL (ii) DML -Technology

Description : Write the full forms of the following: (i) DDL (ii) DML -Technology

Last Answer : (i) DDL-Data Definition Language(ii) DML-Data Manipulation Language

Which of the following is/are the DDL statements? A) Create B) Drop C) Alter D) All of the above

Description : Which of the following is/are the DDL statements? A) Create B) Drop C) Alter D) All of the above

Last Answer : D) All of the above

Anything that affects the database schema is a part of A) DML B) DCL C) DDL D) All of the above

Description : Anything that affects the database schema is a part of A) DML B) DCL C) DDL D) All of the above

Last Answer : D) All of the above

The full form of DDL is (A Dynamic Data Language (B) Detailed Data Language (C) Data Definition Language (D) Data Derivation Language

Description : The full form of DDL is (A Dynamic Data Language (B) Detailed Data Language (C) Data Definition Language (D) Data Derivation Language

Last Answer : C) Data Definition Language

The database schema is written in (A) HLL (B) DML (C) DDL (D) DCL

Description : The database schema is written in (A) HLL (B) DML (C) DDL (D) DCL

Last Answer : (C) DDL

DBMS provides the facility of accessing data from a database through (A) DDL (B) DML (C) DBA (D) Schema

Description : DBMS provides the facility of accessing data from a database through (A) DDL (B) DML (C) DBA (D) Schema 

Last Answer : (B) DML

How would you determine who has added a row to a table?

Description : How would you determine who has added a row to a table?

Last Answer : Turn on fine grain auditing for the table.

How would you determine what sessions are connected and what resources they are waiting for?

Description : How would you determine what sessions are connected and what resources they are waiting for?

Last Answer : Use of V$SESSION and V$SESSION_WAIT

How would you determine the time zone under which a database was operating?

Description : How would you determine the time zone under which a database was operating?

Last Answer : select DBTIMEZONE from dual;

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.

Is it possible to link two groups inside a cross products after the cross products group has been created?

Description : Is it possible to link two groups inside a cross products after the cross products group has been created?

Last Answer : no

An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Description : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Last Answer : True

Can a root window be made modal?

Description : Can a root window be made modal?

Last Answer : No

Could you please list down some of common task used during implementation

Description : Could you please list down some of common task used during implementation

Last Answer : Here are few basic and frequently used task 1. Manage Enterprise HCM Information 2. Manage Legal Entity HCM Information 3. Manage Legal Addresses 4. Manage Legal Entity 5. Manage Location ... Lookups 20. Manage Goal Management Notification Settings P.S. Task names are not case-sensitive

Give two examples of referential integrity constraints.

Description : Give two examples of referential integrity constraints.

Last Answer : rential integrity constraints.

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Name the two files that are created when you generate the form give the filex extension ?

Description : Name the two files that are created when you generate the form give the filex extension ?

Last Answer : INP (Source File) FRM (Executable File)

How does one give developers access to trace files (required as input to tkprof)? (for DBA)

Description : How does one give developers access to trace files (required as input to tkprof)? (for DBA)

Last Answer : The "alter session set sql_trace=true" command generates trace files in USER_DUMP_DEST that can be used by developers as input to tkprof. On Unix the default file mask for these files are "rwx r-- -- ... = true Include this in your INIT.ORA file and bounce your database for it to take effect.

Give the stages of instance startup to a usable state where normal users may access it.

Description : Give the stages of instance startup to a usable state where normal users may access it.

Last Answer : STARTUP NOMOUNT - Instance startup STARTUP MOUNT - The database is mounted STARTUP OPEN - The database is opened

Give the reasoning behind using an index.

Description : Give the reasoning behind using an index.

Last Answer : Faster access to data blocks in a table.

Give the structure of the function ?

Description : Give the structure of the function ?

Last Answer : FUNCTION name (argument list .....) Return datatype is local variable declarations Begin executable statements Exception execution handlers End;

Give the structure of the procedure ?

Description : Give the structure of the procedure ?

Last Answer : PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;

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)

Give the Types of modules in a form?

Description : Give the Types of modules in a form?

Last Answer : Form Menu Library

Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Description : Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Last Answer : Page - Canvas-View Page 0 - Canvas-view null.

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

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

Give the sequence of execution of the various report triggers?

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

How can a button be used in a report to give a drill down facility?

Description : How can a button be used in a report to give a drill down facility?

Last Answer : By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.

What are Two methods that scientist use to determine the age of a fossil?

Description : What are Two methods that scientist use to determine the age of a fossil?

Last Answer : Feel Free to Answer

Which of the following methods of physical examination refers to the translation of physical force into sound? a) Percussion Percussion translates the application of physical force into sound. b) Palpation Palpation refers to examination by non-forceful touching. c) Auscultation Auscultation refers to the skill of listening to sounds produced within the body created by movement of air or fluid. d) Manipulation Manipulation refers to the use of the hands to determine motion of a body part.

Description : Which of the following methods of physical examination refers to the translation of physical force into sound? a) Percussion Percussion translates the application of physical force into sound. b) Palpation ... Manipulation refers to the use of the hands to determine motion of a body part.

Last Answer : a) Percussion Percussion translates the application of physical force into sound.

How to Determine the Right Drug Rehab Methods?

Description : How to Determine the Right Drug Rehab Methods?

Last Answer : Drug abusers habitually use drugs for any number of reasons. They sometimes use drug as a way to escape other problems. Drug abusers often suffer from depression, personal issues ... determine the proper treatment for each individual.TreatmentDrug rehabilitation centers exist to help addicts overco

What are the methods used to determine the molecular weight of proteins?

Description : What are the methods used to determine the molecular weight of proteins?

Last Answer : (1) Ultracentrifugation, (2) Gel filtration and (c) PAGE (poly acrylamide gel electrophoresis).

Methods used to determine total budget for advertising its market offerings are A. affordable method B. competitive parity method C. percentage of sales method D. all of above

Description : Methods used to determine total budget for advertising its market offerings are A. affordable method B. competitive parity method C. percentage of sales method D. all of above

Last Answer : D. all of above

In organization of a workshop, the following cognitive objective is primarily included Options: A) To search the solutions for complicated problems B) To discuss the Socio-philosophical aspects of the research C) To determine the research methods D) All of the above

Description : In organization of a workshop, the following cognitive objective is primarily included Options: A) To search the solutions for complicated problems B) To discuss the Socio-philosophical aspects of the research C) To determine the research methods D) All of the above

Last Answer : D) All of the above 

Gross Profit means - (1) Total investment over total saving (2) Changes in methods of production (3) Changes in the form of business organisation (4) Total receipts over total expenditure

Description : Gross Profit means - (1) Total investment over total saving (2) Changes in methods of production (3) Changes in the form of business organisation (4) Total receipts over total expenditure

Last Answer : (4) Total receipts over total expenditure Explanation: In accounting, gross profit or sales profit is the difference between revenue and the cost of making a product or providing a service, before deducting ... . Gross profit = Net sales (total receipts) - Cost of goods sold (total expenditure).

n project financing ,sensitivity analysis is applied because a) almost all the cash flow methods involve uncertainty b) of the need to assess how sensitive the project to changes in input parameters c) what if one or more factors are different from what is predicted d) all the above situation

Description : n project financing ,sensitivity analysis is applied because a) almost all the cash flow methods involve uncertainty b) of the need to assess how sensitive the project to changes in input parameters c) what if one or more factors are different from what is predicted d) all the above situation

Last Answer : d) all the above situation

Gross Profit means (1) Total investment over total saving (2) Changes in methods of production (3) Changes in the form of business organisation (4) Total receipts over total expenditure

Description : Gross Profit means (1) Total investment over total saving (2) Changes in methods of production (3) Changes in the form of business organisation (4) Total receipts over total expenditure

Last Answer : Total receipts over total expenditure

Could the changes that Microsoft made from Windows Vista to Windows 7 have been released as a service pack?

Description : Could the changes that Microsoft made from Windows Vista to Windows 7 have been released as a service pack?

Last Answer : answer:Yes I believe that to be the case. Fact of the matter is if you take a look under the hood of both operating systems they look and perform almost the exact same, also Windows 7 breaks ... bad. There are now a few bugs rearing their ugly heads with Windows 7 and it's wireless connection

When the continuing auditor intends to use information about the entity and its environment obtained in prior periods, the auditor shoulda. Assess control risk as "high" for theassertions affected by the prior-periodinformation.b. Seek permission with the client in usingthe prior period information obtained bythe auditor.c. Determine whether changes haveoccurred that may affect therelevance of such information in thecurrent audit.d. Determine whether to equitably reducethe audit fee due to lower audit effortexpended during the engagement

Description : When the continuing auditor intends to use information about the entity and its environment obtained in prior periods, the auditor should a. Assess control risk as "high" for the assertions ... whether to equitably reduce the audit fee due to lower audit effort expended during the engagement

Last Answer : Determine whether changes have occurred that may affect the relevance of such information in the current audit.