问题:单选题The TRANS_SUMMARY table contains product-wise transaction details that get updated with everytransaction in the system. Each row has cumulative transaction details of a single product and everyproduct is identified by a product code, which is the primary key. As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY tableto the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products,the company deals with many new products during every quarter. Which method is best suited for this quarterly data transfer()A using the MERGE commandB using the SQL*Loader utilityC using the correlated UPDATE commandD using the INSERT command to perform bulk operation
Friday, September 16, 2022
问题:单选题Observe the information in the columns: 1: The SGA a. Text and parsed forms of all SQL statements 2: The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved 3: User-session data c. Security and resource usage information 4:The stack space d. Local variables for the process Which option has the correct match between the memory areas and their contents()A 1-c,2-b,3-d,4-aB 1-c,2-b,3-c,4-aC 1-a,2-b,3-c,4-dD 1-a,2-b,3-d,4-c
Friday, December 8, 2023
问题:多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table()AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table is truncated when the TRUNCATE command is applied on the parent table.DThe high-water mark (HWM) is set to point to the first usable data block in the table segment.ENo undo or very little undo data is generated during the execution of the TRUNCATE command
Monday, February 12, 2024
问题:多选题A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL> connect smith/smith Connected. SQL> SELECT * FROM v$session; SELECT * FROM v$session * ERROR at line 1: ORA-00942: table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION()Agranting SELECT privilege to SMITH on V$SESSIONBgranting SELECT privilege to SMITH on V_$SESSIONCasking the user SMITH to run the catalog.sql scriptDgranting SELECT privilege to SMITH on V$FIXED_TABLESEsetting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEFcreating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
Tuesday, October 10, 2023
问题:单选题To make audit information more productive, the DBA executes the following command before startingan audit operation: SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase()A It contains only the plan for the SQL statement executed by the user.B It contains the SQL text executed by the user and the bind variables used with it.C It contains the plan and statistics associated with the SQL statement executed by the user.D It contains the plan for the SQL statement executed by the user and the bind variables used with it.
Thursday, September 22, 2022
问题:单选题You plan to configure the new Oracle Database 11g installation by performing these tasks: - Use Automatic Storage Management (ASM) as the storage option. - Use Oracle Enterprise Manager Database Control to manage the database. - Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during theinstallation. - Configure the database to send email notifications. Some tools available to you for installation are: 1:Oracle Universal Installer (OUI) 2:Database Configuration Assistant (DBCA) 3:Database Upgrade Assistant (DBUA) 4:Oracle Net Configuration Assistant Which tools would you use for this installation()A 2B 3C 1 and 2D 3 and 4E 1,2,and 4
Thursday, January 18, 2024
问题:单选题View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the userSKD by executing the command: SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION; Which statement is true about the user SKD afterhe/she is granted this role()AThe user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it.BThe user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.CThe user SKD can grant the privileges in the MGR_ROLE role to other users, but not with ADMIN OPTION.DThe user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privilegesfrom them
Saturday, January 6, 2024
问题:单选题Note the following points describing various utilities in Oracle Database 1g:1. It enables the high-speed transfer of data from one database to another. 2. It provides a complete solution for the backup, restoration, and recovery needs of the entire database.3. It enables the loading of data from an external file into an Oracle database.4. It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup()A 1B 2C 3D 4E 1, 2, and 4F 1, 2, 3, and 4
问题:单选题You want to import schema objects of the HR user using Oracle Data Pump from the development database,DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server:$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP(’25-08-2007 14:35:00’, ’DD-MM-YYYY HH24:MI:SS’)"The command fails displaying the following error:ORA-39001: invalid argument valueORA-39000: bad dump file specification ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable toobtain file status What would you do to overcome the error()A Add the user, SYSTEM, to the schemas option.B Add the network_link = devdb.us.oracle.com option.C Change the dumpfile option to schema.dat@devdb.us.oracle.com.D Replace the schemas option with the network_link = devdb.us.oracle.comE Replace the dumpfile option with the network_link = devdb.us.oracle.com
Monday, January 22, 2024
问题:多选题Which 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
问题:多选题You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about theeffect of the command()ANo flashback is possible to bring back the ITEM table.BThe ORDERS table is dropped along with the ITEM table.CThe dependent referential integrity constraints in the ORDERS table are disabled.DThe dependent referential integrity constraints in the ORDERS table are removed.EThe table definition of the ITEM table and associated indexes are placed in the recycle bin
Sunday, November 19, 2023
问题:单选题Examine the commands executed in the following sequence: 1:SQL> CREATE ROLE mgrrole; 2:SQL> GRANT create user,select any table,connect,resource TO mgrrole; 3:SQL> GRANT select,update ON sh.sales TO mgrrole; 4:SQL> CREATE ROLE ceo IDENTIFIED BY boss; 5:SQL> GRANT mgrrole,drop any table,create any directory TO ceo; 6:SQL> GRANT ceo TO mgrrole; Which statement is true about the above commands()A The commands execute successfully.B Command 6 produces an error because of circular role grant.C Command 5 produces an error because a role cannot be granted to another role.D Command 3 produces an error because the MGRROLE role already contains system privileges.E The table created by HR remains and HR still has the CREATE TABLE system privilege.F The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
问题:多选题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
Tuesday, September 26, 2023
问题:单选题You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night, level 0 backup is performed. - On Monday night and subsequent days, level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday’s backup is true()A The backup contains all the used blocks.B The backup contains all the used and unused blocks.C The backup contains blocks that have changed since the last level 0 backup.D The backup contains blocks that have changed since the last level 1 backup taken last week.
Tuesday, October 17, 2023
问题:单选题The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code, which is the primary key.As part of the archival process, the company wants to transfer therows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of theyear. Along with existing products, the company deals with many new products during every quarter. Whichmethod is best suited for this quarterly data transfer()A Using the MERGE commandB Using the SQL*Loader utilityC Using the correlated UPDATE commandD Using the INSERT command to perform bulk operation
Wednesday, July 5, 2023
问题:单选题Note the following points describing various utilities in Oracle Database 11g: 1:It enables the high-speed transfer of data from one database to another. 2:It provides a complete solution for the backup, restoration, and recovery needs of the entire database. 3:It enables the loading of data from an external file into an Oracle database. 4:It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup()A 1B 2C 3D 4E 1,2,and 4F 1,2,3,and 4
问题:单选题You want to create a role to meet these requirements: 1:The role is to be protected from unauthorized usage. 2:The password of the role is not to be embedded in the application source code or stored in a table. Which method would you use to restrict enabling of such roles()A Create the role with global authentication.B Create the role with external authentication.C Create the role as a secure application role.D Create the role as a password-protected role.E Create a role and use Fine-Grained Access Control (FGAC) to secure the role.
问题:单选题You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()A Archiving will be disabled because the destination for the redo log files is missing.B The database instance will shut down and the error details will be logged in the alert log file.C Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.D Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.
Sunday, September 18, 2022
问题:多选题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
问题:单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. What would be your next step to improve performance()A Run the SQL Access AdvisorB Run the Memory Advisor for the sga.C Run the Memory Advisor for the pga.D Run the Memory Advisor for the shared pool.E Run the Memory Advisor for the buffer cache
Tuesday, November 7, 2023