gs gs117 Concurrency Control - Insertion Deletion Predicate Reads - Quiz No.1
gs gs117 Database Management System Quiz
This quiz belongs to book/course code gs gs117 Database Management System of gs organization. We have 92 quizzes available related to the book/course Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Concurrency Control. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which statements are correct regarding indexes?
When a table is dropped, the corresponding indexes are automatically dropped
For each DML operation performed, the corresponding indexes are automatically updated
A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index
All of the mentioned
Question 2: You executed the following SQL statements in the given order:
CREATE TABLE orders (order_id NUMBER(3) PRIMARY KEY, order_date DATE, customer_idnumber(3)); INSERT INTO orders VALUES (100,'10-mar-2007,,222); ALTER TABLE orders MODIFY order_date NOT NULL; UPDATE orders SET customer_id=333; DELETE FROM order; The DELETE statement results in the following error:
ERROR at line 1: table or view does not exist
What would be the outcome?
All the statements before the DELETE statement would be rolled back
All the statements before the DELETE statement would be implicitly committed within the session
All the statements up to the ALTER TABLE statement would be committed and the outcome of UPDATE statement would be rolled back
All the statements up to the ALTER TABLE statement would be committed and the outcome of the UPDATE statement is retained uncommitted within the session
Question 3: Evaluate the following statements:
CREATE TABLE digits (id NUMBER(2), description VARCHAR2(15)); INSERT INTO digits VALUES (1,'ONE); UPDATE digits SET description ='TWO'WHERE id=1; INSERT INTO digits VALUES (2 ,'TWO'); COMMIT; DELETE FROM digits; SELECT description FROM digits VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE; What would be the outcome of the above query?
It would not display any values
It would display the value TWO once
It would display the value TWO twice
It would display the values ONE, TWO, and TWO
Question 4: A non-correlated subquery can be defined as________
A set of sequential queries, all of which must always return a single value
A set of sequential queries, all of which must return values from the same table
A SELECT statement that can be embedded in a clause of another SELECT statement only
A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query
Question 5: Which statement is true regarding synonyms?
Synonyms can be created for tables but not views
Synonyms are used to reference only those tables that are owned by another user
A public synonym and a private synonym can exist with the same name for the same table
The DROP SYNONYM statement removes the synonym, and the status of the table on which the synonym has been created becomes invalid
Question 6: SCOTT is a user in the database.
Evaluate the commands issued by the DBA: 1 - CREATE ROLE mgr; 2 - GRANT CREATE TABLE, SELECT ON oe. orders TO mgr; 3 - GRANT mgr, create table TO SCOTT; Which statement is true regarding the execution of the above commands?
Statement 1 would not execute because the WITH GRANT option is missing
Statement 1 would not execute because the IDENTIFIED BY clause is missing
Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement
Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command
Question 7: OE and SCOTT are the users in the database. The ORDERS table is owned by OE. Evaluate the statements issued by the DBA in the following sequence:
CREATE ROLE r1; GRANT SELECT, INSERT ON oe. orders TO r1; GRANT r1 TO scott; GRANT SELECT ON oe. orders TO scott; REVOKE SELECT ON oe.orders FROM scott; What would be the outcome after executing the statements?
SCOTT would be able to query the OE.ORDERS table
SCOTT would not be able to query the OE.ORDERS table
The REVOKE statement would remove the SELECT privilege from SCOTT as well as from the role R1
The REVOKE statement would give an error because the SELECT privilege has been granted to the role R1
Question 8: Given below are the SQL statements executed in a user session:
CREATE TABLE product (pcode NUMBER(2), pnameVARCHAR2(10)); INSERT INTO product VALUES(1, 'pen'); INSERT INTO product VALUES (2,'penci'); SAVEPOINT a; UPDATE product SET pcode = 10 WHERE pcode = 1; SAVEPOINT b; DELETE FROM product WHERE pcode = 2; COMMIT; DELETE FROM product WHERE pcode=10; ROLLBACK TO SAVEPOINT a; Which statement describes the consequences?
No SQL statement would be rolled back
Both the DELETE statements would be rolled back
Only the second DELETE statement would be rolled back
Both the DELETE statements and the UPDATE statement would be rolled back
Question 9: Evaluate the following command:
CREATE TABLE employees (employee_id NUMBER(2) PRIMARY KEY, last_name VARCHAR2(25) NOT NULL, department_id NUMBER(2), job_id VARCHAR2(8), salary NUMBER(10,2)); You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization: CREATE OR REPLACE VIEW sales_staff_vu AS SELECT employee_id, last_name job_id FROM employees WHERE job_id LIKE 'SA_%' WITH CHECK OPTION; Which statements are true regarding the above view?
It allows you to insert details of all new staff into the EMPLOYEES table
It allows you to delete the details of the existing sales staff from the EMPLOYEES table
It allows you to update the job ids of the existing sales staff to any other job id in the EMPLOYEES table
It allows you to insert the IDs, last
Question 10: EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?
UPDATE empdet SET ename = 'Amit' WHERE empno = 1234;DELETE FROM empdet WHERE ename LIKE 'J%';CREATE VIEW empvu AS SELECT* FROM empdept;CREATE INDEX empdet_idx ON empdet(empno);Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117
Database Management System Online Quizzes
