单选题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?()AREF BTABLE CCLOB DVARRAY

单选题
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?()
A

REF 

B

TABLE 

C

CLOB 

D

VARRAY


参考解析

解析: 暂无解析

相关考题:

The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ‘6‘ MINUTE)WHERE ename = ‘ALLEN‘;What are the minimum requirements for the statement to execute successfully? ()A. ARCHIVELOG mode must be enabledB. Row Movement must be enabled for the tableC. FLASHBACK must be set to ON for the databaseD. The UNDO_MANAGEMENT parameter must be set to AUTOE. The UNDO_RETENTION parameter must be set appropriately

You have set up an Internet based FTP server, where people can upload and download files. In terms of the OSI model, what is the highest layer used during the FTP sessions.A. ApplicationB. PresentationC. SessionD. TransportE. InternetF. Data LinkG. Physical

“请问您要去哪里?”可以用英文表达为()。A、Where do you want to go?B、Where would you like to go?C、Where are you going?D、Where are they going?

Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?()A、UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%B、UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%C、UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'D、UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%

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?()A、p_where_clause B、:p_where_clause C、WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone D、Where cust_ID=p_custid cust_name=p_cust_name or cust_phone=p_cust_phone

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.

Where do you configure SCREEN options?()A、zones on which an attack might arriveB、zones you want to protect from attackC、interfaces on which an attack might arriveD、interfaces you want to protect from attack

Which three are true regarding the use of outer joins?()A、You cannot use IN operator in a condition that involves an outerjoin.B、You use (+) on both sides of the WHERE condition to perform an outerjoin.C、You use (*) on both sides of the WHERE condition to perform an outerjoin.D、You use an outerjoin to see only the rows that do not meet the join condition.E、In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.F、You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.

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?()A、REF B、TABLE C、CLOB D、VARRAY

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.

Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()A、V$BACKUPSETB、RC_DATABASEC、V$BACKUP_SETD、RC_BACKUP_SET

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()A、LOCK TABLE emp IN SHARE MODE;B、LOCK TABLE emp IN EXCLUSIVE MODE;C、UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER;D、INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

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? ()A、ARCHIVELOG mode must be enabledB、Row Movement must be enabled for the tableC、FLASHBACK must be set to ON for the databaseD、The UNDO_MANAGEMENT parameter must be set to AUTOE、The UNDO_RETENTION parameter must be set appropriately

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?()A、UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;B、UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;C、UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;D、UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180;

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()A、LOCK TABLE emp IN SHARE MODE;B、LOCK TABLE emp IN EXCLUSIVE MODE;C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER?UPDATE emp SET sal=sal*1.2 WHERE job=?ANAGER?D、INSERT INTO emp(empno,ename) VALUES (1289,’Harry’);E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

单选题View the following SQL statements:   Transaction T1 INSERT INTO hr.regions VALUES (5,’Pole’);COMMIT;  Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5; COMMIT;  Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5;   You want to back out transaction T2.  Which option would you use?()A It is possible,but transaction T3 also backs out.B It is possible with the NOCASCADE_FORCE option.C It is possible with the NONCONFLICT_ONLY option.D It is not possible because it has conflicts with transaction T3.

单选题You have set up an Internet based FTP server, where people can upload and download files. In terms of the OSI model, what is the highest layer used during the FTP sessions.()AApplicationBPresentationCSessionDTransportEInternetFDataLinkGPhysical

单选题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? ()AUPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;BUPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;CUPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;DUPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;

单选题Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()AV$BACKUPSETBRC_DATABASECV$BACKUP_SETDRC_BACKUP_SET

单选题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?()AUPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;BUPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;CUPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;DUPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;

单选题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?()AThe Query Only property is set to Yes. BThe Conceal Data property is set to Yes. CThe Insert Allowed property is set to Yes. DThe Update Allowed property is set to Yes.

单选题Which of the following network cable types is MOST often used in environments where physicalsecurity of the data is the top priority?()AUTPBCoaxialCFiber opticDSTP

单选题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?()AIt is created as a nondisplay item. BThe Lock Record property is set to Yes. CIt cannot be referenced in item level triggers. DIt is placed on the canvas with the highest sequence number.

单选题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?()AREF BTABLE CCLOB DVARRAY

单选题Where do you configure SCREEN options?()Azones on which an attack might arriveBzones you want to protect from attackCinterfaces on which an attack might arriveDinterfaces you want to protect from attack

多选题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()ALOCK TABLE emp IN SHARE MODE;BLOCK TABLE emp IN EXCLUSIVE MODE;CUPDATE emp SET sal=sal*1.2 WHERE job=ANAGER?UPDATE emp SET sal=sal*1.2 WHERE job=?ANAGER?DINSERT INTO emp(empno,ename) VALUES (1289,’Harry’);ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

单选题Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?()AUPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%BUPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%CUPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'DUPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%

单选题The warning level threshold value for a tablespace, DATA1, is set to 60% and the critical level threshold value is set to 80%. The tablespace, DATA1, is infrequently used and is not a part of the production environment. You issued the following command:        SQL EXECUTE   DBMS_SERVER_ALERT.SET_THRESHOLD        (dbms_server_alert.tablespace_pct_full,        dbms_server_alert.operator_ge,80,        dbms_server_alert.operator_ge,90,        1,1,NULL,   dbms_server_alert.object_type_tablespace,’DATA’);   What will be the result of the command?()A The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.B The total numbers of alerts that you receive every day will be reduced.C The total number of alerts that you receive every day will be increased.D No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.