网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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.
参考答案
参考解析
解析:
暂无解析
更多 “单选题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?()A
Select 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. B
Choose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C
Choose Tools - Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. D
Select 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. E
Select 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?()A
Differential incremental backupB
Different incremental backup C
Cumulative backup D
Cumulative 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?()A
symmetric key encryptionB
asymmetric key encryptionC
RSAD
digital certificates
考题
单选题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.
考题
多选题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?()A
table B
transactional trigger C
stored procedure D
FROM 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
考题
单选题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.
考题
多选题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?()A
Click 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. B
Choose Tools - Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. C
Select 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. D
Select 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. E
Launch 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?()A
The backup will terminate because the FORMAT clause was not configured for the channelB
It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC
It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD
It 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?()A
operationalB
managedC
configurationD
coreE
instance
考题
单选题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
热门标签
最新试卷