58. Is it possible to Enable or Disable a Database trigger ? a. Yes b. No Ans : A 59. PL/SQL supports datatype(s) a. Scalar datatype b. Composite…

1. SNAPSHOT is used for a. Synonym, b. Table space, c. System server, d. Dynamic data replication   Ans : D 2. We can create SNAPSHOTLOG for a.…

Normalization is a method for organizing data elements in a database into tables. Normalization Avoids   Duplication of Data   – The same data is lis…

Solution. create_structure.sql --------------------------------- STEP 1 --------------------------------- -- Campus CREATE TABLE Campus (     Cam…

In this assignment, build a sample database and create tables in Oracle. Then add sample data and create several queries and a report.  Activities: …