niusouti.com
更多“单选题What is the data type returned by the CREATE_TIMER built-in?()A longB timerC numberD varchar2”相关问题
  • 第1题:

    Data deduplication ratios depend on many factors. However, deduplication ratios are generallygreater for what type of data?()

    • A、encrypted data
    • B、compressed data
    • C、archive data
    • D、multiplexed data streams

    正确答案:B

  • 第2题:

    Which datatype is returned by the FIND_MENU_ITEM built-in function?()

    • A、number 
    • B、Boolean 
    • C、menuitem 
    • D、VARCHAR2 

    正确答案:C

  • 第3题:

    You are maintaining a database of credit card transactions. You want the data to be returned automatically in the chronological order of the credit card numbers without using the ORDER BY clause in the query. Which type of cluster will you use to obtain the desired result?()  

    • A、 Hash cluster
    • B、 Index cluster
    • C、 Sorted hash cluster
    • D、 Real Application cluster

    正确答案:C

  • 第4题:

    You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?()

    • A、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );
    • B、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
    • C、CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
    • D、CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
    • E、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
    • F、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );

    正确答案:E

  • 第5题:

    Windows Communication Foundation (WCF) application uses a data contract that has several data members. You need the application to throw a Serialization Exception if any of the data members are not present when a serialized instance of the data contract is deserialized. What should you do?()

    • A、 Add the Known Type attribute to the data contract.Set a default value in each of the data member declarations.
    • B、 Add the Known Type attribute to the data contract.Set the Order property of each data member to unique integer value.
    • C、 Set the Emit Default Value property of each data member to false.
    • D、 Set the Is Required property of each data member to true.

    正确答案:D

  • 第6题:

    单选题
    You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; ()
    A

    You get an error because of a primary key violation.

    B

    The data and structure of the EMPLOYEES table are deleted.

    C

    The data in the EMPLOYEES table is deleted but not the structure.

    D

    You get an error because the statement is not syntactically correct.


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

  • 第7题:

    单选题
    Data deduplication ratios depend on many factors. However, deduplication ratios are generallygreater for what type of data?()
    A

    encrypted data

    B

    compressed data

    C

    archive data

    D

    multiplexed data streams


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

  • 第8题:

    单选题
    Windows Communication Foundation (WCF) application uses a data contract that has several data members. You need the application to throw a Serialization Exception if any of the data members are not present when a serialized instance of the data contract is deserialized. What should you do?()
    A

     Add the Known Type attribute to the data contract.Set a default value in each of the data member declarations.

    B

     Add the Known Type attribute to the data contract.Set the Order property of each data member to unique integer value.

    C

     Set the Emit Default Value property of each data member to false.

    D

     Set the Is Required property of each data member to true.


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

  • 第9题:

    单选题
    What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED; command?()
    A

    The standby database is protected against write operations. 

    B

    The primary database is protected against write operations. 

    C

    The primary database is protected against data loss and data divergence. 

    D

    The standby database is protected against data loss and data divergence. 


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

  • 第10题:

    单选题
    You are maintaining a database of credit card transactions. You want the data to be returned automatically in the chronological order of the credit card numbers without using the ORDER BY clause in the query. Which type of cluster will you use to obtain the desired result?()
    A

     Hash cluster

    B

     Index cluster

    C

     Sorted hash cluster

    D

     Real Application cluster


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

  • 第11题:

    单选题
    Which datatype is returned by the FIND_MENU_ITEM built-in function?()
    A

    number 

    B

    Boolean 

    C

    menuitem 

    D

    VARCHAR2 


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

  • 第12题:

    单选题
    Which layer 2 protocol encapsulation type supports synchronous and asynchronous circuis and has built-in security mechanisms?()
    A

    Frame Relay

    B

    HDLC

    C

    x.25

    D

    PPP


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

  • 第13题:

    What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED; command?()

    • A、The standby database is protected against write operations. 
    • B、The primary database is protected against write operations. 
    • C、The primary database is protected against data loss and data divergence. 
    • D、The standby database is protected against data loss and data divergence. 

    正确答案:C

  • 第14题:

    Which three statements are true regarding the data types in Oracle Database 10g/11g?()

    • A、Only one LONG column can be used per table 
    • B、A TIMESTAMP data type column stores only time values with fractional seconds 
    • C、The BLOB data type column is used to store binary data in an operating system file 
    • D、The minimum column width that can be specified for a VARCHAR2 data type column is one 
    • E、The value for a CHAR data type column is blank-padded to the maximum defined column width

    正确答案:A,D,E

  • 第15题:

    What is the data type returned by the CREATE_TIMER built-in?()

    • A、long
    • B、timer
    • C、number
    • D、varchar2

    正确答案:B

  • 第16题:

    Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?()

    • A、CYCLE 
    • B、ITERATE
    • C、NO_REPEAT 
    • D、REUSE

    正确答案:C

  • 第17题:

    单选题
    A system administrator has determined that the /development filesystem needs to be changed from JFS to JFS2 to take advantage of the new capabilites available in JFS2. What is the method to convert the /development filesystem from type JFS to JFS2?()
    A

    Umount the /development filesystem and remount it using the following command: mount -t jfs2 /development

    B

    Edit the /etc/filesystems file to change the type paramter to jfs2 and change the log parameter to jfs2log

    C

    Backup the /development filesystem data, delete the JFS /development filesystem, create the new JFS2 /development filsystem, and restore the data to the /development filesystem

    D

    Backup the /development filesystem data, change the /development filesystem using the following command,chfs -t type=jfs2 /development.then, restore the data to the /development filesystem


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

  • 第18题:

    单选题
    Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?()
    A

    CYCLE 

    B

    ITERATE

    C

    NO_REPEAT 

    D

    REUSE


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

  • 第19题:

    单选题
    You are responsible for managing a SQL Server 2005 database that stores sales information. Many values in nchar columns in the database tables contain preceding or trailing spaces. You need to implement a mechanism that selects the data from the tables without leading and trailing spaces. Your solution must be available for reuse in Transact-SQL statements and views. What should you do?()
    A

    Create DML triggers that query the inserted and deleted tables.

    B

    Create a stored procedure that calls the LTRIM and RTRIM built-in functions.

    C

    Create a Transact-SQL function that calls the LTRIM and RTRIM built-in functions.

    D

    Call the TRIM built-in function.


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

  • 第20题:

    单选题
    Which control allows you to bind to data items that are returned from a data source and display them?()
    A

    ListView Web Server Control

    B

    DetailsView Web Server Control

    C

    DataList Web Server Control

    D

    Data Web Server Control


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

  • 第21题:

    多选题
    Which three statements are true regarding the data types in Oracle Database 10g/11g?()
    A

    Only one LONG column can be used per table

    B

    A TIMESTAMP data type column stores only time values with fractional seconds

    C

    The BLOB data type column is used to store binary data in an operating system file

    D

    The minimum column width that can be specified for a VARCHAR2 data type column is one

    E

    The value for a CHAR data type column is blank-padded to the maximum defined column width


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

  • 第22题:

    单选题
    What is the data type returned by the CREATE_TIMER built-in?()
    A

    long

    B

    timer

    C

    number

    D

    varchar2


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

  • 第23题:

    单选题
    You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?()
    A

    CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );

    B

    CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );

    C

    CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );

    D

    CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );

    E

    CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );

    F

    CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );


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

  • 第24题:

    单选题
    What does the value returned by the method getID() found in class java.awt.AWTEvent uniquely identify?()
    A

    The particular event instance.

    B

    The source of the event.

    C

    The set of events that were triggered by the same action.

    D

    The type of event.

    E

    The type of component from which the event originated.


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