先試後買

A. Insert statements can always be done on a table through a view.

B. The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

C. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the columns are not referenced in the defining query of the view.
PRIMARY KEY

D. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains aggregating functions.

E. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

F. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

A. They can be used in SELECT, WHERE, and ORDER BY clauses.

B. The data type returned, can be different from the data type of the argument that is referenced.

C. They can be nested up to only two levels.

D. They can return multiple values of more than one data type.

E. They can accept only one argument.

F. They can accept column names, expressions, variable names, or a user-supplied constants as arguments.

A. SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, `e')IS NOT NULL AND
SUBSTR(cust_first_name, 1, -2)='a';

B. SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, `e')<>0 AND
SUBSTR(cust_first_name, LENGTH(cust_first_name), -2)='a';

C. SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, `e')<>0 AND
SUBSTR(cust_first_name, -2, 1)='a';

D. SELECT cust_first_name
FROM customers
WHERE INSTR(cust_first_name, `e')<>'' AND
SUBSTR(cust_first_name, -2, 1)='a';

A. SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES;

B. SELECT prod_ id, cust_id, amount_sold
FROM sales
ORDER BY araount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;

C. SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount__sold
FETCH FIRST 5 PERCENT ROWS ONLY;

D. SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;

A. FLOOR returns the largest positive integer less than or equal to a specified number.

B. CONCAT joins two or more character strings together.

C. INSTR finds the offset within a character string, starting from position 0.

D. INSTR finds the offset within a string of a single character only.

E. FLOOR returns the largest integer less than or equal to a specified number.

F. CONCAT joins two character strings together.

A. SELECT SYSDATE - TO_DATE('01/JANUARY/2007') FROM DUAL;

B. SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY')-'01-JAN-2007' FROM DUAL;

C. SELECT TO_DATE(SYSDATE,'DD/MONTH/YYYY')-'01/JANUARY/2007' FROM DUAL;

D. SELECT SYSDATE - '01-JAN-2007' FROM DUAL

E. SELECT SYSDATE - TO_DATE('01-JANUARY-2007') FROM DUAL

A. When you terminate your session, the row will be deleted.

B. To drop the table in this session, you must first truncate it.

C. You can add a foreign key to the table.

D. You can add a column to the table in this session.

E. Other sessions can view the committed row.

A. Both the query and the subquery can select only zero rows or one row.

B. Both the query and the subquery can select any number of rows.

C. The query can select any number of rows, but the subquery can select only zero rows or one row.

D. The query can select only zero rows or one row, but the subquery can select any number of rows.

A. It can be used for system and object privileges.

B. The grantee can grant the object privilege to any user in the database, with or without including this option.

C. It cannot be used to pass on privileges to PUBLIC by the grantee.

D. The grantee must have the GRANT ANY OBJECT PRIVILEGE system privilege to use this option.

E. It can be used when granting privileges to roles.

F. It can be used to pass on privileges to other users by the grantee.

A. starting up a database instance

B. querying data from tables across databases

C. connecting to a database instance

D. executing operating system (OS) commands in a session

E. changing the password for an existing database

A. INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE('SYSDATE+10'))

B. INSERT INTO transaction (trn_id, end_date) VALUES ('A1', '10-DEC-2014')

C. INSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE(DEFAULT+10))

D. INSERT INTO transaction (trn_id, start_date, end_date) VALUES ('A1', , '10-DEC-2014')

A. Sequences used in the employees table become invalid.

B. The employees table is moved to the recycle bin.

C. The space used by the employees table is reclaimed immediately.

D. The employees table can be recovered using the rollback command.

E. All uncommitted transactions are committed.

F. All indexes and constraints defined on the table being dropped are also dropped.