Users Also Read
Read MCQ's/Objective questions
MCQ's Search Engine
Important Question
ASP.NET
Basic Computer Knowledge
Basic of Linux/Unix
C Language
C# Programming
C++ Programming
Computer Graphics
Computer Hardware
Computer Networking
Computer Security - Cyber crime & Laws
Data Structures & Algorithms
Database Management System
Digital Computer Electronics
HTML
Important File Extensions
Imp. Shortcut Keys used in Computer
Internet, Web & Email
Java - Concepts and Its Programming
Language Processors
Management Information System (MIS)
MS Access
MS Excel
MS Word
Operating System
PHP Basic
Power Point
Programming Languages
Software Engineering
System Analysis and Design (SAD)
System software & compiler design
Tally
VB.NET
Visual Basic
Home⇒ Computer Engineering⇒ Oracle sql and pl sql
1-Dont try to cram or spend more time here just read it fast and cover syllabus then practice MCQ's cheptor of same topic to check your progress. . |
2-Wrong options are also given but dont concentrate there, Right answer is in bold format. |
Q21 ⇒ Which of the following is the correct order of keywords for SQL SELECT statements? SELECT, FROM, WHERE [other wrong options] [Discuss in forum] FROM, WHERE, SELECT WHERE, FROM,SELECT SELECT,WHERE,FROM |
Q22 ⇒ How does Tomcat execute a JSP? By one of Tomcat's threads [other wrong options] [Discuss in forum] As a CGI script As an independent process None of the above is correct. |
Q23 ⇒ Which of the following do you need to consider when you make a table in SQL? All of the above. [other wrong options] [Discuss in forum] Data types Primary keys Default values |
Q24 ⇒ Which one of the following sorts rows in SQL? ORDER BY [other wrong options] [Discuss in forum] SORT BY ALIGN BY GROUP BY |
Q25 ⇒ How many JDBC driver types does Sun define? Four [other wrong options] [Discuss in forum] One Two Three |
Q26 ⇒ A JSP is transformed into a(n): Java servlet. [other wrong options] [Discuss in forum] Java applet. Either 1 or 2 above. Neither 1 nor 2 above. |
Q27 ⇒ JDBC stands for: Java Database Connectivity [other wrong options] [Discuss in forum] Java Database Components Java Database Control None of the above is correct. |
Q28 ⇒ Which of the following is one of the basic approaches for joining tables? All of the above [other wrong options] [Discuss in forum] Subqueries Union Join Natural join |
Q29 ⇒ Which of the following is true concerning triggers? They have an event, condition, and action. [other wrong options] [Discuss in forum] You do not create them with SQL. They execute against only some applications that access a database. They cannot cascade (cause another trigger to fire). |
Q30 ⇒ For what purposes are views used? All of the above are uses for SQL views. [other wrong options] [Discuss in forum] To hide columns only To hide rows only To hide complicated SQL statements only |
Q31 ⇒ The strictest transaction isolation level provided by SQL Server is called: SERIALIZABLE. [other wrong options] [Discuss in forum] REPEATABLE READ. READ COMMITTED. READ UNCOMMITTED. |
Q32 ⇒ With this type of index, the data are stored in the bottom level of the index and in the same order as that index. Clustered [other wrong options] [Discuss in forum] Nonclustered Primary Secondary |
Q33 ⇒ The command to remove rows from a table 'CUSTOMER' is: DELETE FROM CUSTOMER WHERE ... [other wrong options] [Discuss in forum] REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... |
Q34 ⇒ The SQL keyword(s) ________ is used with wildcards. LIKE only [other wrong options] [Discuss in forum] IN only NOT IN only IN and NOT IN |
Q35 ⇒ The benefits of a standard relational language include which of the following? Reduced training costs [other wrong options] [Discuss in forum] Increased dependence on a single vendor Applications are not needed. All of the above. |
Q36 ⇒ SQL is: a data sublanguage. [other wrong options] [Discuss in forum] a programming language. an operating system. a DBMS. |
Q37 ⇒ What is not true of a Java bean? It may have many constructors as necessary. [other wrong options] [Discuss in forum] There are no public instance variables. All persistent values are accessed using get and set methods. All of the above are true of a Java bean. |
Q38 ⇒ Which JDBC driver Types are for use over communications networks? Both Type 3 and Type 4 [other wrong options] [Discuss in forum] Type 3 only Type 4 only Neither Type 3 nor Type 4 |
Q39 ⇒ Which of the following is true concerning a procedure? They include procedural and SQL statements. [other wrong options] [Discuss in forum] You do not create them with SQL. They do not need to have a unique name. They are the same thing as a function. |
Q40 ⇒ Which of the following is a correlated subquery? Uses the result of an outer query to determine the processing of an inner query. [other wrong options] [Discuss in forum] Uses the result of an inner query to determine the processing of an outer query. Uses the result of an inner query to determine the processing of an inner query. Uses the result of an outer query to determine the processing of an outer query. |
Or |