457541691 Midterms Attempt 1 43 50zzzggg docx PDF

Preview

Summary

Question 1Answer savedMarked out of 1.Flag questionQuestion textWhich one (1) DCL (Data Control Langauge) is considered as part of Database TransactionSelect one: a. COMMIT b. ROLLBACK TO SAVEPOINT c. SAVEPOINT d. ROLLBACK Clear my choiceQuestion 2Answer savedMarked out of 1.Flag questionQuestion te...

Description

Question 1 Answer saved Marked out of 1.00

Flag question

Question text Which one (1) DCL (Data Control Langauge) is considered as part of Database Transaction Select one: a. COMMIT b. ROLLBACK TO SAVEPOINT c. SAVEPOINT d. ROLLBACK Clear my choice Question 2 Answer saved Marked out of 1.00

Flag question

Question text Which of the following statement is not true about Foreign Key constraint. Select one: a. The foreign key constraint is used to prevent actions that would destroy links between tables. b. The foreign key constraint also prevents invalid data from being inserted into the foreign key column, because it has to be one of the values contained in the table it points to. c. Ensures that the relationship between tables remain preserved as data is inserted, deleted and modified d. A foreign key in one table points to a foreign key in another table. Clear my choice

Question 3 Answer saved Marked out of 1.00

Flag question

Question text This is the fundamental entity which introduces abstraction in a Database Management System (DBMS). Select one: a. Entity Relationship Model b. Entity Relationship Diagram c. This is the fundamental entity which introduces abstraction in a Database Management System (DBMS). d. Data Model Clear my choice Question 4 Answer saved Marked out of 1.00

Flag question

Question text Which of the following is the correct representation of one-to-one relation? Select one: a. b. c.

d. Clear my choice Question 5 Answer saved Marked out of 1.00

Flag question

Question text A type constraint that uniquely identifies each record in a database table and can be applied on one or more column. Select one: a. Unique b. Primary key c. Foreign key d. Check Clear my choice Question 6 Answer saved Marked out of 1.00

Flag question

Question text This is also known as unit of work. Select one: a. Database Transaction b. Data Control Language c. Transaction

d. Database Processes Clear my choice Question 7 Answer saved Marked out of 1.00

Flag question

Question text It is a state of operational database with data at any given time. Select one: a. Data Instance b. Logical Data Instance c. Physical Data Instance d. Database Instance Clear my choice Question 8 Answer saved Marked out of 1.00

Flag question

Question text It is the skeleton structure that represents the logical view of the entire database. Select one: a. Database Schema b. Entity Relationship Model c. Entity Relationship Diagram d. Data Model Clear my choice

Question 9 Answer saved Marked out of 1.00

Flag question

Question text Which of the following is the correct example of dropping on delete cascade? Select one: a. ALTER TABLE AUTHORS DROP PRIMARY KEY; b. ALTER AUTHORS DROP PRIMARY KEY CASCADE; c. ALTER TABLE AUTHORS DROP PRIMARY KEY ON DELETE CASCADE; d. ALTER TABLE AUTHORS DROP PRIMARY KEY CASCADE; Clear my choice Question 10 Answer saved Marked out of 1.00

Flag question

Question text Which of the following is the correct example of adding a check constraint on column BOOK_ID to accept value greater that 10? Select one: a. CREATE TABLE BOOKS( BOOK_ID NUMBER, TITLE VARCHAR(10), YEAR NUMBER(4), CONSTRAINT BK_ID CHECK (BOOK_ID > 10));

b. CREATE BOOKS( BOOK_ID NUMBER, TITLE VARCHAR(10), YEAR NUMBER(4), CONSTRAINT BK_ID CHECK (BOOK_ID > 10)); c. CREATE TABLE BOOKS( BOOK_ID NUMBER, TITLE VARCHAR(10), YEAR NUMBER(4), CONSTRAINT BK_ID CHECK KEY (BOOK_ID > 10)); d. CREATE BOOKS( BOOK_ID NUMBER, TITLE VARCHAR(10), YEAR NUMBER(4), CONSTRAINT BK_ID CHECK KEY (BOOK_ID > 10)); Clear my choice Question 11 Answer saved Marked out of 1.00

Flag question

Question text 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. Select one: a. Transaction b. Data manipulation language c. Data control language d. DBMS Clear my choice Question 12 Answer saved Marked out of 1.00

Flag question

Question text Which of the following is the correct example of derived attribute? Select one: a.

b.

c. None d.

Clear my choice Question 13 Answer saved Marked out of 1.00

Flag question

Question text A type of lock that is acquired when an application wants to read and prevent others from updating the same row. Select one: a. Sharelock (S locks) b. Special Lock (Sp lock) c. Exclusive Lock (X Lock)

d. Private Lock (P Lock) Clear my choice Question 14 Answer saved Marked out of 1.00

Flag question

Question text 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. Select one: a. Durability b. Atomicity c. Isolation d. Consistency Clear my choice Question 15 Answer saved Marked out of 1.00

Flag question

Question text It is used to ensures that data values inside a database follow defines rules for values, range and format Select one: a. Not Null b. Referential Itegrity c. Entity Itegrity d. Domain Intergrity

Clear my choice Question 16 Answer saved Marked out of 1.00

Flag question

Question text Which of the following is not possible causes of lock. Select one: a. Lost Update b. Long-running transactions c. Uncommitted changes d. Unnecessarily high locking levels Clear my choice Question 17 Answer saved Marked out of 1.00

Flag question

Question text A type of constraint that is used to insert a default value into a column. Select one: a. Unqiue b. Check c. Default d. Not Null Clear my choice Question 18

Answer saved Marked out of 1.00

Flag question

Question text A transaction start when the first ____________ is issued. Select one: a. DCL b. DDL c. SELECT d. DML Clear my choice Question 19 Answer saved Marked out of 1.00

Flag question

Question text A type of lock that is acquired when an application updates, inserts, or deletes a row. Select one: a. Special Lock (Sp lock) b. Private Lock (P Lock) c. Exclusive Lock (X Lock) d. Sharelock (S locks) Clear my choice Question 20 Answer saved Marked out of 1.00

Flag question

Question text A type of constraint that is used to limit the value range that can be placed in a column. Select one: a. Not Null b. Check c. Default d. Unqiue Clear my choice Question 21 Answer saved Marked out of 1.00

Flag question

Question text A transaction ends when either of the following occurs EXCEPT: Select one: a. CREATE TABLE is issued b. The user type in Rollback c. The user type in Commit d. CREATE VIEW is issued e. The user encounter system failure f. The user closes the isqlplus Clear my choice Question 22 Answer saved Marked out of 1.00

Flag question

Question text Supposed that a user performs the query as shown below, what will happen to the data? UPDATE EMPLOYEES SET JOB_ID = ‘IT’, SALARY =10000 WHERE MANAGER_ID IS NULL; SAVEPOINT UPDATE_IT; UPDATE EMPLOYEES SET JOB_ID = ‘SECRETARY’ WHERE DEPARTMENT IN (50,90) OR SALARY > 500; SAVEPOINT UPDATE_IT; ROLLBACK; Select one: a. 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 than 500 have been updated to secretary. b. Savepoints are saved. c. No changes made on employees table. d. The manager_id that is equal to null has been updated to IT. Clear my choice Question 23 Answer saved Marked out of 1.00

Flag question

Question text

Which of the following is the correct example of referencing the BOOKS table to AUTHORS? Select one: a. CREATE TABLE BOOKS( BOOK_ID NUMBER PRIMARY KEY NOT NULL, TITLE VARCHAR(10), YEAR NUMBER(4), CONSTRAINT BK_ID (BOOK_ID) REFERENCES AUTHORS (BOOK_ID)); b. CREATE TABLE BOOKS( BOOK_ID NUMBER PRIMARY KEY NOT NULL, TITLE VARCHAR(10), YEAR NUMBER(4), CONSTRAINT BK_ID FOREIGN KEY(BOOK_ID) REFERENCES AUTHORS (BOOK_ID)); c. CREATE TABLE BOOKS( BOOK_ID NUMBER PRIMARY KEY NOT NULL, TITLE VARCHAR(10), YEAR NUMBER(4), CONSTRAINT BK_ID FOREIGN KEY(BOOK_ID) REFERENCE AUTHORS (BOOK_ID)); d. CREATE BOOKS( BOOK_ID NUMBER PRIMARY KEY NOT NULL, TITLE VARCHAR(10), YEAR NUMBER(4), CONSTRAINT BK_ID FOREIGN KEY(BOOK_ID) REFERENCES TABLE AUTHORS (BOOK_ID)); Clear my choice Question 24 Answer saved Marked out of 1.00

Flag question

Question text Supposed that a user performs the query as shown below, what will happen to the data? UPDATE EMPLOYEES SET JOB_ID = ‘IT’, SALARY =10000 WHERE MANAGER_ID IS NULL;

SAVEPOINT UPDATE_IT; UPDATE EMPLOYEES SET JOB_ID = ‘SECRETARY’ WHERE DEPARTMENT IN (50,90) OR SALARY > 500; SAVEPOINT UPDATE_SECRETARY; ROLLBACK TO UPDATE_IT; Select one: a. The manager_id that is equal to null has been updated to IT. b. No changes made on employees table. c. Savepoints are discarded. d. 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 than 5000 have been updated to secretary Clear my choice Question 25 Answer saved Marked out of 1.00

Flag question

Question text 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. Select one: a. Isolation b. Atomicity c. Durability d. Consistency Clear my choice Question 26 Answer saved Marked out of 1.00

Flag question

Question text Supposed that a user performs the query as shown below, what will happen to the data? UPDATE EMPLOYEES SET JOB_ID = ‘IT’, SALARY =10000 WHERE MANAGER_ID IS NULL; SAVEPOINT UPDATE_IT; UPDATE EMPLOYEES SET JOB_ID = ‘SECRETARY’ WHERE DEPARTMENT IN (50,90) OR SALARY > 500; SAVEPOINT UPDATE_IT; ROLLBACK TO UPDATE_IT; Select one: a. Savepoints are discarded. b. The manager_id that is equal to null has been updated to IT. c. No changes made on employees table. d. 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. Clear my choice Question 27 Answer saved Marked out of 1.00

Flag question

Question text

An automatic commit is issued by the Oracle Server under the following circumstances. Select one or more: a. Closes the sqlplus normally by closing he isqlplus using x button b. The user encounter system failure c. Closes the sqlplus normally by typing exit d. CREATE TABLE is issued Question 28 Answer saved Marked out of 1.00

Flag question

Question text Which of the following is the correct example of an attributes? Select one: a. USN_ID b. Student c. Teacher d. Department Clear my choice Question 29 Answer saved Marked out of 1.00

Flag question

Question text A type of constraint uniquely identifies each record in a database table. Select one: a. Primary key

b. Foreign key c. Unique d. Check Clear my choice Question 30 Answer saved Marked out of 1.00

Flag question

Question text A type constraint that uniquely identifies each record in a database table and can be applied on one or more column. Select one: a. Foreign key b. Primary key c. Unique d. Check Clear my choice Question 31 Answer saved Marked out of 1.00

Flag question

Question text A type of constraint that ensures the relationship between tables remain preserved as data is inserted, deleted and modified. Select one: a. Primary key b. Foreign key

c. Unique and Primary Key d. Unique Clear my choice Question 32 Answer saved Marked out of 1.00

Flag question

Question text Which two of the following forms key itergrity constraint. Select one: a. Foreign Key and Unique b. Foreign key and Primary Key c. Primary Key and Unique d. Check and Not Null Clear my choice Question 33 Answer saved Marked out of 1.00

Flag question

Question text This is used to enable a currentlt disable constraint in the table definition. Select one: a. ENABLE CONSTRAINT b. ON DELETE CASCADE c. DISABLE CONSTRAINT d. DROP CASCADE

Clear my choice Question 34 Answer saved Marked out of 1.00

Flag question

Question text Which of the following is the correct example of create a default constraint. Select one: a. CREATE TABLE COURSE (CODE CHAR(4) PRIMARY KEY, TITLE VARCHAR(20), CONSTRAINT CODE_df DEFAULT(CODE 'BSIT')); b. CREATE TABLE COURSE (CODE CHAR(4) PRIMARY KEY, TITLE VARCHAR(20) DEFAULT ‘Invalid’)); c. CREATE TABLE COURSE (CODE CHAR(4) PRIMARY KEY, TITLE VARCHAR(20) CONSTRAINT CODE_df DEFAULT(CODE 'BSIT'); d. CREATE TABLE COURSE (CODE CHAR(4) PRIMARY KEY, TITLE VARCHAR(20), CONSTRAINT CODE_df DEFAULT(CODE BSIT)); Clear my choice Question 35 Answer saved Marked out of 1.00

Flag question

Question text Which of the following is the correct example of adding primary key constraint? Select one:

a. ALTER TABLE AUTHORS ADD CONSTRAINT AUTHOR_ID PRIMARY KEY NUMBER; b. ALTER TABLE AUTHORS ADD BK_ID PRIMARY KEY(NUMBER); c. ALTER TABLE AUTHORS ADD CONSTRAINT AUTHOR_ID PRIMARY KEY(NUMBER); d. ALTER TABLE AUTHORS ADD CONSTRAINT AUTHOR_ID PRIMARY KEY; Clear my choice Question 36 Answer saved Marked out of 1.00

Flag question

Question text A type of constraint uniquely identifies each record in a database table. Select one: a. Check b. Unique c. Primary key d. Foreign key Clear my choice Question 37 Answer saved Marked out of 1.00

Flag question

Question text Which of the following is the correct example of saving changes made on the table?

Select one: a. Type exit b. Save; c. Commit; d. CTRL + S Clear my choice Question 38 Answer saved Marked out of 1.00

Flag question

Question text Which of the following transaction rules is not included in the group? Select one: a. Durability b. Isolation c. Redundancy d. Atomicity Clear my choice Question 39 Answer saved Marked out of 1.00

Flag question

Question text It occurs when two or more applications wait indefinitely for a resources. Select one: a. Deadlock

b. Podlock c. Lock d. Lock wait Clear my choice Question 40 Answer saved Marked out of 1.00

Flag question

Question text Supposed that a user performs the query as shown below, what will happen to the data? UPDATE EMPLOYEES SET JOB_ID = ‘IT’ WHERE MANAGER_ID IS NULL; SAVEPOINT UPDATE_IT; UPDATE EMPLOYEES SET JOB_ID = ‘SECRETARY’ WHERE DEPARTMENT IN (50,90); SAVEPOINT UPDATE_IT; COMMIT; ROLLBACK; Select one: a. The job_id of employees under department_id 50,90 have been updated to secretary. b. Changes are made permanently. c. The manager_id that is equal to null has been updated to IT. d. Savepoints are saved. Clear my choice

Question 41 Answer saved Marked out of 1.00

Flag question

Question text This is used to delete child row when a parent key is deleted. Select one: a. DROP CASCADE b. ENABLE CONSTRAINT c. ON DELETE CASCADE d. DISABLE CONSTRAINT Clear my choice Question 42 Answer saved Marked out of 1.00

Flag question

Question text A state of the data where a transaction must be fully complete, saved (committed) or completely undone (rolled back). Select one: a. Atomicity b. Isolation c. Durability d. Consistency Clear my choice Question 43 Answer saved Marked out of 1.00

Flag question

Question text A type of transaction that is ends the current transactions by making all pending data changes permanent. Select one: a. COMMIT b. SAVEPOINT c. ROLLBACK TO SAVEPOINT d. ROLLBACK Clear my choice Question 44 Answer saved Marked out of 1.00

Flag question

Question text This is used to deactivate an integrity constraint. Select one: a. DROP CASCADE b. ENABLE CONSTRAINT c. DISABLE CONSTRAINT d. ON DELETE CASCADE Clear my choice Question 45 Answer saved Marked out of 1.00

Flag question

Question text This is used to deactivate an integrity constraint. Select one: a. ON DELETE CASCADE b. DROP CASCADE c. DISABLE CONSTRAINT d. ENABLE CONSTRAINT Clear my choice Question 46 Answer saved Marked out of 1.00

Flag question

Question text 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. Select one: a. SAVEPOINT b. ROLLBACK TO SAVEPOINT c. COMMIT d. ROLLBACK Clear my choice Question 47 Answer saved Marked out of 1.00

Flag question

Question text It is used to ensures that data values inside a database follow defines rules for values, range and format Select one: a. Domain Intergrity b. Referential Itegrity c. Entity Itegrity d. Not Null Clear my choice Question 48 Answer saved Marked out of 1.00

Flag question

Question text Which of the following is the correct example of disabling an integrity constraint? Select one: a. ALTER TABLE STUDENTS MODIFY CONSTRAINT DISABLE usn_pk; b. ALTER TABLE STUDENTS DISABLE CONSTRAINT usn_pk; c. ALTER TABLE STUDENTS DROP CONSTRAINT usn_pk; d. ALTER TABLE STUDENTS DISABLE usn_pk; Clear my choice Question 49

Answer saved Marked out of 1.00

Flag question

Question text Which of the following is the correct example of enabling constraint? Select one: a. ALTER TABLE BOOKS ENABLE CONSTRAINT STUD_ID; b. ALTER TABLE BOOKS ENABLE COLUMN CONSTRAINT STUD_ID; c. ALTER BOOKS ENABLE CONSTRAINT STUD_ID; d. ALTER TABLE BOOKS ENABLE STUD_ID; Clear my choice Question 50 Answer saved Marked out of 1.00

Flag question

Question text A state where a transaction data changes must be available, even in the event of database failure. Select one: a. Atomicity b. durability c. Consistency d. Isolation Clear my choice

43/50...