-
有如下定义 TABLE1 DD 0,1,2,3 TABLE2 DB 30H, 31H, 32H, 33H 则下列指令中,()项是正确的。
A . MOV AX,TABLE1
B . MOV BX,TABLE2
C . MOV AX,WORD PTR TABLE1
D . MOV BX,BYTE PTR TABLE1
-
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?()
A . A syntax error will result as you cannot specify more than one partition in the same statement
B . All data in p1 and p3 partitions are removed and the table definition is changed
C . All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D . Only the first partition (p1) will be dropped as only one can be dropped at any time
-
On the table there are()
A . five ten-dollar bills
B . five ten-dollars bill
C . five ten dollars bill
-
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
-
Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa > &&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?()
A . An error is returned.
B . You are prompted to enter a new value.
C . A report is produced that matches the first report produced.
D . You are asked whether you want a new value or if you want to run the report based on the previous value.
-
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?()
A . MANAGER must be a role.
B . It allows the MANAGER to pass the specified privileges on to other users.
C . It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
D . It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
E . It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
F . It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
-
User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?()
A . UPDATE pets…
B . SELECT….FROM pets
C . INSERT INTO pets…
D . ALTER TABLE pets&helli
-
Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?()
A . Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B . Using the statement RESET PERFORMANCE CACHE
C . Using the statement FLUSH PERFORMANCE CACHE
D . Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E . Disabling and re-enabling all instruments
F . Restarting Mysql
-
On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()
A . You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
B . You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
C . You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
D . You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
-
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?()
A . It remains valid.
B . It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
C . It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
D . It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
-
Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa >&&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?()
A . An error is returned.
B . You are prompted to enter a new value.
C . A report is produced that matches the first report produced.
D . You are asked whether you want a new value or if you want to run the report based on the previous value.
-
You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? ()
A . CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
B . CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
C . CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
D . CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
E . CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar
-
On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()
A . You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
B . You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
C . You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
D . You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
-
You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?()
A . Drop the table.
B . Partition the table.
C . Truncate the table.
D . Add a column to the table.
E . Rename a column in the table.
-
You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based?()
A . column sizes
B . column data types
C . PCTFREE
D . projected number of row
E . PCTUSED
-
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()
A . No flashback is possible to bring back the ITEM table.
B . The ORDERS table is dropped along with the ITEM table.
C . The dependent referential integrity constraints in the ORDERS table are disabled.
D . The dependent referential integrity constraints in the ORDERS table are removed.
E . The table definition of the ITEM table and associated indexes are placed in the recycle bi
-
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
-
In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table()
A . if a table is not in a cluster
B . if a table has an active trigger
C . if a table has an encrypted
D . if a table has a column of data type LONG defined on it
E . if a table has a referential integrity constraint defined on it
-
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()
A . You must enable the block change tracking feature.
B . You must have enable the flashback feature.
C . You must use the OMF in your database.
D . You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
-
In the west, round tables are the standard.
-
11. To predict the actual depth of water using the Tide Tables,the number obtained from the Tide Tables is _____.
-
The STUDENT_GRADES table has these columns:The register has requested a report listing the students‘ grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/96672f85a7852424612e04353e00d7a4.jpg' />
A. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;
B. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end ASC, gpa ASC;
C. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa DESC;
D. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end DESC;
E. SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC, semester_end ASC;
-
Put the napkin on the table when eating.
-
<table><tbody><tr><td>The bomb could be set out by the slightest touch.</td></tr></tbody></table>