Database Systems – Section 2

26. In SQL, the CREATE VIEW command is used

A. to recompile view
B. to define a view of one or more tables or views
C. to recompile a table
D. to create a trigger
E. None of the above

Correct Answer: B. to define a view of one or more tables or views
Advertisement

27. A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

A. File structure
B. Records
C. Fields
D. Database
E. None of the above

Correct Answer: C. Fields
Advertisement

28. In the DBM approach, application programs perform the

A. storage function
B. processing functions
C. access control
D. All of the above
E. None of the above

Correct Answer: B. processing functions
Advertisement

29. In SQL, which command is used to create a database user?

A. ADD USER TO DATABASE
B. MK USER
C. CREATE USER
D. All of the above
E. None of the above

Correct Answer: C. CREATE USER
Advertisement

30. When performing a look-up operation using a form

A. you enter the search value into the form
B. you look at each form sequentially until you see the one you want
C. you type the key in an entry line, and the correct form is displayed
D. All of the above
E. None of the above

Correct Answer: A. you enter the search value into the form
Advertisement

Leave A Comment?