OracleSIDsonly
Oracle homes only
Oracle install timestamp
Oracle inventory pointer files
Oracle database creation timestamp
OracleSIDsand Oracle homes only
OracleSIDs, Oracle homes and flag for auto startup
第1题:
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()
第2题:
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()
第3题:
You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install, you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks. To allow the new DBAs to perform the administrative tasks, you create a password file on the database server using the following command: ORAPWD file=d:/oracle/ora9i/orapwU01 password=admin entries=4 After creating the password file, you remove the operating system authentication and change the value of the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it?()
第4题:
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()
第5题:
You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?()
第6题:
Use the CREATE DATABASE .. command to create the database with Oracle-managed files.
Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.
Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.
Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.
Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
第7题:
OracleSIDsonly
Oracle homes only
Oracle install timestamp
Oracle inventory pointer files
Oracle database creation timestamp
OracleSIDsand Oracle homes only
OracleSIDs, Oracle homes and flag for auto startup
第8题:
Shared pool
Control file
SGA
PGA
第9题:
CONNECT / AS SYSDBA
CONNECT sys/admin AS SYSDBA
CONNECT sys/admin@mynewdb AS SYSDBA
CONNECT sys/change_on_install AS SYSDBA
第10题:
Start the instance and open the database, instance recovery automatically recovers control files
Create a file based on the contents of the trace file and save it to the control file locations and start the database
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
第11题:
Delete the newly created password file and re-create another password file with the password admin, without shutting down the database.
Enable the operating system authentication, shut down the database, disable the operating system authentication, and restart the database using the password file.
Enable the operating system authentication, shut down the database, re-create the password file using the same ORAPWD command, and restart the database using the password file.
Delete the newly created password file, enable operating system authentication and shut down the database. Then, re-create another password file using the same ORAPWD command and restart the database using this password file.
第12题:
control file
password file
listener controller file
control file and password file
第13题:
You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database?()
第14题:
The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file?()
第15题:
You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology, you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation, you make the following changes in your initialization parameter file:LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d:/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database?()
第16题:
While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software, you are prompted to run orainstRoot.sh script. What does this script accomplish?()
第17题:
What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?()
第18题:
OracleSIDsonly
Oracle homes only
Oracle install timestamp
Oracle inventory pointer files
Oracle database creation timestamp
OracleSIDsand Oracle homes only
OracleSIDs, Oracle homes and flag for auto startup
第19题:
The audit trail is stored in an operating system file.
Auditing is disabled for all privileges.
The audit trail is stored in the database.
Auditing is enabled for all privileges.
Auditing is enabled for certain privileges related to database security.
第20题:
The filename format.
Information stored inside a data dictionary table.
Information stored in the ALERT.LOG file for the corresponding instance.
Information stored inside the corresponding initialization parameter file for the instance.
第21题:
Zero
One or more
NONE
DEFAULT
第22题:
It creates the pointer file.
It creates the base directory.
It creates the Inventory pointer file.
It creates the Oracle user for installation.
It modifies the Unix kernel parameters to match Oracle’s requirement.
第23题:
The archived redo logs are stored in an operating system-dependent location.
The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
第24题:
DB_CREATE_FILE_DEST
DB_CREATE_ONLINE_LOG_1
DB_CREATE_ONLINE_LOG_2
The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed