The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）

相似题目

• You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）

  A . The database must have multiplexed redo logs for the flashback to succeed. B . The database must be MOUNTED for the flashback to succeed. C . The database must use block change tracking for the flashback to succeed. D . The database must be opened in restricted mode for the flashback to succeed. E . The database must be opened with the RESETLOGS option after the flashback is complete. F . The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

  查看最佳答案

• From SQL*Plus, you issue this SELECT statement: https://assets.asklib.com/images/image2/2018080116203977752.jpg You use this statement to retrieve data from a data table for（）。

  A . Updating B . Viewing C . Deleting D . Inserting E . Truncating

  查看最佳答案

• You issue this SQL statement：  ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’；  What does this SQL statement do？（）

  A . It updates the control file with the new location of the data file.  B . It updates only the data dictionary with the new location of the data file.  C . It changes the location of the user_data01.dbf file in the operating system.  D . It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.

  查看最佳答案

• When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）

  A .  Filter versions B .  Filter loads C .  Filter tasks D .  Filter optio

  查看最佳答案

• You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）

  A . The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command. B .  The command will not execute successfully because resumable space allocation is enabled at the session level. C .  The command will execute successfully and resumable space will be allocated at the session level. D .  The command will execute successfully and resumable space will be allocated at the instance level.

  查看最佳答案

• You issued the following statement：  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What will be the result of issuing the statement？（）  

  A .  The control file will be multiplexed. B .  The control file will be recreated. C . The script containing the CREATE CONTROLFILE statement will be created. D .  The binary backup of the control file will be created.

  查看最佳答案

• The DBA issues this SQL command: https://assets.asklib.com/images/image2/2018080117142684706.jpg 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.

  查看最佳答案

• You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?（）

  A . The Flashback Archive FLA1 is dropped only if it is empty. B . The tablespace having Flashback Archive is dropped. C . The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive. D . The Flashback Data Archive and historical data are dropped.

  查看最佳答案

• The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）

  A . statistics recommendations B . SQL profile recommendations C . index-related recommendations D . restructuring of SQL recommendatio

  查看最佳答案

• The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

  A .  statistics recommendations B .  SQL profile recommendations C .  index-related recommendations D .  restructuring of SQL recommendatio

  查看最佳答案

• To view the results of a manual SQL Tuning Advisor task， which steps should the DBA take？（）  

  A .  From the Advisor Central home page，select the tuning task from the Advisor Tasks section  B .  From Advisor Central，choose SQL Advisors，SQL Tuning Advisors，Manual Tuning Task Results C .  From Advisor Central，choose SQL Advisors，Manual SQL Tuning Advisors，Tuning Task Results D .  Either B or C

  查看最佳答案

• From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.

  A . Updating B . Viewing C . Deleting D . Inserting E . Truncating

  查看最佳答案

• Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）  

  A .  Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database. B .  Oracle will automatically take the datafile out of hot backup mode and then open the database. C .  Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database. D .  The database will open with the file in hot backup mode. You can restart the backup at any time. E .  The datafile in hot backup mode will be corrupted and you will have to recover it.

  查看最佳答案

• In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;

  A . $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql B . Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql' C . $ mysql – u root – p – h localhost test ＜ /tmp/t1.sql D . Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1 E . $ mysqlinport – u root – p – h localhost test /tmp/t1.sql

  查看最佳答案

• The Company administrator has issue the "show vlan id 5" command.  What will this command  display？ （）

  A .  Ports in VLAN 5 B .  Utilization C .  VLAN information on port 0/5 D .  Filters E .  MTU and type

  查看最佳答案

• You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?（）

  A . The tablespace must be locally managed. B . The tablespace must have only one temp file. C . The tablespace must be made nondefault and offline. D . The tablespace can remain as the default but must have no active sort operations.

  查看最佳答案

• What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）

  A . The standby database is protected against write operations.  B . The primary database is protected against write operations.  C . The primary database is protected against data loss and data divergence.  D . The standby database is protected against data loss and data divergence.&e

  查看最佳答案

• The undersigned （）that he is duly authorized by the said Government to issue this certificate.

  A . claims B . declares C . complains D . say

  查看最佳答案

• A  user  wants  to  be  permanently  added  to  the  dba  group.  Which  of  the  following  commands  or processes can be used to accomplish this（）

  A . chgrp B . chuser C . edit /etc/user D . edit /etc/security/grou

  查看最佳答案

• You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

  A . All data along with the table structure is deleted  B . The pending transaction in the session is committed  C . All indexes on the table will remain but they are invalidated  D . All views and synonyms will remain but they are invalidated  E . All data in the table are deleted but the table structure will remai

  查看最佳答案

• You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）  

  A .  The tablespace must be locally managed. B .  The tablespace must have only one temp file. C .  The tablespace must be made nondefault and offline. D .  The tablespace can remain as the default but must have no active sort operations.

  查看最佳答案

• “This certicate is valid for six months from the date of issue.”，最确切的翻译是（ ）。

  查看最佳答案

• 4.What is the legal affairs reporter's opinion on this issue?

  查看最佳答案

• The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

  A. statistics recommendations B. SQL profile recommendations C. index-related recommendations D. restructuring of SQL recommendations

  查看最佳答案