databases Online Quiz - 74
|Description: databases Online Quiz - 74|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which of the following is an important consideration when tuning an SQL statement
Which of the following database design features is most important to SQL performance?
Which of the following CANNOT be used to restrict specific values from being inserted into a column in a particular table?
While attempting to connect to a database stored on an iSeries server from a Windows client, the following message was displayed: SQL1013N The database alias name or database name "TEST_DB" could not be found. Which of the following actions can be used to help determine why this message was displayed?
The following SQL statements were executed in sequence: CREATE DISTINCT TYPE salary AS decimal(7,2) WITH COMPARISONS; CREATE TABLE staffsalary(empid INT, empsalary salary); INSERT INTO staffsalary VALUES (10, 50000), (20, 50000.00); UPDATE staffsalary SET empsalary = 60000 WHERE salary(50000) = empsalary; What is the current content of the staffsalary table?
Which of the following provides a logical grouping of database objects?
Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?
Which of the following are types of routine objects?
Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?
Which of the following describes the objects of a DB2 database and their relationships?