问题:单选题You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct?()A imp hr/hr TABLES=(ts_employees) rows=yB imp system/manager FROMUSER=hr file=expdat.dmpC im...
查看答案
问题:单选题The database is configured for automatic archive logging. Along with the other required parameters, this entry is in the initialization file:log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1?(...
问题:单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk; it belo...
问题:多选题Which three statements are true about the privileged connection options available in Oracle9i?()AThe CONNECT INTERNAL is disallowed.BThe Server Manager tool is no longer supplied.CThe listener must be running to make a connection.DThe use of remote pas...
问题:单选题The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?()A Only MEMORY is updated.B Only SPFILE values are updated.C Only init.ora parameters are upd...
问题:多选题Which three statements are true about database recovery operations?()ADamaged or lost data files are restored from backups.BRedo log file entries are used to roll forward the database.CUndo segments are used to roll back any uncommitted transactions.DT...
问题:单选题Users complain SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strat...
问题:You have just run this syntax to start the listener from the...
问题:单选题Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database, each with three members, making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you...
问题:多选题Which four occur during the processing of a request using Oracle Shared Server?()AThe dispatcher returns the response to the user.BThe dispatcher places the request into the request queue.CThe shared server places the response in the response queue.DTh...
问题:多选题Which two are true regarding direct-path exports?()ADirect-path export is typically faster.BDirect-path export can be invoked interactively.CDirect-path export is character set independent.DDirect-path export bypasses the SQL-command processing layer.E...
问题:多选题Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature?()ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH_ESTIMATE...
问题:多选题Oracle Net is responsible for establishing and maintaining the connection between the client application and the server. On the client side, Oracle Net is responsible for which three connectivity issues?()AThe location of the server.BThe Oracle user be...
问题:单选题What is the maximum database block size supported for the Oracle9i database?()A 16KBB 32KBC 64KBD 128KB...
问题:单选题The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this?()A mediaB instanceC statementD user process...
问题:单选题You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types?()A ADDRESS_LISTB SID_NAMEC LISTENERD SERVICE_LIST...
问题:单选题What is the purpose of importing from an export,and specifying that no rows be imported and that the output goes to a log file?()A To verify space requirements in the target database before importing.B To generate the SQL for the DDL operations that wo...
问题:单选题Which of the following packages maintains information in the recovery catalog? ()A DBMS_RCVMANB DBMS_RMANC DBMS_RCVCATD DBMS_CATPROC...
问题:多选题For which two tasks would it be best NOT to use the utility SQL*Loader?()AWhen loading selected rows into each table.BWhen loading data from an export dump file.CWhen loading data from disk, tape, or named pipes.DWhen your data is NOT being inserted fr...
问题:单选题What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?()A It is NOT possible to switch unless no active transaction exist in UNDO1. B It is possible to switch to UNDO2; but current active tran...