ITPub博客

（37）You issued the following command to drop the PRODUCTS table:DROP TABLE products;What is the implication of this command? (Choose all that apply.)A. All data along with the table structure is deleted.B. The pending transaction in the session is committed.C. All indexes on the...

（35）Which two statements are true regarding constraints? (Choose two.)A. A table can have only one primary key and one foreign key.B. A table can have only one primary key but multiple foreign keys.C. Only the primary key can be defined at the column and table levels.D. The foreign ...

（34）You created an ORDERS table with the following description:name              Null           TypeORD_ID       &nb...

（33）You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement:1) The order ID will be unique and cannot have null values.2) The order date cannot have null values and the default should be the current date.3) The order amount s...

（31）Evaluate the following SQL commands:The command to create a table fails. Identify the reason for the SQL statement failure? (Choose all that apply.)A. You cannot use SYSDATE in the condition of a CHECK constraint.B. You cannot use the BETWEEN clause in the condition of a CHECK constra...

（40）View the Exhibit to examine the description for the SALES and PRODUCTS tables. You want to create a SALE_PROD view by executing the following SQL statement:CREATE VIEW sale_prodAS SELECT p.prod_id, cust_id, SUM(quantity_sold) "Quantity" , SUM(prod_list_pric...

（39）Evaluate the following command:CREATE TABLE employees(  employee_id    NUMBER(2) PRIMARY KEY,  last_name       VARCHAR2(25) NOT NULL, &nbsp...

（28）Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. A column with the UNIQUE constraint can contain NULL values.C. A constraint is enforced only for the INSERT operation on a table.D. A constraint can be disabled even ...

（22）You need to create a table for a banking application. One of the columns in the table has the following requirements:1) You want a column in the table to store the duration of the credit period.2) The data in the column should be stored in a format such that it can be easily added and s...

（27）Which two statements are true regarding tables?A. A table name can be of any length.B. A table can have any number of columns.C. A column that has a DEFAULT value cannot store null values.D. A table and a view can have the same name in the same schema.E. A table and a synony...

（24）Examine the structure proposed for the TRANSACTIONS table:Which two statements are true regarding the storage of data in the above table structure? (Choose two.)A. The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.B. The CUST_CREDIT_VALUE column would a...

（23）Examine the structure proposed for the TRANSACTIONS table:Which statements are true regarding the creation and storage of data in the above table structure? (Choose all that apply.)A. The CUST_STATUS column would give an error.B. The TRANS_VALIDITY column would give an error.C. T...

（25）You need to create a table with the following column specifications:1. Employee ID (numeric data type) for each employee2. Employee Name (character data type) that stores the employee name3. Hire date, which stores the date of joining the organization for each employee4. Status ...

（26）Which is the valid CREATE TABLE statement?A. CREATE TABLE emp9$#(emp_no NUMBER (4));B. CREATE TABLE 9emp$#(emp_no NUMBER(4));C. CREATE TABLE emp*123(emp_no NUMBER(4));D. CREATE TABLE emp9$#(emp_no NUMBER(4), date DATE);...

（30）Evaluate the following CREATE TABLE commands:The above command fails when executed. What could be the reason?A. SYSDATE cannot be used with the CHECK constraint.B. The BETWEEN clause cannot be used for the CHECK constraint.C. The CHECK constraint cannot be placed on columns havin...

（29）Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. The column with a UNIQUE constraint can store NULLS .C. A constraint is enforced only for an INSERT operation on a table.D. You can have more than one column in a tab...

（21）Examine the description of the EMP_DETAILS table given below:Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table? (Choose two.)A. An EMP_IMAGE column can be included in the GROUP BY clause.B. An EMP_IMAGE column cannot be included in th...

（24）Examine the structure proposed for the TRANSACTIONS table:Which two statements are true regarding the storage of data in the above table structure? (Choose two.)A. The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.B. The CUST_CREDIT_VALUE column would a...

（29）Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. The column with a UNIQUE constraint can store NULLS .C. A constraint is enforced only for an INSERT operation on a table.D. You can have more than one column in a tab...

（28）Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. A column with the UNIQUE constraint can contain NULL values.C. A constraint is enforced only for the INSERT operation on a table.D. A constraint can be disabled even ...