REF
TABLE
CLOB
VARRAY
第1题:
The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?()
第2题:
Where do you configure SCREEN options?()
第3题:
Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set?()
第4题:
Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()
第5题:
The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are the minimum requirements for the statement to execute successfully? ()
第6题:
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command: SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session()
第7题:
Application
Presentation
Session
Transport
Internet
DataLink
Physical
第8题:
V$BACKUPSET
RC_DATABASE
V$BACKUP_SET
RC_BACKUP_SET
第9题:
The Query Only property is set to Yes.
The Conceal Data property is set to Yes.
The Insert Allowed property is set to Yes.
The Update Allowed property is set to Yes.
第10题:
It is created as a nondisplay item.
The Lock Record property is set to Yes.
It cannot be referenced in item level triggers.
It is placed on the canvas with the highest sequence number.
第11题:
zones on which an attack might arrive
zones you want to protect from attack
interfaces on which an attack might arrive
interfaces you want to protect from attack
第12题:
UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%
UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%
UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'
UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%
第13题:
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?()
第14题:
Which three are true regarding the use of outer joins?()
第15题:
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?()
第16题:
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session()
第17题:
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?()
第18题:
It is possible,but transaction T3 also backs out.
It is possible with the NOCASCADE_FORCE option.
It is possible with the NONCONFLICT_ONLY option.
It is not possible because it has conflicts with transaction T3.
第19题:
UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
第20题:
UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
第21题:
UTP
Coaxial
Fiber optic
STP
第22题:
REF
TABLE
CLOB
VARRAY
第23题:
LOCK TABLE emp IN SHARE MODE;
LOCK TABLE emp IN EXCLUSIVE MODE;
UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER?UPDATE emp SET sal=sal*1.2 WHERE job=?ANAGER?
INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);
SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
第24题:
The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.
The total numbers of alerts that you receive every day will be reduced.
The total number of alerts that you receive every day will be increased.
No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.