当前分类： 1Z0-052
问题：多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn...
查看答案
问题：多选题Which two statements are true regarding Oracle Data Pump（）AEXPDP and IMPDP are the client components of Oracle Data Pump.BDBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.COracle Data Pump export and import operations ca...
问题：单选题User A executes the following command to drop a large table in your database： SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table： SQL DELETE FROM trans WHERE tr_type=’SL’； Whic...
问题：单选题For which database operation would you need the database to be in the MOUNT state（）A renaming the control filesB re-creating the control filesC dropping a user in your databaseD dropping a tablespace in your databaseE configuring the database instance ...
问题：单选题All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 ro...
问题：多选题Which operations require undo data（）ACommitting a transactionBFlashing back a transactionCRecovering a failed transactionDRunning a read-consistent queryEChanging a tablespace status from READ ONLY to READ WRITE...
问题：单选题Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressedmode for an installation（）A Run the root.sh script.B Create the oraInst.loc file.C Create the tnsnames.ora file.D Run the oraintRoot.sh script....
问题：单选题The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgr NUMBER， v_loc NUMBER） BEGIN INSERT INTO...
问题：多选题Which three statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data file.CA data block is the smallest unit of input/output （I/O） in data files.DIt is...
问题：单选题Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A ...
问题：单选题Which statement is true about loading data using the conventional path of SQL*Loader（）A Redo is not generated while performing conventional path loads.B Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.C No exclusive locks are acquire...
问题：单选题In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting（）A Optimizer statistics are collected automatically.B Only timed operating system （OS） statistics and plan execution statistics...
问题：多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on ...
问题：多选题You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays， to tape. Which two statements are true about differential incremental backups（）AThe backup performed on Sundays contains all the blo...
问题：单选题You executed the following commands in an RMAN session for your database instance that has failures： RMAN LIST FAILURE； After some time， you executed the following command in the same session： RMAN ADVISE FAILURE； But there are new failures recorded...
问题：多选题Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）Adata filesBcontrol filesCparameter fileDonline redo log filesEserver parameter file...
问题：单选题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client whileconnecting to the database instance from a remote machine（）A Host naming methodB Local naming methodC External naming methodD Directory naming metho...
问题：多选题Which statements are true regarding the creation of an incident package file by using the EMWorkbench Support（）AYou can add SQL test cases to the incident package.BYou can add or remove the trace files to the package.CYou cannot create an incremental i...
问题：多选题You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）AYou can perform consistent backups only.BYou can pe...
问题：多选题You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays， to tape. Which two statements are true about differential incremental backups（）AThe backup performed on Sundays contains all the b...
