In your production database, data manipulation language (DML) operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users, actions taken, and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information. What action would you take to achieve this task()
A: Apply fine-grained auditing.
B: Implement value-based auditing.
C: Impose standard database auditing to auditobject privileges.
D: Impose standard databaseauditing to audit SQL statements.
A: Apply fine-grained auditing.
B: Implement value-based auditing.
C: Impose standard database auditing to auditobject privileges.
D: Impose standard databaseauditing to audit SQL statements.
举一反三
- While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: a) high availability of data b) faster primary key access to the table data c) compact storage for the table Which type of tables would you use to achieve these objectives?() A: heap tables B: object tables C: partitioned tables D: indexorganized tables (IOTs)
- While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: a) high availability of data b) faster primary key access to the table data c) compact storage for the table Which type of tables would you use to achieve these objectives?() A: Aheap tables B: Bobject tables C: Cpartitioned tables D: Dindexorganized tables (IOTs)
- Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called: A: defragmentation. B: data scrubbing. C: data auditing. D: data optimization.
- The main functions of the database management system are () A: database maintenance B: data calculation C: data manipulation D: data definition
- You want to create a copy of the DEPARTMENTS table. When that is complete, you want to truncate the new DEPARTMENTS table, then restore the data with a direct-load insert from the old DEPARTMENTS table. Which CREATE statement should you use?() A: A B: B C: C D: D