databases Online Quiz - 73
Description: databases Online Quiz - 73 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which of the following database objects is considered executable using SQL?
In which of the following scenarios would a stored procedure be beneficial?
Given the following DDL for the PARTS table: CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9)); All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?
What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?
Which of the following will DELETE all of the rows from table T03?
Which of the following can NOT be done using the ALTER TABLE statement?
Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?
A sequence was created with the DDL statement shown below: CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar What is the current value of the :con1hvar host variable?
Which of the following is not true about XML Columns ?
An application needs to store a 5MB JPEG image in a DB2 table. Which datatype should be used to specify a column that will be used for storing A image ?
Which of the following constraint types can be used to ensure the value Of an INTEGER column references only positive values.