databases Online Quiz - 74
Description: databases Online Quiz - 74 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
What was a problem with navigational data access languages?
Which of the following is an important feature of relational databases and SQL
Which of the following DB2 data types should NOT be used to store double-byte character data?
Which of the following deletion rules on CREATE TABLE will allow parent table rows to be deleted if a dependent row exists?
When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?
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 objects contains control structures that are considered the bound form of SQL statements
Which of the following are types of routine objects?
Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?
Which of the following describes the objects of a DB2 database and their relationships?