网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command?()
A

RAW

B

LONG

C

VARCHAR

D

LONG RAW


参考答案

参考解析
解析: 暂无解析
更多 “多选题Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command?()ARAWBLONGCVARCHARDLONG RAW” 相关考题
考题 Which two statements regarding a SQL profile are true?() A. It is built by Automatic Tuning Optimizer.B. It cannot be stored persistently in the data dictionary.C. It can be used by the query optimizer automatically.D. It can be created manually by using the CREATE PROFILE command.

考题 Which two statements are true regarding the USING clause in table joins?()A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types

考题 Which WAN service utilizes two different encapsulation types (one for data and one for signaling) on its data link layer?()A、ISDNB、Frame RelayC、ATMD、FDDI

考题 Which of the following media types can hold the GREATEST amount of data?()A、 DVDB、 SDLTC、 LTOD、 Blu-Ray

考题 Which are the two options to which a menu can be assigned?() (Choose two.)A、menuB、functionsC、data groupD、responsibilityE、functional group

考题 The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files? ()A、data filesB、backup setsC、control filesD、archived redo log files

考题 Which two chart base types can you select using the Chart Wizard?()A、Line B、Column C、Bubble D、Flowchart E、OHLC candle stock

考题 Which two statements about bigfile tablespaces are true? ()A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.

考题 Which two statements are true about a bitmap index? ()A、It is recommended for the columns that have unique values.B、It can be converted to a B-tree index by using the ALTER INDEX command.C、It has a bitmap segment for each distinct value in the key column, containing a string of bits in which each bit represents the presence or absence of a key column value.D、Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

考题 Which two operations can be flashed back using the Flashback technology?()A、DROP USER SMITH;B、DROP TABLE EMPLOYEES;C、DROP TABLESPACE USERS;D、ALTER TABLE SALES_REP DROP PARTITION P1;E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;

考题 Which two statements regarding a SQL profile are true?()A、 It is built by Automatic Tuning Optimizer.B、 It cannot be stored persistently in the data dictionary.C、 It can be used by the query optimizer automatically.D、 It can be created manually by using the CREATE PROFILE command.

考题 Which two statements are true regarding the USING and ON clauses in table joins?()A、Both USING and ON clauses can be used for equijoins and nonequijoins B、Amaximum of one pair of columns can be joined between two tables using the ON clause C、The ON clause can be used to join tables on columns that have different names but compatible data types D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

考题 Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()A、data filesB、control filesC、parameter fileD、online redo log filesE、server parameter file

考题 Which two statements about Flashback Query are true?()A、It is generated by using the redo log files. B、It helps in row-level recovery from user errors.C、It can be performed to recover ALTER TABLE statements D、It fails when undo data pertaining to the transaction is overwritten.E、The database has to be opened with the resetlogs option after performing Flashback Query.

考题 Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager (RMAN)()A、Data filesB、Control filesC、Parameter fileD、Online redo log filesE、Server parameter file

考题 TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?()A、ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrdersB、DROP TRIGGER trg InsertOrdersC、DISABLE TRIGGER trg InsertOrders ON OrdersD、ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION

考题 多选题Which two statements about Flashback Query are true?()AIt is generated by using the redo log files.BIt helps in row-level recovery from user errors.CIt can be performed to recover ALTER TABLE statementsDIt fails when undo data pertaining to the transaction is overwritten.EThe database has to be opened with the resetlogs option after performing Flashback Query.

考题 多选题Which two statements are true regarding the USING and ON clauses in table joins?()ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause can be used to join tables on columns that have different names but compatible data typesDThe WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause

考题 多选题Which two statements are true regarding the USING clause in table joins?()AIt can be used to join a maximum of three tablesBIt can be used to restrict the number of columns used in a NATURAL joinCIt can be used to access data from tables through equijoins as well as nonequijoinsDIt can be used to join tables that have columns with the same name and compatible data types

考题 多选题Which two chart base types can you select using the Chart Wizard?()ALineBColumnCBubbleDFlowchartEOHLC candle stock

考题 多选题Which two statements are true about a bitmap index? ()AIt is recommended for the columns that have unique values.BIt can be converted to a B-tree index by using the ALTER INDEX command.CIt has a bitmap segment for each distinct value in the key column, containing a string of bits in which each bit represents the presence or absence of a key column value.DUpdating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

考题 多选题You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups()AYou can perform consistent backups only.BYou can perform a complete database backup without shutting down the database instance.CYou can back up data files only when all data files have the same SCN recorded in the control file.DYou can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

考题 多选题Which four types of object can be thrown using the throw statement?()AErrorBEventCObjectDExceptionEThrowableFRuntime Exception

考题 多选题Which statements are true regarding SecureFile LOBs?()AThe amount of undo retained is user controlled.BSecureFile LOBs can be used only for nonpartitioned tables.CFragmentation is minimized by using variable-sized chunks dynamically.DSecureFile encryption allows for random reads and writes of the encrypted data.EIt automatically detects duplicate LOB data and conserves space by storing only one copy.

考题 多选题Which two data types can be converted to LOBs using an ALTER TABLE… MODIFY command?()ARAWBLONGCVARCHARDLONG RAW

考题 多选题A developer chooses to avoid using SingleThreadModel but wants to ensure that data is updated in athread-safe manner. Which two can support this design goal?()AStore the data in a local variable.BStore the data in an instance variable.CStore the data in the HttpSession object.DStore the data in the ServletContext object.EStore the data in the ServletRequest object.

考题 多选题Which four types of objects can be thrown using the throw statement?()AErrorBEventCObjectDExceptionEThrowableFRuntimeException

考题 多选题Which two statements about bigfile tablespaces are true? ()AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.