The results are not sorted.
The results are sorted numerically.
The results are sorted alphabetically.
The results are sorted numerically and then alphabetically.
第1题:
Examine the SQL statement that creates ORDERS table:CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN (‘CREDIT‘, ‘CASH‘)), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date));For which columns would an index be automatically created when you execute the above SQL statement? ()
A. SER_NO
B. ORDER_ID
C. STATUS
D. PROD_ID
E. ORD_TOTAL
F. composite index on ORDER_ID and ORDER_DATE
第2题:
Make a function to print an HTML table of r rows and c cols; fill the cells with up to n consecutive
numbers (if n is greater than the produce of r and c, discard the rest). Ensure that all rows have the
same number of columns.
第3题:
In which of the following situations should correlation names be used?()
第4题:
Evaluate the CREATE TABLE statement: CREATE TABLE products (product_id NUMBER (6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2 (15)); Which statement is true regarding the PROD_ID_PK constraint?()
第5题:
Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? ()
第6题:
displaying the minimum list price for each product status
displaying all supplier IDs whose average list price is more than 500
displaying the number of products whose list prices are more than the average list price
displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable
displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
第7题:
Column definitions cannot be altered to add DEFAULT values.
A change to the DEFAULT value affects only subsequent insertions to the table.
Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.
All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
第8题:
SER_NO
ORDER_ID
STATUS
PROD_ID
ORD_TOTAL
Composite index on ORDER_ID and ORDER_DATE
第9题:
It executes successfully but partition pruning cannot happen for this partition key.
It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
第10题:
Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
第11题:
SER_NO
ORDER_ID
STATUS
PROD_ID
ORD_TOTAL
composite index on ORDER_ID and ORDER_DATE
第12题:
CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);
第13题:
The STUDENT_GRADES table has these columns:The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?()
A.
B.
C.
D.
E.
F.
第14题:
The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMBER(9,2)HIRE_DATE DATEYou query the database with this SQL statement:SELECT empname,hire_date HIREDATE, salaryFROM EMPORDER BY hire_date;How will the results be sorted?()
A.randomly
B.ascending by date
C.descending by date
D.ascending alphabetically
E.descending alphabetically
第15题:
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?()
第16题:
The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?()
第17题:
randomly
ascending by date
descending by date
ascending alphabetically
descending alphabetically
第18题:
Each extra column in the copy with more columns must not have a default value
Columns that are common to both versions of the table must be defined in the same order on the master and the slave
The slave database cannot have more columns than the master. Only the master database can have more columns
Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
第19题:
randomly
ascending by date
descending by date
ascending alphabetically
descending alphabetically
第20题:
Column definitions cannot be altered to add DEFAULT values.
A change to the DEFAULT value affects only subsequent insertions to the table.
Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.
All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
第21题:
SER_NO
ORDER_ID
STATUS
PROD_ID
ORD_TOTAL
composite index on ORDER_ID and ORDER_DATE
第22题:
It would be created only if a unique index is manually created first.
It would be created and would use an automatically created unique index.
It would be created and would use an automatically created nonunique index.
It would be created and remains in a disabled state because no index is specified in the command.
第23题:
SELECT last_name, 12*salary* commission_pct FROM emp;
SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;