更多"In the Oracle system, sets of SQL s"的相关试题:
[单项选择]In the ORACLE system, sets of SQL statements and control flow statements that have been named, compiled ,and stored in database are referred to as stored
A. batches
B. procedures
C. triggers
D. transactions
[多项选择]Identify three correct statements regarding Oracle E-Business Suite.（） (Choose three.)
A. It can run entirely on the Internet.
B. A minimum of two modules needs to be implemented for an organization.
C. It is engineered to work as an integrated system on a single IT infrastructure.
D. It supports multi-directional flows of business information within an organization.
[单项选择]Which of the following statements about ORACLE is (are) correct Ⅰ. ORACLE follows SQL standard Ⅱ. ORACLE database defines two logical types: table and view
A. Ⅰonly
B. Ⅱ only
C. Ⅰ and Ⅱ
D. none of the above
[多项选择]Which two statements about Oracle Direct Network File System (NFS) are true?（）
A. It bypasses the OS file system cache.
B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
C. It uses the operating system kernel NFS layer for user tasks and network communication modules.
D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
[多项选择]Which three statements are true about Oracle Data Pump export and import operations?（）
A. You can detach from a data pump export job and reattach later.
B. Data pump uses parallel execution server processes to implement parallel import.
C. Data pump import requires the import file to be in a directory owned by the oracle owner.
D. The master table is the last object to be exported by the data pump.
E. You can detach from a data pump import job and reattach later.
[多项选择]Which two statements are true about Oracle Managed Files (OMF)?（）
A. OMF cannot be used in a database that already has data files created with user-specified directions.
B. The file system directions that are specified by OMF parameters are created automatically.
C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
D. OMF automatically creates unique file names for table spaces and control files.
E. OMF may affect the location of the redo log files and archived log files.
[多项选择]Which two statements are true about the Oracle Direct Network File system (DNFS)?（）
A. It utilizes the OS file system cache.
B. A traditional NFS mount is not required when using Direct NFS.
C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
D. Direct NFS is available only in UNIX platforms.
E. Direct NFS can load-balance I/O traffic across multiple network adapters.
[单项选择] Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'; What is the impact of this setting on the usage of SecureFiles?（）
A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB
B. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB
C. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
[单项选择]SQL与C语言处理记录的方式是不同的。当将SQL语句嵌入到C语言程序时，为协调两者而引入了( )。
A. 堆
B. 栈
C. 游标
D. 缓冲区
[单项选择]When embedding SQL in a C language program, the prefix that should be added to all SQL statements in order to distinguish SQL statements from the host language statements is( )。
A. :
B. DECLARE
C. EXEC SQL
D. SQL
[单项选择]设有关系R=(A, B, C) 与SQL语句select distinct A, C from R where B=5等价的关系代数表达式是( )。 Ⅰ、πA,C(σB=5(R)) Ⅱ、σB=5(πA，C(R))
A. 都等价
B. 仅Ⅰ
C. 仅Ⅱ
D. 都不等价
[多项选择] On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）
A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
B. It fails because no SQL *Loader data file location is specified.
C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
D. It fails because no SQL *Loader control file location is specified.
[单项选择]设有关系R=(A,B,C)与SQL语句select distinct A，C from R where B=5等价的关系代数表达式是
I．πA,C(σB=5R))
Ⅱ．σB=5(πA,C(R))
A. 都等价
B. 仅Ⅰ
C. 仅Ⅱ
D. 都不等价
[单项选择]设有关系R=(A, B, C)与SQL语句select distinct A, C from R where B=5等价的关系代数表达式是
Ⅰ．πA.C(σB=5(R))
Ⅱ．(σB=5(πA.C(R))
A. 都等价
B. 仅Ⅰ
C. 仅Ⅱ
D. 都不等价
[单项选择]设有关系R＝(A，B，C) 与SQL语句select distinct A，C from R where B＝5等价的关系代数表达式是
Ⅰ．πA,C(σB=5(R))
Ⅱ．σB=5(πA,C(R))
A. 都等价
B. 仅I
C. 仅Ⅱ
D. 都不等价
[单项选择]
设有关系肛(A，B，C) ，与SQL语句select distinct A,C from R where B=5等价的关系代数表达式是（）。
Ⅰ．πA,C(σB=5(R))
Ⅱ．σB=5(πA,C(R))
A. 都等价
B. 仅Ⅰ
C. 仅Ⅱ
D. 都不等价
