单选题A UDT is a data type which:()Amust contain unique values.Bcannot be CAST to other data types.Cis created using the CREATE DISTINCT command.Dcontains a value that was automatically calculated from values in other columns.

单选题
A UDT is a data type which:()
A

must contain unique values.

B

cannot be CAST to other data types.

C

is created using the CREATE DISTINCT command.

D

contains a value that was automatically calculated from values in other columns.


参考解析

解析: 暂无解析

相关考题:

You need to serialize an object of type Listint in a binary format.The object is named data.Which code segment should you use?() A.B.C.D.

Which statement describes the ROWID data type? () A. Binary data up to 4 gigabytes.B. Character data up to 4 gigabytes.C. Raw binary data of variable length up to 2 gigabytes.D. Binary data stored in an external file, up to 4 gigabytes.E. A hexadecimal string representing the unique address of a row in its table.

Which encryption type is used to secure user data in an IPsec tunnel?() A. symmetric key encryptionB. asymmetric key encryptionC. RSAD. digital certificates

An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?() A.GRAPHICB.BINARYC.IMAGED.BLOB

In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table()A、if a table is not in a clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it

A UDT is a data type which:()A、must contain unique values.B、cannot be CAST to other data types.C、is created using the CREATE DISTINCT command.D、contains a value that was automatically calculated from values in other columns.

WebSphere Commerce categorizes store data into several categories.  Prices, Contracts, and Campaigns are all examples of which type of data?()A、operationalB、managedC、configurationD、coreE、instance

Which of the following supports the XML data type?()A、A unique indexB、A composite indexC、A check constraintD、A generated column

An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?()A、GRAPHICB、BINARYC、IMAGED、BLOB

Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?()  A、 Differential incremental backupB、 Different incremental backupC、 Cumulative backupD、 Cumulative incremental backup

You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()A、An object type is a user-defined composite data type. B、The attributes of an object type can be those of other object types. C、A PL/SQL table of records is an example of a nested object type. D、An object type must be declared as a type before the actual object itself can be declared.

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

单选题You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?()ASelect The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. CChoose Tools - Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. DSelect the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. ESelect the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

单选题Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?()ADifferential incremental backupBDifferent incremental backup CCumulative backup DCumulative incremental backup

多选题Examine the list of variables and their data types:  AME DATA Type  TS, TS1 TIMESTAMP  TSZ TIMESTAMP WITH TIME ZONE  TLZ TIMESTAMP WITH LOCAL TIME ZONE  IYM INTERVAL YEAR TO MONTH  IDS, IDSI INTERVAL YEAR To SECOND   Which three expressions using the new data and time data types are valid?()AIDS* 2BTS + IYMCTS –TSIDIDS – TSEIDS + IYM

多选题Which three statements are true regarding the data types in Oracle Database 10g/11g?()AOnly one LONG column can be used per tableBA TIMESTAMP data type column stores only time values with fractional secondsCThe BLOB data type column is used to store binary data in an operating system fileDThe minimum column width that can be specified for a VARCHAR2 data type column is oneEThe value for a CHAR data type column is blank-padded to the maximum defined column width

单选题Which encryption type is used to secure user data in an IPsec tunnel?()Asymmetric key encryptionBasymmetric key encryptionCRSADdigital certificates

单选题Which statement describes the ROWID data type?()ABinary data up to 4 gigabytes.BCharacter data up to 4 gigabytes.CRaw binary data of variable length up to 2 gigabytes.DBinary data stored in an external file, up to 4 gigabytes.EA hexadecimal string representing the unique address of a row in its table.

多选题You need to design the storage of the loan response message. Which actions or actions should you perform?()AUse the xml data type to store the message.BUse a user-defined data type to store the message.CUse the nvarchar(max) data type to store the message.DUse a check constraint to validate that the correct tags are used.EUse an XML schema definition (XSD) to validate that the correct tags are used.FUse a foreign key constraint to validate that the correct tags are used.

单选题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?()Atable Btransactional trigger Cstored procedure DFROM clause query

多选题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table()Aif a table is not in a clusterBif a table has an active triggerCif a table has an encryptedDif a table has a column of data type LONG defined on itEif a table has a referential integrity constraint defined on it

多选题These are the details about V$FLASHBACK_DATABASE_STAT: SQL DESC v$FLASHBACK_DATABASE_STAT  Name                    Null?              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()ABEGIN_TIME is the time at which Flashback logging is enabled.BEND_TIME is the time at which the query is executed on the view.CREDO_DATA is the number of bytes of redo data written during the interval.DThis view contains information about flashback data pertaining to the last 24 hours.EFLASHBACK_DATA is the amount of flashback data generated since the database was opened.

单选题You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?()AClick the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. CSelect the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. DSelect the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. ELaunch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.

单选题You issued the following commands to configure setting in RMAN; RMAN CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?()AThe backup will terminate because the FORMAT clause was not configured for the channelBIt backs up two copies of data files to tape and disk, and two copies of archived log file on tapeCIt backs up the data files and archived log files to disk, making two copies of each data file and archived log fileDIt backs up the data files and archived log files to tape, making two copies of each data file and archived log file

多选题You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()AAn object type is a user-defined composite data type.BThe attributes of an object type can be those of other object types.CA PL/SQL table of records is an example of a nested object type.DAn object type must be declared as a type before the actual object itself can be declared.

单选题WebSphere Commerce categorizes store data into several categories.  Prices, Contracts, and Campaigns are all examples of which type of data?()AoperationalBmanagedCconfigurationDcoreEinstance

单选题Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?()A Differential incremental backupB Different incremental backupC Cumulative backupD Cumulative incremental backup