details

Result for: GIDHAD VIDYA DHANAJI

Exam Name: DATABASE

Download Result (PDF)

Total Marks: 25.0

Score: 7.0

Percentage: 28.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?	DBMS	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?	Outer join	Inner join
5	Which of the following command is used to create a database in SQL?	CREATE	CREATE
6	Which of the following SQL statement selects only unique values from ‘section’ column of table ‘school’?	SELECT * FROM school;	SELECT DISTINCT section FROM school;
7	What is the full form of PL in PL/SQL?	Procedural Language	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?	Where	Where
10	In SQL, which of the following constraint is used to uniquely identify each record in a table?	PRIMARY KEY	PRIMARY KEY
11	Which of the following statement can be used to apply the PRIMARY KEY constraint to a column of an existing table?	ALTER TABLE TABLE_NAME column_name ADD PRIMARY KEY;	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?	Functions	Procedures
13	In how many parts does a PL/SQL sub-program is divided into?	2	3
14	Which of the following are the 3 parameter modes for a procedure in PL/SQL?	READ, WRITE, APPEND	IN, OUT, IN OUT
15	Which of the following keyword is used to call a standalone procedure?	CALL	EXECUTE
16	Which of the following is a default mode for a parameter when it’s mode is not specified?	IN	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