MCQOPTIONS

Explore topic-wise MCQs in Testing Subject.

This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.

1.	create view studentdetselect ID, address, namefrom student;What is the result of the above query?
A.	It creates a view named studentdet with 3 attributes
B.	It creates a view named studentdet with 1 attribute
C.	It creates a view named ID with 2 attributes
D.	It is syntactically wrong and does not give a result
Answer» E.

2.	How can we insert data into a view?
A.	Insert into (),
B.	Create data values (),
C.	Enter (),
D.	Insert into values (),
Answer» E.

3.	What does the following condition do?check( name in( Ryan , Cristiano , Leo ))
A.	The condition checks whether the name attribute includes the three mentioned names
B.	The condition allows the name attribute to possess only the three mentioned names
C.	The condition checks whether the given names are sub-strings in at least one of the values
D.	None of the mentioned
Answer» C. The condition checks whether the given names are sub-strings in at least one of the values

4.	customer_name, loan_number, amount (borrower loan)What does the above expression perform?
A.	It finds the customer_name, loan_number and amount from borrower
B.	It finds the customer_name, loan_number and amount from loan
C.	It finds the customer_name, loan_number and amount from the full outer join of borrower and loan
D.	It finds the customer_name, loan_number and amount from the natural join of borrower and loan
Answer» E.

5.	What type of join is this?
A.	Equi join
B.	Hash join
C.	Nested loop join
D.	Block nested loop join
Answer» D. Block nested loop join

6.	Which JDBC Driver is the most efficient of all the JDBC drivers?
A.	Type 1 Driver
B.	Type 2 Driver
C.	Type 3 Driver
D.	Type 4 Driver
Answer» E.

7.	What does the following relational operation perform? x(A1,A2,A3 ) (E)
A.	It returns the result of expression E with the previous attribute names
B.	It returns the result of expression E renaming the attributes as A1, A2,
C.	It returns the result of the relation E but saves the old attributes
D.	None of the mentioned
Answer» C. It returns the result of the relation E but saves the old attributes

8.	What does p indicate in the following data type?time(p)
A.	The amount of delay that needs to be added to the time
B.	The number of fractional digits for the seconds
C.	The maximum number of allowed hours
D.	None of the mentioned
Answer» C. The maximum number of allowed hours

9.	What does the following statement do?create table temp_inst like institute
A.	It creates a new relation temp_inst with all the tuples and attributes of the institute relation
B.	It creates a new relation temp_inst with the same schema as that of the institute relation
C.	It creates a new relation named temp_inst with institute as its only attribute
D.	It does not create any relations and returns an error
Answer» C. It creates a new relation named temp_inst with institute as its only attribute

10.	revoke select on takes from amit;What does the above query perform?
A.	It revokes all authorizations from amit
B.	It revokes select authorization from amit
C.	It revokes takes authorization from amit
D.	It gives an error
Answer» C. It revokes takes authorization from amit

11.	What does the following relational algebra expression do? amount > 1200 (loan)
A.	Finds all the tuples in loan
B.	Finds the tuples in loan where the amount is greater than 12000
C.	Finds all the tuples in loan where the amount is greater than 1200
D.	Finds all the amounts in loan where the number of values is greater than 1200
Answer» D. Finds all the amounts in loan where the number of values is greater than 1200

Previous Next