默认题库 - 1Z0-042

多选题

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.

查看答案

单选题

You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）

A. Upgrade the hardware/memory to accommodate the data.
B. Load the data into your database by using the PARALLEL clause.
C. Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLE
D. Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.

查看答案

单选题

You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

A. control file
B. password file
C. listener controller file
D. control file and password file

查看答案

单选题

The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）

A. Undo data becomes obsolete after 1，000 seconds.
B. Undo data gets refreshed after every 1，000 seconds.
C. Undo data will be stored permanently after 1，000 seconds.
D. Committed undo data would be retained for 1，000 seconds if free undo space is available.
E. Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.

查看答案

单选题

You work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location of the alert log file？（）

A. USER_DUMP_DEST
B. CORE_DUMP_DEST
C. ALERT_LOG_DEST
D. ALERT_DUMP_DEST
E. TRACE_DUMP_DEST
F. BACKGROUND_DUMP_DEST

查看答案

多选题

You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb Which three statements are correct regarding the connection string？（）

A. mydb is a service name.
B. test.us.oracle.com is a database name.
C. 1521 is the listener port number.
D. mydb is a host name.
E. test.us.oracle.com is a net service name.
F. hr is a username.
G. test.us.oracle.com is an instance name.

查看答案

多选题

Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.（）

A. SYSAUX
B. TOOLS
C. UNDO
D. INDEX
E. SYSTEM
F. USERS
G. TEMP

查看答案

单选题

Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）

A. Java pool
B. Large pool
C. Shared pool
D. Streams pool
E. Library cache
F. Redo log buffer
G. Data dictionary cache
H. Database buffer cache

查看答案

单选题

You want the size of the tablespace to increase when it is full. Which option would you use？（）

A. use automatic extent allocation
B. disable threshold for the tablespace
C. use freelists to manage the free space
D. use automatic segment space management
E. create the tablespace as a bigfile tablespace
F. use the RESIZE clause while creating the tablespace
G. enable AUTOEXTEND for at least one of the data files in the tablespace

查看答案

多选题

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）

A. This clause is not valid for a temporary or undo tablespace.
B. If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.
C. The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.
D. The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

查看答案

Which two statements are true about a bitmap index？ （）

You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）

You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）

You work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location of the alert log file？（）

You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb Which three statements are correct regarding the connection string？（）

Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.（）

Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）

You want the size of the tablespace to increase when it is full. Which option would you use？（）

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）

Which two statements are true about a bitmap index？（）