问题:he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()A、SYS.SOURCE$ B、SYS.AUD$ C、DBA_SOURCE D、DBA_AUDIT_TRAIL
Thursday, April 13, 2023
问题:Which two are attributes of /SQL*Plus? ()A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accesses from a browser.C、/SQL*Plus commands are used to manipulate data in tables.D、/SQL*Plus commands manipulate table definitions in the database.E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
Friday, September 16, 2022
问题: In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required. Which three statements are true about this requirement?()A、The partitions can be moved online to new tablespaces.B、Global indexes must be rebuilt manually after moving the partitions.C、The partitions can be compressed in the same tablespaces.D、The partitions can be compressed in the new tablespaces.E、Local indexes must be rebuilt manually after moving the partitions.
Thursday, September 15, 2022
问题:Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?()A、 NLS_LANGB、 NLS_COMPC、 NLS_SORTD、 None of the above
Friday, June 9, 2023
问题:A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log?() A、 Do nothing.B、 Restart the database.C、 Perform recovery on the database.D、 Restore the alert log from the last backup.
问题:Which of the following parameters defines the location where Oracle should create archived redo logs?()A、LOG_ARCHIVE_1 B、LOG_DESTINATION_1 C、LOG_ARCHIVED_DESTINATION_1D、LOG_ARCHIVE_DEST_1E、LOG_ARCHIVE_SOURCE_1
问题:Which two statements are true regarding single row functions?()A、They accept only a single argument B、They can be nested only to two levels C、Arguments can only be column values or constants D、They always return a single result row for every row of a queried table E、They can return a data type value different from the one that is referenced
问题:What are four capabilities of the mysql client program?()A、Creating, dropping, and modifying tables and indexesB、Initiating a binary backup of the database by using the START BACKUP commandC、Displaying replication status informationD、Shutting down the server by using the SHUTDOWN commandE、Creating and dropping databasesF、Creating and administering users
问题:You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead?()A、 recycle buffer cacheB、 large poolC、 streams poolD、 keep buffer cacheE、 redo log buffer
Monday, September 12, 2022
问题: You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?()A、GRANT select, insert, update ON student_grades TO manager;B、GRANT select, insert, update ON student_grades TO ROLE manager;C、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
问题:Select ‘accp’ from dual后运行结果是()。A、nullB、0C、accpD、编译出错
问题:Which two statements about subqueries are true?()A、A single row subquery can retrieve data from only one table.B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.D、A single row subquery can retrieve data from more than one table.E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
Tuesday, May 2, 2023
问题:Which two roles or privileges must you have to export tables owned by another user?()A、CREATE USERB、CREATE SESSIONC、CREATE ANY TABLED、IMP_FULL_DATABASEE、EXP_FULL_DATABASE
问题:Which three statements describe how the strict SQL mode provides added security?()A、It rejects statements that try to insert out-of-range valuesB、It rejects invalid datesC、It limits the operations that the server can performD、It rejects queries that produce out-of-range valuesE、It rejects dates with zero day or month values
Friday, January 20, 2023
问题:用于删除表中所有数据行的命令是()。A、DELETE TABLEB、TRUNCATE TABLEC、DROP TABLED、ALTER TABLE
问题:Which two statements are true regarding undo tablespaces()A、The database can have more than one undo tablespace.B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.C、Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions.D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
问题: You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls, listed in chronological order. Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?()A、create a hash cluster to store the dataB、create an index cluster to store the dataC、create a partitioned table to store the dataD、create a sorted hash cluster to store the dataE、create a heap table with rowid to store the data
问题:Which view should a user query to display the columns associated with the constraints on a table owned by the user?()A、USER_CONSTRAINTSB、USER_OBJECTSC、ALL_CONSTRAINTSD、USER_CONS_COLUMNSE、USER_COLUMNS
问题:说明触发器的种类和对应的作用对象、触发事件。
问题:Which component of the SGA stores parsed SQL statements is used for process sharing?()A、Buffer cache B、Redo log buffer C、Private SQL area D、Library cache E、Row cache
Friday, January 12, 2024