iHKCL | MCQ Practice


Q1 Display the list of ROLES created by users A. select * from user_roles B. select * from roles C. select * from user-roles D. select * from tab 0 0 Correct Answer A
Q2 Step(s) for creating clusters A. creating cluster B. createing cluster table C. creating cluster index D. all of these 0 0 Correct Answer D
Q3 How Many Indexes are there A. 0 B. 1 C. 2 D. none of these 0 0 Correct Answer C
Q4 Maximum length of all the cluster columns combined is : A. 237 B. 238 C. 239 D. 240 0 0 Correct Answer C
Q5 The command used to make changees to permanent: A. COMMIT B. ROLLBACK C. GRANT D. REVOKE 1 0 Correct Answer A
Q6 The command used to discard part or all work the user has done in current transaction A. COMMIT B. ROLLBACK C. GRANT D. REVOKE 0 0 Correct Answer B
Q7 The statement used to discard or commit all the changes upto a point A. COMMIT B. ROLLBACK C. SAVEPOINTS D. none of these 0 0 Correct Answer C
Q8 Which one is not the section of the PL/SQL program A. Declaration section B. Execution section C. Error section D. Exception Handing section 0 0 Correct Answer C
Q9 %rowtype is used A. provide a record type that represents a row in the table B. access datatype of the specified column C. declare specified data type to a variable D. all of these 0 0 Correct Answer A
Q10 Which operator have the higher precedence A. ** B. + C. LIKE D. OR 0 0 Correct Answer A
Q11 EXIT WHEN A. alterative B. iterative C. used in loops D. none of these 0 0 Correct Answer C
Q12 SELECT statement in PL/SQL must return A. five records B. four records C. three records D. one records 0 0 Correct Answer D
Q13 Which clause used with SELECT statement to store values from the table into variables A. GOTO clause B. INTO clause C. UPTO clause D. none of these 0 0 Correct Answer B
Q14 Which command is used to compile and execute the PL/SQL program A. RUN filename B. @filename C. &filename D. SQL filename 0 0 Correct Answer B
Q15 Command used to print on the screen A. PRINT B. WRITE C. dbms_output.put_line() D. DISPLAY 0 0 Correct Answer C
Q16 variable declaration is done in : A. declaration section B. execution section C. exception handling section D. none of these 0 0 Correct Answer A
Q17 Which on is not acomposite datatype: A. record B. table C. varray D. string 0 0 Correct Answer D
Q18 Which varable attribute is used to define a column type variable A. %rowtype B. %type C. %columntype D. all of these 0 0 Correct Answer B
Q19 Private SQL area to execute SQL statements and store information A. Table B. Record C. View D. Cursor 0 0 Correct Answer D
Q20 Which clause excluded in cursor A. OPEN B. CLOSE C. FETCH D. EXECUTE 0 0 Correct Answer D
Q21 Run time error are known as: A. Exception B. syntax error C. grammetical error D. non of these 0 0 Correct Answer A
Q22 Cursor not supported by A. VB B. JAVA C. c D. all of these 0 0 Correct Answer D
Q23 Which one is not predefined exception A. NO_DATA_FOUND B. TOO_MANY_ROWS C. STORAGE_ERROR D. OTHERS 0 0 Correct Answer D
Q24 In PL/SQL a function returns A. one value B. all values C. non value D. none of theses 0 0 Correct Answer A
Q25 Which argument mode lets the user to pass the value to called subprogram. A. OUT B. IN OUT C. IN D. all of these 0 0 Correct Answer C
Q26 Which one is not the part of trigger A. Trigger Event B. Trigger method C. Trigger action D. Trigger constrait 0 0 Correct Answer B
Q27 Which part is optional A. Trigger Event B. Trigger action C. Trigger constrait D. none of these 0 0 Correct Answer C
Q28 Which one of the following is the correct SQL command to retrieve all of the data from an Excel worksheet named Invoices? A. . SELECT Invoices FROM Excel B. SELECT Worksheet FROM Invoices C. . SELECT * FROM Invoices$ D. . SELECT * FROM Excel WHERE Worksheet=Invoices 0 0 Correct Answer D
Q29 can a trigger be defined as a stored procedure,if so , how, in what way it is different from a stored procedure A. yes, it is special kind of stored procedure, but it need not be called explicitly B. . Trigger can never be a stored procedure C. Triggers are to be called explicitly as we call stored procedures D. none of these 0 0 Correct Answer A
Q30 What happens when you invoke the Close method of a SqlConnection object? A. . The connection will be returned to the pool B. . The connection will be terminated and its resources cleared C. The connection will be maintained until the application invokes the Open method again D. none 0 0 Correct Answer A
Q31 Maximum number of columns allowed in a View is A. 24 B. 512 C. 128 D. 1024 0 0 Correct Answer D
Q32 What is a delegate? A. A strongly typed function pointer B. A light weight thread or process that can call a single method C. A reference to an object in a different process D. . An inter-process message channel 0 0 Correct Answer A
Q33 Which of the following operations can you NOT perform on an ADO.NET DataSet? A. . A DataSet can be synchronised with the database. B. A DataSet can be synchronised with a RecordSet C. A DataSet can be converted to XML D. You can infer the schema from a DataSet 0 0 Correct Answer B
Q34 Which one of the following controls does not ues the imagelist? A. . Slider B. Toolbar C. Tabstrip D. Treeview 0 0 Correct Answer B
Q35 What is the purpose of code-behind? A. To discard the use of HTML B. To separate different sections of a page into different files according to function C. To separate the layout HTML and the code into two different files D. . To merge layout HTML and the code into one file 0 0 Correct Answer C
Q36 Which DataTable property returns all rows and columns from a DataTable? A. TableView B. ViewAll C. DefaultView D. ReturnTable 0 0 Correct Answer C
Q37 which is the base class for all HTML controls? A. System.Web.UI.Html B. System.Web.HtmlControl C. System.Web.UI.HtmlControl D. . System.Web.Controls 0 0 Correct Answer C
Q38 What does the "Volatile" modifier do? A. The value of the object is written immediately on assignment. B. The value is lost after the system reads it. C. . The system stored the value until the end of all current threads. D. The system always reads the current value of a volatile object at the point it is requested. 0 0 Correct Answer D
Q39 What is not the part of .NET Plateform A. CLR B. CTS C. CDS D. CLS 0 0 Correct Answer C
Q40 SOAP stands for? A. Simple Object Access Protocol B. Simple Object Act Protocol C. Simple Object Accept Protocol D. Simple Object Across Protocol 0 0 Correct Answer A
Q41 What does WSDL stand for? A. Web Services Description Language. B. Web Services Describ Language. C. Web Sercular Description Language. D. Web Servay Description Language. 0 0 Correct Answer A
Q42 How many Nesting Levels are allowed in Triggers A. 12 B. 24 C. 32 D. none 0 0 Correct Answer C
Q43 What are the roles of SQL? A. . DML (Data manupulation Language) B. DDL (Data Defination Language) C. DAL (Data administration Language) D. All the above 0 0 Correct Answer D
Q44 What is Structured query language? A. Standard language for Data manipulation B. English Query Language C. English like query language designed by IBM to do datamanupulation D. none 0 0 Correct Answer C
Q45 How many clustered indexes can be createdon a table? A. 0 B. 1 C. 2 D. none of all 0 0 Correct Answer B
Q46 How many non-clustered indexes can be createdon a table? A. 2 B. 8 C. 249 D. 512 0 0 Correct Answer C
Q47 What data types do the RangeValidator control support? A. Integer B. String C. Date D. All of these 0 0 Correct Answer D
Q48 How to display the structure of the Table in SQL Server? A. . sp_TableName B. . sp_help TableName C. sturct TableName D. structure TableName 0 0 Correct Answer B
Q49 SQL Server Comments are ? A. << and -- B. . -- and /* ... / C. . -- and // D. // and / ... */ 0 0 Correct Answer B
Q50 In C# multiline comments are implemented by A. . // Data // B. <-- Data --> C. /* Data */ D. ---data--- 0 0 Correct Answer C
Q51 In ASP.NET, which two properties are present on every validation control A. . ControlToValidate & Type properties B. Type & ErrorMessage properties C. . ControlToValidate & Operator properties D. ControlToValidate & ErrorMessage properties 0 0 Correct Answer D
Q52 @@identity,@@error and @@rowcount are A. Global variables B. Scalar functions C. . Maintained by the server constantly D. All the above 0 0 Correct Answer D
Q53 Null Value is an Empty Value A. ture B. false C. none D. 0 0 0 Correct Answer B
Q54 Numeric data type is functionally equivalent to Deciaml data type A. True B. False C. not relevant D. Blank 0 0 Correct Answer A
Q55 The maximum number of Columns per base Table A. 1024 B. 512 C. 128 D. 32 0 0 Correct Answer A
Q56 The maximum number of Columns per index … A. 10 B. 16 C. 32 D. 64 0 0 Correct Answer B
Q57 The maximum number of column per INSERT Statement.. A. 10 B. 128 C. 256 D. 1024 0 0 Correct Answer D
Q58 The maximum number of column per SELECT Statement .. A. 256 B. 1024 C. 4096 D. no limit 0 0 Correct Answer C
Q59 The maximum number of Table per SELECT Statement … A. 256 B. 128 C. 1024 D. 4096 0 0 Correct Answer A
Q60 The maximum number of Foreign Key table references per Table A. 256 B. 253 C. 128 D. 1024 0 0 Correct Answer B
Q61 The maximum number of Rows per Table … A. 4TB B. 2,147,483,647 C. . Limited by available storage D. 1048516 TB 0 0 Correct Answer C
Q62 We can specify data types when we create a DataColumn for a DataTable in a Dataset. A. . True B. False C. it depends on the type D. none 0 0 Correct Answer A
Q63 What are all the types of Sql Server database file ? A. . Primay File (.mdf) , Secondary File (.ldf) and ldf files (.ldf) B. Primay File (.mdf) , Secondary File (.ldf) and ldf files (.ldf) C. Primay File (.mdf) , Secondary File (.ldf) and ldf files (.ldf) D. none of these 0 0 Correct Answer A
Q64 To associate an event handler with an event, What statement should be used? A. . the WithEvents statement and the Handles clause B. . the AddHandler statement C. the WithEvents statement and the Associates clause D. either A or C 0 0 Correct Answer A
Q65 What are the Three types of database file? A. .ndf file, .bdf file, .dlf file B. .mdf file, .ndf file, .ldf file C. ) .sdf file, .pdf file, .ldf file D. .mdf file, .cdf file, .log file 0 0 Correct Answer B
Q66 Bit data can be null in sql server 2000. A. True B. False C. Don't Know D. else 0 0 Correct Answer A
Q67 What's the difference between a primary key and a unique key? A. primary key creates a clustered index on the column B. . unique creates a nonclustered index by default C. . BOTH 1 & 2 D. . None of the above 0 0 Correct Answer C
Q68 How to find and delete duplicate records from a table? A. . SELECT columnname, count() FROM dbo.tablename GROUP BY columnname HAVING count() > 1 B. SELECT count() FROM dbo.tablename GROUP BY columnname HAVING count() > 1 C. . SELECT columnname, count(*) FROM dbo.tablename GROUP BY columnname HAVING count(columnname) >= 1 D. None of the Above 0 0 Correct Answer A
Q69 Which Command deletes all the rows in a table, but does not log the deletion of each row? A. DELETE TABLE B. . TRUNCATE TABLE C. ALTER TABLE D. None Above. 0 0 Correct Answer B
Q70 What is the difference between 'UNION' and 'UNION ALL' operators A. Both are similar B. only UNION is available in SQL , UNION ALL keyword is not there. C. . UNION will give only distinct records, but union all will give all the records from both the tables D. UNION will not take null values, UNION ALL will include null values also 0 0 Correct Answer C
Q71 What is the process of copying/moving data between databases on the same or different servers known as? A. . Duplication. B. Serialization C. . Replication D. . None Above 0 0 Correct Answer C
Q72 How many primary key(s) in an relation A. one B. two C. four D. six 0 0 Correct Answer A
Q73 Number of columns in an relation known as : A. cardnality of relation B. degree of relation C. width of relation D. height of relation 0 0 Correct Answer B
Q74 Which normal form restrict atomic values in relation A. 1NF B. 2NF C. 3NF D. 5NF 0 0 Correct Answer A
Q75 DBA means A. Database architecture B. Database Administrator C. Database Analyser D. All of these 0 0 Correct Answer B
Q76 Number of rows in the rows in a relation known as: A. cardnality of relation B. degree of relation C. height of ralation D. none of these 0 0 Correct Answer A
Q77 Which one not the feature of RDBMS A. Data Independence B. Data Security C. Data Integrity D. Encapsulation 0 0 Correct Answer D
Q78 SQL means: A. Structural Query Language B. Sequential Query Language C. Serial Query Language D. Selected Query Language 0 0 Correct Answer A
Q79 Which one is not DML: A. select B. insert C. create table D. update 0 0 Correct Answer C
Q80 Which one is DCL: A. Rollback B. delete C. drop table D. none of these 0 0 Correct Answer A
Q81 SQL is: A. non-procedural language B. Procedural Language C. Object Oriented Language D. All of these 0 0 Correct Answer A
Q82 Long data type can store A. 4GB B. 5GB C. 2GB D. 3GB 0 0 Correct Answer C
Q83 Fixed length character data can be stored in: A. VARCHAR2() B. CHAR() C. VARCHAR() D. LONG 0 0 Correct Answer B
Q84 HAVING clause in SELECT statement is used to A. restrict the column of table B. restrict the rows of grouped result C. restrict the rows of ungrouped table D. none of these 0 0 Correct Answer B
Q85 ORDER BY clause in SELECT statement is used for: A. sorting B. selection C. projection D. all of these 0 0 Correct Answer A
Q86 What will be the output of query "select * from emp;" A. Display * on the screen B. Display Name of employes only C. Display all the record of emp table D. none of these 0 0 Correct Answer C
Q87 DISTINCT clause is used to: A. all records B. only one record C. unique records D. selected records 0 0 Correct Answer C
Q88 Which one is not aggregate function A. SUM B. CHECK C. MAX D. AVG 0 0 Correct Answer B
Q89 Which clause is used to restrict the groups? A. WHERE B. ORDER BY C. GOUP BY D. HAVING 0 0 Correct Answer D
Q90 Which clause use at lowest level in SELECT statement A. GROUP BY B. HAVING C. WHERE D. ORDER BY 0 0 Correct Answer D
Q91 ROLLUP used in SELECT statement A. restrict column B. restrict rows C. calculate multiple levels of subtotals D. calculate average 0 0 Correct Answer C
Q92 Which command is used to provide priviledge to different user A. REVOKE B. GRANT C. RECALL D. PROVIDE 0 0 Correct Answer B
Q93 Which data model describes how the data is actually stored? A. internal model B. external model C. conceptual model D. all of these 0 0 Correct Answer A
Q94 Which one is not a set operator A. UNION B. MINUS C. ADD D. INTERSECt 0 0 Correct Answer C
Q95 Two tables are joined together using equality of values in one or more columns, with A. Self join B. Cartestion join C. Equi join D. Outer join 0 0 Correct Answer C
Q96 Which clause used to merge the outputs of two or more queries into single set of rows and columns A. UNION B. MINUS C. INTERSECT D. none of these 0 0 Correct Answer A
Q97 '%' represents a sequence(s): A. one character B. zero character C. zero or more character D. one or more character 0 0 Correct Answer C
Q98 System date function in oracle A. DATE B. SYSDATE C. SDATE D. SYSTEMDATE 0 0 Correct Answer B
Q99 Which condition is not true in case of inner query A. The inner query must be enclosed in parentheses. B. The inner query may not have an order by clause C. The inner query must have use groupby clause D. all of these 0 0 Correct Answer C
Q100 An Operator which check the existance of values A. SOME B. ALL C. LIKE D. EXISTS 0 0 Correct Answer D
Q101 The function finds the smallest integer greater than or equal to n A. FLOOR(n) B. EXP(n) C. CEIL(n) D. ABS(n) 0 0 Correct Answer C
Q102 The output of SIGN(n) if n is negtive A. 0 B. -1 C. 1 D. none of these 0 0 Correct Answer B
Q103 The function which capitalizes the first character of each word in string A. UPPER(string) B. INSTR(string) C. ASC(string) D. INITCAP(string) 0 0 Correct Answer D
Q104 The function removes all blank spaces from the left of string A. LPAD B. LTRIM C. RTRIM D. RPAD 0 0 Correct Answer B
Q105 Output of NEXT_DAY(date,day) is : A. next day of the given date B. Last day of the month C. last day of the year D. date of next specified day of the week 0 0 Correct Answer D
Q106 Which one of the following do you use to retrieve a user's color selection? A. . oDialog.Color.Name B. oDialog.RGB C. oDialog.Color D. oDialog.Text 0 0 Correct Answer A
Q107 Which one of the following pairs of form properties can be set of changed using the window shown above? A. Width and Height B. Top and Height C. Top and Left D. Width and Left 0 0 Correct Answer A
Q108 How do you determine the position of the currently selected item in a ComboBox called ComboBox1? A. ComboBox1.SelectedItem B. ComboBox1.ListItem C. ComboBox1.Selected D. ComboBox1.Index 0 0 Correct Answer A
Q109 Which one of the following properties contains the name of the directory in a FileList named File1? A. File1.ItemData B. File1.Path C. File1.Filename D. File1.Text 0 0 Correct Answer A
Q110 What is the purpose of the ImageList control? A. A ImageList control is used to find and list all image files in the specified path B. An ImageList control is used to list all images stored in other controls C. An ImageList control is used to provide the user with one image from the list D. An ImageList control is used to store images for use by other control 0 0 Correct Answer A
Q111 For which of the following is the BackStyle of the Lable control used? A. It controls the transparency of the Label control B. The Lable control does not have a BackStyle C. It allows you to specify the pattern used to fill the Label control D. It controls the color of the Label background 0 0 Correct Answer A
Q112 Which one of the following controls does not ues the imagelist? A. Toolbar B. Slider C. Tabstrip D. Listview 0 0 Correct Answer A
Q113 Which of the following operations can you NOT perform on an ADO.NET DataSet? A. A DataSet can be synchronised with the database. B. A DataSet can be synchronised with a RecordSet. C. A DataSet can be converted to XML. D. You can infer the schema from a DataSet 0 0 Correct Answer B
Q114 In the NUnit test framework, which attribute must adorn a test class in order for it to be picked up by the NUnit GUI? A. TestAttribute B. TestClassAttribute C. TestFixtureAttribute D. NUnitTestClassAttribute 0 0 Correct Answer C
Q115 What compiler switch creates an xml file from the xml comments in the files in an assembly? A. /text B. /doc C. /xml D. /help 0 0 Correct Answer B
Q116 What is boxing? A. Encapsulating an object in a value type. B. Encapsulating a copy of an object in a value type C. Encapsulating a value type in an object D. Encapsulating a copy of a value type in an object 0 0 Correct Answer D
Q117 If a method is marked as protected internal who can access it? A. Classes that are both in the same assembly and derived from the declaring class. B. Only methods that are in the same class as the method in question. C. Internal methods can be only be called using reflection D. Classes within the same assembly, and classes derived from the declaring class. 0 0 Correct Answer D
Q118 How do you debug in-process components? A. Set the debug property of the component to true B. Set the Enable property of the component to true C. Load a Test project & the component Project into a project group D. Load a Test project in one instance of VB & the component Project in another instance 0 0 Correct Answer C
Q119 You are designing n-tier architecture application with four layers.Which layer should handle security issues send back to the user interface? A. DataBase B. Data Objects C. Client objects D. Bussiness Objects 0 0 Correct Answer D
Q120 What is the function of Response.End? A. it will stop the server process B. it will stop the client process C. or both D. or none 0 0 Correct Answer A
Q121 In Web Application the class "WebForm1" inherits from A. System.Web.Page B. System.Page.Web.WebForm C. System.Web.UI.WebForm D. System.Web.UI.Page 0 0 Correct Answer D
Q122 In the Web Service the class 'Service1' inherits from A. System.WebServices.Service B. System.WebServices.WebService C. System.Web.Services.WebService D. System.Web.Services.Service 0 0 Correct Answer C
Q123 How to identify memory spaces in ArrayList? A. FindMemory B. MemorySpace C. Capacity D. ArrayMemory 0 0 Correct Answer C
Q124 DOT.NET offers two types of Data Adapters: SqlDataAdapter and OleDbDataAdapter. You are connecting to a SQL Server 2000 database and you choose to use the SqlDataAdapter. A. The OleDbDataAdapter is older technology kept in for backward compatibility. B. The OleDbDataAdapter is a sockets-based adapter for databases that are not specific to the machine. C. The OleDbDataAdapter is mainly designed for older, less efficient MS Access databases. D. As SqlDataAdapter does not have to go through an OLE DB layer,it is faster than the OleDbDataAdapter 0 0 Correct Answer D
Q125 which of the following are/is value type datatypes of C#? A. String B. Object C. Struct D. 1 & 2 0 0 Correct Answer C
Q126 Which of these tasks requires you to use imperative security rather than declarative security? A. Refusing dangerous permissions such as Registry permission B. Ensuring that your application has access to an environment variable whose name is not known until runtime C. Ensuring that your application has access to a specific file whose name is known at design time D. Ensuring that your application has access to a Jet database as a specific user. 0 0 Correct Answer B
Q127 How many clustered indexes can be created in table? A. 249 B. 250 C. one D. any number 0 0 Correct Answer C
Q128 XmlSerializer class is used for A. Remoting B. Web Services C. Xml Documentary Files D. Both 0 0 Correct Answer B
Q129 How many Non-Clustered indexes can be created? A. only 1 B. 248 C. 246 D. 249 0 0 Correct Answer D
Q130 How to display the structure of the Table in SQL Server? A. sp_TableName B. sp_help TableName C. sturct TableName D. structure TableName 0 0 Correct Answer B

DOT NET

Q1 Display the list of ROLES created by users

Q2 Step(s) for creating clusters

Q3 How Many Indexes are there

Q4 Maximum length of all the cluster columns combined is :

Q5 The command used to make changees to permanent:

Q6 The command used to discard part or all work the user has done in current transaction

Q7 The statement used to discard or commit all the changes upto a point

Q8 Which one is not the section of the PL/SQL program

Q9 %rowtype is used

Q10 Which operator have the higher precedence

Q11 EXIT WHEN

Q12 SELECT statement in PL/SQL must return

Q13 Which clause used with SELECT statement to store values from the table into variables

Q14 Which command is used to compile and execute the PL/SQL program

Q15 Command used to print on the screen

Q16 variable declaration is done in :

Q17 Which on is not acomposite datatype:

Q18 Which varable attribute is used to define a column type variable

Q19 Private SQL area to execute SQL statements and store information

Q20 Which clause excluded in cursor

Q21 Run time error are known as:

Q22 Cursor not supported by

Q23 Which one is not predefined exception

Q24 In PL/SQL a function returns

Q25 Which argument mode lets the user to pass the value to called subprogram.

Q26 Which one is not the part of trigger

Q27 Which part is optional

Q28 Which one of the following is the correct SQL command to retrieve all of the data from an Excel worksheet named Invoices?

Q29 can a trigger be defined as a stored procedure,if so , how, in what way it is different from a stored procedure

Q30 What happens when you invoke the Close method of a SqlConnection object?

Q31 Maximum number of columns allowed in a View is

Q32 What is a delegate?

Q33 Which of the following operations can you NOT perform on an ADO.NET DataSet?

Q34 Which one of the following controls does not ues the imagelist?

Q35 What is the purpose of code-behind?

Q36 Which DataTable property returns all rows and columns from a DataTable?

Q37 which is the base class for all HTML controls?

Q38 What does the "Volatile" modifier do?

Q39 What is not the part of .NET Plateform

Q40 SOAP stands for?

Q41 What does WSDL stand for?

Q42 How many Nesting Levels are allowed in Triggers

Q43 What are the roles of SQL?

Q44 What is Structured query language?

Q45 How many clustered indexes can be createdon a table?

Q46 How many non-clustered indexes can be createdon a table?

Q47 What data types do the RangeValidator control support?

Q48 How to display the structure of the Table in SQL Server?

Q49 SQL Server Comments are ?

Q50 In C# multiline comments are implemented by

Q51 In ASP.NET, which two properties are present on every validation control

Q52 @@identity,@@error and @@rowcount are

Q53 Null Value is an Empty Value

Q54 Numeric data type is functionally equivalent to Deciaml data type

Q55 The maximum number of Columns per base Table

Q56 The maximum number of Columns per index …

Q57 The maximum number of column per INSERT Statement..

Q58 The maximum number of column per SELECT Statement ..

Q59 The maximum number of Table per SELECT Statement …

Q60 The maximum number of Foreign Key table references per Table

Q61 The maximum number of Rows per Table …

Q62 We can specify data types when we create a DataColumn for a DataTable in a Dataset.

Q63 What are all the types of Sql Server database file ?

Q64 To associate an event handler with an event, What statement should be used?

Q65 What are the Three types of database file?

Q66 Bit data can be null in sql server 2000.

Q67 What's the difference between a primary key and a unique key?

Q68 How to find and delete duplicate records from a table?

Q69 Which Command deletes all the rows in a table, but does not log the deletion of each row?

Q70 What is the difference between 'UNION' and 'UNION ALL' operators

Q71 What is the process of copying/moving data between databases on the same or different servers known as?

Q72 How many primary key(s) in an relation

Q73 Number of columns in an relation known as :

Q74 Which normal form restrict atomic values in relation

Q75 DBA means

Q76 Number of rows in the rows in a relation known as:

Q77 Which one not the feature of RDBMS

Q78 SQL means:

Q79 Which one is not DML: