多项选择题Which two SQL*Loader instructions are used to assemble logical records?()

A.WHEN
B.INFILE
C.CONTINUEIF
D.CONCATENATE
E.TRAILING NULLCOLS


您可能感兴趣的试卷

你可能感兴趣的试题

2.单项选择题After the recovery is complete, which command should you execute?()

A.ALTER DATABASE OPEN;
B.ALTER DATABASE CLEAR LOGFILE;
C.ALTER DATABASE OPEN RESETLOGS;
D.ALTER DATABASE OPEN NORESETLOGS;

5.单项选择题Which statement is true regarding remote archive log file destinations?()

A.Only two destinations per remote database can be specified.
B.Destination is an Oracle Net alias specified by using the SERVICE keyword.
C.The REOPEN attribute must be used when using remote archive log file destinations.
D.The service name is resolved by searching sqlnet.ora file for the remote database name.

8.单项选择题Under the Oracle Shared Server architecture, client-user processes ultimately connect to a()

A.service
B.listener
C.dispatcher
D.shared server process

9.多项选择题Which two are true regarding direct-path exports?()

A.Direct-path export is typically faster.
B.Direct-path export can be invoked interactively.
C.Direct-path export is character set independent.
D.Direct-path export bypasses the SQL-command processing layer.
E.Direct-path export can be used to export rows containing LOBs and BFILEs.

10.单项选择题The Log Writer (LGWR) process reads information from the ()and writes it to the online logs.

A.large pool
B.shared pool
C.data buffer cache
D.redo log buffer
E.data dictionary cache

最新试题

As A DBA, which of the following methods can you use to make a backup of your table?()

题型:单项选择题

You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types?()

题型:单项选择题

Which one of the following statements about the TNSPING utility is correct?()

题型:单项选择题

Which of the following commands cannot be executed when the database open?()

题型:单项选择题

SQL*Loader reads a set of records from a file, generates INSERT commands, and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario?()

题型:单项选择题

Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?()

题型:单项选择题

Which Oracle background process frees SGA resources that were allocated to a user process that failed?()

题型:单项选择题

Which of the following options enables a user to get authenticated though a single password instead of using multiple passwords?()

题型:单项选择题

Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()

题型:单项选择题

Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i?()

题型:单项选择题