A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）A、It deletes all binary log files, except 'mysql-in.010'B、It deletes all binary log files up to and including 'mysql-bin.010'C、It deletes all binary log files before 'mysql-bin.010'D、It deletes all binary log files after 'mysql-bin.010'
A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）
- A、It deletes all binary log files, except 'mysql-in.010'
- B、It deletes all binary log files up to and including 'mysql-bin.010'
- C、It deletes all binary log files before 'mysql-bin.010'
- D、It deletes all binary log files after 'mysql-bin.010'
相关考题：
The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?() A. The job is enabled by default after creationB. The job is automatically dropped after the end dateC. The job executes with the privileges of the user SYSD.
Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?() A. It executes successfully but partition pruning cannot happen for this partition key.B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber
Which statement creates a new user? () A. CREATIVE USER susan;B. CREATIVE OR REPLACE USER susan;C. CREATE NEW USER susan DEFAULTD. CREATE USER susan IDENTIFIED BY blue;E. CREATE NEW USER susan IDENTIFIED BY blue;F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;
Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?（）A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.B. The statement returns an error at the SELECT clause.C. The statement returns an error at the WHERE clause.D. The statement returns an error at the ORDER BY clause.
Given this fragment in a servlet： 23.if（req.isUserInRole（"Admin"）） { 24.// do stuff 25.} And the following fragment from the related Java EE deployment descriptor： 812. 813.Admin 814.Administrator 815. 900. 901.Admin 902.Administrator 903. What is the result？（）A、Line 24 can never be reached.B、The deployment descriptor is NOT valid.C、If line 24 executes， the user’s role will be Admin.D、If line 24 executes， the user’s role will be Administrator.E、If line 24 executes the user’s role will NOT be predictable.
Which statement creates a new user?（）A、CREATE USER susan;B、CREATE OR REPLACE USER susan;C、CREATE NEW USER susan DEFAULT;D、CREATE USER susan IDENTIFIED BY blue;E、CREATE NEW USER susanIDENTIFIED by blue;F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）A、 the datafiles associated with the SYSTEM tablespaceB、 the datafiles associated to the DATA1 tablespaceC、 the datafiles associated to the SYSTEM and DATA1 tablespacesD、 all the datafiles in the database
A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?（）A、20B、25C、50D、55
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）A、It releases the storage space used by the table.B、It does not release the storage space used by the table.C、You can roll back the deletion of rows after the statement executes.D、You can NOT roll back the deletion of rows after the statement executes.E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?（）A、DISPATCHER B、USER C、SERVER D、LGWR E、 DBW0
User A executes the following command to drop a large table in your database：SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A、It fails to delete the records because the records are locked in SHARE mode.B、It deletes the rows successfully because the table is locked in SHARE modeC、It fails to delete the records because the table is locked in EXCLUSIVE mode.D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
单选题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（）AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it.
单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）AAlice onlyBAlice and ReenaCAlice, Reena, and TimberDSue, Alice, Reena, and Timber
多选题Evaluate the SQL statement: TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）AIt releases the storage space used by the table.BIt does not release the storage space used by the table.CYou can roll back the deletion of rows after the statement executes.DYou can NOT roll back the deletion of rows after the statement executes.EAn attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.FYou must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table.
单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table： SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table： SQL ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））； What would happen in this scenario（）A The ALTER TABLE command modifies the column successfully.B The DDL operation gets higher priority and transaction for user a is rolled back.C The ALTER TABLE command waits indefinitely until user a ends the transaction.D The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
单选题To make audit information more productive， the DBA executes the following command before starting an auditoperation： 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（）AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it
单选题Which statement creates a new user? （）ACREATIVE USER susan;BCREATIVE OR REPLACE USER susan;CCREATE NEW USER susan DEFAULTDCREATE USER susan IDENTIFIED BY blue;ECREATE NEW USER susan IDENTIFIED BY blue;FCREATE OR REPLACE USER susan IDENTIFIED BY blue;
单选题A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）AIt deletes all binary log files, except 'mysql-in.010'BIt deletes all binary log files up to and including 'mysql-bin.010'CIt deletes all binary log files before 'mysql-bin.010'DIt deletes all binary log files after 'mysql-bin.010'
单选题Given this fragment in a servlet： 23.if（req.isUserInRole（"Admin"）） { 24.// do stuff 25.} And the following fragment from the related Java EE deployment descriptor： 812. 813.Admin 814.Administrator 815. 900. 901.Admin 902.Administrator 903. What is the result？（）ALine 24 can never be reached.BThe deployment descriptor is NOT valid.CIf line 24 executes， the user’s role will be Admin.DIf line 24 executes， the user’s role will be Administrator.EIf line 24 executes the user’s role will NOT be predictable.
单选题The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?（）ADISPATCHER BUSER CSERVER DLGWR E DBW0
单选题Given this fragment in a servlet： 23.if（req.isUserInRole（"Admin"）） { 24.// do stuff 25.} And the following fragment from the related Java EE deployment descriptor： 812. 813.Admin 814.Administrator 815. 900. 901.Admin 902.Administrator 903. What is the result？（）ALine 24 can never be reached.BThe deployment descriptor is NOT valid.CIf line 24 executes， the user’s role will be Admin.DIf line 24 executes， the user’s role will be Administrator.EIf line 24 executes the user’s role will NOT be predictable.
单选题User A executes the following command to drop a large table in your database：SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）AIt fails to delete the records because the records are locked in SHARE mode.BIt deletes the rows successfully because the table is locked in SHARE modeCIt fails to delete the records because the table is locked in EXCLUSIVE mode.DIt deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
单选题The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command： SQL GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim； Now， the user HR decides to revoke privileges from JIM using this command： SQL REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）AThe command fails because SCOTT still has privileges.BThe command succeeds and privileges are revoked from JIM.CThe command fails because HR cannot revoke the privileges from JIM.DThe command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
多选题Examine the statement： SQL CREATE TABLESPACE user_data 2 EXTENT MANAGEMENT LOCAL 3 SEGMENT SPACE MANAGEMENT AUTO； Which twp assumptions must be true for this statement to execute successfully？（）AOracle Managed Files are used for this instance.BThe USER_DATA tablespace is managed using FET$/UET$ tables.CThe COMPATIBLE initialization parameter must be 9.0.0 or higher.DSpace within segments in the USER_DATA tablespace is managed with freelists.
单选题User A executes the following command to update the TRANS table） SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table： SQl ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））； What would happen in this scenario？（）AThe transaction for user A is rolled back.BThe ALTER TABLE command modifies the column successfully.CThe ALTER TABLE command fails due to the resource being busy.DThe ALTER TABLE command waits until user A ends the transaction.