Your browser does not support JavaScript!
TypicalSparrow just signed up and they study Information Technology 👩‍💻
MaleSalmon just signed up and they study Real Estate Management 🏘️
LightSilverfish just signed up and they study Information Technology 👩‍💻
ConceptualSpider just signed up and they study Hotel Management 🏨
AmericanHare upvoted the question #3996.
RationalCamel just signed up and they study Psychology 😌
LooseReptile just signed up and they study Real Estate Management 🏘️
MarginalTapir just signed up and they study Information Technology 👩‍💻
CautiousOwl downvoted the question #5873.
CautiousOwl just signed up and they study Economics 💵
AMA University Answers
Earn money Login Register

Database Management System 2 (Oracle 10g Admin)

Showing 1-75 of 190 answers

A join condition that is based on all the columns in two or more table that have the same name.
  • Natural Join Correct
153
A join condition used when a table has columns with match values.
  • Self-Join Correct
118
A process where an application waits indefinitely to obtain any needed locks.
  • Lockwait Correct
240
A single row of a table, which contains a single record for that relation.
  • Tuple Correct
250
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.
  • Isolation Correct
188
A state of the data where a transaction must be fully complete, saved (committed) or completely undone (rolled back).
  • Atomicity Correct
193
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.
  • Consistency Correct
176
A state where a transaction data changes must be available, even in the event of database failure.
  • durability Correct
33
A transaction ends when either of the following occurs. (Choose 5)
  • The correct answers are: CREATE TABLE is issued, The user closes the isqlplus, The user type in Commit, The user encounter system failure, The user type in Rollback Correct
222
A transaction start when the first ____________ is issued.
  • DML Correct
249
A type constraint that uniquely identifies each record in a database table and can be applied on one or more column.
  • Unique Correct
211
A type of constraint that ensures the relationship between tables remain preserved as data is inserted, deleted and modified.
  • Foreign key Correct
237
A type of constraint that is used to insert a default value into a column.
  • Default Correct
285
A type of constraint that is used to limit the value range that can be placed in a column.
  • Check Correct
202
A type of constraint uniquely identifies each record in a database table.
  • Primary key Correct
276
A type of lock that is acquired when an application updates, inserts, or deletes a row.
  • Exclusive Lock (X Lock) Correct
254
A type of lock that is acquired when an application wants to read and prevent others from updating the same row.
  • Sharelock (S locks) Correct
245
A type of model that is based on the notion of real-world entities and relationships among them.
  • Entity Relationship Model Correct
255
A type of that do not exist in the physical database, but their values are derived from other attributes present in the database.
  • Derived Attribute Correct
219
A type of transaction that is ends the current transactions by making all pending data changes permanent.
  • COMMIT Correct
129
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.
  • ROLLBACK TO SAVEPOINT Correct
205
Also known as Oracle Database backup and restore operations
  • Large Pool Correct
191
Also known as the application or tool that connects to the Oracle Database Processes
  • session Correct
232
An automatic commit is issued by the Oracle Server under the following circumstances. (Choose 2)
  • The correct answers are: CREATE TABLE is issued, Closes the sqlplus normally by typing exit Correct
30
An automatic rollback is issued by the oracle under the following circumstances. (Choose 2)
  • The correct answers are: The user encounter system failure, Closes the sqlplus normally by closing he isqlplus using x button Correct
202
1
Based on the table EMPLOYEES, DEPARTMENTS and LOCATIONS.
  • KOCHAR, NENA and LEX, DE HAAN Correct
177
Holds information about changes made to the database
  • Redo Log Buffer Correct
171
If WITH CHECK OPTION is added on the view (see sample code below) what is/are the restriction?
  • It restricts the users to add a value where course is equal to BSCS onlyCorrec Correct
216
If WITH READ ONLY is added on the view (see sample code below) what is/are the restriction?
  • NO DML operations allowed on this view. Correct
91
In planning to install Oracle which of the following is not important to consider.
  • Any Oracle version will do even when multiple products are involved. Correct
169
In the given complex view example what will be the possible output if this code is run?
  • Cause an error because the JOIN condition is omitted. Correct
181
It holds information about changes made to the database
  • Redo Log Buffer Correct
226
It is a collection of data treated as a unit with the main purpose of storing and retrieving related information in the database.
  • Oracle Database Correct
215
It is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information.
  • Oracle database Correct
244
It is a communication between a user process and an instance
  • Connection Correct
169
1
It is a communication pathway between a user process and an Oracle Database instance.
  • Connection Correct
249
It is a join of two or more table that returns only matched rows.
  • Inner Join Correct
267
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.
  • Role Correct
179
It is a state of operational database with data at any given time.
  • Database Instance Correct
305
1
It is a type a Oracle environment where Oracle Products run.
  • ORACLE_HOME Correct
39
It is a type of privilege that gain access to the database
  • System Correct
206
It is a type of privilege that is used to manipulating the content of the database objects.
  • Object Correct
154
1
It is a type of process structure that automatically connects to other databases involved in in- doubt distributed transactions
  • Recoverer Process Correct
242
It is a type of process structure that can collect transaction, redo data and transmit that data to standby destinations
  • Archiver Processes (ARCn) Correct
45
1
It is a type of process structure that can collect transaction, redo data and transmit that data to standby destinations.
  • Archiver Processes (ARCn) Correct
233
1
It is a type of process structure that cleans up the database buffer cache
  • Process Monitor Process (PMON) Correct
195
It is a type of process structure that records checkpoint information in Control file on each data file header
  • Checkpoint Process (CKPT) Correct
232
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
  • Database Writer Process (DBWn) Correct
375
It is a type of process structure that writes the redo log buffer to a redo log file on disk
  • Log Writer Process (LGWR) Correct
95
It is a type process structure that automatically connects to other databases involved in in- doubt distributed transactions.
  • Checkpoint Process (CKPT) Correct
261
It is a type process structure that cleans up the database buffer cache
  • Process Monitor Process (PMON) Correct
61
It is a type process structure that records checkpoint information in Control file on each data file header.
  • Checkpoint Process (CKPT) Correct
29
It is also known as specific connection of a user to an instance through a user process
  • Session Correct
59
1
It is an attribute or collection of attributes that uniquely identifies an entity among entity set.
  • Key Correct
241
It is formed when a join condition is omitted.
  • Cartesian Product Correct
256
It is join between two tables that return the result of an Inner Join as well as the results of Left and Right joins.
  • Outer Join Correct
225
It is part of the System Global Area (SGA) that hold copies of data blocks that are read from data files
  • Data Buffer Cache Correct
200
1
It is part of the System Global Area (SGA) that hold copies of data blocks that are read from data files.
  • Data Buffer Cache Correct
171
1
It is part of the System Global Area which is used to provide memory for Oracle Streams processes
  • Java Pool Correct
371
1
It is the key in solving the problems of information management.
  • Database Server Correct
37
It is the key to solving the problems of information management.
  • Database server Correct
285
It is the skeleton structure that represents the logical view of the entire database.
  • Database Schema Correct
179
It is used to ensure that data values inside a database follow defines rules for values, range and format
  • Domain Intergrity Correct
35
It is used to ensures that data values inside a database follow defines rules for values, range and format
  • Domain Intergrity Correct
248
It occurs when two or more applications wait indefinitely for a resources.
  • Deadlock Correct
195
It represents the state of a current user login to the database instance.
  • session Correct
31
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?
  • The record of book OS will be removed in the COPY_AUTHORS view since its YR_PUBLIHED is updated to 2016 Correct
182
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?
  • Unique constraint is violated on AUTHORS table Correct
243
SELECT EMPLOYEES.EMPLOYEE_ID, EMPLOYEES.LASTNAME,EMPLOYEES.DEPARTMENT_ID,DEPARTMENTS.DEPARTMENT_ID,DEPARTMENTS.LOCATION_ID
  • The given statement is Outer Join Correct
50
SELECT EMPLOYEES.EMPLOYEE_ID, EMPLOYEES.LASTNAME,EMPLOYEES.DEPARTMENT_ID,DEPARTMENTS.DEPARTMENT_ID,DEPARTMENTS.LOCATION_ID FROM EMPLOYEES JOIN DEPARTMENTS USING (DEPARTMENT_ID);
  • The given statement is not a valid join condition or is incorrect Correct
204
Supposed that a user performs the query as shown below, what will happen to the data?
  • The manager_id that is equal to null is now change to IT and the job_id of employees under department_id 50,90 or salary greater that 500 have been updated to secretary. Correct
189
Supposed that table: Workers and Employees is consists of the following values.
  • INSERT INTO EMPLOYEES(ID, LASTNAME, DEPARTMENT)SELECT ID, LASTNAME, DEPARTMENTFROM WORKERSWHERE STATUS = ‘Regular’; Correct
238
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.
  • Transaction Correct
42
This is a join clause that produces a cross-product of two or more tables.
  • Cartesian Product Correct
186
This is a join clause used to specify arbitrary conditions of specify columns to join.
  • ON Correct
216
Search
Need to search and CTRL+F on AMA modules?
All courses