出自:Oracle认证

You want to create a copy of the DEPARTMENTS table. When that is complete， you want to truncate the new DEPARTMENTS table， then restore the data with a direct-load insert from the old DEPARTMENTS table.  Which CREATE statement should you use？（）
A:A
B:B
C:C
D:D
View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries？  （）
A: displaying the total order value for sales representatives 161 and 163
B: displaying the order total for sales representative 161 in the year 1999
C: displaying the number of orders that have order mode online and order date in 1999
D: displaying the number of orders whose order total is more than the average order total for all online orders
The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）
A:set the SESSIONS to 1 in the parameter file
B:grant SINGLE SESSION privilege to all of the users
C:set the SESSIONS_PER_USER to 1 in the users’ profile
D:grant RESTRICTED SESSION privilege to all of the database users
E:create a role with SINGLE SESSION privilege and assign the role to the users
he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）
A:Use the Data Block Wizard and base the relation on a REF pointer. 
B:In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.
C:Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. 
D:This task is not possible because master-detail relations can be implemented only for blocks based on relational tables. 
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）
A:no privileges
B:only the SELECT privilege
C:only the CONNECT privilege
D:all the privileges of a default user
下列哪一个命令可以用来执行不完全恢复？（）
A:RESTORE DATABASE UNTIL
B:RECOVER DATABASE UNTIL
C:RECOVER DATA UNTIL
D:RESTORE DATA UNTIL
In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）
A:The source PL/SQL code will be stored in native machine code.
B:The source PL/SQL code will be stored in interpreted byte code.
C:The compiled PL/SQL code will be stored in native machine code.
D:The compiled PL/SQL code will be stored in interpreted byte code.
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement?（）
A:You cannot roll back this statement.
B:All pending transactions are committed.
C:All views based on the DEPT table are deleted.
D:All indexes based on the DEPT table are dropped.
E:All data in the table is deleted, and the table structure is also deleted.
F:All data in the table is deleted, but the structure of the table is retained.
G:All synonyms based on the DEPT table are deleted.
A JavaBeans component has the following field：   11. private boolean enabled；   Which two pairs of method declarations follow the JavaBeans standard for accessing this field？（）
A:A
B:B
C:C
D:D
You create a new Automatic Database Diagnostic Monitor （ADDM） task：  instance_analysis_mode_task. To view the ADDM report， you use the following command：   SQL> SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual；   You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments.  What would you do to achieve this？（）
A: Add a finding directive for the ADDM task.
B: Add a segment directive for the ADDM task.
C: Add a parameter directive for the ADDM task.
D: Disable the Segment Advisor from the Automatic Maintenance Task.
You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）
A: DBA_SCHEDULER_JOB_RUN_DETAILS
B: DBA_SCHEDULER_RUNNING_JOBS
C: DBA_SCHEDULER_JOBS
D: DBA_SCHEDULER_JOB_LOG
Which two statements are true about the Automatic Workload Repository （AWR）（）
A:All AWR tables belong to the SYSTEM schema.
B:The AWR contains systemwide tracing and logging information.
C:The snapshots collected by the AWR are accessible through data dictionary views.
D:The snapshots collected by the AWR are used by self-tuning components in the database.
Given: Which statement is true about the class of an object that can reference the variable base? （）
A:It can be any class.
B:No class has access to base.
C:The class must belong to the geometry package.
D:The class must be a subclass of the class Hypotenuse.
Which two statements are true about record groups?（）
A:They are stored in the database. 
B:They are stored in local Forms memory. 
C:The type is specified explicitly at design time. 
D:The type is implied by when and how it is created.
Which two statements are true about a job chain? （）(Choose two.)
A:A job chain can contain a nested chain of jobs.
B:The jobs in a job chain cannot have more than one dependency.
C:A job of the CHAIN type can be run using event-based or time-based schedules.
D:The jobs in a job chain can be executed only by using the events generated by the Scheduler
What is the purpose of the recover command？（） 
A: Recover database datafiles from physical disk backup sets.
B: Recover required incremental backups from physical disk backup sets.
C: Recover required archived redo logs from physical disk backup sets.
D: Apply incremental backups to recover the database. 
E: Apply archived redo logs to recover the database.
Which two statements about creating constraints are true?（）
A:Constraint names must start with SYS_C
B:All constraints must be defines at the column level.
C:Constraints can be created after the table is created.
D:Constraints can be created at the same time the table is created.
E:Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.
You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase.  Which option of IMPDP would you use to accomplish this task（）
A:FULL
B:SCHEMAS
C:TRANSFORM
D:REMAP_SCHEMA
E:REMAP_TABLESPACE
You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）
A: by using the DBMS_REPAIR package
B: by using the DBVERIFY utility
C: by using Block Media Recovery
D: by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
Which Scheduler view(s) can be queried to see which jobs are currently executing? （）
A:DBA_SCHEDULER_JOB_RUN_DETAILS
B:DBA_SCHEDULER_RUNNING_JOBS DBA
C:DBA_SCHEDULER_CURRENT_JOBS
D:DBA_SCHEDULER_JOBS DBA
E:DBA_SCHEDULER_EXECUTING_JOBS
What are four capabilities of the mysql client program?（）
A:Creating, dropping, and modifying tables and indexes
B:Initiating a binary backup of the database by using the START BACKUP command
C:Displaying replication status information
D:Shutting down the server by using the SHUTDOWN command
E:Creating and dropping databases
F:Creating and administering users
Evaluate the following statements：   CREATE TABLE purchase_orders （po_id NUMBER（4），  po_date TIMESTAMP， supplier_id NUMBER（6）， po_total NUMBER（8，2），  CONSTRAINT order_pk PRIMARY KEY（po_id）） PARTITION BY RANGE（po_date）  （PARTITION Q1 VALUES LESS THAN （TO_DATE（？1-apr-2007？d-mon-yyyy？）， PARTITION Q2 VALUES LESS THAN  （TO_DATE（？1-jul-2007？d-mon-yyyy？），  PARTITION Q3 VALUES LESS THAN（TO_DATE（？1-oct - 2007？d-mon-yyyy？）， PARTITION Q4 VALUES LESS THAN （TO_DATE（？1-jan-2008？d-mon-yyyy？））；  CREATE TABLE purchase_order_items （po_id NUMBER（4） NOT NULL， product_id NUMBER（6） NOT NULL， unit_price NUMBER（8，2）， quantity NUMBER（8）， CONSTRAINT po_items_fk FOREIGN KEY  （po_id） REFERENCES purchase_orders（po_id）） PARTITION BY REFERENCE（po_items_fk）；   What are the two consequences of the above statements？（）
A: Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
B: Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each. 
C: Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
D: The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by  automatically duplicating the key columns.
E: Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）
A: incomplete names
B: incomplete names with templates
C: alias with template names
D: numeric names
You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?（）
A:Mysqld uses internal configuration versioning and reverts to the previous configuration
B:When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes
C:The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes
D:Mysqld prints to the error log about an unknown variable, and then exits
While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）
A:configure the database to run in ARCHIVELOG mode
B:configure the Flash Recovery Area to enable automatic database backup
C:schedule the database backup using DBMS_JOB package after creating the database
D:schedule the database backup using Recovery Manager （RMAN）commands after creating the database
E:schedule the database backup using Database Configuration Assistant （DBCA）while creating the database
You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）
A: Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
B: Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
C: Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
D: You cannot shrink the SCOTT.EMP table.
There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）
A:Define user profiles and set the CPU_PER_CALL limit. 
B:Define a SWITCH_TIME for a plan in the Resource Manager. 
C:Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations. 
D:Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.
A team of programmers is involved in reviewing a proposed design for a new utility class. After some discussion， they realize that the current design allows other classes to access methods in the utility class that should be accessible only to methods within the utility class itself. What design issue has the team discovered？（）
A:Tight coupling
B:Low cohesion
C:High cohesion
D:Loose coupling
E:Weak encapsulation
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification.  Whichschema object enables the user to access the information from the remote database（）
A:Cluster
B:Database link
C:Mapping table
D:Materialized view
Given： What is the result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:The code executes normally and prints "bar".
D:The code executes normally， but nothing prints.
首页 <上一页 88 89 90 91 92 下一页> 尾页