Free CIW 1D0-541 Exam Dumps Questions & Answers

What is the most important service provided by a database management system?

• A.  Translates procedural commands into non-procedural commands
• B.  Provides support for a data manipulation language
• C.  Allows users to store data in a distributed data repository
• D.  Provides support for data formatting language commands

Several SQL operations are performed by User 1 to access the Fee information for Bowling in the Act_Fee relation (shown in the exhibit). The first access returns a fee of 50. An unrelated SQL operation by another user updates the Bowling fee to 60. The second access by User 1 returns a fee of 60. What problem has occurred?

• A.  Rollback
• B.  Dirty read
• C.  Deadlock
• D.  No problem has occurred.

What is a data dictionary?

• A.  Metadata that is stored in tables and is only accessible by the DBMS
• B.  An area of the database that is directly accessible by the user
• C.  A system catalog containing user data
• D.  Data that is stored in tables and is only accessible by the DBMS

Consider the following relational algebraic expression as well as the Employee and Department relations shown in the exhibit: Which of the following relations would result from the given relational algebraic expression?

• A.  B
• B.  D
• C.  A
• D.  C

Which of the following best describes the two-tier database architecture?

• A.  The user accesses a database server using a terminal.
• B.  The user interface and data-processing logic are performed by the client whereas the server handles database access and data validation functions.
• C.  The user interface, data-processing logic, database access and data validation functions are performed on a mainframe server.
• D.  The user interface and data validation functions are performed by the client whereas the data-processing logic is performed on a server.