Test: Structured Query Language - 2 - CUET Humanities MCQ

# Test: Structured Query Language - 2 - CUET Humanities MCQ

Test Description

## 10 Questions MCQ Test Computer Science Practice Tests: CUET Preparation - Test: Structured Query Language - 2

Test: Structured Query Language - 2 for CUET Humanities 2024 is part of Computer Science Practice Tests: CUET Preparation preparation. The Test: Structured Query Language - 2 questions and answers have been prepared according to the CUET Humanities exam syllabus.The Test: Structured Query Language - 2 MCQs are made for CUET Humanities 2024 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for Test: Structured Query Language - 2 below.
Solutions of Test: Structured Query Language - 2 questions in English are available as part of our Computer Science Practice Tests: CUET Preparation for CUET Humanities & Test: Structured Query Language - 2 solutions in Hindi for Computer Science Practice Tests: CUET Preparation course. Download more important topics, notes, lectures and mock test series for CUET Humanities Exam by signing up for free. Attempt Test: Structured Query Language - 2 | 10 questions in 10 minutes | Mock test for CUET Humanities preparation | Free important questions MCQ to study Computer Science Practice Tests: CUET Preparation for CUET Humanities Exam | Download free PDF with solutions
Test: Structured Query Language - 2 - Question 1

### Which of the following is correct about NOT NULL constraint? A. NOT NULL constraint demands a column not to accept NULL values. B. NOT NULL constraint demands a field to always contains some value. C. One cannot insert a new record with a NULL value, when NOT NULL constraint is specified.

Detailed Solution for Test: Structured Query Language - 2 - Question 1

All A, B and C are correct. Option 4 is the correct answer.

Test: Structured Query Language - 2 - Question 2

### Default value of char is

Detailed Solution for Test: Structured Query Language - 2 - Question 2

Default value of char variable is 'u0000'.

 1 Crore+ students have signed up on EduRev. Have you?
Test: Structured Query Language - 2 - Question 3

### Which of the given statements are true? P : Foreign key cannot have a null value. Q : Primary key and foreign key can exist in same relation. R : Foreign key relation is known as target relation.

Detailed Solution for Test: Structured Query Language - 2 - Question 3

Q is a correct statement because the primary key and the foreign key can exist in the same relation. Moreover foreign key can refer to the primary key in the same relation. So this answer is correct.

Test: Structured Query Language - 2 - Question 4

Full form of DDL is

Detailed Solution for Test: Structured Query Language - 2 - Question 4

Full form of DDL is Data Definition Language.

Test: Structured Query Language - 2 - Question 5

Which of the following is used to add a new attribute (column) in the existing relation schema?

Detailed Solution for Test: Structured Query Language - 2 - Question 5

To add a new column to an existing table, use the ALTER TABLE ADD COLUMN statement as follows:
ALTER TABLE table_name

Test: Structured Query Language - 2 - Question 6

Which of the following SQL commands would you use to query data?

Detailed Solution for Test: Structured Query Language - 2 - Question 6

The SELECT command is used to select data from a database and query the data from the database.

Test: Structured Query Language - 2 - Question 7

SQL provides many powerful functions to help you manipulate data.These built-in functions fall into which of these following categories.

Detailed Solution for Test: Structured Query Language - 2 - Question 7

Error reporting, Character, Datatype conversion, Number, Date, Object, Reference, all of these are used in functions.

Test: Structured Query Language - 2 - Question 8

What would be the output of the following SQL query?
SQL> select ltrim(' Harish') from dual;

Detailed Solution for Test: Structured Query Language - 2 - Question 8

'Harish' would be the default output as the pattern specified with the function is not available on the left-side of the input. So, option 1 is correct.

Test: Structured Query Language - 2 - Question 9

Which of the following operations in DBMS is used to retrieve a combination of tuples in two relations based on a common field in both the relations?

Detailed Solution for Test: Structured Query Language - 2 - Question 9

JOIN in DBMS is used to retrieve combination of tuples in two relations based on a common field in both the relations.

Test: Structured Query Language - 2 - Question 10

Which of the following operations selects only some of the tuples in DBMS?

Detailed Solution for Test: Structured Query Language - 2 - Question 10

SELECTION is an operation that selects only some of the tuples in the relation.

## Computer Science Practice Tests: CUET Preparation

28 tests
Information about Test: Structured Query Language - 2 Page
In this test you can find the Exam questions for Test: Structured Query Language - 2 solved & explained in the simplest way possible. Besides giving Questions and answers for Test: Structured Query Language - 2, EduRev gives you an ample number of Online tests for practice

28 tests