Which statement explicitly names a constraint?（）A、ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students(student_id);B、ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);C、ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);D、ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);E、ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
Which statement explicitly names a constraint?（）
- A、ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students(student_id);
- B、ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
- C、ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
- D、ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
- E、ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
相关考题：
Which statement about Automatic Memory Management with Oracle 11g is true?() A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.B. Oracle can reallocate memory between the SGA and PGA automatically as needed.C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
Which three protocols should be explicitly managed by using Control Plane Policing on an Internet borderrouter？（）A、LDAPB、ICMPC、RTPD、BGPE、SSHF、RDP
The Prescott Shovel Company wants to upgrade its Cisco Unity Express from a Cisco Unified CallManager Express integration to a Cisco Unified CallManager integration. Which statement is true?（）A、A special hybrid license is required. B、The Cisco Unity Express license must be changed. C、The Cisco Unity Express license does not need to be changed. D、The license file names are identical, which allows them to be interchanged as long as the module itself is not being upgraded.
In which of the following situations should correlation names be used?（）A、A table referenced in the FROM clause has no indexed column.B、The table referenced in the FROM clause has more than 200 columns.C、Two or more tables in the FROM clause have identical column names.D、The FROM clause contains two or more tables in the SELECT statement.
During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）A、 incomplete namesB、 incomplete names with templatesC、 alias with template namesD、 numeric names
Which two statements about views are true? （）A、A view can be created as read only.B、A view can be created as a join on two or more tables.C、A view cannot have an ORDER BY clause in the SELECT statement.D、A view cannot be created with a GROUP BY clause in the SELECT statement.E、A view must have aliases defined for the column names in the SELECT statement.
Which statement is true regarding the INTERSECT operator?（）A、It ignores NULL values B、Reversing the order of the intersected tables alters the result C、The names of columns in all SELECT statements must be identical D、The number of columns and data types must be identical for all SELECT statements in the query
View the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）A、The user must enable the role explicitly.B、The user can grant the role to other users.C、The user cannot use the role until the DBA enables it explicitly.D、The user can start using the role immediately without any changes
Which two statements are true regarding the ORDER BY clause? （）A、It is executed first in the query execution B、It must be the last clause in the SELECT statement C、It cannot be used in a SELECT statement containing a HAVING clauseD、You cannot specify a column name followed by an expression in this clause E、You can specify a combination of numeric positions and column names in this clause
Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）A、 It is used to change failure priority only for HIGH or LOW priorities.B、 It is used to execute the advised repair script.C、 It is used to change failure priority only for the CRITICAL priority.D、 It is used to explicitly close the open failures.E、 It is used to inform the database about the repair after the repair script executes.
Which statement is true？（）A、A class’s finalize（） method CANNOT be invoked explicitly.B、super.finalize（） is called implicitly by any overriding finalize（） method.C、The finalize（） method for a given object is called no more than once by the garbage collector.D、The order in which finalize（） is called on two objects is based on the order in which the two objects became finalizable.
Where can subqueries be used?（）A、field names in the SELECT statement B、the FROM clause in the SELECT statement C、the HAVING clause in the SELECT statementD、the GROUP BY clause in the SELECT statement E、the WHERE clause in only the SELECT statement F、the WHERE clause in SELECT as well as all DML statements
Which is an example of a dynamic SELECT statement? （）A、A query whose object names change during its execution. B、A query whose object names are not known until run time. C、A query whose bind variables values change during execution. D、A query whose bind variable values are not known until run time.
单选题You need to display the last names of those employees who have the letter "A" as the second character in their names.Which SQL statement displays the required results?（）ASELECT last_name FROM EMP WHERE last_ name LIKE '_A%';BSELECT last_name FROM EMP WHERE last name ='*A%'CSELECT last_name FROM EMP WHERE last name ='_A%';DSELECT last_name FROM EMP WHERE last name LIKE '*A%'
多选题Which of the following statements are true when creating NETBIOS names？ （）ANETBIOS names can only use alphanumeric characters.BYou can use a ’.’ in a NETBIOS name.CYou can use an ’_’ （underscore） in a NETBIOS name.DNETBIOS names must be UPPERCASEENETBIOS names can be a maximum of 32 characters
单选题View the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）AThe user must enable the role explicitly.BThe user can grant the role to other users.CThe user cannot use the role until the DBA enables it explicitly.DThe user can start using the role immediately without any changes
多选题Which two statements are true regarding the ORDER BY clause? （）AIt is executed first in the query executionBIt must be the last clause in the SELECT statementCIt cannot be used in a SELECT statement containing a HAVING clauseDYou cannot specify a column name followed by an expression in this clauseEYou can specify a combination of numeric positions and column names in this clause
单选题Which statement is true？（）AA class’s finalize（） method CANNOT be invoked explicitly.Bsuper.finalize（） is called implicitly by any overriding finalize（） method.CThe finalize（） method for a given object is called no more than once by the garbage collector.DThe order in which finalize（） is called on two objects is based on the order in which the two objects became finalizable.
单选题Which statement explicitly names a constraint?（）AALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);BALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);CALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);DALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);EALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
多选题Which three protocols should be explicitly managed by using a CoPP policy on an Internet border router？（）ASMTPBICMPCBGPDSSHERTPFBitTorrentGVTP
多选题Which two statements about views are true?（）AA view can be created as read only.BA view can be created as a join on two or more tables.CA view cannot have an ORDER BY clause in the SELECT statement.DA view cannot be created with a GROUP BY clause in the SELECT statement.EA view must have aliases defined for the column names in the SELECT statement.
多选题Which three protocols should be explicitly managed by using Control Plane Policing on an Internet border router？（）ALDAPBICMPCRTPDBGPESSHFRDP
多选题Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）AIt is used to change failure priority only for HIGH or LOW priorities.BIt is used to execute the advised repair script.CIt is used to change failure priority only for the CRITICAL priority.DIt is used to explicitly close the open failures.EIt is used to inform the database about the repair after the repair script executes.
单选题Which is an example of a dynamic SELECT statement? （）AA query whose object names change during its execution. BA query whose object names are not known until run time. CA query whose bind variables values change during execution. DA query whose bind variable values are not known until run time.
单选题Which statement is true regarding the INTERSECT operator?（）AIt ignores NULL values BReversing the order of the intersected tables alters the result CThe names of columns in all SELECT statements must be identical DThe number of columns and data types must be identical for all SELECT statements in the query
单选题In which of the following situations should correlation names be used?（）AA table referenced in the FROM clause has no indexed column.BThe table referenced in the FROM clause has more than 200 columns.CTwo or more tables in the FROM clause have identical column names.DThe FROM clause contains two or more tables in the SELECT statement.