________clause is an additional filter that is applied to the result. September 2, 2021September 2, 2021 administrator ________clause is an additional filter that is applied to the result.HavingWell Done. Your Answer is Correct Keep it Up!Order byGroup-bySelect
Which command is used for removing a table and all its data from the database: September 2, 2021September 2, 2021 administrator Which command is used for removing a table and all its data from the database:Drop table commandWell Done. Your Answer is Correct Keep it Up!Create commandAlter table commandAll options are correct
___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity. September 2, 2021September 2, 2021 administrator ___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity. ConstraintWell Done. Your Answer is Correct Keep it Up!ColumnIndexTrigger
In an E-R diagram an entity set is represent by a September 2, 2021September 2, 2021 administrator In an E-R diagram an entity set is represent by aRectangleWell Done. Your Answer is Correct Keep it Up!EllipseDiamond boxCircle
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? September 2, 2021September 2, 2021 administrator Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Definition Language(DDL)Well Done. Your Answer is Correct Keep it Up!Data Manipulation Language(DML)DML and DDLAll options are correct
In Oracle, which of the following package procedure is UNRESTRICTED ? September 2, 2021September 2, 2021 administrator In Oracle, which of the following package procedure is UNRESTRICTED ?USER_EXITWell Done. Your Answer is Correct Keep it Up!EXECUTE_QUERYCLEAR_BLOCKCALL_INPUT
Oracle server configuration is dedicated for September 2, 2021September 2, 2021 administrator Oracle server configuration is dedicated forOne server process – One user processWell Done. Your Answer is Correct Keep it Up!Many server processes – One user processOne server process – Many user processesMany server processes – Many user processes
What are the valid Oracle database schemas? September 2, 2021September 2, 2021 administrator What are the valid Oracle database schemas? Logical and Physical SchemaWell Done. Your Answer is Correct Keep it Up!Physical SchemaLogical SchemaNone of the options are correct
Map entities, attributes and relations in Oracle is represented by_________ September 2, 2021September 2, 2021 administrator Map entities, attributes and relations in Oracle is represented by_________ Logical SchemaWell Done. Your Answer is Correct Keep it Up!Conceptual Schema Physical SchemaAll options are correct
The Oracle environment of database is called as ___________ September 2, 2021September 2, 2021 administrator The Oracle environment of database is called as ___________ Database InstancesWell Done. Your Answer is Correct Keep it Up!Database SchemaData StructureAll options are correct