details

Result for: Pranali Yemale

Exam Name: DATABASE

Download Result (PDF)

Total Marks: 25.0

Score: 22.0

Percentage: 88.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?	Inner 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 DISTINCT section 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?	Order By	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 ADD PRIMARY KEY (column_name);	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?	Procedures	Procedures
13	In how many parts does a PL/SQL sub-program is divided into?	3	3
14	Which of the following are the 3 parameter modes for a procedure in PL/SQL?	IN, OUT, IN OUT	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	True	True
18	How many columns can be copied using a SELECT INTO statement?	Any number of columns	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.	Having, where	Having, where
20	Which of the following is not an aggregate function?	WITH	WITH
21	How many times does a statement/table level trigger is executed for each transaction?	INFINITE TIMES	1
22	Triggers are automatically executed. a) True b) False	True	True
23	In SQL, views can also call as which of the following?	Virtual Table	Virtual Table
24	In SQL, which of the following statement can be used to create a view?	CREATE VIEW view_name AS SELECT column1, column2..... columnn FROM TABLE_NAME WHERE condition;	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?	DROP VIEW view_name;	DROP VIEW view_name;

Page 1

Go to results

Back to home