Ctrl + F is the shortcut in your browser or operating system that allows you to find words or questions quickly.
Ctrl + Tab to move to the next tab to the right and Ctrl + Shift + Tab to move to the next tab to the left.
On a phone or tablet, tap the menu icon in the upper-right corner of the window; Select "Find in Page" to search a question.
Share UsSharing is Caring
It's the biggest motivation to help us to make the site better by sharing this to your friends or classmates.
Delves deeper into advanced concepts and techniques of managing databases, including optimization, and administration, for efficient and secure data storage.
Which of the following is the correct representation of one-to-many relation?
Which of the following is not part or Oracle Installation System Requirement.
Which of the following is the example of creating a user ANNA with password ANN01?
If WITH CHECK OPTION is added on the view (see sample code below) what is/are the restriction?
It represents the state of a current user login to the database instance.
It is a type of process structure that automatically connects to other databases involved in in- doubt distributed transactions
Holds information about changes made to the database
This gives the user more flexibility and control when changing data and they ensure data consistency in the event of user process or system failure.
This is a join clause that produces a cross-product of two or more tables.
Which of the following is the example of adding a CHECK constraint where CODE should start with the character ‘BS’
Which of the following is the correct example of selecting all columns from employees table using the user BEN?
Based on the table EMPLOYEES, DEPARTMENTS and LOCATIONS.
Which of the following is the correct example of creating a role STUDENT?
Which of the following is the correct example of disabling an integrity constraint?
It occurs when two or more applications wait indefinitely for a resources.
Which of the following is the correct example of granting INSERT, UPDATE and DELETE to user ANNA with an option to pass the privilege to other user?
This is a type of schema that has the power to change the physical data without impacting the schema or logical data.
Which of the following is the example of derived attribute?
Which of the following is not true about complex view when using DELETE statement?
Which of the following is the correct example of referencing the BOOKS table to AUTHORS?
Which of the following is not included in the memory requirements of oracle database.
Which of the following are mandatory tablespaces that are created at the time of database creation
Which of the following is the correct example of adding a CHECK constraint where CODE should start with the character ‘BS’.
This is a join clause used to specify arbitrary conditions of specify columns to join.
Which of the following is the correct example of an attribute?
It is a type of process structure that can collect transaction, redo data and transmit that data to standby destinations.
Which of the following is the example of create a default constraint
Which of the following is the example of granting SELECT and INSERT on table EMPLOYEES to roleSTUDENT?
This is a type of attribute that is made of more than one simple attribute.
A type of transaction that is ends the current transactions by making all pending data changes permanent.
Which of the following is the correct example of enabling constraint?
It is a communication between a user process and an instance
Which of the following is the example of selecting all columns from employees table using the user BEN?
Also known as the application or tool that connects to the Oracle Database Processes
Which of the following is the example of an attributes?
It is part of the System Global Area (SGA) that hold copies of data blocks that are read from data files.
Which of the following is the syntax for creating a new user?
It is an attribute or collection of attributes that uniquely identifies an entity among entity set.
Which of the following is the example of adding primary key constraint?
Also known as Oracle Database backup and restore operations
It is formed when a join condition is omitted.
A transaction start when the first ____________ is issued.
A join condition used when a table has columns with match values.
A state of the data where a transaction must be fully complete, saved (committed) or completely undone (rolled back).
Which of the following is the correct example of passing a privilege (INSERT and UPDATE) to user HR coming from a SYSTEM?
It is a type of process structure that records checkpoint information in Control file on each data file header
Which of the following is not included in the oracle environment?
Which of the following is the example of creating a view where LASTNAME ends with letter S rename LASTNAME to SURNAME?
Which of the following is not possible causes of lock.
Refer to the table AUTHORS and COPY_AUTHORS (Note ID column is with Primary Key constraint). Supposed that the user insert the following values to COPY_AUTHORS view as shown below what is/are the possible output on both table and view?
It is a type of process structure that can collect transaction, redo data and transmit that data to standby destinations
This is used to enable a currently disable constraint in the table definition.
Which of the following follows the order of designing, implementing and mainting and Oracle Database
An automatic commit is issued by the Oracle Server under the following circumstances. (Choose 2)
Which of the following is the correct representation of one-to-one relation?
Which of the following is not included in the required operating system users and groups?
Which of the following is the correct syntax for creating a new user?
Which of the following is the correct representation of many-to-many relation?
This is used to quality ambiguous column when joining two or more tables.
Which of the following statement is not true about Foreign Key constraint?
Which of the following is the correct example of saving changes made on the table?
A type of lock that is acquired when an application updates, inserts, or deletes a row.
Which of the following is the correct example of an entity.
_SELECT EMPLOYEES.EMPLOYEE_ID, EMPLOYEES.LASTNAME,EMPLOYEES.DEPARTMENT_ID,DEPARTMENTS.DEPARTMENT_ID,DEPARTMENTS.LOCATION_ID FROM EMPLOYEES JOIN DEPARTMENTS USING (DEPARTMENT_ID);
Which of the following is the correct example of granting SELECT and INSERT on table EMPLOYEES to roleSTUDENT?
Which of the following is the correct example of adding a check constraint on column BOOK_ID to accept value greater that 10?
Which of the following is the example of multiple row subquery?
It is a type of privilege that is used to manipulating the content of the database objects.
This is a type of schema defines all the logical constraints that need to be applied on the data stored. It defines tables, views, and integrity constraints.
Which three (3) of thefollowing is the three Data Manipulation Langauge that is considered as part of database transaction.
This is used to remove a privilege granted to a user.
Which of the following is the correct example of granting role STUDENT to USER ANNA?
Which of the following is the correct Disk space requirement when installing Oracle?
It is a type of process structure that writes modified (dirty) buffers in the database buffer cache asynchronously while performing other processing to advance the checkpoint
Which of the following is the correct query that will create a report that will display the following: FIRTSNAME, SALARY with additional 1000 in employees salary, rename this column as BONUS, then get the DEPARTMENT_NAME and DEPARTMENT_ID. Join the table using ON condition.
Which of the following is the correct example of create a default constraint.
This is a kind of mechanism, which liberalizes itself from actual data stored on the disk.
It is a join of two or more table that returns only matched rows.
It is a type process structure that cleans up the database buffer cache
Which of the following is the query that will create a report that will display the following: STREET_ADDRESS, CITY, DEPARTMENT_NAME and LOATION_ID? Use using clause to get the data from two tables
Which one (1) DCL (Data Control Langauge) is considered as part of Database Transaction
Which of the following is the example of passing a privilege (INSERT and UPDATE) to user HR coming from a user scott?
Which of the following is the example of saving changes made on the table?
Which of the following is the correct example revoking a privilege to INSERT, UPDATE and DELETE to user ANNA from user BEN?
Which of the following is the correct example of creating a subquery that copy the values from employees table to workers table?
Supposed that table: Workers and Employees is consists of the following values.
This is the fundamental entity which introduces abstraction in a Database Management System (DBMS).
This is use to connect to the Oracle instance and is started when a user establishes a session
It is join between two tables that return the result of an Inner Join as well as the results of Left and Right joins.
This is a join clause used when the columns in two or more tables have the same but of different data type.
A join condition that is based on all the columns in two or more table that have the same name.
A type of constraint that is used to limit the value range that can be placed in a column.
It is part of the System Global Area which is used to provide memory for Oracle Streams processes
This is also known as unit of work.
Which of the following is the correct query that will create a report that will display the following: STREET_ADDRESS, CITY, DEPARTMENT_NAME and LOATION_ID? Use using clause to get the data from two tables.
Which of the following is the example of granting create session and create table to user ANNA?
It is the skeleton structure that represents the logical view of the entire database.
A type constraint that uniquely identifies each record in a database table and can be applied on one or more column.
This is a schema that pertains to the actual storage of data and its form of storage like files, indices.
This is a type of attribute that is atomic value, which cannot be divided further.
A state of the data where a transaction must be fully compliant with the state of the database as it was prior to the transaction.
It is part of the System Global Area (SGA) that hold copies of data blocks that are read from data files
A type of model that is based on the notion of real-world entities and relationships among them.
A type of constraint uniquely identifies each record in a database table.
A transaction ends when either of the following occurs. (Choose 5)
Which of the following is the correct example revoking a priviledge to INSERT, UPDATE and DELETE to USER ANNA?
It is a collection of data treated as a unit with the main purpose of storing and retrieving related information in the database.
Which of the following is the correct example of modifying a view where salary manager_id is null?
Which of the following is the correct example of an attributes?
This is acquired automatically as needed to support a transaction based on isolation levels.
This is also known collection of objects such as tables, views, and sequences.
Which of the following statement is not true about Foreign Key constraint
Which of the following is the Disk space requirement when installing Oracle?
It holds information about changes made to the database
Which of the following is the correct example of derived attribute?
Which of the following is the example of granting role STUDENT to USER ANNA?
Which of the following is the example of granting INSERT, UPDATE and DELETE to user ANNA with an option to pass the privilege to other user?
Which of the following is the correct example of creating a view where LASTNAME ends with letter S rename LASTNAME to SURNAME?
Which of the following is the example of changing a password to user ANNA from ANNA01 to AN01?
_SELECT EMPLOYEES.EMPLOYEE_ID, EMPLOYEES.LASTNAME,EMPLOYEES.DEPARTMENT_ID,DEPARTMENTS.DEPARTMENT_ID,DEPARTMENTS.LOCATION_ID
Which of the following is not included in the optional requirement for operating system of oracle database?
What are the two forms of key integrity constraint?
It is a type process structure that automatically connects to other databases involved in in- doubt distributed transactions.
Which of the following is not part of single to subqueries?
It is a state of operational database with data at any given time.
Which of the following transaction rules is not included in the group?
Which of the following is the example of an entity
It is used to ensure that data values inside a database follow defines rules for values, range and format
It is the key in solving the problems of information management.
A type of constraint that ensures the relationship between tables remain preserved as data is inserted, deleted and modified.
Which of the following is the example of dropping on delete cascade?
Which of the following is the example of passing a privilege (INSERT and UPDATE) to user HR coming from a SYSTEM?
Supposed that a user performs the query as shown below, what will happen to the data?
Which of the following is the correct example of dropping on delete cascade?
Which of the following is not part of multiple row subqueries?
Which of the following is the correct example of adding primary key constraint?
Which of the following is the example revoking a priviledge to INSERT, UPDATE and DELETE to USER ANNA?
Which of the following is the correct example of granting create session and create table to user ANNA?
This is a join clause used when the columns in two or more tables have the same but of different data types.
Which of the following System Privileges is not part of SYSTEM privilege?
Which of the following follows the correct order of designing, implementing and mainting and Oracle Database.
It is a named group of related privileges that can be granted to the user. This method makes it easier to revoke and maintain privileges.
A process where an application waits indefinitely to obtain any needed locks.
In planning to install Oracle which of the following is not important to consider.
Which of the following is the example of an attribute?
Which of the following is the correct example of passing a privilege (INSERT and UPDATE) to user HR coming from a user scott?
In the given complex view example what will be the possible output if this code is run?
Which of the following is not true about complex view when using UPDATE statement?
Which of the following system privileges is not part of the task by the database admin.?
Which of the following is the correct example of multiple row subquery?
Which of the following is not included in the disk requirements of oracle database?
An automatic rollback is issued by the oracle under the following circumstances. (Choose 2)
It is a type process structure that records checkpoint information in Control file on each data file header.
Which of the following is the example of disabling an integrity constraint?
A state where a transaction data changes must be available, even in the event of database failure.
It is used to ensures that data values inside a database follow defines rules for values, range and format
Which of the following is the correct example of creating a user ANNA with password ANN01?
Which of the following is the correct example of creating a subquery that will copy all values from employees table to workers where job_id is equal to ST_CLERK;
Which of the following is not true about complex view when using INSERT statement?
Which of the following joins are mutually exclusive.
It is a type of privilege that gain access to the database
This is used to deactivate an integrity constraint.
Which of the following is the correct example of changing a password to user ANNA from ANNA01 to AN01?
A state of the data where a transaction data must not be available to other transactions until the original transaction is committed or rolled back.
Which one (1) Data Definition Language is considered as part of Database Transaction.
Refer to the table AUTHORS and COPY_AUTHORS (Note during the creation of view the condition added is YR_PUBLISHED=2010). Supposed that the user update the YR_PUBLISHED of book OS to from 2010 to 2010 as shown below what is/are the possible output on both table and view?
Which of the following is the example of creating a role STUDENT?
Which of the following is the query that will create a report that will display the following: FIRTSNAME, SALARY with additional 1000 in employees salary, rename this column as BONUS, then get the DEPARTMENT_NAME and DEPARTMENT_ID Join the table using ON condition
It is the key to solving the problems of information management.
A type of lock that is acquired when an application wants to read and prevent others from updating the same row.
A type of constraint that is used to insert a default value into a column.
Which of the following is the example of enabling constraint?
This is used to delete a primary key constraint in a parent table and will automatically drop the foreign key constraint in the child table.
Which of the following is the example of referencing the BOOKS table to AUTHORS?
It is also known as specific connection of a user to an instance through a user process
Which of the following is the example of creating a subquery that copy the values from employees table to workers table?
It is a type of process structure that writes the redo log buffer to a redo log file on disk
It is a type of process structure that cleans up the database buffer cache
A type of transaction that rolls back the current transaction to the specified savepoint, thereby discarding any changes or savepoint created after the savepoint to which you are rolling back.
It is a type a Oracle environment where Oracle Products run.
A type of that do not exist in the physical database, but their values are derived from other attributes present in the database.
Which of the following is the example of modifying a view where salary manager_id is null?
Which of the following is the example of adding a check constraint on column BOOK_ID to accept value greater that 10?
It is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information.
Which of the following is the example of creating a subquery that will copy all values from employees table to workers where job_id is equal to ST_CLERK;
If WITH READ ONLY is added on the view (see sample code below) what is/are the restriction?
It is a communication pathway between a user process and an Oracle Database instance.
This is used to delete child row when a parent key is deleted.
Which of the following is the example revoking a privilege to INSERT, UPDATE and DELETE to user ANNA from user BEN?
A single row of a table, which contains a single record for that relation.
To keep up this site, we need your assistance. A little gift will help us alot.
Donate- The more you give the more you receive.
Related SubjectRelational Database Systems
Management Accounting
Advanced Database Management Systems
Fundamentals of Database System
Emergency and Disaster Management
Risk Management Applied to Safety Security and Sanitation
Shopee Helmet
Shopee 3D Floor
Lazada Smart TV Box