vu cs403 Final Term - Quiz No.1
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: A super key that does not contain a subset of attributes that is itself a super key is called a __________.
candidate key
primary key
superkey
secondary key
Question 2: Which of the following is not true regarding DB transactions?
A set of database operations that are processed partly
A database transaction is a logical unit of database operations
A database transaction must be atomic
A database transaction must contains the ACID property
Question 3: Which of the following will be deleted relating to a table if you use TRUNCATE command?
all rows in a table
indexes
table structure and its columns
constraints
Question 4: Which of the following is correct?
The relation Interview is in 3NF
The relation Interview is in BCNF.
The FD3 violates 3NF.
The FD2 violates 2NF
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
Has an error - the string should be in double quotes
Has an error - ORDER BY clause.
Does not have an error.
Has an error - the string in single quotes 'NORTH' and 'SOUTH'.
Question 6: The log file is also called __________.
Non Transaction file
Transaction file
Temporary file
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?
SELECT * FROM WORKER WHERE joining_Year>1965;
SELECT * FROM WORKER WHERE joining_Year>'1965';
SELECT * FROM WORKER AND joining_Year>'1965';
SELECT * WHERE joining_Year>1965;
Question 9: Database management systems, operating systems, applications and utilities are all examples of __________.
hardware
software
computer infrastructure
input and output
Question 10: An entity can be logically connected to another by defining a __________.
hyperlink
common attribute
primary key
superkey
