vu cs403 Final Term - Quiz No.8
vu cs403 Database Management Systems Quiz
This quiz belongs to book/course code vu cs403 Database Management Systems of vu organization. We have 18 quizzes available related to the book/course Database Management Systems. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Final Term. 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 of the following is not a feature of TRANSACTION?
Users should be able to regard the execution of each transaction as atomic
Each transaction, run by itself
must preserve the consistency of the database
dependant on other concurrent transactions
Question 2: Which of following is NOT generally the aim of data partitioning and placement of data?
Reduce Workload
Balance Workload
Merging different relations
Speed up rate of useful works.
Question 3: Which of the following is incorrect with respect to indexed sequential files?
New records are added to an overflow file
Record in main file that precedes it is updated to contain a pointer to the new record
The overflow is merged with the main file during a batch update
Multiple indexes for the same key field cannot be setup
Question 4: Which of the following is one of the purposes of using DML commands?
Creating databases
Destroying databases
Inserting data in tables
Non of the above
Question 5: Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuringminimum data loss?
User accessible catalog
Data processing
Authorization service
Recovery service
Question 6: Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?
the number of columns in the first table multiplied by the number of columns in the second table.
the number of columns in the first table multiplied by the number of rows in the second table.
the number of rows in the first table multiplied by the number of columns in the first table.
the number of rows in the first table multiplied by the number of rows in the second table.
Question 7: In a conceptual database model, which of the following most likely represents a valid identifier for a classgrades?
StudentID
StudentID, CourseID
StudentID, CourseID, InstructorID
StudentID, CourseSectionID
Question 8: Inverted files or inversions, Linked lists, B+ Trees, these are the three implementation approaches of __________.
Sequential Access
Hashing
Non sequential
Indexes
Question 10: GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION;What does this SQL statement do?
Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, onlyto update the designation from Employee table.
Grant permission to Amali & Hiruni to retrieve data from Employee table
Grant permission to Hiruni in order to grant, select and update permission to Amali.
Grant permission to Amali and Hiruni to update all data except designation in Employee table
