details

Result for: Ankit Pradhan

Exam Name: DATABASE

Download Result (PDF)

Total Marks: 25.0

Score: 3.0

Percentage: 12.00%

Question Answers

Sr. No.	Question	Selected Answer	Correct Answer
1	Which of the following is NOT a valid keyword in SQL?	INCLUDE	INCLUDE
2	Which of the following is basis for SQL?	RDBMS	RDBMS
3	Which statement(s) are mandatory in a simple SQL SELECT statement?	Select, From	Select, From
4	Which of the following is a default join type?	No answer selected	Inner join
5	Which of the following command is used to create a database in SQL?	No answer selected	CREATE
6	Which of the following SQL statement selects only unique values from ‘section’ column of table ‘school’?	No answer selected	SELECT DISTINCT section FROM school;
7	What is the full form of PL in PL/SQL?	No answer selected	Procedural Language
8	Which SQL keyword is used to sort the data returned by a SELECT statement?	No answer selected	Order By
9	The SQL LIKE operator is used in which of the following clause?	No answer selected	Where
10	In SQL, which of the following constraint is used to uniquely identify each record in a table?	No answer selected	PRIMARY KEY
11	Which of the following statement can be used to apply the PRIMARY KEY constraint to a column of an existing table?	No answer selected	ALTER TABLE TABLE_NAME ADD PRIMARY KEY (column_name);
12	A sub-program is called as which of the following when it does not return any value directly?	No answer selected	Procedures
13	In how many parts does a PL/SQL sub-program is divided into?	No answer selected	3
14	Which of the following are the 3 parameter modes for a procedure in PL/SQL?	No answer selected	IN, OUT, IN OUT
15	Which of the following keyword is used to call a standalone procedure?	No answer selected	EXECUTE
16	Which of the following is a default mode for a parameter when it’s mode is not specified?	No answer selected	IN
17	The “ OR REPLACE” option in the definition of a function in PL/SQL is used to modify an existing function. The “ OR REPLACE” option in the definition of a function in PL/SQL is used to modify an existing function. a) True b) False	No answer selected	True
18	How many columns can be copied using a SELECT INTO statement?	No answer selected	Any number of columns
19	Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.	No answer selected	Having, where
20	Which of the following is not an aggregate function?	No answer selected	WITH
21	How many times does a statement/table level trigger is executed for each transaction?	No answer selected	1
22	Triggers are automatically executed. a) True b) False	No answer selected	True
23	In SQL, views can also call as which of the following?	No answer selected	Virtual Table
24	In SQL, which of the following statement can be used to create a view?	No answer selected	CREATE VIEW view_name AS SELECT column1, column2..... columnn FROM TABLE_NAME WHERE condition;
25	. Which of the following statement can be used to drop a view in SQL?	No answer selected	DROP VIEW view_name;

Page 1

Go to results

Back to home