Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
- 0 Answers
- 642 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is primary key and unique key?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
explain advantages of myisam over innodb? : Sql dba
How do I count records in sql?
what is the bond code in materialized view?
How do I edit a trigger in sql developer?
Explain table and field in sql?
How can you view the errors encountered in a trigger?
Which join condition can be specified using on clause?
What is the use of sqlerrd 3?
what is the use of double ampersand (&&) in sql queries?
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
