单选题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

题目
单选题
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


相似考题
更多“单选题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”相关问题
  • 第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?()

    • 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

    正确答案:A

  • 第2题:

    Where do you configure SCREEN options?()

    • A、zones on which an attack might arrive
    • B、zones you want to protect from attack
    • C、interfaces on which an attack might arrive
    • D、interfaces you want to protect from attack

    正确答案:A

  • 第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?()

    • A、REF 
    • B、TABLE 
    • C、CLOB 
    • D、VARRAY

    正确答案:D

  • 第4题:

    Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()

    • A、V$BACKUPSET
    • B、RC_DATABASE
    • C、V$BACKUP_SET
    • D、RC_BACKUP_SET

    正确答案:C

  • 第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? ()

    • A、ARCHIVELOG mode must be enabled
    • B、Row Movement must be enabled for the table
    • C、FLASHBACK must be set to ON for the database
    • D、The UNDO_MANAGEMENT parameter must be set to AUTO
    • E、The UNDO_RETENTION parameter must be set appropriately

    正确答案:D,E

  • 第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()

    • 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

    正确答案:A,B,E

  • 第7题:

    单选题
    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

    Application

    B

    Presentation

    C

    Session

    D

    Transport

    E

    Internet

    F

    DataLink

    G

    Physical


    正确答案: G
    解析: 暂无解析

  • 第8题:

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

    V$BACKUPSET

    B

    RC_DATABASE

    C

    V$BACKUP_SET

    D

    RC_BACKUP_SET


    正确答案: A
    解析: 暂无解析

  • 第9题:

    单选题
    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.


    正确答案: B
    解析: 暂无解析

  • 第10题:

    单选题
    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.


    正确答案: D
    解析: 暂无解析

  • 第11题:

    单选题
    Where do you configure SCREEN options?()
    A

    zones on which an attack might arrive

    B

    zones you want to protect from attack

    C

    interfaces on which an attack might arrive

    D

    interfaces you want to protect from attack


    正确答案: D
    解析: 暂无解析

  • 第12题:

    单选题
    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%


    正确答案: A
    解析: 暂无解析

  • 第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?()

    • 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.

    正确答案:A

  • 第14题:

    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.

    正确答案:D,E,F

  • 第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?()

    • 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.

    正确答案:A

  • 第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()

    • 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;

    正确答案:A,B,E

  • 第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?()

    • 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;

    正确答案:D

  • 第18题:

    单选题
    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.


    正确答案: D
    解析: 暂无解析

  • 第19题:

    单选题
    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 = 'Smoth' WHERE employee_id = 180;

    C

    UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;

    D

    UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;


    正确答案: D
    解析: 暂无解析

  • 第20题:

    单选题
    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 = 'Smoth' WHERE employee_id = 180;

    C

    UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;

    D

    UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;


    正确答案: C
    解析: 暂无解析

  • 第21题:

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

    UTP

    B

    Coaxial

    C

    Fiber optic

    D

    STP


    正确答案: D
    解析: 暂无解析

  • 第22题:

    单选题
    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


    正确答案: A
    解析: 暂无解析

  • 第23题:

    多选题
    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


    正确答案: A,D
    解析: 暂无解析

  • 第24题:

    单选题
    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.


    正确答案: A
    解析: 暂无解析