Which object is a stored procedure defined into?
Which object is a stored procedure defined into? A. Table B. Schema C. Package D. Database
Which object is a stored procedure defined into? A. Table B. Schema C. Package D. Database
Which clause should be included in a ALTER TABLE statement to update a table definition with a new column? A. ADD COLUMN B. ALTER COLUMN C. APPEND COLUMN D. RENAME COLUMN
Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used? A. ALTER TABLE sales ADD COLUMN item CHAR(40); B. ALTER TABLE…
If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database? A. 4 B. 8 C. 16 D. 32