问题:多选题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
查看答案
问题:单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()A You can perform online whole database backups.B You can performofflinewhole database backups.C You cannot perform schema-level export/import operations.D You can perform the backup of only the SYSTEM tablespace when the database is open.
问题:多选题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 blocks that have ever been used in the database.BThe backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.CThe backup performed on each working day contains all the blocks that have changed since the last level 0 backup.DThe backup performed on Monday contains all the blocks that have changed since the level 0 backup, and every other working day contains all the blocks that have changed since the level 1 backup
问题:多选题Which two statements are true regarding the usage of the SQL*Loader utility()AYou can load data into multiple tables during the same load session.BYou can load data from multiple files to a table during the same load session.CYou cannot perform selective data loading based on the values available in the records.DYou can use an export file generated by the EXPDP utility as an input data file to load the data.EYou can load data only if the input file is available on the disk and tape but not in a named pipes.
问题:单选题Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statement describes the effect of the above command()A Automatic statistics collection is stopped for the CUSTOMERS table.B Statistics for the CUSTOMERS table are locked and cannot be overwritten.C Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics.
问题:单选题Which statement is true about the Manageability Monitor (MMON) background proces()A It transfers statistics from memory to disk at regular intervals.B It coordinates the rebalance activity for disk groups when ASM is used.C It communicates with the Automatic Storage Management (ASM) instance on behalf of the databaseinstance.D It performs dynamic memory management when Automatic Shared Memory Management is enabledfor 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 rows updated. SQL> DELETE FROM persons WHERE exp=’Y’; 3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can seethe effect of the UPDATE and DELETE commands ()A all sessions of the HR user onlyB all sessions of the HR user and the SYS userC the session of the HR user that executed the commandsD all the sessions for which the database users have access privilege to the PERSONS table
问题:多选题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 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.
问题:多选题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 SPFILE can be read by the database server, but it is not written to by the server.FAn SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database
问题:多选题Which two statements are true regarding a tablespace()AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned segment.
问题:多选题Which two statements correctly describe the relation between a data file and the logical database structures()AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data file can have only one segment created in it.EA data block can spread across multiple data files as it can consist of multiple operating system (OS)blocks
问题:多选题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 it. Which constraints will remain enabled by default during this operation()ACHECKBUNIQUECNOT NULLDPRIMARY KEYEFOREIGN KEY
问题:单选题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 are collected.C The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.D Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.E The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
问题:多选题You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()AYou can perform consistent backups only.BYou can perform a complete database backup without shutting down the database instance.CYou can back up data files only when all data files have the same SCN recorded in the control file.DYou can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands
问题:单选题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 hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END; The users having permission to execute the procedure are able to insert records into the DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would you suggest to the PL/SQL developers to achieve this()A Create the procedure with definer’s right.B Create the procedure with invoker’s right.C Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.D Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users
问题:多选题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 can be performed only by users with the SYSDBA privilege.DOracle Data Pump imports can be done from the export files generated in the export utility of previous versions.EEXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
问题:单选题You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order: 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task()A 4, 1, 3, 2, 5B 1, 3, 4, 5, 2C 1, 3, 2, 5; 4 not requiredD 4, 1, 5, 2; 3 not requiredE 1, 3, 4, 5; 2 not required