long
timer
number
varchar2
第1题:
Data deduplication ratios depend on many factors. However, deduplication ratios are generallygreater for what type of data?()
第2题:
Which datatype is returned by the FIND_MENU_ITEM built-in function?()
第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?()
第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?()
第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?()
第6题:
You get an error because of a primary key violation.
The data and structure of the EMPLOYEES table are deleted.
The data in the EMPLOYEES table is deleted but not the structure.
You get an error because the statement is not syntactically correct.
第7题:
encrypted data
compressed data
archive data
multiplexed data streams
第8题:
Add the Known Type attribute to the data contract.Set a default value in each of the data member declarations.
Add the Known Type attribute to the data contract.Set the Order property of each data member to unique integer value.
Set the Emit Default Value property of each data member to false.
Set the Is Required property of each data member to true.
第9题:
The standby database is protected against write operations.
The primary database is protected against write operations.
The primary database is protected against data loss and data divergence.
The standby database is protected against data loss and data divergence.
第10题:
Hash cluster
Index cluster
Sorted hash cluster
Real Application cluster
第11题:
number
Boolean
menuitem
VARCHAR2
第12题:
Frame Relay
HDLC
x.25
PPP
第13题:
What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED; command?()
第14题:
Which three statements are true regarding the data types in Oracle Database 10g/11g?()
第15题:
What is the data type returned by the CREATE_TIMER built-in?()
第16题:
Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?()
第17题:
Umount the /development filesystem and remount it using the following command: mount -t jfs2 /development
Edit the /etc/filesystems file to change the type paramter to jfs2 and change the log parameter to jfs2log
Backup the /development filesystem data, delete the JFS /development filesystem, create the new JFS2 /development filsystem, and restore the data to the /development filesystem
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
第18题:
CYCLE
ITERATE
NO_REPEAT
REUSE
第19题:
Create DML triggers that query the inserted and deleted tables.
Create a stored procedure that calls the LTRIM and RTRIM built-in functions.
Create a Transact-SQL function that calls the LTRIM and RTRIM built-in functions.
Call the TRIM built-in function.
第20题:
ListView Web Server Control
DetailsView Web Server Control
DataList Web Server Control
Data Web Server Control
第21题:
Only one LONG column can be used per table
A TIMESTAMP data type column stores only time values with fractional seconds
The BLOB data type column is used to store binary data in an operating system file
The minimum column width that can be specified for a VARCHAR2 data type column is one
The value for a CHAR data type column is blank-padded to the maximum defined column width
第22题:
long
timer
number
varchar2
第23题:
CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );
CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );
第24题:
The particular event instance.
The source of the event.
The set of events that were triggered by the same action.
The type of event.
The type of component from which the event originated.