questions

A. A way to establish an IF-THEN-ELSE in SQL.
B. A way to establish a loop in SQL.
C. All of the above.
D. A way to establish a data definition in SQL.
A. Equi-join
B. Outer join
C. All of the above.
D. Natural join
A. Subqueries
B. Natural join
C. All of the above
D. Union Join
A. You do not create them with SQL.
B. They are the same thing as a function.
C. They do not need to have a unique name.
D. They include procedural and SQL statements.
A. RDBMS store database definition information in system-created tables.
B. This information often cannot be updated by a user.
C. All of the above.
D. This information can be accessed using SQL.
A. They have an event, condition, and action.
B. They execute against only some applications that access a database.
C. They cannot cascade (cause another trigger to fire).
D. You do not create them with SQL.
A. Combines the output from no more than two queries and must include the same number of columns.
B. Combines the output from no more than two queries and does not include the same number of columns.
C. Combines the output from multiple queries and must include the same number of columns.
D. Combines the output from multiple queries and does not include the same number of columns.
A. Hard-coded SQL statements in a program language such as Jav
B. The process of making an application capable of generating specific SQL code on the fly.
C. Hard-coded SQL statements in a procedure.
D. Hard-coded SQL statements in a trigger.
A. Two
B. one
C. All of the above
D. Three
A. Outer join
B. Natural join
C. All of the above.
D. Equi-join
A. The before-image of a record
B. The essential data of the record
C. The after-image of a record
D. The after-image of a record
A. Data becoming lost or inaccurate
B. Planned database maintenance activities
C. All of the above.
D. The database server
A. Limiting particular areas within a building to only authorized people
B. Authentication policies
C. All of the above.
D. Ensure appropriate responses rates are in external maintenance agreements
A. Rollback
B. Reprocess transactions
C. Switch to duplicate database
D. Rollforward
A. Both consist of procedural code.
B. Both are stored in the database.
C. Both run automatically.
D. Both have to be called to operate.
A. Involves the use of an inner and outer query.
B. Does not start with the word SELECT.
C. All of the above.
D. Cannot return the same result as a query that is not a subquery.Cannot return the same result as a query that is not a subquery.
A. The typical roles of a database administrator and redesigning existing applications
B. The typical roles of a data administrator and redesigning existing applications
C. The time to make a decision and the typical roles of a database administrator
D. The time to make a decision but not the typical roles of a database administrator
A. Read
B. Update
C. Insert
D. Delete
A. Tune database performance
B. Protect the security of the database.
C. Resolve data ownership issues
D. Establish backup and recovery procedures