All MCQs Tests - VU CS403 - Database Management Systems

Question 1: A super key that does not contain a subset of attributes that is itself a super key is called a __________.

Question 2: Which of the following is not true regarding DB transactions?

Question 3: Which of the following will be deleted relating to a table if you use TRUNCATE command?

Question 4: Which of the following is correct?

Question 5: Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order ByCUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS WhereREGION = 'E' Order By CUSTOMERThe above statement

Question 6: The log file is also called __________.

Question 7: Suppose there are 4 fields in a table named WORKER (Id, first_name, last_name, joining_year). Which of thefollowing gives all the information of the workers who have joined after 1965?

Question 8: Which of the following types of partitioning reduces the chances of unbalanced partitions?

Question 9: Database management systems, operating systems, applications and utilities are all examples of __________.

Question 10: An entity can be logically connected to another by defining a __________.