If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?

If an unique key constraint on DATE column is created,
will it validate the rows that are inserted with SYSDATE ?
by

1 Answer

Answer :

It won't, Because SYSDATE format contains time attached with it.
by

Related questions

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

Description : What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

Last Answer : A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls.

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

Description : What are the Referential actions supported by FOREIGN KEY integrity constraint ?

Last Answer : UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

Write any one similarity and one difference between primary key and unique Constraint. -Technology

Description : Write any one similarity and one difference between primary key and unique Constraint. -Technology

Last Answer : Similarity: Column with both the constraints will only take unique values.Difference: Column with Primary key constraints will not be able to hold NULL values while Column with Unique constraints will be able to hold NULL values.

Write any one similarity and one difference between primary key and unique Constraint -Technology

Description : Write any one similarity and one difference between primary key and unique Constraint -Technology

Last Answer : Similarity: Column with both the constraints will only take unique values.Difference: Column with Primary key constraints will not be able to hold NULL values while Column with Unique constraints will be able to hold NULL values.

What is difference between UNIQUE constraint and PRIMARY KEY constraint?

Description : What is difference between UNIQUE constraint and PRIMARY KEY constraint?

Last Answer : A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can’t contain Nulls. 47.What is Index Cluster? – A Cluster with an index on the Cluster Key 48.When does a Transaction end? – When it is committed or Rollbacked.

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

What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

Description : What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

Last Answer : On-validate-field trigger fires, when the field Validation status New or changed. Post-field-trigger whenever the control leaving form the field, it will fire.

What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

Description : What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

Last Answer : When you changes the Existing value to null, the On-validate field trigger will fire post change trigger will not fire. At the time of execute- query post-change trigger will fire, on-validate field trigger will not fire.

In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: (A) Referential integrity (B) Multi-valued dependency (C) Entity Integrity (D) Functional dependency

Description : In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: (A) Referential integrity (B) Multi-valued dependency (C) Entity Integrity (D) Functional dependency

Last Answer : (C) Entity Integrity

What is the difference between candidate key, unique key and primary key

Description : What is the difference between candidate key, unique key and primary key

Last Answer : Candidate keys are the columns in the table that could be the primary keys and the primary key is the key that has been selected to identify the rows. Unique key is also useful for identifying the distinct rows in the table.)

What is difference between UNIQUE and PRIMARY KEY constraints?

Description : What is difference between UNIQUE and PRIMARY KEY constraints?

Last Answer : A table can have only one PRIMARY KEY whereas there can be any number of UNIQUE keys. The columns that compose PK are automatically define NOT NULL, whereas a column that compose a UNIQUE is not automatically defined to be mandatory must also specify the column is NOT NULL.

Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

Description : Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

Last Answer : (b) Key is a data item that allows you to uniquely identify individual occurrences which is defined as the column or set of columns.

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

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

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Last Answer : By dragging the column outside the group.

What is an Integrity Constraint ?

Description : What is an Integrity Constraint ?

Last Answer : Integrity constraint is a rule that restricts values to a column in a table.

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.

An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?

Description : An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?

Last Answer : No.

Deleting the Duplicate rows in the table

Description : Deleting the Duplicate rows in the table

Last Answer : We can delete the duplicate rows in the table by using the Rowid

How do you find the numbert of rows in a Table ?

Description : How do you find the numbert of rows in a Table ?

Last Answer : A bad answer is count them (SELECT COUNT(*) FROM table_name) A good answer is :- 'By generating SQL to ANALYZE TABLE table_name COUNT STATISTICS by querying Oracle System Catalogues (e.g ... utility which Oracle released which makes it unnecessary to do ANALYZE TABLE for each Table individually.

How will you delete duplicating rows from a base table?

Description : How will you delete duplicating rows from a base table?

Last Answer : delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); or delete duplicate_values_field_name dv from table_name ta where rowid

What is the built-in routine used to count the no of rows in a group?

Description : What is the built-in routine used to count the no of rows in a group?

Last Answer : Get_group _row_count System Variables

What is the use of ROWS option in IMP command ?

Description : What is the use of ROWS option in IMP command ?

Last Answer : A flag to indicate whether rows should be imported. If this is set to 'N' then only DDL for database objects will be executed.

What is the use of ROWS option in EXP command ?

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

Last Answer : Flag to indicate whether export should compress fragmented segments into single extents.

Which parameter in Storage clause will reduce no. of rows per block?

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

What are built-ins used for Processing rows?

Description : What are built-ins used for Processing rows?

Last Answer : GET_GROUP_ROW_COUNT(function) GET_GROUP_SELECTION_COUNT(function) GET_GROUP_SELECTION(function) RESET_GROUP_SELECTION(procedure) SET_GROUP_SELECTION(procedure) UNSET_GROUP_SELECTION(procedure)

What are the built-ins used for processing rows?

Description : What are the built-ins used for processing rows?

Last Answer : Get_group_row_count(function) Get_group_selection_count(function) Get_group_selection(function) Reset_group_selection(procedure) Set_group_selection(procedure) Unset_group_selection(procedure)

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.

. An important aim of a post-project review is to: a. validate overall progress to date against the budget and schedule. b. capture learning and document it for future usage. c. ensure acceptance of all permanent documentation, signed by the sponsor. d. establish that project benefits have been identified.

Description : . An important aim of a post-project review is to: a. validate overall progress to date against the budget and schedule. b. capture learning and document it for future usage. c. ... of all permanent documentation, signed by the sponsor. d. establish that project benefits have been identified.

Last Answer : b. capture learning and document it for future usage.

An important aim of a post-project review is to: a. validate overall progress to date against the budget and schedule. b. capture learning and document it for future usage. c. ensure acceptance of all permanent documentation, signed by the sponsor. d. establish that project benefits have been identified

Description : An important aim of a post-project review is to:  a. validate overall progress to date against the budget and schedule.  b. capture learning and document it for future usage.  c. ... of all permanent documentation, signed by the sponsor.  d. establish that project benefits have been identified

Last Answer : b. capture learning and document it for future usage.

What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Description : What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Last Answer : b) A 2 dimensional column chart

What are the key components in the "Triple constraint Triangle"? A. Scope, Schedule, Cost, Project Manager B. Scope, Time, Cost, Project (Ans.)C. Time, Money, Scope, Project D. Project Manager, Time, Scope, Money

Description : What are the key components in the "Triple constraint Triangle"?  A. Scope, Schedule, Cost, Project Manager B. Scope, Time, Cost, Project (Ans.) C. Time, Money, Scope, Project D. Project Manager, Time, Scope, Money

Last Answer : B. Scope, Time, Cost, Project (Ans.)

What are the Referential actions supported by FOREIGN KEY integrity constraint?

Description : What are the Referential actions supported by FOREIGN KEY integrity constraint?

Last Answer : UPDATE and DELETE Restrict – A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade – When a referenced row is deleted all associated dependent rows are deleted.

Drop Table cannot be used to drop a table referenced by a …………… constraint. A) Local Key B) Primary Key C) Composite Key D) Foreign Key

Description : Drop Table cannot be used to drop a table referenced by a …………… constraint. A) Local Key B) Primary Key C) Composite Key D) Foreign Key

Last Answer : D) Foreign Key

Drop Table cannot be used to drop a Table referenced by .................. constraint. (a) Primary key (b) Sub key (c) Super key (d) Foreign key (A) (a) (B) (a), (b) and (c) (C) (d) (D) (a) and (d)

Description : Drop Table cannot be used to drop a Table referenced by .................. constraint. (a) Primary key (b) Sub key (c) Super key (d) Foreign key (A) (a) (B) (a), (b) and (c) (C) (d) (D) (a) and (d)

Last Answer : (C) (d)

…………….. is used to determine whether of a table contains duplicate rows. A) Unique predicate B) Like Predicate C) Null predicate D) In predicate

Description : …………….. is used to determine whether of a table contains duplicate rows. A) Unique predicate B) Like Predicate C) Null predicate D) In predicate

Last Answer : A) Unique predicate

What is mean by Extra key inserted at the end of Array?

Description : What is mean by Extra key inserted at the end of Array?

Last Answer : It means the array has a sentinel to mark the end of the array.Any elements that follow the sentinel element are deemed invalid.Sentinels are usually denoted with a special value that is not usedby ... strings arean example, where the NULL character (ASCII code 0) marks the endof a character array.

What is mean by Extra key inserted at the end of Array?

Description : What is mean by Extra key inserted at the end of Array?

Last Answer : It means the array has a sentinel to mark the end of the array.Any elements that follow the sentinel element are deemed invalid.Sentinels are usually denoted with a special value that is not usedby ... strings arean example, where the NULL character (ASCII code 0) marks the endof a character array.

What column differentiates the V$ views to the GV$ views and how?

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.

Can a formula column be obtained through a select statement?

Description : Can a formula column be obtained through a select statement?

Last Answer : Yes

Can a formula column referred to columns in higher group?

Description : Can a formula column referred to columns in higher group?

Last Answer : Yes

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 : 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?

Last Answer : Yes

There is a % sign in one field of a column. What will be the query to find it?

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 '%'.

Write the order of precedence for validation of a column in a table ?

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.?

What is the use of hidden column? What are the various sub events a mouse double click event involves?

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.

What is the use of place holder column? What are the various sub events a mouse double click event involves?

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.

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.

If a break order is set on a column would it affect columns which are under the column?

Description : If a break order is set on a column would it affect columns which are under the column?

Last Answer : No

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.