-
You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）
A . It is created as a nondisplay item.
B . The Lock Record property is set to Yes.
C . It cannot be referenced in item level triggers.
D . It is placed on the canvas with the highest sequence number.
-
Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?（）
A . The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
B . The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
C . Referential integrity constraint cannot be set on the invisible column.
D . The invisible column cannot be made visible and can only be marked as unused.
E . A primary key constraint can be added on the invisible column.
-
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）
A . You cannot roll back this statement.
B . All pending transactions are committed.
C . All views based on the DEPT table are deleted.
D . All indexes based on the DEPT table are dropped.
E . All data in the table is deleted, and the table structure is also deleted.
F . All data in the table is deleted, but the structure of the table is retained.
G . All synonyms based on the DEPT table are deleted.
-
Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）
A . The DESCRIBE DEPT statement displays the structure of the DEPT table.
B . The ROLLBACK statement frees the storage space occupies by the DEPT table.
C . The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D . The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
-
You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）
A . The Query Only property is set to Yes.
B . The Conceal Data property is set to Yes.
C . The Insert Allowed property is set to Yes.
D . The Update Allowed property is set to Yes.
-
Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）
A . SRW.BREAK
B . SRW.SET_ALTER
C . SRW.REFERENCE
D . SRW.DO_SQL
E . SRW.RUN_REPORT
F . SRW.SET_FIELD
-
Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）
A . The DESCRIBE DEPT statement displays the structure of the DEPT table.
B . The ROLLBACK statement frees the storage space occupied by the DEPT table.
C . The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D . The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
-
Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）
A . A CHECK constraint is created on the OID column.
B . A NOT NULL constraint is created on the OID column.
C . The ORDERS table is the only object created in the USERS tablespace.
D . The ORDERS table and a unique index are created in the USERS tablespace.
E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
-
Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? （）
A . It releases the storage space used by the table.
B . It does not release the storage space used by the table.
C . You can roll back the deletion of rows after the statement executes.
D . You can NOT roll back the deletion of rows after the statement executes.
E . An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F . You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
-
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
A . FORMS_DDL
B . DO_SQL
C . FORM_SUCCESS
D . FORM_NOT_SUCCESS
E . DBMS.ERROR_CODE
-
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）
A . Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B . Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C . Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D . Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E . Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
-
You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
A . table
B . transactional trigger
C . stored procedure
D . FROM clause query
-
You need to create a partitioned table to store historical data and you issued the following command:
https://assets.asklib.com/images/image2/2018080209263145770.jpg
What is the outcome of the above command?（）
A . It returns an error because the range partitions P1 and P2 should be of the same range.
B . It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
C . It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each.
D . It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.
-
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）
A . REFERENCES
B . SELECT
C . UPDATE
D . ALTER
-
Evaluate the following command： SQL> CREATE TABLE design_data （id NUMBER， doc CLOB） LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）； Which statement is true regarding the above command？（）
A . The LOB values are automatically compressed.
B . The LOB values are cached by default in the buffer cache.
C . The LOB values are automatically stored in encrypted mode.
D . All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
-
CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set? （）
A . The DESCRIBE DEPT statement displays the structure of the DEPT table.
B . The ROLLBACK statement frees the storage space occupies by the DEPT table.
C . The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D . The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
-
Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）
A . A CHECK constraint is created on the OID column.
B . A NOT NULL constraint is created on the OID column.
C . The ORDERS table is the only object created in the USERS tablespace.
D . The ORDERS table and a unique index are created in the USERS tablespace.
E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
-
The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement? （）
A . The results are not sorted.
B . The results are sorted numerically.
C . The results are sorted alphabetically.
D . The results are sorted numerically and then alphabetically.
-
The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）
A . CREATE SYNONYM ord FOR orders; This command is issued by OE
B . CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE
C . CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator
D . CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator&e
-
Evaluate the following SQL statement used to create the PRODUCTS table:
https://assets.asklib.com/images/image2/2018080210365762118.jpg
Which statement is true regarding this command?（）
A . It executes successfully but partition pruning cannot happen for this partition key.
B . It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C . It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D . It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
-
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）
A . CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B . CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C . GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
-
The following statements:CREATE TABLE t1 （col1 INT NOT NULL, PRIMARY KEY（col1)); CREATE TA
The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, ‘a‘), (1, ‘b‘), (2,‘c‘); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);How many rows will be deleted by the following DELETE statement？ DELETE FROM t1 WHERE col1= 1;（）
A.4
B.3
C.1
D.0
-
Evaluate the set of SQL statements:CREATE TABLE dept（deptno NUMBER（2),dname VARCNAR2（14),1oc VARCNAR2 （13));ROLLBACK;DESCRIBE DEPTWhat is true about the set？（）
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.
B. The ROLLBACK statement frees the storage space occupies by the DEPT table.
C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
-
Examine the data of the EMPLOYEES table.EMPLOYEES （EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Evaluate this SQL statement:What is its output？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/6bce46904716f2e8357f4849d2a3423d.jpg' />
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/c5c76fa6bab26c6735c868df586306cf.jpg' />
A.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/0f921b8c15106e9d6cc8e36a50134106.jpg' />
B.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/d072515564553d90b433296aa71e021a.jpg' />
C.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b4721c6b94a9b61c92cdbe82aabc3ae1.jpg' />
D.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b27c35e83798de4bbbccaef22fa31b48.jpg' />
E. The SQL statement produces an error.
