• databases Online Quiz - 79
Back
0

databases Online Quiz - 79

Description: databases Online Quiz - 79
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which of the following is the major difference between relational data and XML data?

technology databases

  1. A. Relational data is self-describing; XML data is not

  2. B. Relational data has inherent ordering; XML data does not

  3. C. Relational data must be tabular; XML data does not have to be tabular

  4. D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates

Show answer
Correct Option: C

Which of the following is the major difference between relational data and XML data?
technology databases

  1. A. Relational data is self-describing; XML data is not

  2. B. Relational data has inherent ordering; XML data does not

  3. C. Relational data must be tabular; XML data does not have to be tabular

  4. D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates

Show answer
Correct Option: C

Which of the following products is allowed to access other DB2 servers, but cannot accept requests from other remote clients?
technology databases

  1. DB2 Personal Edition

  2. DB2 Workgroup Server Edition

  3. DB2 Enterprise Server Edition

  4. DB2 Data Warehouse Edition

Show answer
Correct Option: B

A client application on z/OS must access a DB2 database on a Solaris Server. At a minimum, which of the following products must be installed on the Solaris workstation?

technology databases

  1. DB2 Connect Enterprise Edition

  2. DB2 Workgroup Server Edition

  3. DB2 Workgroup Server Edition and DB2 Connect Enterprise Edition

  4. DB2 Enterprise Server Edition and DB2 Connect Enterprise Edition

Show answer
Correct Option: C

Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?
technology databases

  1. DB2 Enterprise Server Edition

  2. DB2 Personal Developer's Edition

  3. DB2 Universal Developer's Edition

  4. DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition

Show answer
Correct Option: C

Which of the following tools can be used to catalog a database?

technology databases

  1. Visual Explain

  2. Alert Center

  3. Journal

  4. Configuration Assistant

Show answer
Correct Option: A

Which of the following is used to create and debug user-defined functions?

technology databases

  1. SQL Assist

  2. Control Center

  3. Command Editor

  4. Developer Workbench

Show answer
Correct Option: D

Which of the following DB tools allow the user to execute an SQL statement and view a graphical representation of the access plan?

technology databases

  1. Task Center

  2. Command Editor

  3. Developer Workbench

  4. Command Line Processor

Show answer
Correct Option: B

AI Explanation

To answer this question, you need to understand the different DB tools and their functionalities. Let's go through each option to understand why it is correct or incorrect:

Option A) Task Center - Task Center is a tool used for managing and scheduling database tasks. It does not provide the functionality to execute SQL statements or view graphical representations of access plans. Therefore, this option is incorrect.

Option B) Command Editor - The Command Editor is a tool that allows users to execute SQL statements and view a graphical representation of the access plan. This tool is commonly used in database management systems (DBMS) to interact with the database. Therefore, this option is correct.

Option C) Developer Workbench - Developer Workbench is a tool that provides a graphical interface for developers to design, develop, and manage databases. However, it does not specifically mention the capability to execute SQL statements or view graphical representations of access plans. Therefore, this option is incorrect.

Option D) Command Line Processor - The Command Line Processor is a tool that allows users to execute SQL statements via a command-line interface. It does not provide a graphical representation of the access plan. Therefore, this option is incorrect.

The correct answer is Option B) Command Editor. This option is correct because it allows the user to execute an SQL statement and view a graphical representation of the access plan.

For which of the following is a data warehouse optimized?
technology databases

  1. Backup and Recovery

  2. Transactions

  3. Security

  4. Queries

Show answer
Correct Option: D

Which of the following is a typical data warehouse query?

technology databases

  1. What is this customer’s address?

  2. Does this customer have any unpaid bills?

  3. What is the balance in this customer’s account?

  4. What is the total sales for each of the last 6 months?

Show answer
Correct Option: D

Which of the following best describes the age of the data in an OLTP system?
technology databases

  1. Current

  2. Projected

  3. Historical

  4. Current and Projected

Show answer
Correct Option: A

) Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?

technology databases

  1. Design Advisor

  2. Visual Explain

  3. Performance Advisor

  4. Configuration Assistant

Show answer
Correct Option: A

Which of the following is NOT a valid method of authentication that can be used by DB2 9?

technology databases

  1. SERVER

  2. SERVER_ENCRYPT

  3. CLIENT

  4. DCS

Show answer
Correct Option: D

A table named DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER AVG_SALARY Which of the following is the best way to prevent most users from viewing AVG_SALARY data?
technology databases

  1. Encrypt the table's data

  2. Create a view that does not contain the AVG_SALARY column

  3. Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data

  4. Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users

Show answer
Correct Option: B

Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2?
technology databases

  1. CREATEIN privilege on the database

  2. REFERENCES privilege on TAB1 and TAB2

  3. CREATE_TAB privilege on the database

  4. SELECT privilege on TAB1 and TAB2

Show answer
Correct Option: D

After the following SQL statement is executed: GRANT ALL PRIVILEGES ON TABLE employee TO USER user1 Assuming user USER1 has no other authorities or privileges, which of the following actions is USER1 allowed to perform?

technology databases

  1. Drop an index on the EMPLOYEE table

  2. Grant all privileges on the EMPLOYEE table to other users

  3. Alter the table definition

  4. Drop the EMPLOYEE table

Show answer
Correct Option: C

A user wishing to invoke an SQL stored procedure that queries a table must have which of the following privileges?

technology databases

  1. CALL privilege on the procedure; SELECT privilege on the table

  2. CALL privilege on the procedure; REFERENCES privilege on the table

  3. EXECUTE privilege on the procedure; SELECT privilege on the table

  4. EXECUTE privilege on the procedure; REFERENCES privilege on the table

Show answer
Correct Option: C

User USER1 wants to utilize an alias to remove rows from a table. Assuming USER1 has no authorities or privileges, which of the following privileges are needed?
technology databases

  1. DELETE privilege on the table

  2. DELETE privilege on the alias

  3. DELETE privilege on the alias; REFERENCES privilege on the table

  4. REFERENCES privilege on the alias; DELETE privilege on the table

Show answer
Correct Option: A

Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?
technology databases

  1. REVOKE CONNECT ON DATABASE FROM user2

  2. REVOKE CREATETAB ON DATABASE FROM user2

  3. REVOKE BIND ON DATABASE FROM user2

  4. REVOKE BINDADD ON DATABASE FROM user2

Show answer
Correct Option: D

Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform DML, but no other operations on table TABLE1?
technology databases

  1. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO user1 AND group1

  2. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1

  3. GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 TO USER user1, GROUP group1

  4. GRANT CONTROL ON TABLE table1 TO user1 AND group1

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions