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. |
Q1 ⇒ What type of join is needed when you wish to include rows that do not have matching values? Outer join [other wrong options] [Discuss in forum] ![]() ![]() Equi-join Natural join All of the above. |
Q2 ⇒ The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID Equi-join [other wrong options] [Discuss in forum] ![]() ![]() Natural join Outer join Cartesian join |
Q3 ⇒ A ________ is a stored program that is attached to a table or a view. trigger [other wrong options] [Discuss in forum] ![]() ![]() pseudofile embedded SELECT statement None of the above is correct. |
Q4 ⇒ When using the SQL INSERT statement: rows can either be inserted into a table one at a time or in groups. [other wrong options] [Discuss in forum] ![]() ![]() rows can be modified according to criteria only. rows cannot be copied in mass from one table to another only. rows can be inserted into a table only one at a time only. |
Q5 ⇒ What SQL structure is used to limit column values of a table? The CHECK constraint [other wrong options] [Discuss in forum] ![]() ![]() The LIMIT constraint The VALUE constraint None of the above is correct. |
Q6 ⇒ Which type of SQL Server cursor concurrency places an update lock on a row when the row is read? READCOMMITTED [other wrong options] [Discuss in forum] ![]() ![]() READ_ONLY SCROLL_LOCK OPTIMISTIC |
Q7 ⇒ Which of the following is true concerning systems information in an RDBMS? All of the above. [other wrong options] [Discuss in forum] ![]() ![]() RDBMS store database definition information in system-created tables. This information can be accessed using SQL. This information often cannot be updated by a user. |
Q8 ⇒ With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data. Nonclustered [other wrong options] [Discuss in forum] ![]() ![]() Clustered Primary Secondary |
Q9 ⇒ The SQL command to create a table is: CREATE TABLE. [other wrong options] [Discuss in forum] ![]() ![]() MAKE TABLE. ALTER TABLE. DEFINE TABLE. |
Q10 ⇒ Which of the following is the original purpose of SQL? All of the above. [other wrong options] [Discuss in forum] ![]() ![]() To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language To define the data structures |
Q11 ⇒ What is an SQL virtual table that is constructed from other tables? A view [other wrong options] [Discuss in forum] ![]() ![]() Just another table A relation Query results |
Q12 ⇒ A subquery in an SQL SELECT statement is enclosed in: parenthesis -- (...) . [other wrong options] [Discuss in forum] ![]() ![]() braces -- {...}. CAPITAL LETTERS. brackets -- [...]. |
Q13 ⇒ The SQL ALTER statement can be used to: change the table structure. [other wrong options] [Discuss in forum] ![]() ![]() change the table data. add rows to the table. delete rows from the table. |
Q14 ⇒ SQL query and modification commands make up a(n) ________ . XML [other wrong options] [Discuss in forum] ![]() ![]() DDL DML HTML |
Q15 ⇒ SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n): INSTEAD OF trigger. [other wrong options] [Discuss in forum] ![]() ![]() BEFORE trigger. AFTER trigger. BEGIN trigger. |
Q16 ⇒ To sort the results of a query use: ORDER BY. [other wrong options] [Discuss in forum] ![]() ![]() SORT BY. GROUP BY. None of the above is correct. |
Q17 ⇒ In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup? Differential backup [other wrong options] [Discuss in forum] ![]() ![]() Complete backup Transaction Log None of the above is correct. |
Q18 ⇒ Where is metadata stored in MySQL? In the MySQL database [other wrong options] [Discuss in forum] ![]() ![]() In the MySQL database In the MySQL database None of the above is correct. |
Q19 ⇒ The SQL WHERE clause: limits the row data are returned. [other wrong options] [Discuss in forum] ![]() ![]() limits the column data that are returned. Both A and B are correct. Neither A nor B are correct. |
Q20 ⇒ Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine? All of Type 1, Type 2, Type 3 and Type 4 [other wrong options] [Discuss in forum] ![]() ![]() Type 1 only Type 2 only Both Type 3 and Type 4 |
Or |